Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can someone answer any of these please Consider the following details for a production process that manufactures four types of products (A, B, C, and
can someone answer any of these please
Consider the following details for a production process that manufactures four types of products (A, B, C, and D). Each workstation ( V,W,X,Y, and Z) is available for 40 hours per week. The operations manager realizes that it will not be possible to meet the demands as shown below. The manager determines the updated/feasible product mix using the "traditional" method as well as the "bottleneck" method. Please answer the following questions. Numbers above in minutes/unit Numbers above in dollars/unit Mats refers to the "Materials Cost." Q18: Based on your calculations, how much more weekly profit (in \$) would be made using the bottleneck method versus the traditional method? Please enter only the numeric value rounded off to two places of decimal, if needed, below. [2 points] Q19: Please briefly describe your solution steps for the the product mix related question above. Now, solve the above-described product mix question using the linear programming method. Using "Solver," please generate the sensitivity report for the optimal solution. Based on this sensitivity report (and your understanding of the related concepts), please answer the following questions. Q20: Which of the following stations has the largest amount of slack in their production constraint? [1 point] Station V Station Z Q21a: By how much (in \$) will the profit improve if we enhance the availability of Station X by 100 minutes? Please enter only the numeric value rounded off to two places of decimal, if needed, below. [1 point] Q21b: For the question above, please briefly explain how you obtained your answer by just reading the sensitivity report. (Word limit: 200 characters) Q22a: Say, we increase the price of product type B by $10. What would be the total weekly profit (in \$) that the production firm can make now by using the optimal product mix? Please enter only the numeric value rounded off to two places of decimal, if needed, below. [1 point] Q22b: For the question above, please briefly explain how you obtained your answer by just reading the sensitivity report. (Word limit: 200 characters) Consider the following details for a production process that manufactures four types of products (A, B, C, and D). Each workstation ( V,W,X,Y, and Z) is available for 40 hours per week. The operations manager realizes that it will not be possible to meet the demands as shown below. The manager determines the updated/feasible product mix using the "traditional" method as well as the "bottleneck" method. Please answer the following questions. Numbers above in minutes/unit Numbers above in dollars/unit Mats refers to the "Materials Cost." Q18: Based on your calculations, how much more weekly profit (in \$) would be made using the bottleneck method versus the traditional method? Please enter only the numeric value rounded off to two places of decimal, if needed, below. [2 points] Q19: Please briefly describe your solution steps for the the product mix related question above. Now, solve the above-described product mix question using the linear programming method. Using "Solver," please generate the sensitivity report for the optimal solution. Based on this sensitivity report (and your understanding of the related concepts), please answer the following questions. Q20: Which of the following stations has the largest amount of slack in their production constraint? [1 point] Station V Station Z Q21a: By how much (in \$) will the profit improve if we enhance the availability of Station X by 100 minutes? Please enter only the numeric value rounded off to two places of decimal, if needed, below. [1 point] Q21b: For the question above, please briefly explain how you obtained your answer by just reading the sensitivity report. (Word limit: 200 characters) Q22a: Say, we increase the price of product type B by $10. What would be the total weekly profit (in \$) that the production firm can make now by using the optimal product mix? Please enter only the numeric value rounded off to two places of decimal, if needed, below. [1 point] Q22b: For the question above, please briefly explain how you obtained your answer by just reading the sensitivity report. (Word limit: 200 characters) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started