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

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter4: Linear Functions

Section4.3: Fitting Linear Models To Data

Problem 23SE: The US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the...

See similar textbooks

Related questions

Q: The quarterly sales data (number of copies sold) for a college textbook over the past three years…

A: a.The excel steps to draw the time series plot is: Enter the data in the excel spread sheet. Select…

Q: Given the following data for demand at the XYZ Company, calculate the monthly forecast for 2003…

A: Forecast are used to determine the future value over a period of time. Error in forecast can be…

Q: Calculate the indices of seasonal variation by ratio to trend method from the following data. Year…

A: Year Quarter y 4 figures moving total 4 figures moving average 2 figures moving total 2 figures…

Q: In 2020, an adult season pass lift ticket for Devil's Head Ski Resort in Merrimac, WI costs $449. If…

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

A: See the handwritten solution

Q: Calculate seasonal indices for the following data using the percentage of annual average method.…

Q: 19. The following data describes the export quantity of a company. Year: 1995 1996 1997 1998 1999…

Q: Calculate the seasona! indices by the 'ratio to moving average' method from the fotnowing data. Year…

Q: Based on the information in the following table, use the THREE-MONTH MOVING AVERAGE Approach to…

A: Given: Period Month Demand 1 Jan 129 2 Feb 57 3 Mar 66 4 Apr 138 5 May 183 6 Jun 54…

Q: The demand for a product of a company in each of the last twelve months is shown in the table below;…

A: Given data: The given demand for September is DS=56. The given demand for October is DO=52. The…

Q: Given the following data: Year |Weekly take-home Consumer pay (wages price index 2007 109.5 112.8…

Q: Use the following data to answer the following problems Year Quarter Sales 2 3 3 1 2 3 1 2 3 55 58…

A: Step 1: Unstack columns by quarter: Go to Data > Unstack columns then new window is opened as…

Q: Fit a straight line trend by the method of least squares and estimate the sales for 2004 and 2005,…

A: Given:

Q: A share has the following prices at the end of each of the years shown. What is the geometric…

Q: Calculate Price Index using Fisher's Method and Bowley's formula: Current year Base year Quantity…

Q: The sales (in millions of dollars) for an 18-month period are as follows. Month Sales Month Sales 1…

A: Forecasting of time series data is done to predict the value for the future using the past trends.…

Q: XYZ Company, Annual Data Actual Demand. Forecasted Demand 15 14 15…

A: The formula for mean absolute deviation is MAD = (Σ|At – Ft|)/n, where At is the actual value and Ft…

Q: Find the trend line equation and obtain the trend values for the followin data using the method of…

Q: This is the following demand data: Period Demand 1 40 2 55 60 4 35 30 6. 52

A: Given information: The data represents the values of demand for the time periods 1 through 8.

Q: (c) Table 1 shows the daily income of fruit sellers. 100 120 120 110 200 180 170 160 145 120 Table…

A: Given data, 100 120 120 110 200 180 170 160 145 120 Arrange the data in the ascending order 100 110…

Q: 33. Estimate the production of sugar for the year 2000 and 2010 from the following data : Year 1985…

Q: The records shown in the table provide an excellent opportunity for you to assist them with their…

Q: Calculate trend values by the method of least square from the data given below and estimate the…

Q: pllowing are the data on demand for white bread loave Day 2 3 4 5 6 7 8 9 10 11 12 Loaves 199 209…

A: day loaves 1 199 2 209 3 215 4 226 5 233 6 237 7 252 8 257 9 253 10 265 11…

Q: Estimate the production for the years 1955 and 1965 with the help of the following table Year 1940…

A: Here, we have Year Production (000 tonnes) 1940 200 y0 1945 220 y1 1950 260 y2 1955 ?…

Q: 80 1540 1600 1660 1720 1780 Distribution of Prices

A: In statistics, the 68–95–99.7 rule, also known as the empirical rule, is a shorthand used to…

Q: Monthly data for the demand of an item are shown in the table below. 1 2 3 45 6 Month Demand 93 99…

A: The given table is as follows:

Q: Consider the following quarterly demand level for electricity (in 1000 megawatts) in Mankweng from…

A: Hello! As you have posted more than 3 sub parts, we are answering the first 3 sub-parts. In case…

Q: The following are historical demand data: YEAR SEASON ACTUAL DEMAND 2 years ago Spring 205…

A: Solution: The historical demand data is given. It is asked to use the regression analysis on…

Q: The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag…

Q: 2021 in a Southeast Asian city: Item Expenditure weight 2019 Price 2020 Price 2021 Price Clothes 10%…

A: Explanation: a)

