When you set up a line item code, you can specify the rate at which the product or service will be sold. These rates are calculated from two components on the line item code record:
- Rate Type – Drop-down list to specify the rate structure. (For more details, see below.)
- Rate value – Number field to specify the amount used for the calculation.
You can specify these components on the Line Item Codes Detail screen, in the General Info section:
Rate Types and Rate Values
The Rate Type is a drop-down list from which you select the type of pricing structure you need. The Rate Value field holds the value used with the Rate Type to calculate the final default selling price. There are four choices for Rate Type:
- Fixed Price - Sets the Rate Value as-is. For example, selecting a Rate Type of Fixed Price and entering 100.00 for a Rate Value will set a default price of $100.00. The default price will not be altered unless you change it manually.
- Fixed Mark Up - Sets the default price by marking up the Estimated Unit Cost by the Rate Value entered. For example, if the Estimated Unit Cost is $25.00 and the Rate Value is 100.00, then the default price will be $125.00. If costs change, the default price will always be the Estimated Unit Cost plus the markup amount set in Rate Value.
Formula: Unit Cost + Rate Value = Default Price Rate. - Mark Up % - Sets the default price by marking up the Estimated Unit Cost by the stated Rate Value percentage. For example, if the Estimated Unit Cost is $25.00 and the Rate Value is 10%, then the default price will be $27.50. If costs change, the default price will automatically adjust to maintain the stated markup percentage.
Formula: (Unit Cost * Rate Value ) + Unit Cost = Default Price Rate. - Margin % - Sets the default price to a level which maintains the profit margin stated by the Rate Value percentage. For example, if the Estimated Unit Cost is $25.00 and Rate Value is 40%, the default price will be $41.67. If costs change, the default price will automatically adjust to maintain the stated gross profit margin.
Formula: Unit Cost / ( 1 - Rate Value % ) = Default Price Rate.