Month Sales 1 1331 2 1293 3 1276 4 979 5 1012 6 770 7 798 8
Fantastic news! We've Found the answer you've been seeking!
Question:
Month | Sales |
1 | 1331 |
2 | 1293 |
3 | 1276 |
4 | 979 |
5 | 1012 |
6 | 770 |
7 | 798 |
8 | 836 |
9 | 605 |
10 | 715 |
11 | 836 |
12 | 1133 |
13 | 1447 |
14 | 1309 |
15 | 1359 |
16 | 1062 |
17 | 1062 |
18 | 820 |
19 | 864 |
20 | 886 |
21 | 671 |
22 | 715 |
23 | 919 |
24 | 1265 |
25 | 1551 |
26 | 1403 |
27 | 1458 |
28 | 1128 |
29 | 1155 |
30 | 880 |
31 | 913 |
32 | 957 |
33 | 693 |
34 | 814 |
35 | 952 |
36 | 1293 |
37 | 1651 |
38 | 1513 |
39 | 1558 |
40 | 1228 |
41 | 1255 |
42 | 980 |
43 | 1013 |
44 | 1015 |
45 | 798 |
46 | 919 |
47 | 1052 |
48 | 1394 |
Transcribed Image Text:
The CSUSM Restaurant just finished its fourth year of operation. Through the great efforts of its manager and staff, this restaurant has become one of the most popular and fastest-growing restaurants in the SD County. The manager has recently decided to improve the capacity planning process of the restaurant. To do so, they need to come up with an effective forecasting procedure to predict the monthly sales of foods for up to a year in advance (12 months). Data file RestaurantCSUSM shows the value of food sales ($100s) for the first four years of operation. You, as the new forecasting analyst, have been asked to propose a new forecasting procedure with a summary of your method, forecasts, and recommendations. Include the followings: 1. A time series plot. Comment on the underlying pattern in the time series. What forecasting technique(s) do you recommend based on your visualization? 2. Do you consider moving average as an effective method for forecasting the food sales of this restaurant? Why? 3. Using dummy variables for seasonality effects, forecast sales for January through December of the fifth year. 4. Add a trend effect to your forecasting model in (3) and forecast sales for January through December of the fifth year again with the new model. 5. Which model is expected to give more accurate forecasts, (3) or (4)? Calculate MSE for both techniques. 6. Assume that restaurant's sales in January of the fifth year turn out to be $165,000. What was your forecast (and what is the forecasting error)? How do you explain this error to the manager? The CSUSM Restaurant just finished its fourth year of operation. Through the great efforts of its manager and staff, this restaurant has become one of the most popular and fastest-growing restaurants in the SD County. The manager has recently decided to improve the capacity planning process of the restaurant. To do so, they need to come up with an effective forecasting procedure to predict the monthly sales of foods for up to a year in advance (12 months). Data file RestaurantCSUSM shows the value of food sales ($100s) for the first four years of operation. You, as the new forecasting analyst, have been asked to propose a new forecasting procedure with a summary of your method, forecasts, and recommendations. Include the followings: 1. A time series plot. Comment on the underlying pattern in the time series. What forecasting technique(s) do you recommend based on your visualization? 2. Do you consider moving average as an effective method for forecasting the food sales of this restaurant? Why? 3. Using dummy variables for seasonality effects, forecast sales for January through December of the fifth year. 4. Add a trend effect to your forecasting model in (3) and forecast sales for January through December of the fifth year again with the new model. 5. Which model is expected to give more accurate forecasts, (3) or (4)? Calculate MSE for both techniques. 6. Assume that restaurant's sales in January of the fifth year turn out to be $165,000. What was your forecast (and what is the forecasting error)? How do you explain this error to the manager?
Expert Answer:
Answer rating: 100% (QA)
For ease of understanding I have named the given months from Jan15Dec18 We will be calculating ... View the full answer
Related Book For
Intermediate Accounting principles and analysis
ISBN: 978-0471737933
2nd Edition
Authors: Terry d. Warfield, jerry j. weygandt, Donald e. kieso
Posted Date:
Students also viewed these accounting questions
-
For a forecasting problem, come up with an unique business idea. Discuss the business idea and its financial projections (Including Sales, COGS, other expenses, assets) for three years in two pages....
-
eBay has become one of the most popular auction sites in the world. Each day, millions of products and services are bought and sold on the site. Because of its popularity, eBay is also a home for...
-
Come up with an explanation as to why radiation is easily blocked by materials such as a piece of wood, whereas radiation easily passes through those same materials.
-
Consider two farmers, A and B, produce farm products and sell in the same market. Assume that the supply of the two farmers products are the same but the demand for Farmer Bs product is relatively...
-
Find an equation of the tangent to the curve at the given point. (a) y = 4 sin2x, (/6, 1) (b) y = 1 + 4 sin x, (0, 1)
-
A concave cosmetic mirror has a focal length of \(40 \mathrm{~cm}\). A 5 - \(\mathrm{cm}\)-long mascara brush is held upright \(20 \mathrm{~cm}\) from the mirror. Use ray tracing to determine the...
-
What critical piece of information is required to post analyze variablespeed machinery?
-
Felton Company has a factory machine with a book value of $90,000 and a remaining useful life of 4 years. A new machine is available at a cost of $200,000. This machine will have a 4-year useful life...
-
17. The following data was obtained from orthogonal turning of PEEK and short- fiber-reinforced PEEK (C/PEEK, V = 0.3) [24]. Refer to Fig. 2.2 for definition of cutting variables. The cutting...
-
It is now Prime Day, the deal is selling well, but you just got a call from the vendor explaining that they will not be able to fill any more units for the next 3 weeks. Your Instock Manager (Anjali...
-
Identify the important elements of the income tax in the state of Georgia. Does your state levy individual and corporate income taxes; do local governments levy such income taxes and, if so, are they...
-
How do unrealized profits on upstream sales affect the minority interests share of a subsidiarys earnings?
-
In Problems 11-18, find the three measures of central tendency (the mean, median, and mode). \(79,90,95,95,96 \)
-
What is a least squares line?
-
Prepare a frequency distribution for each data set in Problems 24-27. Consider the following data sets: Data set \(C\) Data set A: The annual wages of employees at a small accounting firm are given...
-
Highlight the key items in the balance sheet of an Islamic bank.
-
As a new Tax Professional provide your financial recommendation and overview of the importance of planning financial goals and explain how a tax strategy aligns with the client's future goals. Be...
-
During the month, services performed for customers on account amounted to $7,500 and collections from customers in payment of their accounts totaled $6,000. At the end of the month, the Accounts...
-
Synergetics Inc. leased a new crane to M. K. Gumowski Construction under a 5-year noncancelable contract starting January 1, 2008. Terms of the lease require payments of $22,000 each January 1,...
-
Angela Lansbury Company deposits all receipts and makes all payments by check. The following information is available from the cash records. Instructions (a) Prepare a bank reconciliation going from...
-
During its first year of operations, Collin Raye Corporation had the following transactions pertaining to its common stock . Jan. 10 Issued 80,000 shares for cash at $6 per share. Mar. 1 Issued 5,000...
-
Solve Example 7.5 with equilibrium energy as the initial condition for the Oxygen molecule at 1 atmosphere and \(3200 \mathrm{~K}\). Example 7.5 Obtain the time dependent expression for the vibration...
-
Obtain a pseudo tri-diagonal matrix equation to solve the vorticity transport equation in a boundary layer with forward differencing in time and with appropriate differencing in space suitable for...
-
If the waverider of the Problem 7.44 has the wall temperature of \(1400 \mathrm{~K}\) and \(\operatorname{Re}=1.371 \times 10^{6}\) with respect to its length then find the drag coefficient with...
Classroom Management For Middle And High School Teachers 10th Edition - ISBN: 0134028813 - Free Book
Study smarter with the SolutionInn App