Question I. 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: case Annual fixed cost $120,000.00 Production cost $125.00 per case Marketing fee 3.0% of selling price Shipping cost $19.00 per 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: I Selling price ($/case) Data $xx.xx Results Total Revenue $xxx Annual Fixed Cost $xx,xxx.xx Total Fixed Costs $xxx Production Cost ($/case) $xx.xx Returns above Fixed Costs $xxx Marketing Fee (% of price) x.x% Production Costs $xxx Marketing Fee ($/case) $XX.XX Marketing Costs $xxx Shipping Cost ($/case) Sales Forecast (cases) $xx.xx Shipping Costs $xxx XXX Total Variable Costs $XXX Total Costs $xxx Variable Cost per Unit ($/case) Fixed Cost per Unit ($/case) $xx.xx Net Profit (Loss) $xxx $xx.xx Net Profit per Unit ($/case) $XX.XX Total Cost ner Init ($/casell Svv vv Break-Even Quantity