Preserve the raw source. The final O107 is the same order exported twice. O108 returned units are unconfirmed. All prices are USD per unit.
| order id | week | region | product | units | unit price usd | returned units |
|---|---|---|---|---|---|---|
| O101 | W1 | North | Notebook | 10 | 8 | 1 |
| O102 | W1 | South | Pen Set | 20 | 5 | 0 |
| O103 | W1 | North | Desk Mat | 5 | 12 | 1 |
| O104 | W1 | South | Notebook | 8 | 8 | 0 |
| O105 | W2 | North | Notebook | 12 | 8 | 2 |
| O106 | W2 | South | Pen Set | 15 | 5 | 1 |
| O107 | W2 | North | Desk Mat | 6 | 12 | 0 |
| O108 | W2 | South | Notebook | 10 | 8 | Unconfirmed |
| O107 | W2 | North | Desk Mat | 6 | 12 | 0 |
Download the learner workbook to complete the checked eight-order analysis. The separate worked explanation contains solutions.
Use a separate calculation to verify the spreadsheet. Preserve unresolved inputs in your conclusion.
| Source version | |
|---|---|
| Confirmed duplicate and evidence | |
| Missing input and follow-up | |
| Row formula and actual reference | |
| Weekly ranges | |
| Units and percentage denominator |
Use a separate calculation to verify the spreadsheet. Preserve unresolved inputs in your conclusion.
| Independent row arithmetic | |
|---|---|
| Spreadsheet comparison | |
| Two-sentence business conclusion | |
| Assistant preparation/checking/correction effort if used |