Updated June 30, 2022
Data entered in this frame will only apply if the user selects either the Use Cost Grid and/or Use Unit Cost for Job Costing option in the process setup. If this is the case, the system may calculate time for the process but will only use the grid to calculate and apply Estimated Cost or Sell Price.
Entering information in the Cost Grid will only be used if the Costing Method is set to Cost per Unit AND the Use Cost Grid option is checked. This will negate any entry in the Unit Cost field.
Select Add, Edit or Delete to affect a selected line entry in the Cost Grid.
Quantity : Cost grids are based on a tiered system with the first number always being 1 and the last number will be the value that is used for any quantity above the last number.
Cost : The value is a per unit cost used for calculating the estimated cost of a process which in turn may be used for producing a final Sell Price.
Flat Cost : A value that will be added to the unit Cost x the Input Quantity to calculate the estimated cost of the process. For Example; Quantity of 100 x Per Unit Cost of $2.50 = $250.00 + Flat Cost of $50.00 = Estimate Cost of $300.00. Each tier in the grid can have a different Flat Cost value.
Fixed Cost : The above values will calculate the Estimate Cost whereas the Fixed Cost will automatically become the Sell Price regardless of Production Markup.
Unit Price : This value will be used to calculate the Sell Price, regardless of Production Markup, overriding the Fixed Price. The Estimate Cost will still be calculated using the Cost.
Markup % : The Markup % field will on being used only if the Mark up Separately option is check. This value will also not be used if either the Fixed Price or the Unit Price field are used.