Will thumbs up if solved quickly!!!

Needed urgent!!!

Use Excel to do problem #1 on worksheet 57 and answer correctly.

Seall Manufacturing Company makes television sets. It produces a bargain set that yields $100 profit and a

deluxe set that yields $150 profit. On the assembly line the bargain set requires 3 hours and the deluxe set

takes 5 hours. The cabinet shop spends 1 hour on the cabinet for the bargain set and 3 hours on the cabinet

for the deluxe set. Both sets requires 2 hours of time for testing and packing. On a particular production

run, the Seall Company has available 3900 work hours on the assembly line, 2100 work hours in the cabinet

shop, and 2200 work hours in the testing and packing department. How many sets of each type should Seall

Manufacturing produce to make maximum profit? What is the maximum profit?

Answer:

Seall Manufacturing should produce 800 Bargain sets and 300 Deluxe sets to maximize

profit. The maximum profit is $125,000.

The photos below shows the instructions (sample example) for solving problem #1 on worksheet 57

8:44 HD SU 8:44