Price Grid Table

Updated October 11, 2022

The Price Grid Table data will only apply if option Use Price Grid for Estimating is selected.

 

 

Enter or modify price grid data by selecting Add, Edit or Delete as applicable.

 

 

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 be used only if the Mark up Separately option is checked. This value will also not be used if either the Fixed Price or the Unit Price field are used.