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 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Each alternator requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 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.

Answer 1

(b) Here we have to use solver to solve the given problem.According to solver, if we want to maximize the profit we will make 130 generators and 0 alternators.

	Generators	Alternators	Total Contribution	Available capacity
Decision variables	130 (as per solver)	0 (as per solver)
Contribution	$250 (selling price profit of an generator)	$150 (selling price profit of an alternator)	(130*250) =$32500
Wiring	2(number of hours required for wiring)	3(number of hours required for wiring)	260(required time to manufacture next generators)	260
Testing	1(number of hours required for testing)	2(number of hours required for testing)	130( consider as per solver)	140(required time to manufacture next generators)