Mario & Luigi own the Super brother canteen. Mario is in-charge of marketing and is developing his sales forecast for next year. Because of his marketing efforts, he predicts a 5 percent increase in his monthly guest counts. Mario is not aware of any anticipated menu price increases and assumes, therefore, that his weighted check average will remain stable. A Taing laat u

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

How do i answer this problem?

Mario & Luigi own the Super brother canteen. Mario is in-charge of marketing and is
developing his sales forecast for next year. Because of his marketing efforts, he
predicts a 5 percent increase in his monthly guest counts. Mario is not aware of any
anticipated menu price increases and assumes, therefore, that his weighted check
average will remain stable.
A. Using last year's sales and guest counts, estimate Mario's weighted check average
for the year.
B. Using the weighted check average calculated in part A, determine Mario's
projected sales assuming a 5 percent increase in guest counts.
Month
Sales last year
Guest count last year
Check average
January
45,216.00
4,800
1
February
48,538.00
5,120
March
50,009.00
5,006
3
April
45,979.00
4,960
May
49,703.00
5,140
June
48,813.00
5,300
6
July
55,142.00
5,621
7
August
59,119.00
6,002
8
September
55,257.00
5,780
October
50,900.00
5,341
10
November
54,054.00
5,460
11
December
50,998.00
5,400
12
Total
14
15
13
Transcribed Image Text:Mario & Luigi own the Super brother canteen. Mario is in-charge of marketing and is developing his sales forecast for next year. Because of his marketing efforts, he predicts a 5 percent increase in his monthly guest counts. Mario is not aware of any anticipated menu price increases and assumes, therefore, that his weighted check average will remain stable. A. Using last year's sales and guest counts, estimate Mario's weighted check average for the year. B. Using the weighted check average calculated in part A, determine Mario's projected sales assuming a 5 percent increase in guest counts. Month Sales last year Guest count last year Check average January 45,216.00 4,800 1 February 48,538.00 5,120 March 50,009.00 5,006 3 April 45,979.00 4,960 May 49,703.00 5,140 June 48,813.00 5,300 6 July 55,142.00 5,621 7 August 59,119.00 6,002 8 September 55,257.00 5,780 October 50,900.00 5,341 10 November 54,054.00 5,460 11 December 50,998.00 5,400 12 Total 14 15 13
Projected
Guest count last
Sales/ Ave
Month
Guest Count forecast
Weighted Check
year
Sales per
Guest Forecast
January
4,800
17
30
31
February
5,120
18
32
March
5,006
19
33
April
4,960
20
34
May
5,140
21
35
June
5,300
22
36
July
5,621
23
37
August
6,002
24
38
September
5,780
25
39
October
5,341
26
40
November
5,460
27
41
December
5,400
28
42
Total
16
29
43
Transcribed Image Text:Projected Guest count last Sales/ Ave Month Guest Count forecast Weighted Check year Sales per Guest Forecast January 4,800 17 30 31 February 5,120 18 32 March 5,006 19 33 April 4,960 20 34 May 5,140 21 35 June 5,300 22 36 July 5,621 23 37 August 6,002 24 38 September 5,780 25 39 October 5,341 26 40 November 5,460 27 41 December 5,400 28 42 Total 16 29 43
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman