Mesquite Ridge Metal Works - load check

Export date 2026-11-16. Four weeks, Monday to Sunday. Past-due lines are in week 1. Sample data.

Load by work center and week

Work centerWeek 1
Nov 16 - Nov 22
Week 2
Nov 23 - Nov 29
Week 3
Nov 30 - Dec 06
Week 4
Dec 07 - Dec 13
LATHE83%
66.70 h of 80.00 h
52%
41.50 h of 80.00 h
57%
45.30 h of 80.00 h
13%
10.00 h of 80.00 h
MILL86%
69.16 h of 80.00 h
123%
98.31 h of 80.00 h
56%
44.40 h of 80.00 h
80%
64.32 h of 80.00 h
WELD93%
74.00 h of 80.00 h
30%
24.00 h of 80.00 h
24%
19.00 h of 80.00 h
0%
0.00 h of 80.00 h
ASSY42%
33.50 h of 80.00 h
69%
55.50 h of 80.00 h
0%
0.00 h of 80.00 h
56%
44.50 h of 80.00 h

Red: over 100%. Amber: 90 to 100%. Color uses the rounded whole-number load %.

Order lines behind each red cell

MILL, week 2 (Nov 23): 98.31 h of 80.00 h, 123%

OrderLineReleaseItemOperationHours
4819512MR-10201024.50
4821010MR-10201022.25
4820710MR-10201015.50
4820910MR-10152011.00
4819512MR-1020209.82
4821010MR-1020208.94
4820710MR-1020206.29

Operations skipped: work center not in the hours file

OrderLineReleaseItemOperationWCHours not counted
4820510MR-103020OUT-PC0.00
4821510MR-103020OUT-PC0.00

No routing, hours unknown

Excel rowOrderLineReleaseItemOpen qtyDue
164820520MR-10021502026-11-20

Order lines not counted

Excel rowOrder/Line/ReleaseReason
648182/1/0Status is Filled, not Ordered
748185/1/0Status is Complete, not Ordered
848195/1/1Status is Filled, not Ordered
2148210/1/0Duplicate of Excel row 20
2348212/1/0No due date
2548214/1/0Status is Planned, not Ordered

Check

Rows in export 27 = lines counted 21 + lines not counted 6 (OK)