Operational management

Individual Bonus Assigment
1. Annual Demand= 10 cameras/day X 365 days= 3,650 cameras per year
Ordering Cost= (3,650/70)(25)= $1303.57
Holding Cost= (70/2) X 30= $1,050
Total AnnualCost= 1,303.57+1,050= $2353.57

2. = 78 boxes

Order Cost= (3650/78)25=$1,169.87
Holding Cost=(78/2)30=$1,170
Total Annual Cost= 1,169.87+1,170= $2,339.87
3. Calculations forending inventory, stockouts are expressed as a negative number in red.
Day | Order Receipt | Beginning Inventory | Demand | Ending Inventory |
1 (Mon) | 70.00 | 0.00 | 10.00 | 60.00 |
2 | |60.00 | 8.00 | 52.00 |
3 | | 52.00 | 20.00 | 32.00 |
4 | | 32.00 | 16.00 | 16.00 |
5 | | 16.00 | 8.00 | 8.00 |
6 | | 8.00 | 14.00 | (6.00) |
7 | | (6.00) | 6.00 |(12.00) |
8 (Mon) | 70.00 | (12.00) | 8.00 | 50.00 |
9 | | 50.00 | 5.00 | 45.00 |
10 | | 45.00 | 8.00 | 37.00 |
11 | | 37.00 | 16.00 | 21.00 |
12 | | 21.00 | 7.00 | 14.00|
13 | | 14.00 | 8.00 | 6.00 |
14 | | 6.00 | 17.00 | (11.00) |
15(Mon) | 70.00 | (11.00) | 8.00 | 51.00 |
16 | | 51.00 | 5.00 | 46.00 |
17 | | 46.00 | 17.00 | 29.00 |18 | | 29.00 | 14.00 | 15.00 |
19 | | 15.00 | 3.00 | 12.00 |
20 | | 12.00 | 9.00 | 3.00 |
21 | | 3.00 | 7.00 | (4.00) |
22(Mon) | 70.00 | (4.00) | 0.00 | 66.00 |
23 || 66.00 | 10.00 | 56.00 |
24 | | 56.00 | 7.00 | 49.00 |
25 | | 49.00 | 10.00 | 39.00 |
26 | | 39.00 | 4.00 | 35.00 |
27 | | 35.00 | 13.00 | 22.00 |
28 | | 22.00 |4.00 | 18.00 |
29(Mon) | 70.00 | 18.00 | 8.00 | 80.00 |
30 | | 80.00 | 10.00 | 70.00 |
31 | | 70.00 | 11.00 | 59.00 |
32 | | 59.00 | 12.00 | 47.00 |
33 | | 47.00 |5.00 | 42.00 |
34 | | 42.00 | 11.00 | 31.00 |
35 | | 31.00 | 7.00 | 24.00 |
36(Mon) | 70.00 | 24.00 | 2.00 | 92.00 |
37 | | 92.00 | 6.00 | 86.00 |
38 | | 86.00 |...