Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Slove Lady M Break Even Excel with formulas YEAR ONE Break-even Rent $ 310,600.00 Utilities $ 38,644.00 Labor $ 594,750.00 COGS (50% of Gross Sales)
Slove Lady M Break Even Excel with formulas
YEAR ONE | ||||||
Break-even | ||||||
Rent | $ 310,600.00 | |||||
Utilities | $ 38,644.00 | |||||
Labor | $ 594,750.00 | |||||
COGS (50% of Gross Sales) | $ 944,620.00 | |||||
Total Cost | $ 1,888,614.00 | |||||
Gross Sales | $ 1,889,240.00 | |||||
Average Retail per Cake | $ 80.00 | |||||
Cakes Sold per year | 23,616 | |||||
Cakes Sold per day | 64.7 | |||||
Net Income | $ 626.00 | |||||
Margin | 0.03% | Growth Rate | ||||
Year One | Year Two | Year Three | Year Four | Year Five | ||
Rent (3% escalation) | $ 310,600.00 | |||||
Utilities (3% escalation) | $ 38,644.00 | |||||
Labor (5% escalation) | $ 594,750.00 | |||||
COGS (50% of Gross Sales) | $ 944,620.00 | |||||
Total Cost | $ 1,888,614.00 | |||||
Gross Sales | $ 1,889,240.00 | |||||
Average Retail per Cake | $ 80.00 | |||||
Cakes Sold per year | 23,616 | |||||
Cakes Sold per day | 64.7 | |||||
Net Income | $ 626.00 | |||||
Margin | 0.03% | |||||
Start-up Cost Left | $ 999,374.00 | |||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started