Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A B D E F 1 Pop. Ratio & Sales analysis P Quiz # 1 Max Marks 30 2 HRM 1016 3 4 Please study

image text in transcribed
image text in transcribed
A B D E F 1 Pop. Ratio & Sales analysis P Quiz # 1 Max Marks 30 2 HRM 1016 3 4 Please study the following Restaurant Sales summary and calculate the popularity ratio 5 of Various Food items listed. The Restaurant is in the process of revising its Menu. Based 6 on the popularity ratio, please recommend which two items could be deleted from the Menu, 7 please provide justification for your recommendation. 8 Based on the calculation, answer the following questions 9 Restaurant Sales Summary for the month of February, 2020. 10 11 s.No Menu Item 12 1 Filetmignon 13 2 Grilled Trout 14 3 Club House Sandwich 15 4 Spaghetty Bolognaise (pasta) 16 5 fettuccini Alferado (pasta) 17 6 Macaroni & Cheese 18 7 Barbecued Chicken & Fries 8 Fish N Chips Total Sold 69222 19 20 21 4 Sheet1 Sheet2 Sheet3 890 12 e G H Grades 1 1st week 2nd week 3rd week 4th week Total Sold Pop. % S. P. Tt. Sale 210 205 178 120 $ 20.00 $ 126 105 122 148 $ 16.00 $ 188 198 176 210 $ 9.00 $ 120 68 92 106 $11.00 $ 96 47 59 70 $ 8.50 $ 44 25 48 81 $ 9.50 $ 48 50 42 47 $ 12.50 $ 58 30 32 44 $ 16.00 $ 728 749 826 S 10% - 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 A C D 890 E F B Total Sold 728 749 Items to be deleted: 1. 2. Justification: 1. Cost of average Cover $ 2. Average number of covers per day 3. The Restaurant has only 80 seats, what is the Restaurant Turnover /day? 4. If our food cost % is 36%, what is the cost of food sold? 826 G H $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Intelligence For IT Professionals

Authors: Karen Berman, Joe Knight, John Case

1st Edition

1422119149, 9781422119143

More Books

Students also viewed these Finance questions

Question

Answered: 1 week ago

Answered: 1 week ago

Question

Why must in-service training or on-the-job education be continuing?

Answered: 1 week ago