Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Develop a LP and spreadsheet model for Problem 2 3 at the end of Chapter 3 in the Ragsdale portion of your book. The Electrotech
Develop a LP and spreadsheet model for Problem at the end of Chapter in the Ragsdale portion of your book. The Electrotech Corporation manufactures two industrialsized
electrical devices: generators and alternators. Both of these
products require wiring and testing during the assembly process.
Each generator requires hours of wiring and hour of testing
and can be sold for a $ profit. Each alternator requires
hours of wiring and hours of testing and can be sold for a
$ profit. There are hours of wiring time and hours
of testing time available in the next production period and
Electrotech wants to maximize profit. You develop a linear
program to find the product mix that maximizes profit, and find
the profit for this optimal mix is $ The sensitivity
analysis report from Excel for this solution is given below. Use
this report to answer Questions below.
Adjustable Cells
Constraints
How many hours of slack in wiring capacity exists in the optimal solution?
How many hours of slack testing capacity exists in the optimal soluWhat is the company's total profit if it has additional hours of wiring capacity?What is the minimum transportation cost if the rental car company optimizes shipments between locations?
What is the company's total profit if it has additional hours of wiring capacity?
By how much does the profit on alternators need to increase before their production is justified?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started