Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beyond Agile Auditing Three Core Components To Revolutionize Your Internal Audit Practices

Authors: Clarissa Lucas

1st Edition

1950508676, 978-1950508679

More Books

Students also viewed these Accounting questions