Apply the 3-years moving average method to forecast the required demand for the year 2021 from the following historical data. Years 2012 2013 2014 2015 2016 2017 2018 2019 2020 Demand 245 325 300 350 295 400 450 380 500

Apply the 3-years moving average method to forecast the required demand for the year 2021 from the following historical data. Years 2012 2013 2014 2015 2016 2017 2018 2019 2020 Demand 245 325 300 350 295 400 450 380 500

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: Moving average is used to forecast room demand. Generate. a forecast for June using MA =2 and MA =…

A: To find: The forecast from this approach, and which is closer to the actual for June. Given: The…

Q: Assuming that after analyzing two years, 8 time periods of quarterly demand data with four seasons…

A: Given data: seasonal factors are: S1: 1.03, S2: 0.92, S3: 0.88, and S4: 1.32 Estimated level L8 =…

Q: Determine the forecast results for the next 12 months using one of the following methods and provide…

Q: My App is a small but growing start-up that sees demand for several of its apps increasing quickly.…

A: Double exponential smoothing is a forecasting model which identify the forecasting with the…

Q: Lori Cook has developed the following forecasting model: where y demand for Kool Air conditioners…

A: Regression is a statistical technique used in the fields of finance, investing, and other…

Q: Below is a table containing data on product demand for the most recent five months along with the…

A: Forecast by using 3 period simple moving average method-

Q: Given the following historical data, what is the simple three-period moving average forecast for…

A: A moving average is a running average of a set of numbers or a series. It can be used to calculate…

Q: A store has the following demand figures for the last five years: Year Demand 1 1000 2 1500 3 1200 4…

A: Formulae used: For Exponential Smoothing Forecast: Ft =α At-1 + (1-α)Ft-1WhereFt-1= forecast for…

Q: A manager of a trav company using the following data for the pacCkaged tours. Compute additive…

A: D3=D1+D5+2(D2+D3+D4)8=1800+1848+2(1525+2100+1940)8=1847 By formula From above equation , first…

Q: Auniversity lecturer needs to allocate time next week to include time for office hours. He needs to…

A: Exponential smoothing is a time series forecasting method. It calculates a weighted average of past…

Q: Suppose the following actual and forecast values for June bed demands have been recorded. Year…

Q: The operations manager of a company extructed the following annual demand data from the research and…

A: Find the Given details below: Given Details: Quarters Demand 1 120 2 90 3 100 4 75 5…

Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…

A: Solution Moving average considers the average of the past data. The average can be of three periods…

Q: The table below comprises of demand from the last 10 months: Month Demand 1 31 2 34 3 33…

A: The answers is provide in given below. If it is useful to you, Please like it.Explanation:Step…

Q: The following are monthly actual and forecast demand levels for May through December for units of a…

A: A forecast refers to a prediction or estimation of future events or conditions based on available…

Q: Given the following data, use exponential smoothing (a=0.10) to develop a demand forecast. Assume…

A: Exponential smoothing is time series method which uses for forecasting univariate time series data.…

Q: 7. Using both time series methods of forecasting, predict the number of meals that should be…

A: Find the Given details below:

Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…

Q: The Holy Smokes Corporation sells altar candles world-wide. Quarterly sales data for the past 5…

A: Below are the used three standard error measures: mean squared error (MSE), mean absolute percent…

Q: The table below shows forecasts and true values Quarter Forecast True Value 1 327 345 2 332 317 3…

A: Quarter Forecasted valueTrue value 1327345233231733283364330311

Q: Apply the appropriate forecasting tools and techniques in predicting product demand using OM…

A: Demand forecasting is the assessment of likely future demand for an item or administration. The term…

Q: Apply the 3-years moving average method to forecast the required demand for the year 2021 from the…

A: Years Demand 2012 245 2013 325 2014 300 2015 350 2016 295 2017 400 2018 450 2019 380…

Q: ACTUAL DEMAND 2011 Spring 203 Summer 144

A: YEAR SEASONACTUAL DEMAND 2011 Spring 203 Summer 144 Fall 382 Winter 565…

Q: What is the coefficient?

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In business…

