Old MathJax webview

pls answer all the questions and fill the table ASAP

Practice Quiz 1 b Sales Forecast July 2021 HRM 1016 Please study the Restaurant Sales summary & the popularity ratio for July 2019 provided and estimatethe sales summary per week and thetotal revenue for the month of July 2020 Using the comments below. Based on the calculation, answer the following questions Restaurant Sales Summary for the month of July 1 - 31, 2021 s. No 1st week 2nd week 3rd week 4th week Total Sold Pop. % S.P. Menu Item 1 T-Bone Steak 2 Salmon in Whitewine Sauce 3 Cheeseburger 4 Spaghetty Bolognaise (pasta) 5 fettuccini Alferado (pasta) 6 Macaroni & Cheese 7 Barbecued Chicken Breast 8 Fish N Chips $ $ $ $ $ $ $ Tt. Sale 18.00 $ 15.00$ 9.00 $ 10.50 $ 8.50 $ 8.50 $ 13.50 $ 17.00 $ Total Sold $ using the sales summary above, create a forecast for the month of July, 2021, Keeping in mind that due to. COVID 10 virus the business might drop by about 20% in this year. You may use a blank format provided for calculating the forecast for March 2021. Usung the New forecast, calculate the following: 1. Cost of average Cover $ 2. Average number of covers per day 3. The Restaurant has only 40 seats, what is the Restaurant Turnover /day? 4. If our food cost % is 33%, what is the cost of food sold? $ Quiz # 1 Max Marks 30 Grades Pop. Ratio & Sales analysis HRM 1016 10% Please study the following Restaurant Sales summary and calculate the popularity ratio of Various Food items listed. The Restaurant is in the process of revising its Menu. Based on the popularity ratio, please recommend which two items could be deleted from the Menu, please provide justification for your recommendation. Based on the calculation, answer the following questions Restaurant Sales Summary for the month of February, 2020. S.No. Menu Item 1 Sirloin Steak 2 Salmon in Whitewine Sauce 3 Club House Sandwich 4 Spaghetty Bolognaise (pasta) 5 fettuccini Alferado (pasta) 6 Macaroni & Cheese 7 Chicken Burger & Fries 8 Fish N Chips 1st week 2nd week 3rd week 4th week 240 183 168 115 941 132 210 190 198 94 77 84 85 32 47 44 25 48 51 32 42 52 26 54 Total Sold Pop. % S.P. Tt. Sale 93 684 22.3% $ 18.00 $ 12,312.00 120 461 15.0% $ 15.00 $ 6,915.00 216 814 26.6% $ 9.00 $ 7,326.00 98 353 11.5% $ 10.50 $ 3,706.50 70 234 7.6% $ 8.50 $ 1,989.00 58 1751 5.7% $ 8.50 $ 1,487.50 44 169 5.5% $ 13.50 $ 2,281.50 43 175 5.7% $ 17.00 $ 2.975.00 Total Sold 891) 659 773 7421 30651 $ 38,992.50 Items to be deleted: _1. Fish N Chips 2. Macaroni & Cheese Justification: even though the lowest popularity % is Chicken Burger, look at the menu, this is the only Chicken item on the Menu, it would be wise not to delete it. Next Lowest % is Fish N Chips & Macaroni, we have 2 Fish items & 3 Pasta items on the Menu, it there fore make more business sense to remove these 2 items. 1. Cost of average Cover $ Toal revenue / number of covers : 38,992.50/3065 =$12.72 2. Average number of covers per day Totalcovers / days in the month : 3065/29 = 105 3. The Restaurant has only 60 seats, what is the Restaurant Turnover /day? Covers served per day / number of seats 105 / 60 = 1.76 4. If our food cost % is 33%, what is the cost of food sold? Cost of food = Food sales X FC % / 100: 38,992.50 X 33 / 100 = 12,867.52