How are Expected Costs calculated in Sage X3?

Hello!

We are finding that it's become near impossible for us to Close and Cost our work orders prior to our shipments. We run on average costs. To ensure our actuals are close to the expected, does anyone have a breakdown on how Expected Costs are calculated? I understand the BoM and Routings are used but how exactly does Sage build the cost? What formula is used where we could try and simulate the cost in excel to better understand and build our costs...

Any insight/help is appreciated! Thanks!! 

Jenny C. in NJ

Parents
  • Well Jenny, we're the same so I'll jump in the convo. The expected work order cost is from the provisional cost calculation. Provisional cost inquiry shows that. It's based on the components' standard cost and the operations' cost structures at the time the work order is released. It can be recaclulated within the work order or using the calculate expected cost function for a group of them. The actual work orders costs accumulate in WIP and replace the provisional cost in F/G during close/cost process. Yes, in a fast paced environment it's a real job to do. We recalc provisional on the work orders frequently(using the function in costing) to ensure they're up to date.

Reply
  • Well Jenny, we're the same so I'll jump in the convo. The expected work order cost is from the provisional cost calculation. Provisional cost inquiry shows that. It's based on the components' standard cost and the operations' cost structures at the time the work order is released. It can be recaclulated within the work order or using the calculate expected cost function for a group of them. The actual work orders costs accumulate in WIP and replace the provisional cost in F/G during close/cost process. Yes, in a fast paced environment it's a real job to do. We recalc provisional on the work orders frequently(using the function in costing) to ensure they're up to date.

Children
  • in reply to John Mitchell

    Hello John,

    We recalc provisional on the work orders frequently(using the function in costing) to ensure they're up to date. Can you tell me where what this is called the function is to update the provisional cost. When we build something for the first time we are seeing large variances especially if the qty on the work order is more than 1 ea and we have not closed the work orders below it. Wondering if this will help to update the provisional cost as we are building?

  • in reply to SteveC

    Costing>Production costs>Calculate expected cost. The function is CALMFGCOST. Read the function help becasue there's a few ways to do that. You' want to do the standard cost update frequently for raw and components as well. Keeps the variance much tighter. Prices have been flucuating wildy over the last year or so we have to run those frequently.