Compute a three-period moving average forecast given demand for shopping carts for the last five periods. (Round all your answers to two decimal points.) Period 1 2 3 4 5 Demand 48 44 50 44 53 Answer is complete but not entirely correct. Forecast Period 4 Forecast Period 5 Forecast Period 6 40.67 42.67 49.33 If actual demand in period 6 turns out to be 48, the moving average forecast for period 7 would be Answer is complete but not entirely correct. Forecast Period 7 50.33

Compute a three-period moving average forecast given demand for shopping carts for the last five periods. (Round all your answers to two decimal points.) Period 1 2 3 4 5 Demand 48 44 50 44 53 Answer is complete but not entirely correct. Forecast Period 4 Forecast Period 5 Forecast Period 6 40.67 42.67 49.33 If actual demand in period 6 turns out to be 48, the moving average forecast for period 7 would be Answer is complete but not entirely correct. Forecast Period 7 50.33

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 11P: For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12...

See similar textbooks

Similar questions

Refer to the gasoline sales time series data in Table 8.1. Compute four-week and five-week moving averages for the time series. Compute the MSE for the four-week and five-week moving average forecasts. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that the MSE for the three-week moving average is 10.22.
Weekly customer demand for the ice cream can be seen in the table below. Week Demand (gallons) 1 280 2 295 3 315 4 300 5 340 6 335 7 350 Compute a three-week moving average demand and a four-week moving average demand for weeks 5, 6, and 7. Compute the MAD for both forecasting methods. Which model is more accurate? Forecast week8 with the more accurate method
The following monthly sales (in thousands of AUS dollars) of chocolate boxes have been recorded for January, February, March, and April, respectively: 8, 8, 5, 9. Focusing on sales forecast accuracy for the month of April only, explain which of the following forecasting method would you recommend: the Naïve method, the Average method, or the Simple exponential smoothing method (assuming alpha=0.8 and initial state of 7)?
The quarterly sales data (number of copies sold) for a college textbook over the past three years are as follows: a. Construct a time series plot. What type of pattern exists in the data? b. Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = l if quarter l, 0 otherwise; Qtr2 = l if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Based on the model you developed in part (b), compute the quarterly forecasts for next year. d. Let t = 1 to refer to the observation in quarter 1 of year 1; t = 2 to refer to the observation in quarter 2 of year 1; ; and t = 12 to refer to the observation in quarter 4 of year 3. Using the dummy variables defined in part (b) and t, develop an equation to account for seasonal effects and any linear trend in the time series. e. Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year. f. Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.
Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?
You are assisting the management accountant with sales forecast of two brands – Y and Z – for the next three quarters of 2019. Brand Y has a steady, increasing trend in sales of 2% a quarter and Brand Z a steadily falling trend in sales of 3% a quarter. Brand Y are subject to seasonal variations as a proportion to the sales units as follows: Quarter 1 2 3 4 Seasonality -30% 0% -30% 60% Brand Z however is subject to seasonal variations in sales units as follows Quarter 1 2 3 4 Seasonality (in sales unit) -112 10 -70 172 The last four quarters unit sales are shown below: 2018 Q2 2018 Q3 2018 Q4 2019 Q1 Brand Y 331 237 552 246 Brand Z 873 593 1,314 558 Required Produce sales forecast for the remaining three quarters of 2019 for each brand.
QWE Inn has recorded the following number of rooms sold for the first quarter of the year: January 2100 February 2500 March 2550 Assume that you found an average monthly geometric rate of change in rooms sales from the month of January to March be equal to 5%. What would be your forecast of rooms sales for the month of April if sales are expected to continue increasing at the same rate?
Using the following Quarterly Sales Demand Data; read and answer the questions listed below. Quarter # Actual Sales (dollars) 1 1416 2 1398 3 1274 4 1167 Calculate the average quarterly Seasonal Index value? (rounded to 2 decimal places). Calculate the total sales if there is a 35% total annual sales decrease next year? (rounded to the nearest whole number) Calculate the Seasonal Index value for Quarter 3? (rounded to 2 decimal places)
2. A manager is using the equation Y(t) = 6400 + 70t to forecast quarterly demand for a product. In the equation, t = 0 at Q2 of last year. Quarter relatives are Q1 = 0.89, Q2 = 0.88, Q3 = 0.73, and Q4 = 1.5. What forecasts are appropriate for the last quarter of this year? a. 10230 b. 10125 c. 9810 d. 10020 e. 4546.67
1. If last year's sales were $906,050 and a store was planning an increase in sales of 3.75% and a markdown percent of 18.25%, what is the planned markdown in dollars? (Present your answer rounded to the dollar with a dollar sign and comma separator (i.e. $109,455).) 2. Using the following data, calculate the planned April purchases at cost. (Present your answer rounded to the dollar with a dollar sign and comma separator (i.e. $109,455).) Sales $220,000 BOM Stock for April $380,000 BOM Stock for May $240,000 Markup 51% Markdowns 2.3%
Given: Peter Piper has projected sales of 72,000 pipes this year, ordering cost of P6 per order, and carrying costs of P2.40 per pipe. With the given data, can you give me the solution on how to get: -What is the economic ordering quantity? -Total inventory cost at EOQ -How many orders will be placed during the year?-What will the average inventory be? Thank you in advance.
The monthly sales for Yazici Batteries, Inc., were asfollows: a) Plot the monthly sales data.b) Forecast January sales using each of the following:i) Naive method.ii) A 3-month moving average.iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3,with the heaviest weights applied to the most recent months.iv) Exponential smoothing using an a = .3 and a Septemberforecast of 18.v) A trend projection. c) With the data given, which method would allow you to fore-cast next March’s sales?