AI for Ecommerce
0/15 complete

Module 04 · Pricing Intelligence

Margin Math: PKR Costs, Shipping, and Platform Fees

Revenue is not margin, and a positive gross margin can still lose cash after fulfillment, returns and acquisition. Build the model per fulfilled order, then reconcile it against actual statements.

// concept

Use Three Margin Views

Gross margin: selling price minus product cost. Useful, incomplete.

Contribution margin: net revenue minus variable costs caused by the order. This should include product/inbound allocation, packaging, current platform/payment charges, seller shipping contribution, discounts, expected return/defect allowance and attributable advertising.

Operating result: contribution minus fixed costs such as staff, software, storage and equipment allocation. Do not force every fixed cost into one SKU blindly; choose and document a method.

// prompt — copy me2 lines
contribution_rate = contribution_margin / net_revenue
break_even_orders = monthly_fixed_costs / contribution_margin_per_order

Run base, downside and upside scenarios. The downside should change real uncertainty: return rate, currency cost, ad cost or shipping—not simply reduce every number by 10%.

// worked_example

Worked Example

A home organizer sells for PKR 2,400. Product and inbound allocation is 1,050; packaging 120; current channel/payment lines 300; shipping contribution 180; discount 100; return/defect allowance 150; ads 220. Contribution is PKR 280 before fixed costs—not the PKR 1,350 implied by price minus product cost.

The seller raises price blindly in the first draft. A better response is to test packaging cost, bundle economics, ad targeting and supplier terms while preserving customer value. Actual monthly statements then replace estimates.

Keep cash flow separate from profitability. A profitable order can still create a short-term cash gap if stock is prepaid and settlement arrives later. Add expected payment date, supplier payment date and reorder date to the model so growth does not consume cash faster than the business receives it.

// failure_cases

Failure Cases to Diagnose

5 cases to diagnose

  • Quoting platform fees from memory.

  • Ignoring tax treatment or mixing tax-inclusive and exclusive numbers.

  • Counting placed orders rather than fulfilled/settled orders.

  • Omitting return, defect and failed-delivery costs.

  • Using AI arithmetic without checking formulas and units.

// pakistan_angle

Pakistan Angle

Date all PKR and foreign-currency inputs. Keep evidence for business and tax records, and get qualified advice for your specific registration and filing position. Model courier zones and remote delivery separately when they materially differ.

// hands_on

Hands-On Exercise

5 steps

  1. Build the three margin views for one SKU.

  2. Link every cost to an invoice, statement or labeled estimate.

  3. Run one realistic downside case.

  4. Calculate break-even fulfilled orders.

  5. Reconcile the model with one actual settlement when available.

// completion_rubric

Completion Rubric

5 checks — tick as you verify

0/5

// sources

Sources