Connected sources, already read
- Specification systemPDF Packaging specification, rev. C: five componentsread
- Specification systemXLSX Bill of materials, 12-pack SKUread
- Shared driveXLSX Artwork calendar: can, carton, trayread
- Co-packerXLSX Line schedule as the co-packer shares it, weeks 12 to 24read
- ERPPO Purchase orders and supplier confirmationssynced
- Quality systemASL Approved supplier list and certificatessynced
Components read from the specification, linked to the run
Lead times against the run
Forecast run: week 20, the line's next open slot. The cans set the date, and the cartons are three weeks late behind them, which nobody is watching because the cans are later still.
Delay against the planned reset
Planned shelfWeek 18
Forecast shelfWeek 24
Delay6 weeks
Cost of the delay$362,500
Two sourcing events hold the run in week 14
On the critical pathPrinted cans from a second can makerQuality reviews its certificate, audit report and letter of guarantee from the award in week 3 to week 10 while the cans are made, trial cans run on the co-packer's line in week 11 for the seam checks, and the order is on the dock in week 13 instead of week 17.
- On dock
- Week 13
- Premium, first run
- $9,720
- Alone, the run moves to
- Week 20
Next in lineShort-run cartons from a second converterOnce the cans move, the cartons due in week 16 set the date, so this event asks for week 12 or sooner.
- On dock
- Week 12
- Premium, first run
- $31,500
- With the cans, the run holds
- Week 14
Either event alone recovers nothing, because a run is a slot and both components have to make week 13. Together they hold the run in week 14 and the reset in week 18 for $41,220 more on the first run, against $362,500 of delay. The premiums assume $9 more per thousand cans on 1,080,000 cans and $0.35 more per carton on 90,000 cartons, before the line trial and seam checks your packaging engineer runs on the new cans; the quotes decide the real figures.
Supplier search, prefilled from the specification
- Printed cans, 12 oz standard
- 1,080,000 cans
- Order in week 3
- On dock by week 13
- Same metal basis: LME plus Midwest premium
- GFSI-benchmarked certificate
- Food-contact letter of guarantee
Each lead time and price is that supplier's own reply to the RFQ, since no can maker's queue sits in a database; the RFQ went out in under an hour from the specification your packaging engineer had approved, and the replies took the days they take. Distributor C is fastest, and its sleeved brite cans need a trial on the co-packer's line, so it stays off the shortlist unless your packaging engineer asks for it.
Add Can maker A to the shortlistForecast run: still week 20, because the cartons, on the dock in week 16, now set the date.
Add the carton eventThe run holds in week 14 and the launch makes the week 18 reset, so the delay cost falls from $362,500 to nothing, for $41,220 more on the first run.
Run it on your next launch