Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer this question CHAPTER 7 You manage a restaurant that serves a variety of 5 different main dishes, from various national cuisines. In order

please answer this question

image text in transcribed
CHAPTER 7 You manage a restaurant that serves a variety of 5 different main dishes, from various national cuisines. In order to have enough inventory on hand, you have decided to create an inventory system. The first part of that will be statistical calculations about how many servings of each main dish are sold, each day of the week. Data are as follows (for the most recent two weeks): Day Roast Beef Chili Lasagna Bun Cha Escargots Mon 1 23 14 32 28 10 Tues 1 20 18 29 35 8 Wed 1 18 12 25 27 14 Thurs 1 25 15 30 22 18 Fri 1 34 25 33 30 15 Sat 1 42 33 40 37 20 Sun 1 34 30 35 32 17 Mon 2 25 17 26 27 Tues 2 21 20 30 25 12 Wed 2 16 14 26 19 15 Thurs 2 23 21 36 28 13 Fri 2 33 29 42 31 15 Sat 2 36 33 39 30 19 Sun 2 29 24 31 22 13 Enter these data into an Excel spreadsheet, with the same rows and columns as presented above. Provide a column for the total of each row, and a row for the total of each column, and a total of totals in the far right corner. Also provide a row of average amount sold for each main dish. Properly program Excel to calculate these row and column totals, as well as the row of averages. Then, answer the following questions: a. Which dish was the most popular one served, during these two weeks? b. Which dish was the least popular one served, during these two weeks? c. On which day of the week was the restaurant most busy, during the two-week period? (Assume each customer has ordered a main dish.) Is the answer the same for both weeks? 159 d. On which day of the week was the restaurant least busy over the two-week period? (Assume each customer has ordered a main dish.) Is the answer the same for both weeks? e. If you calculate the average number of each dish sold within each week separately, are these averages similar to each other per dish, or do they vary widely? Deliverable: One worksheet, and the answers to the five questions above, supported by your numeric data. For any averages you calculate, be sure to use the special Excel AVG function...... do not create the formulas yourself

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Construction Accounting And Financial Management

Authors: Steven J. Peterson

4th Edition

0135232872, 978-0135232873

Students also viewed these Mathematics questions