Question: Need solution to question B. Please solve using excel! Problem 2. AVA, Inc. wants to determine the amount of each of two products to produce
Need solution to question B. Please solve using excel!
Problem 2. AVA, Inc. wants to determine the amount of each of two products to produce over the coming planning period. The following information regarding labor availability, labor utilization, and product profitability are shown below. Required Time (minutes/unit) Department Product 1 Product two Labor - Hours Available A 1525500 B 3020400 C 1040300 Profit contribution/unit $60.00$50.00 a. Develop a linear programming model of SABA, Inc.'s problem. Solve the model to determine the optimal production quantities of products 1 and 2. b. Suppose that 40, 30, and 20 hours of overtime may be scheduled in departments A, B, and C, respectively. The cost per hour of overtime is $15 in department A, \$20 in department B, and \$30 in department C. Formulate a linear programming model that can be used to determine the optimal production quantities if overtime is made available. Solve your model and find the optimum solution
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
