Problem Parker Sisters produces two types of electric devices Electric Device A and Electric Device B One item of Device A requires 2 hours of wiring, 1 hour of testing and 2 hours to assemble One item of Device B requires 1 hour of wiring, 1 hour of testing and 5 hours to assemble Available hours are 160 for wiring, 100 for testing and 400 for assembly Device A unit profit is 70$ and Device B unit profit is 40$ PART A Create a mathematical model of the problem and solve it using Excel Solver or QM for windows Upload the file on Moodle together with its sensitivity report (Assume fractional results are allowed) (20 pts) PART B Answer each of the below questions with relevant explanation Upload a single word file on Moodle Make sure you indicate each answer corresponding to which question number (Total 30 pts) Define all decision variables Make sure to indicate the units of variable values (2 pts) Write an objective function and explain its meaning briefly (2 pts) Write all constraints and explain their meaning briefly (2 pts) Write the optimal solution and the optimal objective function value that were determined by the Excel Solver or QM for windows Write an interpretation of the result (4 pts) Based on the sensitivity analysis report ( Note each part is independent ) Which constraints are binding and which are non binding Explain your response (2 pts) Calculate the slack for the non binding constraint(s) Explain your response (2 pts) What is the marginal value of one more hour of wiring Explain your response (2 pts) What is the marginal value of one more hour of assembly Explain your response (2 pts) If the per unit profit of device B increased to $50, what is the optimal product mix, and what is the companys total profit Explain your response (2 pts) If the per unit profit of device A is $55 instead of $70, what is the optimal product mix and optimal profit Explain your response (2 pts) If an employee takes a day off and now we only have 92 hours of testing Is it possible to find the optimal decision and profit without resolving the LP If so, find the optimal decision and profit Explain your response (2 pts) We are considering manufacturing a new device (Device C) along with devices A and B Device C requires 2 5 hours of wiring, 2 hours of testing and 8 hours to assemble Device C unit profit is 80$ Would you recommend manufacturing Device C Explain your response (2 pts) We are considering manufacturing a new device (Device D) along with devices A and B Device D requires 1 hour of wiring, 2 hours of testing and 5 hours to assemble What profit must this device generates in order to make it worthwhile to produce Explain your response (2 pts) The R D department has been redesigning device B to make it more profitable The new design requires 1 hour of wiring, 1 hour of testing and 3 hours to assemble If the company can sell one of these devices at a net profit of $35, should it approve the new design Explain your response (2 pts)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 04, 2024

Problem: Parker Sisters produces two types of electric devices: Electric Device A and Electric Device B . One item of Device A requires 2 hours

Problem: Parker Sisters produces two types of electric devices: Electric Device A and Electric Device B. One item of Device A requires 2 hours of wiring, 1 hour of testing and 2 hours to assemble. One item of Device B requires 1 hour of wiring, 1 hour of testing and 5 hours to assemble. Available hours are 160 for wiring, 100 for testing and 400 for assembly. Device A unit-profit is 70$ and Device B unit-profit is 40$.

PART A: Create a mathematical model of the problem and solve it using Excel Solver or QM for windows. Upload the file on Moodle together with its sensitivity report. (Assume fractional results are allowed). (20 pts)

PART B: Answer each of the below questions with relevant explanation. Upload a single word file on Moodle. Make sure you indicate each answer corresponding to which question number. (Total 30 pts)

Define all decision variables. Make sure to indicate the units of variable values. (2 pts)
Write an objective function and explain its meaning briefly. (2 pts)
Write all constraints and explain their meaning briefly. (2 pts)
Write the optimal solution and the optimal objective function value that were determined by the Excel Solver or QM for windows. Write an interpretation of the result. (4 pts)
Based on the sensitivity analysis report (Note: each part is independent):
1. Which constraints are binding and which are non-binding? Explain your response. (2 pts)
2. Calculate the slack for the non-binding constraint(s). Explain your response. (2 pts)
3. What is the marginal value of one more hour of wiring? Explain your response. (2 pts)
4. What is the marginal value of one more hour of assembly? Explain your response. (2 pts)
5. If the per-unit profit of device B increased to $50, what is the optimal product mix, and what is the companys total profit? Explain your response. (2 pts)
6. If the per-unit profit of device A is $55 instead of $70, what is the optimal product mix and optimal profit? Explain your response. (2 pts)
7. If an employee takes a day off and now we only have 92 hours of testing. Is it possible to find the optimal decision and profit without resolving the LP? If so, find the optimal decision and profit. Explain your response. (2 pts)
8. We are considering manufacturing a new device (Device C) along with devices A and B. Device C requires 2.5 hours of wiring, 2 hours of testing and 8 hours to assemble. Device C unit profit is 80$. Would you recommend manufacturing Device C? Explain your response. (2 pts)
9. We are considering manufacturing a new device (Device D) along with devices A and B. Device D requires 1 hour of wiring, 2 hours of testing and 5 hours to assemble. What profit must this device generates in order to make it worthwhile to produce? Explain your response. (2 pts)
10. The R&D department has been redesigning device B to make it more profitable. The new design requires 1 hour of wiring, 1 hour of testing and 3 hours to assemble. If the company can sell one of these devices at a net profit of $35, should it approve the new design? Explain your response. (2 pts)