Configure Basic Product Costing Settings
Use this procedure to select a general costing model for product costing. It also explains which costing types to use in certain situations as well as the subtotal numbers reserved for values such as inventory valuation and customer order entry.
Outcome
These values are defined:
- Which general costing model to use for costing calculations
- Whether and how material costs are split on different item types
- How the costing date is updated during the costing calculation
- Which costing types to use for standard cost, target costing, sales statistics and order reporting
- Which elements in the costing model that represent subtotals that M3 can reuse, for example, for inventory valuation
- When cost warnings are issued
- How the cost is calculated for purchased items and distributed items.
The parameter table (CSYTAB) is also updated in this process.
Your settings are applied when you calculate product costs. See Managing M3 Product Costing.
Before you start
A costing model that corresponds to the company's general costing needs must exist in 'Costing Model. Open' (PCS025).
Follow these steps
-
Start 'Settings – Product Costing' (PCS001/F).
-
On the E panel, select a costing model (required).
-
Select whether to split material costs and whether to apply overhead to old purchase prices.
-
Specify the costing date rule.
-
Specify the costing types for standard cost, sales statistics, ordering cost, and operation reporting.
-
Specify the subtotals for standard cost, sales statistics, contribution analysis, profit analysis, and target costing. Press Enter.
-
On the F panel, select the warnings to be displayed.
-
Define how to calculate the cost for purchased and distributed items. Press Enter to finish.
Parameters to set
Basic settings for calculation of product costs
| Program ID/ Panel | Field | Description |
|---|---|---|
| (PCS001/E) | 01 General product costing model | The field indicates the ID of the product costing model to apply be default. Required value.
Note:
If you have selected a different costing model for an item on 'Item. Connect Facility' (MMS003/F), that model overrules the default costing model. However, you can also select a costing model for a specific costing in programs such as 'Product Costing. Calculate Selected Item' (PCS200). This costing model then overrules all other costing models that may apply. |
| (PCS001/E) | 02 Split material costs per item type | The field indicates whether it is possible to split material costs on different item types to differentiate costs for production material from packaging material, for example
If you do not select the check box, all material costs are displayed for costing component A01. If you select the check box, for each item type you must select which of the costing components A01–A03 to use. You do this in 'Item Type. Open' (CRS040/E). |
| (PCS001/E) | 03 Overhead on old purchase prices | The field indicates whether it is possible to add an overhead expressed in percent directly to costing components for direct material (A01–A03) instead of regulating it only by using costing components A04 and A05.
Usually the purchase price of the direct material is used in the costing calculation. Any estimated overhead is then added by using costing components A04 and A05. However, if you suspect that the price might increase during the year, you can select this check box. This enables you to add the extra overhead by selecting option 12='Enter costing rates' for any of costing components A01–A03 in 'Costing Component. Open' (PCS001). You can still use costing components A04 and A05 for "regular" overhead. |
| (PCS001/E) | 04 Costing date rule | The field indicates how the costing date is set during the calculation. This is a required value. In the examples below, the date is represented as YYMMDD (year, month, and day).
These are the valid alternatives:
|
Settings for costing texts
| Program ID/ Panel | Field | Description |
|---|---|---|
| (PCS001/E) | 05 Costing text connection | The field indicates from where any costing texts are retrieved.
A costing text is a user-defined comment that can be specified on several different levels. Its purpose is to document prerequisites for the costing calculation. The costing text is displayed on 'Product Costing. Display' (PCS300/E) when pressing F6. The purpose of selecting the location is to minimize response times by avoiding unnecessary table reads. These are the valid alternatives:
You can also specify an additional text in 'Item. Connect Facility' (MMS003) for a specific item. Then specify the ID of the text block in the 'Costing text – item' field below. You can always update the texts on (PCS300/E) manually after a costing run. |
| (PCS001/E) | 06 Costing text – item | The field indicates the ID of a user-defined text block for a specific item in 'Item. Connect Facility' (MMS003) to use as costing text. Optional value.
After a costing run, you can review and update the text by pressing F6 on (PCS300/E) and then select text category 'Item no'. |
Definitions of costing types and subtotals
| Program ID/ Panel | Field | Description |
|---|---|---|
| (PCS001/E) | 07 Costing type–standard cost and target costing | The field indicates the costing type which holds the locked standard cost. This is a required value. The subtotal with the standard cost from this costing type is used in inventory valuation.
For example, you have three costing types: Budget (used to develop standard for the following year), Simulation (for simulations and tests) and Financial Standard. The latter costing type holds the standard cost to apply and is the one to select in this case. |
| (PCS001/E) | 08 Subtotal – standard cost | The field indicates the subtotal number of the subtotal in the product costing model that displays the standard cost. This is a required value. The standard cost is synonymous to the inventory value of the item that is costed.
If the subtotal is different to the number selected in the 'Subtotal – sales statistics' field, then sales and administration overhead is created based on cost of sales. The subtotal number must have been selected for a costing element of type 3 in 'Costing Element. Open' (PCS015). |
| (PCS001/E) | 09 Costing type – sales statistics | The field indicates the costing type from where to retrieve the cost price of an item in customer order processing. Required value.
The cost price is the cost of an item used to calculate the contribution margin ratio for a customer order line on 'Customer Order. Open Line' (OIS101/E). The cost price updates the sales statistics during invoicing. Compare the field below. |
| (PCS001/E) | 10 Subtotal – sales statistics | The field indicates the subtotal number of the subtotal used as cost price in customer order processing and sales statistics. Required value.
The reason for not using the standard cost here is that the standard cost usually reflects the lowest production cost. In sales, a company can add an overhead to ensure that the product is not sold at a loss. The cost is displayed as the cost price for the customer order line on 'Customer Order. Open Line' (OIS101/E). For example, if a product has inventory cost of 100 and total cost of 110, using separate subtotal numbers for inventory accounting and sales statistics means that inventory is reduced by 100 and cost of sales is 110. |
| (PCS001/E) | 30 Subtotal – sales statistics All level | This field indicates whether the cost price for customer order processing and sales statistics is retrieved from 'All Levels' (MCCOMA). If the check box is not selected, the cost price for customer order processing and sales statistics is retrieved from 'This Level' (MCCOML). |
| (PCS001/E) | 11 Costing type – ordering cost | The field indicates the costing type from which the ordering cost is retrieved when the order specific cost is moved from the costing to the item/facility. Required value.
M3 calculates the ordering cost by multiplying the accumulated cost of certain costing components that have a cost driver equal to or larger than 41 and less than 98 with the order quantity. However, there are two prerequisites for including a costing component in this calculation. 1) It must have a cost driver equal to or larger than 41 and less than 98. 2) The 'Ordering cost' check box is selected on 'Costing Component. Open' (PCS010/E). |
| (PCS001/E) | 12 Subtotal – contribution analysis | The field indicates the subtotal number of the subtotal that represents the basis for calculating the effect of contribution margins. Required value.
The subtotal is displayed and used on 'Product Costing. Simulate Sls Prices/CM' (PCS306/E). The program is reached by selecting option 23='Sales/cost simulation' for the costing calculation in (PCS300). |
| (PCS001/E) | 13 Subtotal – profit analysis | The field indicates the subtotal number of the subtotal that represents the basis for making a profit analysis.
The subtotal is displayed and used on 'Product Costing. Simulate Sls Prices/CM' (PCS306/E). |
| (PCS001/E) | 14 Subtotal – target costing | This field is currently not in use. |
| (PCS001/E) | 15 Costing type – operation reporting | The field indicates the costing type to use for operation costs (B costing components).
Since each costing type is connected to a costing rate in (PCS100), you can use a different costing rate for operation transactions. Provided that you have defined it possible to display and change the costing type for the work center on 'Work Center. Open' (PDS010/J), you can also specify the costing type manually when reporting operations in 'MO Operation. Report' (PMS070) or 'WO Operation. Report' (MOS070). This way, you can create a cost variance for the operation without a difference in time or units. For example, work performed at night usually costs more. You can get a better estimate of the cost for the order using a different rate for operations completed on the night shift, than by using the standard rate. Consequently, in this example you use a separate costing type called Overtime Premium with a different cost rate for the night shift. |
Settings for warnings
| Program ID/Panel | Field | Description |
|---|---|---|
| (PCS001/F) | 16 Warning: Material with cost=0 | The field indicated whether a costing warning is issued when there is a material line with cost equal to zero in the costing calculation.
While running the costing programs, it is possible to get warnings in case there is some information missing in the cost calculation. There are several settings in M3 Product Costing where you can activate or deactivate warnings. (PCS001) is the highest level where warnings can be selected. You can overrule costing warnings when you run a costing program such as 'Product Costing. Calculate Selected Items' (PCS200) for a specific product or range of products. Current warnings can be displayed on a separate panel when specifying 'Product Costing. Display' (PCS300), provided that you have selected the 'Warning first' check box on (PCS300/P). You can view warnings in 'Costing Warning. Open' (PCS325), a program reached through option 16 in (PCS300).Please note that warnings are displayed for all costing components, regardless of whether they are used in the costing model of the product. The reason for this is that values are always calculated for all components when the costing is run, and the ones that not are "accurate" receives a warning. |
| (PCS001/F) | 17 Warning: Operation with cost= 0 | The field indicates whether a costing warning is issued when an operation line included in the costing calculation has a cost equal to zero. |
| (PCS001/F) | 18 Warning: Operation with order cost but order qty=0 | The field indicates whether a costing warning is issued when there are order-specific costs on an operation line for a product having an order quantity equal to zero. When the order quantity is zero, there is no distribution base for the order-specific costs. |
| (PCS001/F) | 19 Warning: Item with order cost but order qty=0 | The field indicates whether a costing warning is issued when there are order-unique costs for a purchase item with order quantity equal to zero. If order quantity is zero, there is no distribution base for the order-unique costs. |
| (PCS001/F) | 20 Warning: Product with order cost but order qty=0 | The field indicates whether a costing warning is issued when there are order-specific costs common to the product costs (E components) for a product having order quantity equal to zero. If the order quantity is zero, there is no distribution base for the order-specific costs. |
Settings for purchase/distribution costing
| Program ID/ Panel | Field | Description |
|---|---|---|
| (PCS001/F) | 21 Print purchase price on costing printout | The field indicates whether to print the purchase price and currency in columns 3 and 4 for material lines for purchased items in the analysis report you can print in the costing programs such as 'Product Costing. Calculate Selected Item' (PCS200). If you select this check box, these values are printed in columns 3 and 4 for the items even if you have made another selection of columns in 'Panel Vsn – Product Costing. Open' (PCS251). |
| (PCS001/F) | 22 Split distribution cost into costing components |
The field indicates whether to split the total cost into its costing components when calculating the cost of distributed items in 'Purchase/Distribution Costing. Calculate' (PCS280). The values in the product costing model for the item in the delivering facility are then copied per costing component to the receiving facility. If you do not select the check box, only one total cost is saved in the receiving facility. If Cost Is Split The structure of the distribution costing model as well as the product costing model in the receiving facility determine how any difference in cost between the two facilities is saved. The product costing model for the item in the receiving facility must always contain an E costing component with cost driver 98 for the uplift cost (the difference in cost between the two facilities). To store the distribution cost separately, there must also be a costing component with cost driver 97 (valid for costing components E01–E10 and A04–A05). Both costing components must be placed before the subtotal representing the standard cost in the model. The two scenarios below are based on a distribution costing model that has separate costing elements for internal transfer price and distribution-related costs (such as internal charges and overhead). – In the first scenario, the product costing model has an E costing component with cost driver 98 that is reserved for the uplift cost. The entire difference in cost is saved separately for this costing component. In this case, this cost is the sum of the difference in cost due to the internal transfer price AND the distribution cost. – In the second scenario, the product costing model has both an E costing component with cost driver 98 reserved for the uplift cost and a costing component with cost driver 97 reserved specifically for the distribution cost. The internal transfer price is then saved separately for the E costing component with cost driver 98 as the uplift cost, whereas the distribution cost is saved for the costing component with cost driver 97.
Note: The 032 parameter in 'Settings – Cost Accounting' (CAS900/E) determines how the split of the Cost of Goods Sold (COGS) is done for distributed items.
|
| (PCS001/F) | 23 Default update rule – purchase/distribution costing | The field indicates whether and how to update the cost of a purchased or distributed item if there already is a cost for the item with the same costing type in the receiving facility. You can override your selection here when costing purchased or distributed items in (PCS280).
These are the valid alternatives:
|
| (PCS001/F) | 24 General distribution costing model | The field indicates the general costing model to apply at distribution costing if there is no costing model selected for the respective combination of item and facility on (MMS003/F). The costing model can be overruled when calculating the cost in (PCS280). |
| (PCS001/F) | 25 Default priority order – distribution costing | The field indicates the priority order for retrieving the costing base (the cost of the goods itself) when a cost is calculated for distributed items in (PCS280). The result of this calculation is displayed in (PCS300). A default priority order is defined in (PCS001). You can override the default values when calculating the cost in (PCS280). The alternative selected in the top field has the highest priority. The alternative selected in the next field below has the second highest priority, and so on.
For costing of purchased items through (PCS280), the costing base is defined in (CRS780) instead. These are the valid alternatives:
|