3. (18 pts) Cal-Bees is considering manufacturing a tablet. The fixed cost is estimated to be $550,000. Variable manufacturing costs are estimated to be $125 per tablet. Cal-Bees plans to sell a tablet for $249. a) Build a spreadsheet model to calculate the profit/loss for a given demand. What profit (loss) can be anticipated with a demand of 24,000 tablets? (Create an excel spreadsheet Q3a) b) Use a one-way data table to vary demand from 12,000 to 32,000 in increments of 5,000 to assess the sensitivity of profit to demand. (Create an excel spreadsheet Q3b) c) Use a two-way data table to assess the sensitivity of profit to demand and selling price. (Create an excel spreadsheet Q3c) i. Demand varies from 8,000 to 48,000 in increments of 5,000 (in column) ii. Selling price varies from $219 to $319 in increments of $20 d) Use Goal Seek to determine the demand that the CAL-Bees must produce (find the quantity) to break-even? (Create an excel spreadsheet Q3d - Use Goal-Seek in Excel) e) Consider the following scenarios: Scenario 1 Scenario 2 Scenario 3 Scenario 4 Variable Cost per Tablet $125 $95 $149 $170 Selling Price $249 $275 $299 $350 Demand 24,000 12,000 35,000 10,000 For each of these scenarios, the fixed cost remains $550,000. Use Scenario Manager to generate a summary report that gives the profit for each of these scenarios. Which scenario yields the highest profit? Which scenario yields the lowest profit? (Create an excel spreadsheet Q3e - Use Scenario Manager in Excel)