Calculate Standard Costs by Project (tipcs3250m000)

Use this session to calculate the standard cost of a project and its customized items. The output gives insight in the budgeted, estimated and actual costs per project.

Note
  • To improve system performance, you can run this process in multiple bshells, which allows LN to run the process on multiple processors. The project calculations can be performed in separate bshells. For more information, refer to To use boosters.

  • When you execute this session, the standard cost of customised subassemblies is calculated for the projects within the specified range.

 

Selection
Calculation Group

A code representing a group of projects the user uses to compare financial data.

You can assign a calculation group to:

  • A budget
  • A main project (as long as the calculation group is not assigned to another project or single project)
  • A single project (as long as the calculation group is not assigned to another main project or single project)
Project

A collection of manufacturing and purchasing actions that are performed especially for a particular customer order. A project is initiated to plan and coordinate the production of these items.

For a standard-to-order production, the project is only used to link the item with the customer order. Otherwise, a project can include:

  • Customized item data (BOMs and routings)
  • Project planning (activity planning)
Project Type

A way to characterize projects.

A project can have one of these types:

  • Main Project: the project structure is composed of subprojects
  • Subproject: the project is a subproject to a main project
  • Single Project: the project is a stand-alone project and is not part of a main project/subproject structure
Search Key

An alternative form of a description used for convenience during searching. Typically, it is an abbreviation, an acronym, or a mnemonic alternative to a full description.

Perform Estimated Cost Calculation
Perform Estimated Cost Calculation

If this check box is selected, the estimated cost are calculated for the range of projects you specify.

Skip Projects with an Estimated Cost

If this check box is selected, no estimates are made for projects with an estimated cost present.

Effective Date

You can specify the effective date of the valuation price or cost, which can be the current date or a date in the past.

If the Perform Actual Cost Calculation check box is selected, and the Backdate Valuation Price Allowed check box in the Standard Cost Calculation Parameters (ticpr0100m000) session is also selected, you can specify for which date the valuation price or cost is calculated or actualized.

Possible values

  • Current Date
    The date for which the valuation price is calculated or actualized is the current date.
  • Last Date of Previous Period

    The date for which the valuation price is calculated and actualized is the last date of the previous period.

  • Specific Date

    The date for which the valuation price is calculated and actualized is a date in the past, which you can enter in the Specific Date field.

Note
  • If you select the Last Date of Previous Period option, you can also select the Reverse to original inventory value at start of current period check box. For more information, refer to Lower of cost or market value.
  • If you click Specific Date, you can enter a date in the past in this field.
Perform Actual Cost Calculation
Perform Actual Cost Calculation

If this check box is selected, LN calculates the actual cost for the specified range of projects.

Net Change Only

If this check box is selected, LN calculates the actual cost only for projects for which financial transactions were recorded after the previous standard cost calculation.

The Net Change Actual Costs check box in the Project Details (tipcs2130m000) session indicates whether financial transactions were recorded for a project after the last time the actual costs were calculated.

Perform Simulated Cost Calculation
Perform Simulated Price Calculation

If this check box is selected, a simulated cost is performed. You cannot perform an estimated or actual cost calculation.

Use Cost Calculation Code of Project

The cost calculation code which you defined in the Projects (tipcs2101m000) session is used.

Alternative Cost Calculation Code

You can enter an alternative cost calculation code if you calculate a simulated cost.

Options
Update COGS Distribution

If this check box is selected, the cost of goods sold is updated during calculation.

Recalculate Standard Parts

If this check box is selected, the standard cost of the standard parts in a customized bill of material (BOM) is recalculated, but not updated during estimated and simulated standard cost calculations.

Market Value
Inventory Value Based on Lower of Cost or Market Value

You can base the value of inventory on the original purchase prices or the market values.

  • If this check box is selected, and the market values are lower than the purchase prices, the market values are used to value inventory. This method is called lower cost or market value (LCMV).
  • If this check box is cleared, purchase prices are used to determine the inventory value.
Reverse to original inventory value at start of current period

Using lower cost or market value (LCMV) to value inventory can result in an inventory value that differs from the inventory value that is calculated based on the original purchase prices. If the effective date is the last day of the previous financial period (the Last Date of Previous Period option is selected), you can use this check box to determine whether the inventory value is based on LCMV or the original purchase prices at the start of the current financial period:

  • If this check box is selected, LN uses the original inventory value when starting the current financial period.
  • If this check box is cleared, LN uses the inventory value based on LCMV when starting the current financial period.
Note

This check box is only available if:

  • Your inventory valuation price is actualized
    The Perform Actual Cost Calculation check box is selected.
  • You use LCMV to value inventory
    The Inventory Value Based on Lower of Cost or Market Value check box is selected.
  • The effective date is the last date of the previous financial period
    The Last Date of Previous Period option is selected.
Value Used if Purchase Receipts exist after last Market Value Date

If new purchase receipts exist after the date that market values are entered for the last time, you must select which cost to use to calculate the inventory value. You can choose between the following options:

  • Last Available Order Price
    The purchase price on the last available purchase order is used to calculate inventory value.
  • Last Available Market Value
    The last available market value entered in the Market Values (whina1118m000) session is used to calculate inventory value.
Note

You can only select these options if the Inventory Value Based on Lower of Cost or Market Value check box is selected.