Need to be answered in excel template and do one with the solution and other with formulas

PART II: EXCEL APPLICATION 26) 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 an 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 produced to maximize the total profit? Complete the excel spreadsheet and run the solver to calculate the solution and answer the following questions I a) Shuffle units: bj Nano units c Touch units d) Maximum Profit: Submission