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

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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!