The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each generator requires 3 hours of wiring and 2 hour of testing and can be sold for a $275 profit. Each alternator requires 3 hours of wiring and 3 hours of testing and can be sold for a $190 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period and Electrotech wants to maximize profit. Formulate the LP model for this problem.
The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each generator requires 3 hours of wiring and 2 hour of testing and can be sold for a $275 profit. Each alternator requires 3 hours of wiring and 3 hours of testing and can be sold for a $190 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period and Electrotech wants to maximize profit. Formulate the LP model for this problem.
Algebra for College Students
10th Edition
ISBN:9781285195780
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Jerome E. Kaufmann, Karen L. Schwitters
Chapter12: Algebra Of Matrices
Section12.CR: Review Problem Set
Problem 37CR
Related questions
Question
The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each generator requires 3 hours of wiring and 2 hour of testing and can be sold for a $275 profit. Each alternator requires 3 hours of wiring and 3 hours of testing and can be sold for a $190 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period and Electrotech wants to maximize profit.
- Formulate the LP model for this problem.
- Create the spreadsheet model and use Solver to solve the problem.
SOLVE THIS PROBLEM USING EXCEL ,PLEASE.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
Recommended textbooks for you
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning