Reference no: EM131838119
Assignment
Using the table below, find the assigned information. All boxes have a value of $12.50.
1. Find the number of boxes produced each week
2. Find the number of boxes lost during the given period
3. Find the number of delivered boxed during the given period
4. Calculate the total production cost for each week (This will include both delivered and lost boxes)
5. Calculate the cost of lost boxes per week
6. Find the percent of boxes lost over the given period (lost boxes/produced boxes)
7. Find the greatest fmancial loss
8. Find the least fmancial loss
9. Using an if/the function show if each week has a loss greater than $62.50
10. Find the average number of boxes lost over the given period
11. Assuming that 80 boxes were delivered during week 11, use goal seek to determine the number of boxes lost that will create an 8% average number of boxes lost for an 11 week period.
Box Cost: $12.50
|
Week
|
Delivered Boxes
|
Lost Boxes
|
|
1
|
45
|
6
|
|
2
|
65
|
4
|
|
3
|
85
|
7
|
|
4
|
70
|
3
|
|
5
|
80
|
5
|
|
6
|
95
|
5
|
|
7
|
45
|
6
|
|
8
|
60
|
8
|
|
9
|
80
|
2
|
|
10
|
85
|
5
|