Connected sources, already read
- Store development trackerXLSX Fall openings: 24 stores, delivery and opening datesread
- Store planningPDF Prototype fixture plan, rev. 6: 58 sheetsread
- Store planningXLSX Fixture schedule by store: 2,184 linesread
- Construction managementPM General contractors' schedules, 24 storessynced
- ERPPO Purchase orders and supplier confirmationssynced
- Real estatePDF Leases: delivery dates and when rent startsread
Packages read from the fixture plan, linked to the stores
Each store's fixtures against its install week
Six stores open in January. The incumbent's June confirmation puts their fixture sets on site three weeks after the install date, which would move the openings to November 8 and 15, past the November 1 cut-off. Behind them, the checkout counters for stores 322 to 324 are due on October 25, a week after they are needed, which no schedule shows yet.
The cost of the missed season
Cut-offNov 1
Stores past it6
Months lost eachNov and Dec
Cost of the six$2.6M
Two sourcing events put five of the six back in the fall
On the critical pathA second fixture maker for stores 319 to 324Built to the same drawings and on site September 27 and October 4; store planning approves its mock-up section before the award.
- Recovers
- 3 stores
- Cost avoided
- $1.3M
- Cancellation
- $0.11M
Next in lineCheckout counters for stores 322 to 324, bid on delivery dateWith the fixture sets moved, the counters decide the last three openings, so the event asks for October 18.
- Recovers
- 2 more stores
- Cost avoided
- $0.9M
- Cancellation
- $0.02M
Store 324 still opens on January 17, about $0.4M of missed season. Maker A's sets land at $94K against the incumbent's $88K, $36K more for the six. Cancellation charges are an assumed 20% of each moved order (six fixture sets at $88K and three counter packages at $36K), and your purchase orders decide the real figure.
Supplier Search, prefilled from the fixture plan
- Gondolas and wall systems
- Prototype drawings, rev. 6
- 6 store sets
- On site by Sep 27 and Oct 4
- Landed price: freight, duty, install
- Mock-up section with the bid
Every date here is that maker's own reply to the RFQ sent on June 23, which asks for the ship week, the date on site and the price delivered with duty, because no maker's queue sits in a database. Each maker also sends a mock-up section within four weeks, so store planning reviews it before the award on July 28, and the lead times run from that date. Maker B's wall finish differs from the drawings, so store planning decides whether it can be used, and maker C arrives after the cut-off.
Add maker A for stores 319 to 324Stores 319 to 321 open in October, the checkout counters now decide stores 322 to 324, and the cost of the missed season falls from $2.6M to $1.3M.
Run it on your opening calendar