OM_Take_Exam__2.xlsx3Ftarget3D9a2ca953-9380-42a9-a745-0e73086bb6c9.xlsx
Question #1
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Sales | 460 | 415 | 432 | 450 | 488 | 512 | 475 | 502 | 449 | 486 |
Question #2
| | Quarter |
| Year | 1 | 2 | 3 | 4 | Total Sales |
| 1 | 4 | 2 | 1 | 5 | 12 |
| 2 | 6 | 4 | 4 | 14 | 28 |
| 3 | 10 | 3 | 5 | 16 | 34 |
| 4 | 12 | 9 | 7 | 22 | 50 |
| 5 | 18 | 10 | 13 | 35 | 76 |
Question #3
| | Projected |
| Item | Usage |
| Number | Annual |
| 1 | 15000 |
| 2 | 6450 |
| 3 | 5000 |
| 4 | 200 |
| 5 | 20000 |
| 6 | 84 |
| 7 | 800 |
| 8 | 300 |
| 9 | 10000 |
| 10 | 2000 |
| 11 | 5000 |
| 12 | 3250 |
| 13 | 9000 |
| 14 | 2900 |
| 15 | 800 |
| 16 | 675 |
| 17 | 1470 |
| 18 | 8200 |
| 19 | 1250 |
| 20 | 2500 |
Question #4
| Year | Cost/Unit ($) |
| 1.00 | 20.00 |
| 2.00 | 24.50 |
| 3.00 | 28.20 |
| 4.00 | 27.50 |
| 5.00 | 26.60 |
| 6.00 | 30.00 |
| 7.00 | 31.00 |
| 8.00 | 36.00 |
bremichelle
