Skip to main content
Solved

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

  • September 7, 2022
  • 1 reply
  • 363 views

matt.watters
Superhero (Partner)
Forum|alt.badge.img+25

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?

Best answer by Charana Udugama

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

View original
Did this topic help you find an answer to your question?

1 reply

Charana Udugama
Superhero (Employee)
Forum|alt.badge.img+12
  • Superhero (Employee)
  • 117 replies
  • Answer
  • September 7, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings