Overview
The I/C Selling Price/Margin Analysis report includes items whose base prices, discount prices, or markup prices have a gross profit margin that is less than the percentage you specify.
When to Print
Print this report to:
- Analyze item profit margins.
- Compare base price margins with the margins on discounted or marked-up prices.
- Identify items with unusually low or high profit margins.
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 price list and location.
- The unit cost and cost UOM for each type of costing method selected for the report.
- The base price (entered on the Prices tab of the I/C Item Pricing screen).
- The pricing unit of measure (selected on the Prices tab of the I/C Item Pricing screen).
- The margin percentage, which is calculated as follows:
100 x [ (Base price - Unit cost) / Base price ] - The discount or markup price (calculated as specified on the Discounts tab of the I/C Item Pricing screen).
- The quantity that must be purchased for each discount level to apply, if the price varies by the volume purchased.
- The margin percentage for each discount or markup price, which is calculated as follows:
100 x [ (Discount or markup price - Unit cost) / Discount or markup price ]