Question: must show work through excel pls. Also please list the maximum profit, standard, and duluxe models #s. Billy Penny is trying to determine how many

must show work through excel pls. Also please list the maximum profit, standard, and duluxe models #s.
must show work through excel pls. Also please
Billy Penny is trying to determine how many units of two types of lawn mowers to produce each day. One of these is the Standard model, while the other is the Deluxe model. The profit per unit on the Standard model is $60, while the profit per unit on the Deluxe model is $40. The Standard model requires 20 minutes of assembly time, while the Deluxe model requires 35 minutes of assembly time. The Standard model requires 10 minutes of inspection time, while the Deluxe model requires 15 minutes of the inspection time. The company must fill an order for 6 Deluxe models. There are 450 minutes of assembly time and 180 minutes of inspection time available each day. Billy Penny is to determine the best possible combination of Standard model and Deluxe model to manufacture in order to reach the maximum profit. Formulate this as a linear programming problem and find the solution that gives the maximum profit. By using Excel Solver, the obtained maximum profit is $ by producing Standard and Deluxe models. Instruction for" Fill in Multiple Blanks" questions: 1. In order to receive FULL credit, you must submit an Excel file to justify your answers by writing the complete LP model and solving the problem using Excel Solver. 2. If you only filled the blanks correctly without submitting an EXCEL file, you will receive a zero on these questions

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 General Management Questions!