Inventory Solver Assignment Storage Space per unit (m3) 4.4 Demand per month 200 Storage space available (m3) 1300 Inventory Holding Budget per month $2,500 8.5 Ordering cost per order $75 $50 $60 $35 $80 TV 1 TV 2 TV3 TV 4 TV 5 325 Item Value $1,500 $2,000 $1,300 $1,750 $2,500 12.6 400 6.4 300 9.5 150 Problem 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. 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 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 How many orders per month should they place? order? 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? How much would the inventory cost change? Why do you think this is? Hint: you may need to reset the variable values for the order quantities to 1 between runs in order to avoid an error. Inventory Solver Assignment Storage Space per unit (m3) 4.4 Demand per month 200 Storage space available (m3) 1300 Inventory Holding Budget per month $2,500 8.5 Ordering cost per order $75 $50 $60 $35 $80 TV 1 TV 2 TV3 TV 4 TV 5 325 Item Value $1,500 $2,000 $1,300 $1,750 $2,500 12.6 400 6.4 300 9.5 150 Problem 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. 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 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 How many orders per month should they place? order? 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? How much would the inventory cost change? Why do you think this is? Hint: you may need to reset the variable values for the order quantities to 1 between runs in order to avoid an error