Q: Develop a trend line for the demand for fertilizer, forecast the demand for year 12. Year Demand…

A: Note: Thanks for the question, the estimate of the demand obtained by the given data is not matching…

Q: Estimate the production for the year 2005 With the Production (m. tonnes) Year 20 1980 1985 1990 22…

A: Given: Let Year 1980 be denoted by 1 Let years be denoted by x and production be denoted by y. The…

Q: Calculate trend values by the method of Least Square from the data given below and estimate the…

Q: Based on the information in the following table, use the THREE-MONTH MOVING AVERAGE Approach to…

Q: Obtain the straight line trend equation and tabulate against each year trend and short term…

Q: Use the method of least square to fit a trend line for the income from the following data. Estimate…

Q: Based on the information in the following table, use the Naive Approach to forecast the demand for…

A: According to the Naive method of forecasting the forecasted value of any period is best given by the…

Q: Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are…

Q: From the data given below, find the second five years moving average. Year Sales 2012 20 2013 25…

A: The following is the data provided: Period Data 2012 20 2013 25 2014 30 2015 35 2016 40…

Q: The following are historical demand data: ACTUAL YEAR SEASON DEMAND 2 years ago Spring 205 Summer…

A: Seasonal index is measured in terms of index. It is calculating the average of all the data which…

Q: Given the following past sales data, forecast the demand for the next 2 years. Account for trend and…

A: Consider the linear regression model for the month and sales: Excel Procedure: Enter Month and…

Q: Consider the following quarterly demand level for electricity (in 1000 megawatts) in Mankweng from…

A: Hello! As you have posted more than 3 sub parts, we are answering the first 3 sub-parts. In case…

Q: 5. Estimate the production for the years 2008 and 2010 with the help d following table : Year…

Q: A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales…

A: (a). Demand Forecast values for the days 9 through 16 using trend-adjusted exponential smoothing:…

Q: (On inequal time interval) Obtain the straightline trend equation for the following data by the…

A: The objective is to find out the straight line trend equation for the given data , also compute the…

Q: From the following data fit a trend line and obtain the trend values for the different years using…

Q: Provide a bar chart (with data labels rounded to two decimal points) showing the average demand for…

A: Consider the following table:- Weekday Date Sum of Daily Demand Average Mon…

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

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Time Series Analyses, Forecasting Methods, and Indices$

Learn more about

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

Similar questions

Cable TV The following table shows the number C. in millions, of basic subscribers to cable TV in the indicated year These data are from the Statistical Abstract of the United States. Year 1975 1980 1985 1990 1995 2000 C 9.8 17.5 35.4 50.5 60.6 60.6 a. Use regression to find a logistic model for these data. b. By what annual percentage would you expect the number of cable subscribers to grow in the absence of limiting factors? c. The estimated number of subscribers in 2005 was 65.3million. What light does this shed on the model you found in part a?
Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?
The US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the trend appearslinear. Ifso, and assuming the trend continues, in what year will imports exceed 12,000 hectoliters?
U.S. Civilian Labor Force (thousands)Year Labor Force Year Labor Force2007 173,966 2012 175,6762008 174,703 2013 175,1992009 173,159 2014 176,2862010 173,698 2015 178,0052011 174,043 2016 179,688 Make forecasts using the following fitted trend models for years 2017-2019. t Linear Quadratic Exponential 111213
The accompanying data represent the annual rates of return of two companies' stock for the past 12 years. Complete parts (a) through (k). Year Rate of Return of Company 1 Rate of Return of Company 21996 0.203 0.3981997 0.310 0.5101998 0.267 0.4101999 0.195 0.4362000 -0.101 -0.0602001 -0.130 -0.1512002 -0.234 -0.3572003 0.264 0.3282004 0.090 0.2072005 0.030 -0.0142006 0.128 0.0932007 -0.035 0.027 (j) Plot residuals against the rate of return of Company 1. Does the residual plot confirm that the relation between the rate of return of Company 1 and Company 2 is linear? Yes or No? (k) Are there any years where the rate of return of Company 2 was unusual? Yes or No?