Your are a Assistant Restaurant Manager and have been recent…
Your are a Assistant Restaurant Manager and have been recently hired to assist GM to run the restaurant more efficiently. As shown below, you are setting goals to bring 3.1% more Total Sales. Also, you set the goals to have Beverage Sales to contribute 27% of Total Sales. Other goals that you set were 34, 29.5, 43, and 19.30% respectively. Complete the budget spreadsheet below by filling out yellow-highlighted cells. Your work of calculations on the spreadsheet should be made with MS Excel formulas and corresponding cells. Any changes made in prediction should be reflected on the results. Please be noted that simply typing numbers as text won’t be awarded any points. Download the file below and complete budgeting by Horizontal and Vertical Analysis technique. Financial Analysis Budgetring.xlsx
Read Details