Open Orders Dashboard

As of 2026-11-16 (date taken from file name mrmw-co-lines-2026-11-16.xlsx). Open = status in the open list, open qty above 0, and a readable due date.

Open lines
21
Open value
$333,580.00
Past due lines
3
Past due value
$31,044.00

Open orders by when they are due

When dueDatesOpen linesOpen value
Past duebefore 2026-11-163$31,044.00
This week2026-11-16 to 2026-11-226$83,660.00
Next week2026-11-23 to 2026-11-296$112,900.00
Later2026-11-30 or later6$105,976.00
Total21$333,580.00

Open orders by customer

CustomerOpen linesOpen value
Prairie Wheel Equipment7$121,260.00
Cottonwood Draw Farm Supply2$68,220.00
Anchor Point Machinery4$58,050.00
Bayou Drilling Supply4$42,810.00
Sandy Fork Ag Center1$22,740.00
Tri-County Implement3$20,500.00
Total21$333,580.00

Past due lines (oldest due date first)

Excel rowOrderLineReleaseCustomerItemDue dateDays lateOpen qtyUnit priceOpen value
34815010Prairie Wheel EquipmentMR-10152026-11-10640$142.00$5,680.00
44816610Anchor Point MachineryMR-10102026-11-12424$486.00$11,664.00
54817110Bayou Drilling SupplyMR-10312026-11-1332$6,850.00$13,700.00

Planned, not firm

Not included in any total above.

Planned linesPlanned value
1$56,850.00

Rows set aside

Every row not counted as an open line, by Excel row number.

Excel rowOrderLineReleaseStatusReason
64818210FilledClosed status 'Filled'
74818510CompleteClosed status 'Complete'
84819511FilledClosed status 'Filled'
214821010OrderedDuplicate of row 20 (same Order + Line + Release)
234821210Ordereddue date is blank
254821410PlannedPlanned, not firm (status 'Planned'): counted separately, not in totals
Check: rows in export 27 = open lines 21 + rows set aside 6 (27) - OK.