Question: use excel and explain please Develop a model that would tell the company how many of each toy to produce during each month. You are

Develop a model that would tell the company how many of each toy to produce during each month. You are to minimixe total cost. Imventory cost will be levied on any tems in inventory on June 30, 2uly 31, or August 31 after demand for the month has been satisfied. Your model should make use of the relationship: Begining inventory + Production - Demand = Ending inventory for each month. The company wants to end the summer with at least 145 rocking horses and 40 scooters as beginning inventory for September 1 . (Let Pg=n umber of toy iU=1 corresponds to rocking horses and i=2 corresponds to scooters.) to produce in month j(j=1 corresponds to Sune, j=2 corresponds to July, j=3 corresponds to August). Let Sj= surplus (inventory) of toy i to at the end of month f.) Min Rioking Horse Inventory (June) P11S11=195 Rocking Horse Inventory (July) Rocking Horse Inventory (August) Final Rocking Horse Inventory Scooter Inventory (June) Scooter Inventory (July) Scooter Horse Inventory (August) Final Scooter Inventory June Plastic Availability July Plastic Availability August Plastic Availability June Time Availability July Time Availability August Time Availability
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
