# Answer key, sample data: open-orders dashboard for the 2026-11-16 export

SAMPLE DATA. FICTIONAL COMPANY. NOT REAL.

Rules: open = Status Ordered, open qty (Ordered minus Shipped) above 0, a due date, counted once per Order + Line + Release.
Open value = open qty x Unit Price. Past due = due before 2026-11-16. This week = 2026-11-16 to 2026-11-22.

- Rows in the export (below the captions): 27
- Open order lines: 21
- Open value: $333,580.00
- Past due: 3 lines, $31,044.00
- Planned (not firm, not in the totals): 1 lines, $56,850.00

| When due | Lines | Open value |
|---|---|---|
| Past due | 3 | $31,044.00 |
| This week | 6 | $83,660.00 |
| Next week | 6 | $112,900.00 |
| Later | 6 | $105,976.00 |

| Customer | Lines | Open value |
|---|---|---|
| Prairie Wheel Equipment | 7 | $121,260.00 |
| Cottonwood Draw Farm Supply | 2 | $68,220.00 |
| Anchor Point Machinery | 4 | $58,050.00 |
| Bayou Drilling Supply | 4 | $42,810.00 |
| Sandy Fork Ag Center | 1 | $22,740.00 |
| Tri-County Implement | 3 | $20,500.00 |

Past due lines:

| Order | Line | Release | Customer | Item | Open qty | Due | Open value |
|---|---|---|---|---|---|---|---|
| 48150 | 1 | 0 | Prairie Wheel Equipment | MR-1015 | 40 | 2026-11-10 | $5,680.00 |
| 48166 | 1 | 0 | Anchor Point Machinery | MR-1010 | 24 | 2026-11-12 | $11,664.00 |
| 48171 | 1 | 0 | Bayou Drilling Supply | MR-1031 | 2 | 2026-11-13 | $13,700.00 |

Rows set aside (Excel row numbers):

| Excel row | Order | Line | Release | Item | Status | Reason |
|---|---|---|---|---|---|---|
| 6 | 48182 | 1 | 0 | MR-1001 | Filled | Status is Filled, nothing left to ship |
| 7 | 48185 | 1 | 0 | MR-1015 | Complete | Status is Complete, nothing left to ship |
| 8 | 48195 | 1 | 1 | MR-1020 | Filled | Status is Filled, nothing left to ship |
| 21 | 48210 | 1 | 0 | MR-1020 | Ordered | Same order, line, and release as an earlier row |
| 23 | 48212 | 1 | 0 | MR-1020 | Ordered | Due Date is blank |
| 25 | 48214 | 1 | 0 | RL-200 | Planned | Status is Planned, not a firm order yet |
