Question

Deegan Industries manufactures two types of roll bars for Porsches. Model DRB is bolted to the...

Deegan Industries manufactures two types of roll bars for Porsches. Model DRB is bolted to the car using existing hotels in the car's frame. Model DRW is a heavier roll bar that must be welded to the cars frame. Model DRB requires 20 pounds of a special high alloy steel, 40 minutes of manufacturing time, and 60 minutes of assembly time. Model DRW requires 25 pounds of the special high alloy steel, 100 minutes of manufacturing time, and 40 minutes of assembly time. Deegan's steel supplier indicated that at most 40,000 pounds of the high-alloy steel will be available next quarter. In addition, Deegan estimates that 2000 hours of manufacturing time and 1600 hours of assembly time will be available next quarter. The profit contributions are $200 per unit for model DRB and $280 per unit for model DRW. The linear programming model for this problem is as follows:

Subject to

20DRB + 25DRW ≤ 40,000 Steel available
40DRB + 100DRW ≤ 120,000 Manufacturing minutes
60DRB + 40DRW ≤ 96,000 Assembly minutes
DRB, DRW ≥ 0

a) Obtain a computer solution and find the optimal solution and the total profit contribution?
b) Another supplier offered to provide Deegan Industries with an additional 500 pounds
of the steel alloy at $2 per pound. Should Deegan purchase the additional pounds of
the steel alloy? Explain.
c) Deegan is considering using overtime to increase the available assembly time. What
would you advise Deegan to do regarding this option? Explain.
d) Because of increased competition, Deegan is considering reducing the price of model
DRB such that the new contribution to profit is $175 per unit. How would this change
in price affect the optimal solution? Explain.
e) If the available manufacturing time is increased by 500 hours, will the dual value for
the manufacturing time constraint change? Explain.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
XYZ Manufacturing Company produces three types of expresso machines: Grade-A model, GradeB model, and Grade C...
XYZ Manufacturing Company produces three types of expresso machines: Grade-A model, GradeB model, and Grade C model. The Grade-A model is sold at a unit price of $750 per unit; Grade-B model is sold at $600 per unit; Grade-C model is sold at $450 per unit. XYZ requires 25lb of steel and 5 labor hours to manufacture a Grade-A machine requires, 22lb of steel and 4 labor hours for a Grade-B machine, and 20lb of steel and 3 labor hours...
A computer company manufactures two types of computers. Each type of computer will require assembly time,...
A computer company manufactures two types of computers. Each type of computer will require assembly time, inspection time, and storage space. The amounts of each of these resources that can be devoted to the production of the computers is limited. The manager wants to determine the quantity of each computer to produce to maximize the profit generated by sales of these computers. In order to develop a suitable model of the problem, the manager has met with design and manufacturing...
The Wellbuilt Company produces two types of wood chippers, economy and deluxe. The deluxe model requires...
The Wellbuilt Company produces two types of wood chippers, economy and deluxe. The deluxe model requires 3 hours to assemble and 1/2 hour to paint, and the economy model requires 2 hours to assemble and 1 hour to paint. The maximum number of assembly hours available is 24 per day, and the maximum number of painting hours available is 8 per day. If the profit on the deluxe model is $94 per unit and the profit on the economy model...
The Wellbuilt Company produces two types of wood chippers, economy and deluxe. The deluxe model requires...
The Wellbuilt Company produces two types of wood chippers, economy and deluxe. The deluxe model requires 3 hours to assemble and 1 2 hour to paint, and the economy model requires 2 hours to assemble and 1 hour to paint. The maximum number of assembly hours available is 24 per day, and the maximum number of painting hours available is 8 per day. If the profit on the deluxe model is $90 per unit and the profit on the economy...
The Wellbuilt Company produces two types of wood chippers, economy and deluxe. The deluxe model requires...
The Wellbuilt Company produces two types of wood chippers, economy and deluxe. The deluxe model requires 3 hours to assemble and 1 2 hour to paint, and the economy model requires 2 hours to assemble and 1 hour to paint. The maximum number of assembly hours available is 24 per day, and the maximum number of painting hours available is 8 per day. If the profit on the deluxe model is $90 per unit and the profit on the economy...
Kelson Sporting Equipment, Inc. makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc. makes two different types of baseball gloves: a regular model and a catcher’s model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 100 hours available in its packaging and shipping department. The production time requirements and profit contribution per glove are given in the following table. Production Time (hours) Model Cutting and Finishing Packaging and Profit/Globe Sewing Shipping Regular model 1...
As a supervisor of a production department, you must decide the daily production totals of a...
As a supervisor of a production department, you must decide the daily production totals of a certain product that has two models, the Deluxe and the Special. The profit on the Deluxe model is $12 per unit and the Special's profit is $10. Each model goes through two phases in the production process, and there are only 100 hours available daily at the construction stage and only 80 hours available at the finishing and inspection stage. Each Deluxe model requires...
Novacook Ltd makes two types of cooker, one electric and one gas. There are four stages...
Novacook Ltd makes two types of cooker, one electric and one gas. There are four stages in the production of each of these, with the following features: Manufacturing Time Need (hours per unit) Electric Manufacturing Stage Time Needed(hours per unit) Total time available (hours a week Electric Gas Forming 4 2 3457 Machine Shop 10 8 11954 Assembly 6 4 5437 Testing 2 2 2106 Each electric cooker has a variable cost of $200 and a selling price of $300,...
Harriet is trying to determine how many units of two types of lawn mowers to produce...
Harriet is trying to determine how many units of two types of lawn mowers to produce each day. One of these is the Standard model, while the other is the Deluxe model. The profit per unit on the Standard model is $60, while the profit per unit on the Deluxe model is $40. The Standard model requires 20 minutes of assembly time, while the Deluxe model requires 35 minutes of assembly time. The Standard model requires 10 minutes of inspection...
NEED TO ACTUALLY HAVE THE EXCEL DOCUMENT OR I WILL FAIL THE QUESTION. CANT BE SCREENSHOT...
NEED TO ACTUALLY HAVE THE EXCEL DOCUMENT OR I WILL FAIL THE QUESTION. CANT BE SCREENSHOT Attach the excel document please 1. Create the model and use Excel Solver to answer the following: A computer company manufactures two types of computers. Each type of computer will require assembly time, inspection time, and storage space. The amounts of each of these resources that can be devoted to the production of the computers is limited. The manager wants to determine the quantity...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT