Answered step by step
Verified Expert Solution
Question
1 Approved Answer
create a spreadsheet of a report showing the sales, expenses, and profit for a restaurant utilizing markup rates. Create a chart showing sales. the beverage
create a spreadsheet of a report showing the sales, expenses, and profit for a restaurant utilizing markup rates. Create a chart showing sales. the beverage sales are 25% of food sales, beverage cost is 5% of beverage sales. in the expenses section: Utilities is 5% of total sales, Payroll is 30% of total sales, Direct is 25% of payroll.
$ 5,000 Start-up Costs Purchase materials Licenses, fees and permits Kitchen supplies New stove and other appliances Remodeling and Improvements to the building Furniture $ $ $ $ 2,500 5,000 20,000 100,000 30,000 $ Misc. $ 25,000 Total SALES Year 1 2 3 4 5 6 Food $ 40,000 $ 80,000 $ 120,000 $ 140,000 $ 160,000 $ 180,000 Beverage Total Sales EXPENSES $ Food Beverage Payroll Lease Utilities $ $ $ $ $ $ $ $ $ $ $ $200/month $ $ $ $ $ $ Direct $ Total Expens: $ $ $ $ $ $ $ $ $ $ $ Annual Profit $ $ $ Cumulative Pr $ $ Markup Rates (based on selling price) Food 80% Beverage 90% Financial Analysis 7% 8% 6% 9% Discount Rate NPV Sales Forecast Breakeven Point 8 Year Month o $ 5,000 Start-up Costs Purchase materials Licenses, fees and permits Kitchen supplies New stove and other appliances Remodeling and Improvements to the building Furniture $ $ $ $ 2,500 5,000 20,000 100,000 30,000 $ Misc. $ 25,000 Total SALES Year 1 2 3 4 5 6 Food $ 40,000 $ 80,000 $ 120,000 $ 140,000 $ 160,000 $ 180,000 Beverage Total Sales EXPENSES $ Food Beverage Payroll Lease Utilities $ $ $ $ $ $ $ $ $ $ $ $200/month $ $ $ $ $ $ Direct $ Total Expens: $ $ $ $ $ $ $ $ $ $ $ Annual Profit $ $ $ Cumulative Pr $ $ Markup Rates (based on selling price) Food 80% Beverage 90% Financial Analysis 7% 8% 6% 9% Discount Rate NPV Sales Forecast Breakeven Point 8 Year Month oStep 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