Problem 2 (30 points) Can and Deniz, Inc. (C&D) manufactures three different products: Standard (ST), Superior (Sup), and Premium (PR). C&D just received a new order for all of the products: 300 units of ST; 700 units of Sup; and 400 units of PR. Currently, there is no inventory of any of the products. All three products require special processing that can be conducted on one of the two machines. The cost of producing each product on each machine is summarized in the following table: Cost of Producing a Unit of Product ST Sup $1.60 $1.80 $1.20 $2.40 Machine 1 Machine 2 PR $2.00 $1.60 The time required to produce each product on each machine is summarized in the following table: Time (Hours) Needed to produce a Unit of Product ST Sup 0.2 0.40 0.25 0.60 Machine 1 Machine 2 PR 0.50 0.70 The available hours for Machine 1 and Machine 2 are 300 hours and 350 hours, respectively. Part a: (30 pts) Develop a spreadsheet model for calculating the optimal production plan for these three products. Please adhere to the spreadsheet engineering principles and show all your work (formulas). What is the optimal production plan to meet the demand? Part b: (10 pts) Please comment on the marginal value (shadow price) of available hours for Machine 1 and Machine 2. If you have the opportunity to increase the capacity of one machine, which machine's capacity would you increase? By How much? How much benefit (cost reduction) this capacity change would bring to C&D Inc.? Please explain in detail