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 time and 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?

1. Create a spreadsheet that represents this model and determine the optimal solution using EXCEL™ Solver. Name your spreadsheet tab
   Q1.
2. Create and save the answer report created by the EXCEL solver. Name the Tab
   A1 .
3. How many of each product should be produced?
4. What is the expected profit from this solution?

Price: $2.99

Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document