# Linear Programming

Not what you're looking for?

See attached file for proper format.

Linear Programming - Analytical Methods of Supply Chain Management

Problem 2

The Tots Toys Company is trying to schedule production of two very popular toys for the

next three months: a rocking horse and a scooter. Information about both toys is given

below.

Beg. Inv.

June 1

30

10

Scooter

Plastic

Available

3500

5000

4800

Time

Available

2100

4000

2500

Monthly Demand

Horse

220

350

600

Monthly Demand

Scooter

450

700

520

Required

Plastic/Unit

5

4

Required

Time/Unit

2

3

Production

Cost/Unit

10

12

Holding

Cost/Unit/Month

1.50

1.20

Toy

Rocking

Horse

Summer Schedule

June

July

August

Develop a linear programming model that would tell the company how many of each toy

to produce during each month. You are to minimize total cost (production cost + holding

cost). Inventory holding cost will be levied on any items in ending inventory on June 30,

July 31, or August 31 after demand for the month has been satisfied. The company wants

to end the summer with 85 rocking horses and 50 scooters as beginning inventory for

Sept. 1.

Questions: How many of each toy will be produced each month? What will the total

cost equal? Be sure to specify that all variables are integer.

Define the decision variables, the objective function, and the constraints within your

answer to this question. Then, solve the model using Excel Solver. Finally, copy your

spreadsheet into the appendix of your Word report and submit your Excel file to the

dropbox.

2

##### Purchase this Solution

##### Solution Summary

The solution does a great job of answering the question. The solution is brief and concise and very easy to follow along. All the steps are clearly shown and Excel formulas are provided so that the student can answer similar questions in the future. It can be easily understood by anyone with a basic understanding of the topic. Overall, an excellent solution.

##### Purchase this Solution

##### Free BrainMass Quizzes

##### Lean your Process

This quiz will help you understand the basic concepts of Lean.

##### Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

##### Introduction to Finance

This quiz test introductory finance topics.

##### Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

##### Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.