Develop a spreadsheet model in Excel to estimate breakeven quantities to cover fixed and total costs...

Transcribed Image Text:

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: Data Results Selling price ($/case) $XX.XX Total Revenue $xxx Annual Fixed Cost $XX.XXX.XX Total Fixed Costs $xxx Production Cost ($/case) $xx.xx Returns above Fixed $xxx Costs Marketing Fee (% of price) XX% Production Costs $xxx Marketing Fee ($/case) $XX.XX Marketing Costs $xxx Shipping Cost ($/case) $XX.XX Shipping Costs $xxx Sales Forecast (cases) XXX Total Variable Costs $xxx Total Costs $xxx Variable Cost per Unit ($/case) $XX.XX Net Profit (Loss) $xxx Fixed Cost per Unit ($/case) $XX.XX Net Profit per Unit ($/case) $XX.XX Total Cost per Unit ($/case) $XX.XX Break-Even Quantity: BE to cover Fixed Costs XXXX Production Quantity (cases) XXX-X BE to cover Total Costs XXXX 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: Data Results Selling price ($/case) $XX.XX Total Revenue $xxx Annual Fixed Cost $XX.XXX.XX Total Fixed Costs $xxx Production Cost ($/case) $xx.xx Returns above Fixed $xxx Costs Marketing Fee (% of price) XX% Production Costs $xxx Marketing Fee ($/case) $XX.XX Marketing Costs $xxx Shipping Cost ($/case) $XX.XX Shipping Costs $xxx Sales Forecast (cases) XXX Total Variable Costs $xxx Total Costs $xxx Variable Cost per Unit ($/case) $XX.XX Net Profit (Loss) $xxx Fixed Cost per Unit ($/case) $XX.XX Net Profit per Unit ($/case) $XX.XX Total Cost per Unit ($/case) $XX.XX Break-Even Quantity: BE to cover Fixed Costs XXXX Production Quantity (cases) XXX-X BE to cover Total Costs XXXX