PLEASE USE EXCEL FOR YOUR ANSWER

YSE SOLVER TO MAKE THE REPORT TOO.

The times in minutes) required on each machine are as follows: Component Shaper Grinder 1 6 4 2 4 5 3 4 4. 2 The shaper is available for 120 hours, and the grinder is available for 110 hours. No more than 200 units of component 3 can be sold, but up to 1000 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, $6, and $9, respectively. a. Formulate and solve for the recommended production quantities. b. What are the optimal production quantities and the optimal profit? c. If more time could be made available on the grinder, how much would it be worth? What to submit: Final submission must be an Excel file with answers to the above questions. Please follow the format of the example provided in the Excel Lab