Exam 2 EXCEL/SOLVER Complete the excel spreadsheet and run solver to calculate the solutions. 26) A production manager wants to determine how many units of each product to produce weekly to maximize weekly profits. Production requirements for the products are shown in the following table. What is the optimal number of units for each product and the maximum profit? Complete the excel spreadsheet and run solver to calculate the solution. (25pts) Product A Product B Product C Maximum Available Material 1 Material 2 Selling Price per unit Material Cost per unit 3 pound s per unit 2 pound s per unit $101 1 pound s per unit 4 pound s per unit $67 5 pound s per unit 0 pound s per unit $97.50 300 pounds $31 $27 $35 a) Product A units: ___________ b) Product B units: ___________ 400 pounds c) Product C units: ___________ d) Maximum Profit: ___________ 27) Apple makes three models of the iPOD (Shuffle, Nano, and Touch). The selling prices per unit are $49, $149 and $229, respectively for each model. Apple manufactures these three versions at labor cost per unit of $5, $10 and $12, respectively for each model. Each model has increasing amount of memory (GB). The Shuffle has 2GB, Nano has 16GB and the Touch has 64GB. A GB of memory has an electronic material cost of $2. If Apple only has 30,000 GB of electronic memory material available per month how many of each iPOD model should be produce to maximize the total profit? Complete the excel spreadsheet and run solver to calculate the solution. (25pts) a) Shuffle units: __________ b) Nano units: __________ c) Touch units: __________ d) Maximum Profit: __________