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 manufacture 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.
a) Shuffle units: __________
b) Nano units: __________
c) Touch units: __________
d) Maximum Profit: __________