A marketing company is planning with sales activity for next quarter for their product A. The fixed cost to launch the product is $180,000.00. Variable processing costs are estimated to be $9.00 per product A. The targeted sales price per product A is $52. a. Build a spreadsheet model to calculate the profit/loss for a given demand b. What is the profit expected with a demand of 12000 units of product A? c. Use data table to vary demand from 1000 to 20000 in increments of 1000 . Between what sales volume range does the returns change from loss to profit? d. Use goal seek to determine the selling price per copy if the marketing company expects to be break even with a demand of 4000 units of product A. e. Consider the following scenarios. Calculate the profit for each scenario using scenario manager