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
icon
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.

  1. Formulate the LP model for this problem.
  2. Create the spreadsheet model and use Solver to solve the problem.

SOLVE THIS PROBLEM USING EXCEL ,PLEASE.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Recommended textbooks for you
Algebra for College Students
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax