Solved

How are Shop Order Estimated Costs for Machine or Labor Calculated in Weighted Average?

  • 7 September 2022
  • 1 reply
  • 257 views

Userlevel 6
Badge +20

Apps10 Upd11

Working in a Weighted Average, Cost per Part world.

When a shop order is created, how are the estimates determined for buckets other than 110 (estimated material)?

What is used to determine the Estimated Level and Accumulated Cost for buckets such as 200, 201, 300, 321, 322, 400, and 421?

icon

Best answer by Charana Udugama 7 September 2022, 03:31

View original

1 reply

Userlevel 7
Badge +11

Hi @matt.watters ,

For Level 0,

Total Est Level Cost = Level Cost of part for the specific cost bucket in level 0 (i.e. Level Cost/Unit column shown in Order Cost Estimates tab in the Shop Order Costs window)

For Levels > 0,

Total Est Level Cost = Cost Qty per Assembly * Accum Cost of part for the specific cost bucket in that specific level

Cost Qty per Assembly is shown in the Estimated Details tab in Shop Order Costs window. I could not find a window which is showing shop order specific Accum Costs for levels > 0. You can get that value from the Part Cost window I guess.

For By-Products, the calculation is same as described in levels > 0 section above.

This is how it calculates in code level. Hope this helps.


This is quoted from the below thread. Please refer to it for further information

How the Total Est Level Cost is calculated in shop order estimated cost? | IFS Community

 

Best Regards,
Charana

Reply