a report of azola nkota resturant
Mrs Azola Nkota has the following data (R1000s) on total food and beverage sales for the three years of operation: Month 2018 2019 2020 January 243 263 282 February 235 238 255 March 232 247 265 April 178 193 205 May 184 193 210 June 140 149 260 July 145 157 266 August 152 161 174 September 110 122 126 October 130 130 148 November 152 167 173 December 256 230 235 4. Managerial report Use Microsoft Excel to perform an analysis of the sales data for the Buzbey restaurant. Prepare a report for Mrs Azola Nkota that includes: a) A graph of the time series to represent sales for Buzbey Restaurant. Comment. (5 marks) b) A least-square regression method to derive a forecasting equation for the Buzbey restaurant’s sales. (10 marks) c) An analysis of the seasonality of the data. Indicate the seasonal indexes for each month, and comment on the high and low seasonal sales months. (30 marks) d) A multiplicative forecasting model (combining trend and seasonal components) to estimate sales for the Buzbey restaurant from 2018 to 2020. (36 marks) e) A forecasting % error using MAPE. (7 marks) f) A seasonally adjusted forecast for 2021.
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
The next page provides the monthly sales data for Joe's Stone Crab. We have been hired to develop...
please answer with clear work using decomposition including
season factor
The next page provides the monthly sales data for Joe's Stone Crab. We have been hired to develop a forecasting model that will predict future sales for 2018 using the time-series seasonal adjustment method. Assume that data is only available through the end of 2017 You are also to prepare a 1-2 page report within a Word file that will explain to the owner (Mr. Joe) what is happening with...
The Vintage Restaurant, on Captiva Island near Fort Myers, Florida, is owned and operated by Karen Payne. The restaurant just completed its third year of operation. Since opening her restaurant, Karen...
The Vintage
Restaurant, on Captiva Island near Fort Myers, Florida, is owned
and operated by Karen Payne. The restaurant just completed its
third year of operation. Since opening her restaurant, Karen has
sought to establish a reputation for the Vintage as a high-quality
dining establishment that specializes in fresh seafood. Through the
efforts of Karen and her staff, her restaurant has become one of
the best and fastest growing restaurants on the island.
To better plan for
future growth of...
1. Exercise 5.1 The forecasting staff for the Prizer Corporation has developed a model to predict...
1. Exercise 5.1 The forecasting staff for the Prizer Corporation has developed a model to predict sales of its air-cushioned-ride snowmobiles. The model specifies that sales, S, vary jointly with disposable personal income, Y, and the population between ages 15 and 40,Z, and inversely with the price of the snowmobiles, P. Based on past data, the best estimate of this relationship is: where k has been estimated (from past data) to equal 100 If Y $13,000, Z- $1,200, and P...
What are the formulas I need to find total product profit, total staff cost and gross...
What are the formulas I need to
find total product profit, total staff cost and gross nightly
profit?
2020 25 Staff Hourly Rates (changes on 1 Jan each year) Staff 2018 2019 Bar Staff A $ 21 $ 23 $ Bar Staff B $ 21 $ 23 $ Bar Staff C $ 21 $ 23 $ Bar Staff D $ 26 $ 27 $ Bar Staff E $ 30 $ 32 S Security Staff A $ 20 $ 21 $...
kelly Pitney began her censulting busines, kelly Consulting For egete kelly on April 1, 2019. The...
kelly Pitney began her censulting busines, kelly Consulting For egete kelly on April 1, 2019. The accoenting cycle Consulting a April, includia financial in this chapter. During Hay kelly Consulting entered inato the follew ing transactiens: Statements, was illestrated May 3 Received cash from clents as an aduance payment for services to be preided and recorded t as onearned fees, 4,500 5, Received cash fram clients on account, 2, 450 9 Paid cash for a news paper advertisement, $225 13....
HELP needed urgently....Data and question is attacted below..... Thank you in advance there is no data...
HELP needed urgently....Data and question is attacted below.....
Thank you in advance
there is no data link fir this data it’s all in photos.... thank
you
i
have already posted the question
We were unable to transcribe this imageNo. 2 3 4 5 6 7 8 Working Sector Public Own Public Public Private Public Private Private Own Own Private Public Public Public Private 9 10 11 12 13 Public IS 16 17 18 19 20 21 22 23 24 25...
please answer with clear work using decomposition including
season factor
The next page provides the monthly sales data for Joe's Stone Crab. We have been hired to develop a forecasting model that will predict future sales for 2018 using the time-series seasonal adjustment method. Assume that data is only available through the end of 2017 You are also to prepare a 1-2 page report within a Word file that will explain to the owner (Mr. Joe) what is happening with...
The Vintage
Restaurant, on Captiva Island near Fort Myers, Florida, is owned
and operated by Karen Payne. The restaurant just completed its
third year of operation. Since opening her restaurant, Karen has
sought to establish a reputation for the Vintage as a high-quality
dining establishment that specializes in fresh seafood. Through the
efforts of Karen and her staff, her restaurant has become one of
the best and fastest growing restaurants on the island.
To better plan for
future growth of...
1. Exercise 5.1 The forecasting staff for the Prizer Corporation has developed a model to predict sales of its air-cushioned-ride snowmobiles. The model specifies that sales, S, vary jointly with disposable personal income, Y, and the population between ages 15 and 40,Z, and inversely with the price of the snowmobiles, P. Based on past data, the best estimate of this relationship is: where k has been estimated (from past data) to equal 100 If Y $13,000, Z- $1,200, and P...
What are the formulas I need to
find total product profit, total staff cost and gross nightly
profit?
2020 25 Staff Hourly Rates (changes on 1 Jan each year) Staff 2018 2019 Bar Staff A $ 21 $ 23 $ Bar Staff B $ 21 $ 23 $ Bar Staff C $ 21 $ 23 $ Bar Staff D $ 26 $ 27 $ Bar Staff E $ 30 $ 32 S Security Staff A $ 20 $ 21 $...
kelly Pitney began her censulting busines, kelly Consulting For egete kelly on April 1, 2019. The accoenting cycle Consulting a April, includia financial in this chapter. During Hay kelly Consulting entered inato the follew ing transactiens: Statements, was illestrated May 3 Received cash from clents as an aduance payment for services to be preided and recorded t as onearned fees, 4,500 5, Received cash fram clients on account, 2, 450 9 Paid cash for a news paper advertisement, $225 13....
HELP needed urgently....Data and question is attacted below.....
Thank you in advance
there is no data link fir this data it’s all in photos.... thank
you
i
have already posted the question
We were unable to transcribe this imageNo. 2 3 4 5 6 7 8 Working Sector Public Own Public Public Private Public Private Private Own Own Private Public Public Public Private 9 10 11 12 13 Public IS 16 17 18 19 20 21 22 23 24 25...
Most questions answered within 3 hours.
-
It was brought to Dwight’s attention that one of his hotel
employees had a substance abuse...
asked 2 minutes ago -
PYTHON CODE:
Fill in the blanks in following line of code to get desired
output?
print(“My...
asked 1 minute ago -
1.
Craft a text message to your boss at work. In the message, you need
to...
asked 8 minutes ago -
A high energy pulsed laser emits 3.00 nano second-long pulse of
average power 1.50×1011 W. The...
asked 13 minutes ago -
A spring is at -4.5 m at time 10.0 sec and has an angular
speed of...
asked 16 minutes ago -
Charlie's utility function for his consumption of apples xA and
bananas xB is u(xA, xB) =...
asked 16 minutes ago -
Standard Direct Materials Cost per Unit from Variance Data
The following data relating to direct materials...
asked 18 minutes ago -
Which should give the least vigorous reaction when dropped in
water? Rb, Na, K, Cs, or...
asked 30 minutes ago -
Which simple forecasting method is equivalent to extrapolating
a line draw between the first and lost...
asked 37 minutes ago -
Why does a sonic boom irritate people on the ground below a
supersonic aircraft and not...
asked 37 minutes ago -
Calculate the changes in internal energy dU for the following
systems:
a) one of which 3...
asked 44 minutes ago -
1. True or false. The elements in group 2A all have the same
tendencies to form...
asked 49 minutes ago