Question: Mr. Nick "Last Out" Nugent is the production manager for the Sappadilla Manufacturing Company. Mr. Nugent is faced with the task of making a decision on the best allocation of production tiMeand raw materials to two new products that the company is planning to introduce. The products (which have been designated as products X and Y by the R&D department) both can be produced on a certain machine. There are 12 hours of machine time available (per week) to produce these products. Product X requires 1 hour of machine time per unit, and product Y requires 3 hours per unit. Both products require one raw material: Product X uses 4 pounds per unit, and Product Y uses 3 pounds. There are 24 pounds of the raw material available (per week). If the goal is to maximize the contribution to profit from manufacturing these products and Product X contributes $4 per unit and Product Y contributes $5 per unit, what quantity of each should Mr. Nugent produce?

a. Create a spreadsheet that represents this model and determine the optimal solution using EXCEL™ Solver. Name your spreadsheet tab

b. Create and save the answer report created by the EXCEL solver. Name the Tab

c. How many of each product should be produced?

d. What is the expected profit from this solution?