To find the optimal solution to a linear optimization problem, do you have to examine all...

70.2K

Verified Solution

Question

Basic Math

  1. To find the optimal solution to a linear optimizationproblem, do you have to examine all the points in the feasibleregion? Explain.

  1. Can a linear programming problem have no solution? Morethan one solution? Explain.

----------------------------------------------------------------------------------------------------------------

  1. A beverage can manufacturer makes three sizes of softdrink cans—Small, Medium and Large. Production is limited bymachine availability, with a combined maximum of 90 productionhours per day, and the daily supply of metal, no more than 120 kgper day. The following table provides the details of the inputneeded to manufacture one batch of 100 cans for eachsize.

?

                                                                              Cans

Large

Medium

Small

Maximum

Metal (kg)/batch

9

6

5

120

Machines’ Time (hr)/batch

4.4

4.2

4

90

Profit/batch

$50

$45

$42

?

Develop a linear programmingmodel to maximize profit and determine how many batches of each cansize should be produced.

------------------------------------------------------------------------------------------------------------

  1. Gatson manufacturing company produces two types oftires: Economy tires and Premium tires. The manufacturing time andthe profit contribution per tire are given in the followingtable.

?

?

Operation

Manufacturing Time (Hours)

Time Available

Economy tires

Premium tires

Hours

Material Preparation

4/3

1/2

600

Tire Building

4/5

1

650

Curing

1/2

2/4

580

Final Inspection

1/5

1/3

120

Profit/Tire

$12

$10

?

Answer the following assumingthat the company is interested in maximizing the total profitcontribution.

  1. What is the linear programming model for thisproblem?
  2. Develop a spreadsheet model and find the optimalsolution using Excel Solver. How many tires of each model shouldGatson manufacture?
  3. What is the total profit contribution Gatson can earnwith the optimal production quantities?

Answer & Explanation Solved by verified expert
3.6 Ratings (582 Votes)
The formula for thespreadsheet is shown belowThe solver    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students