Manufacturing · Food packaging · Hong Kong
Material purchasing and three-way match for a Hong Kong packaging factory
Every week's material orders worked out from the sales orders — and every supplier invoice checked against what was ordered and what arrived.
Representative example — a composite of typical Hong Kong workflows, written from the duties in current job ads. Company names, documents and figures are sample data.
A food-packaging manufacturer with about 60 staff makes paper lunch boxes, cups and bowls, with its office and production in Hong Kong. Its main materials are bought every week from a small group of suppliers. Ordering too little stops the machines; ordering too much fills the warehouse; and paying an invoice without checking it costs money quietly.
At a glance
The files they already use
- Sales orders for the week
- Bill of materials
- Stock and open orders
- Goods received notes
- Supplier invoices
- Usage per 1,000 pieces, plus scrap
- Less stock and open orders
- Rounded up to the supplier's minimum order
- PO, GRN and invoice must agree
- Quantity within ±2%, price exact
Done automatically
- Purchase orders — for approval
- Material requirement sheet
- Three-way match report
- Supplier query email — drafted
The purchasing manager approves each purchase order, the warehouse confirms receipt, and the accounts supervisor approves payment after reviewing the three-way match.
How they used to do it
Every Monday the production clerk copied the week's sales orders into a spreadsheet, looked up how much board each product used in a printed bill of materials, and worked out the total on a calculator. Then the clerk walked to the warehouse to check the stock sheet, and tried to remember which materials were already on order.
Purchase orders were typed in Word. When the goods arrived, the warehouse wrote a paper goods received note, and the supplier's invoice went to the accounts clerk, who matched the three documents by flipping through three different files before paying.
The difficulties
- Ordered twice. Board already on order could be forgotten and ordered again, leaving extra pallets in the warehouse for weeks.
- Ran short. If scrap is left out of the calculation, a cup line can stand idle waiting for board.
- Paid above the agreed price. A supplier raised its price on the invoice, and nobody compared it with the purchase order.
- Short deliveries paid in full. Invoices were paid for the ordered quantity even when less had arrived.
- Three documents, three places. The PO was in Word, the goods received note on paper in the warehouse, and the invoice in accounts.
Their formula, broken down
How much to order looks like a simple guess. Behind it are four steps, and skipping any one of them means either a stopped line or a full warehouse. Here is one week's PE-coated paperboard (300 g, used for lunch boxes, cups and bowls).
Material needed for the week's orders
The bill of materials gives the board used per 1,000 pieces, so each line is (order quantity ÷ 1,000) × usage per 1,000 pieces: lunch boxes (50,000 ÷ 1,000) × 18 kg, cups (120,000 ÷ 1,000) × 6 kg, bowls (40,000 ÷ 1,000) × 12 kg.
lunch boxes 900 kg + cups 720 kg + bowls 480 kg2,100 kg
Add the scrap allowance
Cutting and forming waste about 5% of the board, so 5% is added on top.
2,100 kg × 5% scrap+105 kg
Take off stock and open orders
650 kg is in the warehouse and 400 kg is already on order from last week, so only 1,155 kg is still needed.
−650 kg in stock − 400 kg on order−1,050 kg
Round up to the supplier's minimum order
The supplier sells in 500 kg pallets with a minimum of 1,000 kg, so 1,155 kg becomes 1,500 kg. The purchase order is drafted at HK$11.20 per kg: HK$16,800.00 for approval.
order 1,500 kg (3 pallets) − needed 1,155 kg+345 kg
What the system produces
This week's orders using PE-coated board
| Product | Order pcs | kg per 1,000 | Board kg |
|---|---|---|---|
| Lunch box, 2 compartments | 50,000 | 18 | 900 |
| Paper cup, 8 oz | 120,000 | 6 | 720 |
| Soup bowl, 16 oz | 40,000 | 12 | 480 |
| Board needed before scrap | 2,100 | ||
Three-way match on delivery of PO-2611
| Check | PO | GRN | Invoice |
|---|---|---|---|
| Quantity, kg | 1,500 | 1,480 | 1,500 |
| Quantity difference | — | −20 kg (−1.3%, within ±2%) | — |
| Unit price, HK$ per kg | 11.20 | — | 11.50 |
| Amount, HK$ | 16,800.00 | — | 17,250.00 |
| To approve: 1,480 kg at the PO price of HK$11.20 | 16,576.00 | ||
How it was calculated
Pay for the quantity received, at the price agreed on the purchase order
= 1,480 kg × HK$11.20 = HK$16,576.00
Held back: invoice HK$17,250.00 − HK$16,576.00 = HK$674.00 = 1,500 kg × HK$0.30 + 20 kg × HK$11.20 = HK$450.00 + HK$224.00
Flagged for a person to confirm
- Invoice INV-5582 charges HK$11.50 per kg against HK$11.20 on the PO — HK$674.00 is held back (HK$450.00 on price, HK$224.00 for the 20 kg not received) until purchasing confirms with the supplier.
- Water-based ink for next week's new cup print has no supplier on file — no purchase order is drafted until purchasing chooses a supplier.
In this example: the order quantity is worked out from the week's sales orders, and the delivery is paid at the quantity received and the price agreed, not at the price on the invoice.
How we helped
We connect the factory's sales orders, bill of materials, stock sheet and supplier list in one system. Each week it works out what to order and drafts the purchase orders; when goods arrive, the warehouse enters the goods received note, and each supplier invoice is matched to both before it can be paid.
- Orders in. The sales team keeps using the same order spreadsheet; the system reads it with the bill of materials.
- Requirement worked out. Usage, scrap, stock and open orders are applied for each material, and the result is rounded up to each supplier's minimum order.
- POs approved, then sent. Purchase orders are drafted for the purchasing manager to approve; a person sends them to the supplier.
- Matched before payment. Each invoice is matched to its PO and goods received note; only matched amounts go on the payment list, and every difference is flagged.
What the system handles
Material planning
Weekly requirements for board, lids, inks and cartons, from the sales orders and the bill of materials.
Purchase orders
Drafted per supplier at the agreed prices and minimum orders, for approval.
Goods receiving
Goods received notes are entered at the warehouse and linked to their purchase orders.
Three-way match
Invoices are checked against the PO and goods received note for quantity and price before payment.
Production reports
Material used against the bill of materials, so higher-than-planned scrap shows up each week.
Before and after
| Topic | Before | After |
|---|---|---|
| Requirement | Worked out on a calculator from a printed bill of materials. | Worked out from the sales orders, with scrap, stock and open orders applied. |
| Open orders | Remembered, or not — so board could easily be ordered twice. | Every open purchase order is deducted automatically. |
| Invoice price | Rarely compared with the purchase order. | Every unit price is compared with the PO, and any increase is held for approval. |
| Short deliveries | Invoices were paid for the ordered quantity. | Payment follows the quantity received; a shortfall beyond ±2% is flagged. |
| Month-end | Accounts spent days matching paper files. | Invoices are matched as they arrive, and only the flagged ones need a person. |
How much time it saves
- Each week about 90 materials are worked out for purchasing (about 10 minutes each), and about 600 supplier invoices a month are matched by hand (about 15 minutes each).
- 90 × 10 minutes × 4 weeks = 60 hours; 600 × 15 minutes = 150 hours; 210 hours a month.
- With the system, the weekly plan is reviewed in about 2.5 hours (10 hours a month) and each invoice in about 3 minutes (600 × 3 = 30 hours): 40 hours in all.
- Time saved ≈ 170 hours a month — about 21 working days.
- At HK$110 an hour (about HK$19,000 a month for one full-time clerk, MPF included), that is about HK$18,700 a month — before counting price increases and short deliveries no longer paid.
These are the working assumptions behind the figure, not an audited result.
How a project like this runs
- Free assessment. We sit with your production clerk on a Monday and your accounts clerk at month-end, and collect the bill of materials, stock sheet and a month of invoices.
- Built on your own records. Usage and scrap figures are checked against your past production, and the matching rules against invoices already paid.
- Side by side. For a month your clerks work as before while the system runs on the same orders and invoices, and the two are compared line by line.
- Live, then maintained. Once they match, the manual spreadsheets stop. New products, materials and suppliers are added as they come, and we fix anything that comes up.
Questions owners usually ask
- Does the system place orders with suppliers by itself?
No. It drafts purchase orders; the purchasing manager approves each one and a person sends it. - What if a supplier delivers a little more or less than ordered?
Differences within the company's tolerance, for example ±2%, pass and are paid on the quantity received. Anything outside it is flagged before payment. - Our scrap rate differs by product. Can it handle that?
Yes. Scrap is set per product and material in the bill of materials, and can be adjusted as production data comes in.
The results
- Every week's material orders are worked out from the sales orders, with scrap, stock and open orders applied.
- Every supplier invoice is matched to its purchase order and goods received note before it can be paid.
- Price increases, short deliveries and materials with no supplier are flagged for a person to decide.
Representative example — a composite of typical Hong Kong workflows, written from the duties in current job ads. Company names, documents and figures are sample data.
Related case studies
Also useful: Back-office outsourcing · Try a working demo · Free tools · All case studies
Does your company have a formula like this?
Send us one real example — a quotation, an invoice or a month-end statement — and we will show you how the system would work it out. The assessment is free.
Get a free assessment →