Download 03 Sales & Gross Margin
The best-selling product is not always the one that earns the most gross profit. Compare revenue, gross profit and margin by product, then split the revenue variance into price and volume.
What is inside the file
The sheet list below is read out of the actual workbook when this page is built, not typed. If the file changes, the list changes with it.
Where to look first
- Start on Sales Review and compare revenue, gross profit in baht and gross margin for each product together. Do not rank by revenue alone.
- To look at one business line, change the business-type cell on the same sheet to Trading or Manufacturing, then check each product's unit before comparing quantities.
- Open Price Volume to see whether the revenue variance comes from price or from volume.
- Before passing the file on, open Checks. If a line fails, do not send it yet.
Read the guide to this report first →
What you need before using it on your own company
- Monthly sales by product, in units and in value.
- Cost of sales for each product, per unit or in total.
- A sales budget split by the same products and units, so price and volume can be separated.
Check the file against the original
The SHA-256 values below come from the pack’s FILE_MANIFEST.json and are re-checked against the real files every time the site is built; a mismatch fails the build. To verify your copy yourself:
certutil -hashfile 03_Sales_and_Margin_TH.xlsx SHA256sha256sum 03_Sales_and_Margin_TH.xlsx| File | bytes | SHA-256 |
|---|---|---|
| 03_Sales_and_Margin_TH.xlsx | 139,105 | ab3b39f90d2d1231802172ffcb62d624768f3177c78473f0c4b8591d76850b38 |
| 03_Sales_and_Margin_EN.xlsx | 136,627 | 89455fd5b24df5764c63845456d16e81ae0e0f484955fc3f61bf8eb766310fb5 |
Use it in your work, change it, use it inside your company — no permission needed. The one ask is not to resell it as your own product. The figures are synthetic teaching data, not a real company’s results, and someone responsible for finance should review the formulas and costing policy before you run it on real numbers.
Download the workbook
What will you use this file for?
Optional. No personal details.
Thanks. This helps decide which files to build next.