Q: The analytics department is researching the past five years of their company's sales to better…

A: Step 1: Identify the formula for Mean Absolute Deviation (MAD)MAD = ∑|e|/nwhere:∑|e| = total of all…

Q: What will be the demand forecast for period t? (Keep one decimal place in your answer).

A: The weighted average moving forecast is a technique that is used to predict the future of a…

Q: What is linear trend forecast.

A: Forecasting is the process of identifying the demand accurately for future production planning and…

Q: The following table contains the demand from the last 10 months. Calculate the exponential smoothing…

A: Given: An initial trend forecast (T1) = 1.00 An initial exponentially smoothed forecast (F1) = 30.…

Q: Harlen Industries Limited has a simple forecasting model whose forecast demand has been plotted…

A: In this question, we have the table data for an 8 periods duration, for each period, we have actual…

Q: c) If the forecasted demand for the week of August 31 is 350 and a=0.20, using exponential…

A: Calculation of the forecast of each of the week by exponential smoothing method using the formula…

Q: Given the following history, use a three-quarter moving average to forecast the demandfor the third…

A: Given information:

Q: a03 a05 Period Forecast Forecast 3 10 11 12 2.

A: Here, I will conduct a simple exponential smoothing forecast for the given data set, I have…

Q: Discuss when is time series forecasting used?

A: Forecasting is a strategy for forecasting future events using historical data and knowledge.

Q: Consider the following information: Year Quarter Actual Sales (000) 2018 1 20 2 15…

A: The trend projection method depends with the understanding that the elements obligated for the…

Q: ind Naïve Forecast, Moving Average and Weighted Average based on the data given at the below table.…

A: In the question, we have monthly data for the year 2018, I would apply forecasting techniques to get…

Q: Assume that the initial forecast for February is 65.0 (in $ thousands) and the initial trend…

A: There are various methods of forecasting. One of the methods is the trend-adjusted exponential…

Q: Consider the following actual and forecast demand levels for Big Mac hamburgers at a local…

A: The Formula for exponential smoothing forecast is:Ft+1 = Yt + ( 1 - ) FtHere, Ft+1 is the Forecast…

Q: Given the sales data, compute the seasonal index for each period and forecast demand each period…

A: Given sales data - Quarter Year 1 Year 2 1 350 370 2 490 560 3 560 590 4 250 310

Q: Given the actual demand for years 2013/14, calculate the total forecast for year 2015, as well as…

A: Below is the solution:-

Q: Actual demand for a product for the past three months was: Three months ago 400 units Two months…

A: Month Actual demand3 months ago4002 months ago350Last month325

Q: Please do not give solution in image format thanku supose that the demand in period 1 was 7 units…

A: Formula: For Exponential Smoothing F(t+1) = alpha*D(t) + (1-alpha)*F(t) F(t+1) = Forecast in t+1…

Concept explainers

Forecasting in Business

Forecasting is the process of predicting the future based on the past and the present data and circumstances. In other words, forecasting is the act of making a detailed analysis of future events based on the decisions made in the past as well as the present. Forecasting plays a very important role in operational management as it helps in planning and decision-making. It is not only important for the success of a business but also contributes to individual growth and success. Many business organizations or companies have failed due to the shortcomings of their forecasting.

Question

Apply the 3-years moving average method to forecast the required demand for the year 2021
from the following historical data.
Years
2012
2013
2014
2015
2016
2017
2018
2019
2020
Demand
245
325
300
350
295
400
450
380
500

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction

VIEW

Step 2: Calculation

VIEW

