I/C Selling Price/Margin Analysis Report

Overview

The I/C Selling Price/Margin Analysis report lists items whose base prices or discount 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 or compare base price margins with the margins on discounted or marked-up prices, or to identify items with unusually low or high profit margins.

Information Printed on This Report

  • Amounts in the currency and at the exchange rate you specify, if you use a multicurrency ledger.

    Note: The markup cost is always in the functional currency.

  • The unit cost for each type of costing method selected for the report.
  • The base price, from the Prices tab of the Item Pricing screen.
  • The margin, calculated as follows:

    (Base price - Unit cost) / Base price

  • The discount or markup prices calculated as specified for the item on the Discounts tab of the Item Pricing screen.
  • The quantity that must be purchased for each discount level to apply, if the prices vary by the volume purchased.
  • The margin for each discount or markup price, calculated as follows:

    (Discount or markup price - Unit cost) / Discount or markup price