Question: Please answer thoroughly and include work in excel solver. Thank you. A manufacturer owns two plants that produce the same product. It costs 20x1/2 to

Please answer thoroughly and include work in excel solver. Thank you.

A manufacturer owns two plants that produce the same product. It costs 20x1/2 to produce x units at Plant 1and 40x1/3 to produce x units at Plant 2. Each plant can produce up to 70 units and each unit produced can sell for $10. At most 120 units can be sold.

a) Formulate a mathematical program to determine the production levels that will maximize profit for

this manufacturer. Clearly define your decision variables, objective and constraints

b) Implement the model in Excel and use solver to find the optimal solution.

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 General Management Questions!

A manufacturer owns two plants that produce the same product. It costs 20x^1/2 to produce x units at Plant 1 and 40x^1/3 to produce x units at Plant 2. Each plant can produce up to 70 units and each...

A manufacturer owns two plants that produce the same product. It costs 20x!? to produce x units at Plant 1 and 40x1% to produce x units at Plant 2. Each plant can produce up to 70 units and each unit...

A manufacturer owns two plants that produce the same product. It costs 20x^0.5 to produce x units at Plant 1 and 40x^0.33 to produce x units at Plant 2. Each plant can produce up to 70 units and each...

please show your work in Excel . Baseball bats are manufactured at two different plants in Kentucky and Tennessee. The Kentucky plant has weekly costs that can be expressed as a function of the total...

please answer the questions under "assignment" given the information. thank you! FlexCon's Insourcing/Outsourcing of Pistons FlexCon, a $3 billion maker of small industrial engines, is undergoing a...

Please answer it using Excel Please answer it using Excel Newton Gourmet Chocolates operates two plants that produce candy. The Jefferson Clty plant which can produce up to 50 tons per month and the...

Please answer fast! Especially part a and b fast! Thank you!! Golf Shafts, Inc. (GSI), produces graphite shafts for several manufactures of golf clubs. Two GSI manufacturing facilities, one located...

Please show steps. Thank you. The Little Feat Manufacturing Company produces a product that is sold as an input to most golf cart manufacturers. Little Feat has two production plants that are capable...

Please answer in Excel! 8. Lithium Battery Production. Photon Technologies, Inc., a manufacturer of batteries for mobile phones, signed a contract with a large electronics manufacturer to produce...

Let Y be a random variable that we would like to predict. Suppose that we must choose a single number d as the prediction and that we will lose (Y d)2 dollars. Suppose that our utility for dollars...

A larger and more modem main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density from where it was 40 years ago when the...

What would the board of directors have considered before making the dividend decisions?

pls answer quickly im on a time limit 1 . Why would Congress initiate new tax legislation? Group of answer choices a. They might be trying to balance the budget to avoid a deficit b. All answers are...