Step 3: Conclusion

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the 3-period simple moving average method to forecast the number of sales to expect next month. Month Demand Forecast 1 308 341 388 343.3 3 344 364.7 4 400 346.7 341 377.3
Sunrise is planning its purchases of ingredients for bread production. If bread demand had been forecast for last week at 22k loaves & only 21k loaves were actually demanded, what would Sunrise’s forecast be for this week using exponential smoothing with α = 0.10?
Explain how can does the number of periods in a moving average affect the responsiveness of the forecast?
A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives areSR1 = .90, SR2 = .95, SR3 = 1.05, and SR4 = 1.10. The trend equation is: Ft= 10 + 5t. Over thepast nine quarters, demand has been as follows:Period, t 1 2 3 4 5 6 7 8 9Demand 14 20 24 31 31 37 43 48 52Is the forecast performing adequately? Explain.
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The milles driven during the past 5 years are K as follows Year Mileage 3,000 2 3 4,000 3,400 4 3,800 5 3,700 a) Using a 2-year moving average, the forecast for year 6- 3750 miles (round your response to the nearest whole number) b) If a 2-year moving average is used to make the forecast, the MAD based on this miles (round your response to a whole number). (Hint: You will have only 3 years of matched data)
The following table shows the actual demand observed over the last 4 years: 1 Year Demand 8 Year Forecast (ES) 1 7.0 Using exponential smoothing with a = 0.30 and a forecast for year 1 of 7.0, provide the forecast from periods 2 through 5 (round your responses to one decimal place). 3 5 Provide the forecast from periods 2 through 5 using the naive approach (enter your responses as whole numbers). Year Forecast (NA) 2 10 2 2 3 4 3 4 4 9 4 5
Use simple exponential smoothing with a -0.8 to forecast electric scooter sales at Guelph- Humber Inc. for July. Assume that the forecast for May was for 45 electric scooters. Round your answer to 1 decimal Electric Scooter Sales Month May 42 June 47 July 45 August 40 Weekly demand for medical masks for the last five weeks at Chopper Drug Store has been as follows: 92, 96, 100, 100 and 102 (listed from the oldest to most recent). Suppose a naive forecast was used to forecast demand. What would the MAD be for this situation? Enrollment in a particular Yoga class at Guelph Fitness Centre for the last five months has been 80, 86, 88, 88 and 90(listed from the oldest to most recent). Suppose a two-month mov average was used to forecast enrollment. What would the MSE be for this situation?
The following table shows the actual demand observed over the last 11 years: Year Demand 1 7 Year Forecast 2 8 2 3 4 3 4 10 4 Using exponential smoothing with a = 0.30 and a forecast for year 1 of 6.0, provide the forecast from periods 2 through 12 (round your responses to one decimal place). 3 2 4 5 6 T 8 9 Year 1 Forecast 6.0 Provide the forecast from periods 2 through 12 using the naive approach (enter your responses as whole numbers) 5 12 5 6 7 6 7 8 11 14 7 8 9 10 9 10 10 10 13 11 11 11 8 12 12
14.5. For the data in Exercise 14.4, use an a of 0.1 to make a forecast for July F Ft-1 + 0.1(At-1-Ft-1) Months January 15 February 18 March 22 23 27 26 April May June Demand Smoothing unit (At) (St) July 15 15.3 15.97 16.67 17.7 18.53 Forecast for July= 18.53 Forecast (Ft) 15 15.3 15.97 16.67 17.7 18.53
A firm uses simple exponential smoothing with trend adjustment to forecast demand, "a = 0.6" and "B=0.6". The Forecast including Trend (FIT) for the 1st month of 2022 was 434 units whereas the actual demand turned out to be 488 units, the trend over that period was 26. Calculate the demand forecast including trend for the 2nd month.
Prepare a graph of the monthly forecasts and average forecast demand for Chicago Paint Corp., a manufacturer of specialized paint for artists. Compute the demand per day for each month (round your responses to one decimal place). Month January February March April May June July August September October November December Choose the correct graph of the forecast demands below. OA Production Days 2222222222 23 19 20 21 20 23 21 20 19 Demand Forecast 950 1,050 1,250 1,350 1,300 1,300 1,250 1,150 1,050 1,000 1,000 950 Demand per Day 325
Please consider the following information and make forecasts for January, February, March, and April of Year 2. Use second-order polynomial regression to make forecasts. Adjusted seasonal index Actual sales Deseasonalized sales 836 825 Year 1 Year 2 January February March April May June July August September October November December January February March April 0.72 0.75 1:22 1.48 1 1.23 0.7 0.78 0.92 1.13 1.28 1.33 0.72 0.75 1.22 1.48 1220 1319 1020 1184 685 641 875 1008 1068 1141