Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a business memo answering this question using the excel information Assignment Summc #1 Create a sumn (?) Tell me more statement of your new
Write a business memo answering this question using the excel information
Assignment Summc \#1 Create a sumn (?) Tell me more statement of your new restuarnt (using the information above). Hint: Any variables mentioned above should be setup in a way that easy to update and change as needed \#2 Make a recommendation on what average wage you will need to pay team members in order to achieve a 10% restaurant cashflow at the store (Hint Use Solver Function) \#3 What is the highest average hourly rate we can pay employees before the restaurant will become unprofitable? (Hint Use Solver Function) \#4 If 100% of employees decide to contribute to their 401ks how will this effect the companies profitability? \#5 Create a Scenario Analysis Output by looking at the starting AWS (looking from $25k to $40k by every $1000 dollars). For the columns look at the average team wage from $10 to $15 an hour (by every $0.50 cents) that shows the restaurant cashflow under each scenario
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