Question: Pleas solve via excel Problem 1: 20 Points The Elon Engineering manufactures two industrial sized electrical motors: Alset I and Alset 11. Both of these

Pleas solve via excel

 Pleas solve via excel Problem 1: 20 Points The Elon Engineering

Problem 1: 20 Points The Elon Engineering manufactures two industrial sized electrical motors: Alset I and Alset 11. Both of these products require wiring and testing during the assembly process. Each Alset I motor requires 5 hours of wiring and 1 hour of testing and can be sold for a $250 prot. Each Alset 11 motor requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 prot. The company has 260 hours of wiring time and 140 hours of testing time available in the next production period. Due to a backlog, at least 50 Alset II motors are required to be produced. Problem 2: 20 Points Scotts' Scooters manufactures produces two popular scooters: the Blazer and the Boomer. In the coming week, the company wants to produce at least 500 scooters. Each Blazer produced results in a unit cost of $70, and each Boomer results in a unit cost of $40. The scooters are identical mechanically and differ only in the appearance of the plastic trim around the fenders and seat. Each Blazer's trim requires 2 pounds of plastic and 3 hours of production time, and each Boomer's trim requires 1 pound of plastic and 8 hours of production time. The company has 900 pounds of plastic and 2400 hours of labor hours available for the next production period

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!