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...
Pricilla Phashions Pricilla Phranklin opened her new clothing store, Pricilla Phashions, in downtown Dover. Pants s...
Pricilla Phashions Pricilla Phranklin opened her new clothing store, Pricilla Phashions, in downtown Dover. Pants skirts, blouses, and shirts have fairly consistent sales, while things like shorts, sweater and outerwear are highly seasonal. On the other hand, dresses are a little harder to predict. Pricilla is hiring you to arrive at the best forecasting method for dresses. The following table contains three years of dress sales data Year 1 Year 2 Year 3 Demand Month Demand Demand 155 181 177...
38. Refer to the Baseball 2016 data, which report information on the 30 Major League Baseball teams for the 2016 season....
38. Refer to the Baseball 2016 data,
which report information on the 30 Major League Baseball teams for
the 2016 season.
Texas
American
1994
144.31
2710402
95
4.37
0.262
215
2016
4.40
Toronto
American
1989
112.90
3392299
89
3.78
0.248
221
Washington
National
2008
166.01
2481938
95
3.51
0.256
203
At the .05 significance level, can we conclude that there is a
difference in the mean salary of teams in the American League
versus teams in the National League?
At...
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...
33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim...
33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim plans to repay the loan on March 11. Assume the loan is on ordinary interest. How much will Jim repay on March 11? (Use Days in a year table) (Round your answer to the nearest cent.) Jm repay etbook 7-1 TABLE Exact days-in-a-year calendar (excluding leap year)" Day of month 30 31 30 31 28 31 30 31 31 30 31 31 Dec Mar...
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 $...
Project The required tasks are detailed below: (1) Prepare vertical common-size income statements and balance sheets...
Project The required tasks are detailed below: (1) Prepare vertical common-size income statements and balance sheets for both companies. Note: Use "Total Sales" and "Total Assets" as the denominators for income statement and balance sheet, respectively. Compute for 2018, 2017, and 2016. (2) Prepare horizontal analysis on income statements and balance sheets for both companies. (3) Prepare ratio analyses (for 2018, 2017, and 2016) for both companies. You should include the following ratios in your computations: Profitability ratios o Gross...
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....
If the two signal handling functions in 3000pc were replaced by one function, would there be...
If the two signal handling functions in 3000pc were replaced by one function, would there be any significant loss of functionality? Briefly explain /* 3000pc.c */ 2 3 4 5 6 7 8 #include <stdio.h> 9 #include <stdlib.h> 10 #include <unistd.h> 11 #include <sys/mman.h> 12 #include <errno.h> 13 #include <string.h> 14 #include <sys/types.h> 15 #include <sys/wait.h> 16 #include <semaphore.h> 17 #include <string.h> 18 #include <time.h> 19 20 #define QUEUESIZE 32 21 #define WORDSIZE 16 22 23 const int wordlist_size =...
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...
Pricilla Phashions Pricilla Phranklin opened her new clothing store, Pricilla Phashions, in downtown Dover. Pants skirts, blouses, and shirts have fairly consistent sales, while things like shorts, sweater and outerwear are highly seasonal. On the other hand, dresses are a little harder to predict. Pricilla is hiring you to arrive at the best forecasting method for dresses. The following table contains three years of dress sales data Year 1 Year 2 Year 3 Demand Month Demand Demand 155 181 177...
38. Refer to the Baseball 2016 data,
which report information on the 30 Major League Baseball teams for
the 2016 season.
Texas
American
1994
144.31
2710402
95
4.37
0.262
215
2016
4.40
Toronto
American
1989
112.90
3392299
89
3.78
0.248
221
Washington
National
2008
166.01
2481938
95
3.51
0.256
203
At the .05 significance level, can we conclude that there is a
difference in the mean salary of teams in the American League
versus teams in the National League?
At...
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...
33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim plans to repay the loan on March 11. Assume the loan is on ordinary interest. How much will Jim repay on March 11? (Use Days in a year table) (Round your answer to the nearest cent.) Jm repay etbook 7-1 TABLE Exact days-in-a-year calendar (excluding leap year)" Day of month 30 31 30 31 28 31 30 31 31 30 31 31 Dec Mar...
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 $...
Project The required tasks are detailed below: (1) Prepare vertical common-size income statements and balance sheets for both companies. Note: Use "Total Sales" and "Total Assets" as the denominators for income statement and balance sheet, respectively. Compute for 2018, 2017, and 2016. (2) Prepare horizontal analysis on income statements and balance sheets for both companies. (3) Prepare ratio analyses (for 2018, 2017, and 2016) for both companies. You should include the following ratios in your computations: Profitability ratios o Gross...
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....
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago