Question: 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
Get step-by-step solutions from verified subject matter experts
