excel
SalesData
| Quarter 1 Sales | |||||||||||
| ProductID | Product | Unit Price | January | February | March | Total | |||||
| PRD-00078 | 12 | 11 | 12 | ||||||||
| PRD-000587 | 7 | 6 | 8 | ||||||||
| Met Goal Last Month | |||||||||||
| PRD-00056 | Product Type | Goal | Actual | Outcome | |||||||
| PRD-000837 | 20 | 12 | 13 | ||||||||
| PRD-000173 | 18 | 20 | 19 | ||||||||
| PRD-000382 | 5 | 4 | 5 | ||||||||
| PRD-000663 | |||||||||||
| PRD-000446 | 2 | 6 | 5 | ||||||||
| PRD-000660 | 13 | 11 | 12 | ||||||||
| PRD-000229 | 3 | 5 | 4 | ||||||||
| PRD-00065 | 2 | 3 | 5 | ||||||||
| Totals | |||||||||||
| Monthly Snapshot | |||||||||||
| Totals by Item | Goal | Actual | Outcome | ||||||||
| Hard Drives | 50 | ||||||||||
| Flash Drives | 75 | ||||||||||
| Monitors | 52 | ||||||||||
| Keyboard | 55 | ||||||||||
| RAM | 12 |
&F
Data
| ProductID | Product Name | Category | Price |
| PRD-00078 | 1TB SSD Hard Drive | Storage | $ 169.99 |
| PRD-000587 | 8TB HDD Hard Drive | Storage | $ 249.00 |
| PRD-00056 | 2TB Flash Drive USB 3.0 | Storage | $ 47.99 |
| PRD-000837 | 32GB Flash Drive USB 2.0 | Storage | $ 19.99 |
| PRD-000173 | 128 GB Flash Drive USB 2.0 | Storage | $ 21.75 |
| PRD-000382 | 27" Monitor LED | Display | $ 175.00 |
| PRD-000663 | 32" Monitor LED QHD | Display | $ 280.00 |
| PRD-000446 | Keyboard | Keyboard | $ 20.00 |
| PRD-000660 | Ergo Keyboard | Keyboard | $ 35.00 |
| PRD-000229 | 64GB RAM | Memory | $ 360.00 |
| PRD-00065 | 128GB RAM | Memory | $ 650.00 |