Question: Develop a spreadsheet model in Excel to estimate breakeven quantities to cover fixed and total costs as well as projected net returns for the

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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
