Ecommerce, Stock & Profit

Track order contribution, stock and reorder timing.

Lead time: days from ordering stock until it is ready to sell.

Who it is for

For small online stores.

Your outcome

Product register, stock warning and profit comparison.

What is inside

  • Store calculator: available stock, unit profit after fees and shipping, and monthly profit.
  • True-profit layer: discounts, returns, ads and holding cost, ad cost per order, break-even units, reorder point with safety stock and suggested quantity, a discount ladder, seven stress tests and three charts.
  • An in-kit product register that transfers totals to the calculator.
  • Bilingual Excel file: products and stock with reorder alerts and unit profit, an order log with profit per order and returns, and a monthly summary of orders, sales, profit and return rate with a chart, plus six new sheets: controls, true profit, reorder, discount ladder, stress tests and a decision dashboard with three charts.

Before you begin

Your figures and results inside the kit are in US dollars, and you can switch currency to match your country.

Supporting your chances of success

This kit combines precise calculations with guidance and organisation to help you work towards your goal. We help you organise inputs, understand options and assess strengths and risks, then suggest practical steps suited to its subject — such as pricing, cash flow or marketing.

Guidance supports decisions, not guaranteed success; estimates depend on the accuracy of your inputs.

Understand the kit step by step

This kit links stock movements with order contribution. Stock falls with sales and rises with deliveries, but more revenue does not guarantee profit after purchasing, shipping and platform fees. Compare stock coverage with supplier lead time to avoid running out of a successful product.

What to prepare before starting

Prepare opening stock, receipts, units sold, price, purchase cost, shipping, fees, fixed costs and lead time. Use one product and period or consistent aggregates.

From information to a decision

  1. Check unit movements and confirm sales do not exceed available stock.
  2. Calculate contribution after purchasing, shipping and fees.
  3. Compare days of stock with lead time to plan replenishment.

A simple example to explain the idea

200 units with no receipts and 120 sold leave 80. A price of 100, cost of 50, shipping of 10 and fee of 5 leave 35 per unit. 120 × 35 − 1,000 fixed costs = 3,200. At four sales daily, stock covers twenty days.

These figures are illustrative, not approved prices or guaranteed forecasts; they may differ from the worked example below.

How to interpret and use the result

If replenishment takes thirty days but stock covers twenty, a stockout is possible. Operating profit is not cash because stock may be purchased before sales.

A common mistake to avoid

Free customer shipping still costs your business. Allow for returns and damaged goods; do not mix unlike units without checking.

The included Excel file and how to use it

The Excel file has a products and stock sheet that calculates the balance, alerts when the reorder point is reached, and calculates unit profit after platform fees and shipping and the stock value, an order log that looks up goods cost by SKU and calculates the profit of each order including returns, and a summary of order count, return rate and average order profit, plus a controls sheet with the calculator figures and validity checks, a true-profit sheet from unit price after discount, fees, shipping and returns down to monthly profit after ads and holding cost, break-even units and ad cost per order, a reorder sheet with safety stock and a suggested quantity, a discount ladder showing how many units each discount needs to pay for itself, seven stress tests including supplier delay and stock-outs, and a decision dashboard with three charts and recommendations. The example matches the calculator.

First-week actions after calculating

  1. Enter each product with its SKU, cost and price, and stop or reprice any product with negative unit profit.
  2. Set a reorder point for each product from two weeks of sales and the supplier's lead time.
  3. Record last week's orders and review the return rate and average order profit.