# Answer key, sample data: open-orders dashboard for the 2026-11-23 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-23. This week = 2026-11-23 to 2026-11-29.

- Rows in the export (below the captions): 22
- Open order lines: 19
- Open value: $328,254.00
- Past due: 2 lines, $14,950.00
- Planned (not firm, not in the totals): 1 lines, $45,480.00

| When due | Lines | Open value |
|---|---|---|
| Past due | 2 | $14,950.00 |
| This week | 6 | $112,900.00 |
| Next week | 6 | $118,874.00 |
| Later | 5 | $81,530.00 |

| Customer | Lines | Open value |
|---|---|---|
| Prairie Wheel Equipment | 5 | $95,700.00 |
| Cottonwood Draw Farm Supply | 2 | $68,220.00 |
| Sandy Fork Ag Center | 1 | $56,850.00 |
| Bayou Drilling Supply | 5 | $42,320.00 |
| Anchor Point Machinery | 3 | $40,554.00 |
| Tri-County Implement | 3 | $24,610.00 |

Past due lines:

| Order | Line | Release | Customer | Item | Open qty | Due | Open value |
|---|---|---|---|---|---|---|---|
| 48171 | 1 | 0 | Bayou Drilling Supply | MR-1031 | 1 | 2026-11-13 | $6,850.00 |
| 48205 | 2 | 0 | Tri-County Implement | MR-1002 | 150 | 2026-11-20 | $8,100.00 |

Rows set aside (Excel row numbers):

| Excel row | Order | Line | Release | Item | Status | Reason |
|---|---|---|---|---|---|---|
| 6 | 48201 | 1 | 0 | MR-1015 | Filled | Status is Filled, nothing left to ship |
| 7 | 48204 | 1 | 0 | MR-1015 | Filled | Status is Filled, nothing left to ship |
| 24 | 48222 | 1 | 0 | RL-200 | Planned | Status is Planned, not a firm order yet |
