Question: You have one hour to formulate the linear program, buildi it in excel, and solve. The Alpha Beta Corporation makes laser and ink jet printers

You have one hour to formulate the linear program, buildi it in excel, and solve. The Alpha Beta Corporation makes laser and ink jet printers for personal computers. Each laser printer yields $40.00 in profits and each ink jet printer provides $20.00. Each of the printers goes through two assembly areas. The following table provides processing times per unit (in minutes) as well as total available processing times per department: Dept B 128 Printer Dept A 9 laser ink jet total time per day 6222384 Sales commitments require at least 5 laser printers and 10 ink jet printers to be made per day. The company is interested in determining how many of each printer to produce so as to maximize its profit. 1. Formulate this problem as an LP.2. Build the model in excel 3. What is the optimal solution? Submit one excel file that has the written linear program, the model with a solution using Excel Solver and a conclusion on what the optimal solution is.

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 Accounting Questions!