Calculate estimated end item unit costs of a production order
The end item unit costs are the planned costs of one end item for a specific production order. LN calculates the end item unit costs by means of the estimates for hours or materials (item surcharges included). The calculation of estimated end unit costs of a production order is described in the following paragraphs.
LN calculates the estimated end unit costs when one of the following actions takes occurs:
- When the production order is released.
- You use the Calculate Estimated End Item Unit Costs (ticst0210m000) session.
- You use the Print Differences between Frozen and Current Estimated Costs (ticst0411m000) session. If you use this session, the costs are only printed, not stored.
If you print the differences between the current estimates and the previous calculated values in the Print Differences between Frozen and Current Estimated Costs (ticst0411m000) session, LN calculates the estimated unit costs.
The operation costs and the material costs are determined when you create the production order. The operation costs and the material costs of the end item are calculated when the costs are frozen. The data in the Estimated vs. Actual Material Costs (ticst0501m000) and Estimated vs. Actual Hours Costs (ticst0502m000) session are already filled at this moment. LN does the following when you calculate the estimated end-item unit costs:
Note: If multisite functionality is active, all calculations are done for a combination of item and the site where it is manufactured.
Example
Work Center 1 | ||
---|---|---|
operation 10 | operation 20 | |
yield % | 100 | 50 |
qty plan in | 200 | 200 |
qty plan out | 200 | 100 |
net mat per 10 pcs | 1 pcs | 3 pcs |
estimated material qty | 20 pcs | 60 pcs |
cost per pcs | $ 5 | $ 10 |
total costs | $ 100 | $ 600 |
per pcs, per workcenter | $ 1.00 | $ 6.00 |
Quantity Ordered = 100 pcs
Work Center 2 | |
---|---|
operation 30 | |
yield % | 100 |
qty plan in | 100 |
qty plan out | 100 |
net mat per 10 pcs | 2 pcs |
estimated material qty | 20 pcs |
cost per pcs | $ 6 |
total costs | $ 120 |
per pcs, per workcenter | $ 1.20 |
The transfer cost of amount per unit from work center 1 to work center 2 =
($100 + $600) / 100 = $7.00
The transfer cost of amount per unit from work center 2 to calculation office =
$7.00 + $1.20= $8.20
The base for calculation are all cost components of material and operation costs. The amounts are aggregated together and stored in a transfer price on the transfer component WIP Transfer Cost Component that is defined in the Production Order (tisfc0101m100) session.
Refer to the Help of the JSC Financial Transactions (ticst3500m000) session and the PCS Financial Transactions by Transaction Origin and Financial Trans. (tipcs3500m000) session for details about financial transactions.