Heritage & Paint Outlook

From Production and Paint Outlook.xlsm · orders as of 2026-09-25 · generated 2026-09-25 07:22 · dates = requested ship dates · next 42 days
In the back now: 39 Heritage doors over 8 ship dates (Oct 06–Oct 16) — next-5 ≈5/day, next-10 ≈3.9/day. Upcoming pipeline (by ship date; paperwork lands closer to each date) shown through Nov 06 — heaviest week of Oct 19 at 37 doors (~7.4/day), with more ceiling-busting days: Oct 21 (9).
In the back now
39
Heritage doors papered & in production (8 ship dates)
In-back run rate
5/day
next 5 days · next 10 days ≈ 3.9/day
Pipeline · 42 days
109
Heritage scheduled by ship date
Overload days >8
1
peak Oct 21 (9)

Weekly Heritage load (pipeline)

Average Heritage doors/day per week (scheduled by ship date ÷ 5). Red dashed line = 8/day ceiling.

Overload >8/day   Healthy 4–8   Light / not yet booked

Next Heritage ship dates

Per-date scheduled Heritage doors, and how many are already in the back. Red = over the 8/day ceiling.

Ship date Day Doors In back Status
Oct 02Fri1—LIGHT
Oct 06Tue44HEALTHY
Oct 07Wed33LIGHT
Oct 08Thu76HEALTHY
Oct 09Fri66HEALTHY
Oct 13Tue76HEALTHY
Oct 14Wed77HEALTHY
Oct 15Thu66HEALTHY
Oct 16Fri81HEALTHY
Oct 19Mon8—HEALTHY
Oct 20Tue4—HEALTHY
Oct 21Wed9—OVERLOAD
Oct 22Thu8—HEALTHY
Oct 23Fri8—HEALTHY
Oct 26Mon3—LIGHT
Oct 27Tue4—HEALTHY
Oct 28Wed1—LIGHT
Oct 29Thu6—HEALTHY
Oct 30Fri5—HEALTHY
Nov 02Mon1—LIGHT
Nov 05Thu3—LIGHT

Paint load estimate

Estimated painted doors/day = (RI PAINT + 0.87 × RI PRODUCTION) ÷ 5 per week — mirrors your 'Painted Doors' column.

Week of Heritage/day Status Paint est./day Status
Sep 210—0—
Sep 280.2LIGHT3.7LIGHT
Oct 054HEALTHY19.8OVERLOAD
Oct 125.6HEALTHY12.3HEALTHY
Oct 197.4HEALTHY13.6HEALTHY
Oct 263.8LIGHT5.9LIGHT
Nov 020.8LIGHT2.4LIGHT

Doors by batch

Total doors in each batch (from the Overview sheet). Total includes Oct 2 holding; Booked excludes it; the Oct 2 holding is split into Heritage vs other.

BatchTotalBookedOct 2 — HeritageOct 2 — other
RI SCHEDULE445272371
RI TREE232201526
RI PAINT14214102
RI TRUCK13212507
RI STOCK131121010
RI FALSE TRIP2813213
SUPPLY ONLY231904

Future demand — unbooked

Parked on the Oct 2 holding date: demand with no firm ship date yet (not in the pipeline above) — shows what is coming.

Heritage (future)
79
unbooked · no ship date yet
Flush (future)
410
unbooked · no ship date yet
Breakdown by category & style
Heritage future demand — by categoryDoors
RI SCHEDULE72
RI SHOWHOME6
RI 2026-09-241

By style: Catherine 31, Carmen 27, Jane 18, Other 3

Southern demand

Doors headed to Southern Alberta (Calgary, Airdrie, Cochrane, Chestermere, Strathmore, Balzac, Okotoks, High River) — from the Schedule tab, already-made & cancelled batches removed. Future = parked on the Oct 2 holding date (not yet booked); Booked = has a real ship date.

Booked
16
1 Heritage · 15 Flush
Future (unbooked)
114
15 Heritage · 99 Flush
Total Southern
130
16 Heritage · 114 Flush
Show by area
By areaHeritageFlushTotal
Calgary45458
Cochrane54247
Airdrie01010
Chestermere448
Strathmore123
Okotoks213
High River011
Balzac000

How to read this
In the back = paperwork physically in production (Return Date is a real date). Only these count toward the next-5 / next-10 run rate — they're what's actually actionable.
Pipeline = Heritage scheduled by requested ship date. Paperwork comes into the back closer to each date, so upcoming dates showing 0 in-back is normal, not a gap.
Colours flag overload (>8 Heritage/day), which backs up Paint — those are the days to pull forward or add capacity.
Formula fixes (AA denominator, R1/R2) are applied in Production and Paint Outlook - FIXED.xlsm; AC left empty per your call.
Read-only view generated from a copy; your shared workbook is untouched.