Question

In: Accounting

Week Covers 1 2,200 2 2,200 3 2,300 4 2,600 5 2,500 6 2,400 This food...

Week Covers

1 2,200
2 2,200
3 2,300
4 2,600

5 2,500
6 2,400

This food operation uses a moving average and a 4-week base period for forecasting sales. The forecast for the upcoming Week 7's volume is:

Solutions

Expert Solution

Week Sales Forecast 2 week average 3 week average 4 week average
1                   2,200
2                   2,200
3                   2,300                      2,200
4                   2,600                      2,250                      2,233
5                   2,500                      2,450                      2,367                      2,325
6                   2,400                      2,550                      2,467                      2,400
Total                      2,450                      2,500                      2,450

Forecast for the Week 7's volume = 2450


Related Solutions

ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5...
ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5 8 7 6 5 7 7 6 7 8 8 8 9 7 8 10 12 11 Test the significance of the correlation coefficient. Then use math test scores (X) to predict physics test scores (Y).  Do the following: Create a scatterplot of X and Y. Write the regression equation and interpret the regression coefficients (i.e., intercept and slope). Predict the physics score for each....
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Find mean, median, mode, variance, standard deviation, coefficient of variation, range, 70th percentile, 3rdquartile of the data and skewness and define what each of these statistics measure. For example, mean is a measure of the central tendency, what about the rest? Use Chebyshev’s rule to find...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Split the dataset in two equal parts. You have 30 datavalues. If you split the data in two equal parts each part will contain 15 data values.  Call the first part Y and second part X.Draw scatter plot of the 2 datasets, X being on the horizontal...
tens Units 1 5 2 3 4 8 5 2 5 6 9 6 1 3...
tens Units 1 5 2 3 4 8 5 2 5 6 9 6 1 3 5 4 7 9 7 0 0 4 5 6 9 9 8 1 3 5 6 8 9 9 0 1 2 3 5 9 The table represent a random sample of 31 test scores taken from a large lecture class. Find the following [round to 2 decimal points X. XX] a) [2 pts] Find the 5 number summary [L, Q1, Q2, Q3,...
X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot...
X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot the date B: find the line of best fit C: determine ŷ AT x=3 D: Find r and r^2 E: explain r and r^2
2. Consider functions f : {1, 2, 3, 4, 5, 6} → {1, 2, 3, 4,...
2. Consider functions f : {1, 2, 3, 4, 5, 6} → {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}. (a) How many of these functions are strictly increasing (i.e. f(1) < f(2) < f(3) < f(4) < f(5) < f(6))? Hint: How many different possibilities are there for the range of f? For each range of f, how many strictly increasing functions are there? (b) How many of these functions are non-decreasing (i.e. f(1) ≤ f(2) ≤...
Problem 6-01 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6...
Problem 6-01 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 18 12 16 10 19 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. Mean absolute error. If required, round your answer to one decimal place. Mean squared error. If required, round your answer to one decimal place. Mean absolute percentage error. If required, round your intermediate calculations and final...
Question 1. Consider the following time series data. Week 1 2 3 4 5 6 Value...
Question 1. Consider the following time series data. Week 1 2 3 4 5 6 Value 118 113 116 111 117 114 Construct a time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Use a =0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Compare the three-week moving average forecast with...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12 15 11 18 13 a. Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 19 2 12 3 15 4 11 5 18 6 13 Compute MSE. (Round your answer to two decimal places.) MSE =   b. Use a smoothing constant of α = 0.4 to compute the exponential smoothing forecasts. Week Time...
Considering the following time series data: Week 1 2 3 4 5 6 7 8 9...
Considering the following time series data: Week 1 2 3 4 5 6 7 8 9 10 Sales 8 11 14 19 16 10 8 12 14 16 Compute the naïve forecast and the three-week Moving Average and evaluate the forecast accuracy considering the Mean Absolute Error (MAE), Mean Squared Error (MSE) and the Mean Absolute Percentage Error (MAPE) for each of these two predictions. Compare both of them and determine which is the best model
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT