This page is for a merchandiser, a costing clerk, or a domestic buyer such as Cedar & Co. who needs to add one more order to a sheet that already tracks a factory's whole monthly result. At work, this is the final, practical step of everything this course has taught: an order's own P&L, overhead allocated across several orders, and a business P&L that adds every order together. This lesson mainly teaches the money flow: it takes one new, blank domestic order and shows exactly how filling it in changes every total on the sheet above it.
Omar, at Cedar & Co., is placing a new domestic order with Delta Garments, Order 3, 10,000 pieces, on top of the two Cedar & Co. orders and Order A already running that month. Before confirming it, he wants to see, using the same sheet from lessons T16-C04-L01 to L04, exactly what Order 3 adds to Delta Garments' combined monthly result once it is entered. Without this skill, a buyer or a merchandiser has to rebuild these calculations from scratch every time a new order joins an already-running month, instead of adding one row to a sheet that already does the work.
You need: every lesson in this course, T16-C04-L01 through L04. You do not need any accounting qualification.
By the end of this lesson you can:
Not covered here: this is the last lesson of the course. Course 4 continues with no further lesson; the same working sheet is reused on every future order and every future month.
| Term | Meaning |
|---|---|
| Order P&L | A statement that sets out one order's revenue, cost and profit as one continuous calculation. |
| Overhead allocation | Splitting a shared overhead pool across several orders in proportion to a chosen allocation base. |
| Business P&L | A statement that adds every order's own revenue and cost together for a period, then subtracts the factory's period overhead to show its overall result. |
| Net profit | A business's profit after every cost is subtracted, including costs not allocated to any single order. |
| Make to Stock (MTS) | Producing against the seller's own sales forecast, rather than a single confirmed buyer order. |
| Hybrid business model | A factory's own combination of export orders and domestic orders running side by side, each tracked according to its own market's requirements. |
A complete order and business P&L sheet links three things this course has already taught: each order's own P&L, the shared overhead pool split across every order running at once, and the business P&L that adds every order's revenue and cost together. Adding a new order changes all three at once, because the new order adds its own revenue and cost lines, changes the total pieces the overhead pool is split across, and joins the combined totals at the business level. None of these three parts stands alone; a sheet built correctly recalculates every one of them the moment a new order is entered.
A merchandiser or a buyer meets several different shapes of this same situation across a normal season, and learning to recognise each one prevents a sheet from being rebuilt by hand every time an order changes.
| What can differ | The shapes you will meet | Why it matters |
|---|---|---|
| A domestic buyer adding a new Make to Stock order mid-month | Cedar & Co. confirms Order 3 partway through a month that already has Order A and two other Cedar & Co. orders running. | The overhead pool must be recalculated across all four orders together, not just the three that were already on the sheet. |
| An export order added alongside existing domestic orders | A new export order for Northline Apparel could be added to the same sheet as Cedar & Co.'s domestic orders. | The sheet handles export and domestic orders identically once each order's own revenue and cost lines are entered. |
| An order removed or cancelled after being entered | An order already on the sheet is cancelled before shipment. | Removing an order changes the shared overhead pool and the business P&L the same way adding one does, in the opposite direction. |
| Make to Order versus Make to Stock added to the same month | Order A only exists because Northline Apparel confirmed it; Cedar & Co.'s orders exist against its own forecast. | Both order types are added to the sheet using the same three linked parts; the sheet does not need a different structure for each. |
Order 3 is 10,000 pieces, priced at Order A's own equivalent value per piece for a like-for-like comparison, joining Order A and the two existing Cedar & Co. orders already on the sheet from lesson T16-C04-L04. Mona enters Order 3's own revenue and cost lines on the "Order P&L" sheet, and the "Overhead allocation" and "Business P&L" sheets recalculate automatically, since they are built from live formulas rather than typed totals.
A common mistake is adding a new order's own revenue straight into the combined monthly revenue, but forgetting that its overhead share also changes the total pieces the whole overhead pool is split across, which changes every other order's own allocated overhead slightly as well. A sheet built on live formulas, as this course's workbook is, avoids this mistake automatically; a sheet with typed totals instead of formulas does not, and can quietly understate the true combined cost of goods sold once a new order joins. What this costs a factory or a buyer that gets it wrong is real: a business P&L that only adds new revenue without recalculating shared overhead overstates net profit, which can lead to a credit or pricing decision based on a number that was never actually correct.
Adding one new order to a factory's monthly sheet is not just adding its revenue to a total. The new order also has its own costs, and it changes how many pieces the factory's shared overhead is split across, which slightly changes every other order's own share too. A sheet built with live formulas updates all of this automatically the moment the new order's own figures are entered. A sheet that only adds a new total by hand, without recalculating the shared parts, can quietly show a higher profit than the business actually has. This course's own workbook is built to avoid that mistake, from one order's own P&L up to the whole month.
Omar wants to confirm Order 3 with Delta Garments, but only if it is still profitable once its own fair share of Delta Garments' overhead is counted, not just its revenue against its direct costs alone. Mona sends him the sheet with Order 3 already entered, alongside Order A and the two existing Cedar & Co. orders.
Here is the note Mona actually sent with the sheet:
Using only Mona's note, is Order 3 still profitable once its own overhead share is included? Decide before opening the answer.
Yes, USD 2,600 profit. Two figures in Mona's own note decide this.
First, Order 3's full cost, direct cost plus its own overhead share. USD 24,500 direct cost plus USD 4,900 overhead share is USD 29,400, Order 3's own complete cost of goods sold.
Second, revenue minus that full cost. USD 32,000 revenue minus USD 29,400 cost of goods sold leaves USD 2,600 profit, matching Order A's own USD 0.26 per piece rate applied to Order 3's 10,000 pieces exactly.
Omar can confirm Order 3 on this basis. Checking only revenue against direct cost, USD 32,000 minus USD 24,500, would have shown a misleadingly larger USD 7,500 figure, ignoring Order 3's own fair share of Delta Garments' overhead entirely.
Checking only direct cost overstates Order 3's own profit by USD 4,900, the exact size of its own overhead share, almost three times the real figure. A buyer who confirms future orders based on this overstated view builds a false picture of how strong the deal really is for the factory supplying it, which can shape unrealistic price expectations on the buyer's own next order.
Open the course workbook. The "Order P&L" sheet holds every order's own revenue and cost lines; the "Overhead allocation" sheet splits the shared overhead pool across every order by pieces produced; the "Business P&L" sheet adds every order together into the factory's combined monthly result. Enter a new order once, on the "Order P&L" sheet, and every other sheet updates from it automatically.
[Download the Order and business P&L sheet](../../templates/T16-C04-order-and-business-pl-sheet.xlsx)
1. What three parts of the course workbook does adding one new order change together?
2. Order 3 has USD 32,000 revenue, USD 24,500 direct cost, and a USD 4,900 overhead share. What is its real profit?
3. A new order adds 5,000 pieces to a month that already has 20,000 pieces running, with a combined overhead pool of USD 12,250 across all 25,000 pieces. What is the new order's own overhead share?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Order P&L | بيان أرباح وخسائر الطلبية | Compte de résultat de la commande | Sipariş kâr-zarar tablosu | A statement that sets out one order's revenue, cost and profit as one continuous calculation. |
| Overhead allocation | توزيع التكاليف العامة | Répartition des frais généraux | Genel gider dağıtımı | Splitting a shared overhead pool across several orders in proportion to a chosen allocation base. |
| Business P&L | بيان أرباح وخسائر الأعمال | Compte de résultat de l'entreprise | İşletme kâr-zarar tablosu | A statement that adds every order's own revenue and cost together for a period, then subtracts the factory's period overhead to show its overall result. |
| Net profit | صافي الربح | Bénéfice net | Net kâr | A business's profit after every cost is subtracted, including costs not allocated to any single order. |
| Make to Stock (MTS) | إنتاج حسب المخزون | Fabrication sur stock | Stoğa üretim | Producing against the seller's own sales forecast, rather than a single confirmed buyer order. |
| Hybrid business model | نموذج عمل مختلط | Modèle économique hybride | Karma iş modeli | A factory's own combination of export orders and domestic orders running side by side, each tracked according to its own market's requirements. |
This is the last lesson of Course 4. You can now build one order's own P&L, allocate overhead across several orders, and read a factory's whole monthly business result, in one working sheet. Back to the course map