Excel Business Unit 3 Assessment 2 - Kelly Computers
abparsley
Parsley_Excel_BU03_Assessment2_KellyComputers.xlsxSalesData
| Monthly Sales | ||||||||
| Product | Unit Price | January | February | March | Total | Product of the Month | ||
| 64GB Hard Drive | $ 150.00 | 12 | 11 | 12 | Goal | 75 | ||
| 128 GB Hard Drive | $ 249.00 | 7 | 6 | 8 | Product | |||
| 2GB Flash Drive | $ 8.00 | |||||||
| 4GB Flash Drive | $ 10.00 | 20 | 12 | 13 | ||||
| 8GB Flash Drive | $ 15.00 | 18 | 20 | 19 | ||||
| 15" Monitor | $ 75.00 | 5 | 4 | 5 | ||||
| 18" Monitor | $ 100.00 | |||||||
| Keyboard | $ 20.00 | 2 | 6 | 5 | ||||
| Ergo Keyboard | $ 35.00 | 13 | 11 | 12 | ||||
| 8GB RAM | $ 150.00 | 3 | 5 | 4 | ||||
| 16GB RAM | $ 200.00 | 2 | 3 | 5 | ||||
| Monthly Snapshot | ||||||||
| Totals by Item | Goal | Actual | Outcome | |||||
| Hard Drives | 50 | |||||||
| Flash Drives | 75 | |||||||
| Monitors | 52 | |||||||
| Keyboard | 55 | |||||||
| RAM | 12 | |||||||
&F
