c D E F G H J L A B Inventory Solver Assignment 1 Ordering cost per order Storage space available (m3) 1300 Inventory Holding Budget per month $2,500 $75 3 4 TV 1 5 TV 2 6 TV3 7 TV 4 8 TV 5 Storage Space per Demand Item Value unit (m3) per month $1,500 4.4 200 8.5 325 $1,300 12.6 400 $1,750 6.4 300 $2,500 9.5 150 $2,000 $50 $60 $35 $80 10 11 12 Problem 13 Wolverine Electronics sells five different televisions with a different demand for each product. The holding cost for each TV is 10% of the item value. 14 Wolverine Electronics has only 1300 m3 of capacity available to store these TVs. They also have a very limited budget to hold the inventory such that they would like to keep 15 the cost to hold TVs in inventory for the month to under $2500. In order to minimize total inventory cost with this budget, how many of each TV should they order each time they place a 16 How many orders per month should they place? 17 18 How much should they have budgeted for holding costs in order to minimize total inventory cost? What would the ordering quantities be with this budget? 19 How much would the inventory cost change? Why do you think this is? 20 Hint: you may need to reset the variable values for the order quantities to 1 between runs in order to avpid an error. 21 22 23 24 25 26 c D E F G H J L A B Inventory Solver Assignment 1 Ordering cost per order Storage space available (m3) 1300 Inventory Holding Budget per month $2,500 $75 3 4 TV 1 5 TV 2 6 TV3 7 TV 4 8 TV 5 Storage Space per Demand Item Value unit (m3) per month $1,500 4.4 200 8.5 325 $1,300 12.6 400 $1,750 6.4 300 $2,500 9.5 150 $2,000 $50 $60 $35 $80 10 11 12 Problem 13 Wolverine Electronics sells five different televisions with a different demand for each product. The holding cost for each TV is 10% of the item value. 14 Wolverine Electronics has only 1300 m3 of capacity available to store these TVs. They also have a very limited budget to hold the inventory such that they would like to keep 15 the cost to hold TVs in inventory for the month to under $2500. In order to minimize total inventory cost with this budget, how many of each TV should they order each time they place a 16 How many orders per month should they place? 17 18 How much should they have budgeted for holding costs in order to minimize total inventory cost? What would the ordering quantities be with this budget? 19 How much would the inventory cost change? Why do you think this is? 20 Hint: you may need to reset the variable values for the order quantities to 1 between runs in order to avpid an error. 21 22 23 24 25 26