Implementation
The report shows products sold during the selected period through “Orders” and “Shop”.
Calculation Principle
Section titled “Calculation Principle”Only products from closed orders and paid sales are counted.
Not included in the calculation:
- unpaid sales
- unclosed orders with statuses “New”, “In Progress”, “Deferred”, “Ready”
Indicators:
- Sales — number of products sold
- Revenue — price minus discount × quantity
- Cost — cost × quantity
- Profit — revenue minus cost
- Markup, % — profit ÷ cost × 100%
Calculation Example
Section titled “Calculation Example”Let’s take the product “Motherboard”. It was sold twice during the period:
- In sales: price $1000, discount $100, cost $600
- In order: price $1000, discount $200, cost $600
Calculate separately:
-
Sale
Revenue — 1000 − 100 = $900
Cost = $600
Profit — 900 − 600 = $300
-
Order
Revenue — 1000 − 200 = $800
Cost = $600
Profit — 800 − 600 = $200
Total for the product:
Revenue — 900 + 800 = $1700
Cost — 600 + 600 = $1200
Profit — 300 + 200 = $500
Markup — (500 ÷ 1200) × 100% = 41.7%
Summary
Section titled “Summary”Product: “Motherboard”;
Revenue: $1700;
Cost: $1200;
Profit: $500;
Markup: 41.7%
Product Report Key metrics on revenue and profit, recommendations for optimizing stock and improving profitability