Selling Price/Margin Analysis Report — Features

Sage ERP Accpac Inventory Control 6.0

Selling Price/Margin Analysis Report — Features

The Selling Price and 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.

Use the report to identify items with unusually low or high profit margins.

For instructions on printing the report, see Printing the Selling Price/Margin Analysis Report.

Information printed on the report

  • Amounts in the currency and at the exchange rate you specify, if you use a multicurrency ledger. Note that 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 form.

  • The margin, calculated as follows:

image\margin.gif

  • The discount or markup prices calculated as specified for the item on the Discounts tab of the Item Pricing form.

  • 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:

image\margin_discount.gif

See also