Two situations break the simple "buy material, make product, sell from stock" picture, and spreadsheets handle both badly.
The first is subcontracting (maklon): you send your own material to a vendor who processes it, galvanising, heat-treating, machining or painting, and sends it back. In a spreadsheet the material simply disappears from the stock sheet when the truck leaves, and the vendor's invoice is booked as an expense. Nobody can say how much of your steel is sitting at the galvaniser, and the product cost misses the processing fee.
The second is make-to-order (MTO): you build a product for one specific customer order, often to that customer's specification. The spreadsheet risk is the opposite: the finished goods arrive, someone ships them to a different customer who shouted louder, and the original order is late.
Subcontracting: your material, their work
The key idea is that material at a subcontractor is still your inventory. It has left your building but not your balance sheet. A good ERP therefore treats the vendor's premises as one of your warehouses: a subcontractor warehouse.
The flow:
- Subcontract order. Like a purchase order for a service: which item the vendor will return, how many, the service price per unit, the expected date.
- Send material. The components (from the BOM, or listed on the order) move from your warehouse to the subcontractor warehouse. This is a transfer: the value stays in inventory, but the material is no longer available for your own production or for MRP.
- Receive the finished item. As processed goods come back, the components are consumed at the vendor's location and the finished item enters your stock, valued at material cost plus the service fee. Partial receipts are normal.
- Vendor's invoice. The bill for the service is matched against what was received, just like a purchase. See Supplier invoices and the three-way match.
- Close. Leftover material at the vendor is either brought back or counted as their stock for the next order.
Worked example
You send steel for 100 side panels to a galvaniser who charges Rp 8,000 per panel. Each panel uses 1.5 kg of steel at Rp 18,000 per kg.
| Step | Debit | Credit | Amount |
|---|---|---|---|
| Send 150 kg of steel | (transfer between warehouses, no journal) | ||
| Receive 100 panels: steel consumed | WIP | Inventory | 2,700,000 |
| Receive 100 panels: panels into stock | Inventory | WIP | 2,700,000 |
| Inventory | GRNI | 800,000 | |
| Vendor's bill (PPN 11% effective, PPh 23 2%) | GRNI | 800,000 | |
| Input VAT (PPN Masukan) | 88,000 | ||
| PPh 23 payable | 16,000 | ||
| Accounts payable | 872,000 |
The panels enter stock at Rp 35,000 each: Rp 27,000 of steel plus Rp 8,000 of service. The service fee is product cost, not an expense of the month.
Controls that matter
- Reconcile vendor stock. Ask each subcontractor for a stock statement monthly and compare it with the subcontractor warehouse. Losses at vendors are a classic hidden leak.
- Agree the yield. If the vendor is allowed 2% loss, put it in the BOM scrap of the subcontracted item, so planning sends enough and anything beyond is visible.
- Bill only what came back. Never pay a processing fee for units not received.
Make-to-order: building for one customer
Most factories mix two strategies:
| Strategy | When to use it | Customer waits for |
|---|---|---|
| Make-to-stock (MTS) | Standard products, steady demand | Delivery only |
| Make-to-order (MTO) | Customised, expensive or slow-moving products | Production and delivery |
| Assemble-to-order | Standard components, final assembly per order | Final assembly and delivery |
In MTO the link between the sales order and the work order is the point. It does three things:
- Planning. The work order's output is pegged to the customer's line, so MRP does not count it as free stock for other demand.
- Protection. When the goods are finished, they are held for that line, so they cannot be shipped to someone else by mistake.
- Cost visibility. The work order's actual cost can be compared directly with the order's price: did this customer's job make money?
A few rules every MTO business learns:
- Confirm before you build. Never release an MTO work order for an unconfirmed order; take a down payment for anything custom. See Invoicing and revenue recognition.
- Promise dates from the plan, not from the salesperson's hope: material lead time plus production time plus delivery.
- Cancelling is a decision. If the customer cancels, decide explicitly whether to stop the work order or finish it for stock.
In Voltrus
Checklist
- Each subcontractor has its own warehouse, reconciled monthly with the vendor's statement.
- Subcontract service prices are on the order before material leaves.
- PPh 23 is withheld on processing bills.
- MTO work orders are created only from confirmed sales orders.
- A cancelled MTO order triggers an explicit decision on its work order.