Overview
The I/C Markup Analysis report includes items whose base price varies from a desired selling price by more than the percentage you specify.
When to Print
Use this report to help you identify products that do not meet the desired markup.
Information Printed on This Report
The top of the report shows the criteria you selected for the report, including the price list range and location range.
For each item that meets the criteria, the report includes:
- The item number, item description, and location.
- The most recent cost (entered for the item and costing unit from the I/C Location Details screen).
- The markup factor (entered on the Prices tab of the I/C Item Pricing screen).
- The desired selling price, which is calculated by multiplying the most recent cost by the markup factor.
- The pricing unit of measure (selected on the Prices tab of the I/C Item Pricing screen).
- The base price (entered on the Prices tab of the I/C Item Pricing screen).
- The percentage variance between the desired selling price and the base price, which is calculated as follows:
100 x [ (Base - Desired) / Desired ]