Fill in these first
- Sale name and dates: [e.g. Diwali sale, 20 to 31 October]
- Products: [paste product, regular price, product cost, shipping cost, marketplace or payment fee as a percentage, usual orders per week]
- Discount options to test: [e.g. 10%, 20%, buy 2 get 10% off, flat 200 off above 1,499]
- Minimum margin the business will accept: [e.g. 15% of selling price]
- Stock to clear, if any: [product and units]
Task
Work out what each discount option leaves as margin and how many more orders it would need to earn the same profit as no sale.
Output format
- Table per product:
| Option | Sale price | Fees | Margin per order | Margin % | Orders needed to match regular profit | Meets minimum margin |
- Recommended option per product, with one line of reasoning.
- Products that should not be discounted, and why.
- Two lines on clearance items, if stock to clear was given.
Rules
- Show the formula once: margin per order = sale price - product cost - shipping - fees.
- Fees are calculated on the sale price, not the regular price.
- Use only the numbers given; if a cost is missing, write "missing" and skip that row.
- Do not predict how many orders the sale will bring; show only the break-even requirement.
Example
| 20% off | 1,199.20 | 143.90 | 355.30 | 29.6% | 1.4x usual orders | Yes |






