Question 1. Problem Statement: A company is evaluating the production and sale of a new product. The projected wholesale selling price of the product is $225.00 per case. Fixed costs and variable costs (production, marketing, shipping) anticipated to be incurred in the production of this new product are estimated as follows: Annual fixed cost = $120,000.00 Marketing fee = 3.0% of selling price Production cost = $125.00 per case Shipping cost = $19.00 per case Develop a spreadsheet model in Excel to estimate breakeven quantities to cover fixed and total costs as well as projected net returns for the sales forecast of 2,000 cases in the following format: Results $xxx $xxx $xxx Data Selling price ($/case) $xx.xx Annual Fixed Cost $xx.XXX.XX Production Cost ($/case) $XX.XX Marketing Fee (% of price) x.x% Marketing Fee ($/case) $xx.xx Shipping Cost ($/case) $xx.xx Sales Forecast cases) Variable Cost per Unit $xx.xx ($/case) Total Revenue Total Fixed Costs Returns above Fixed Costs Production Costs Marketing Costs Shipping Costs Total Variable Costs Total Costs Net Profit (Loss) $xxx $xxx $xxx $xxx $xxx $xxx XXX Fixed Cost per Unit ($/case) $xx.xx $xx.xx Net Profit per Unit ($/case)