Based on the information in the following table, use the THREE-MONTH MOVING AVERAGE Approach to forecast the demand for periods 4 to 12. PERIOD MONTH Demand Forecast 1 Jan 129 Feb 57 Mar 66 Apr 138 May 183 6. Jun 54 7. Jul 141 8. Aug 216 9. Sep 51 10 Oct 102 11 Nov 213 12 Dec 78

Based on the information in the following table, use the THREE-MONTH MOVING AVERAGE Approach to forecast the demand for periods 4 to 12. PERIOD MONTH Demand Forecast 1 Jan 129 Feb 57 Mar 66 Apr 138 May 183 6. Jun 54 7. Jul 141 8. Aug 216 9. Sep 51 10 Oct 102 11 Nov 213 12 Dec 78

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: Consider the following data: Monthly Profit of a Gym: Month & Profit: Jan-12: 5800 Feb-12: 5553…

A: Given the data on the monthly profit of a Gym. The table below shows the required calculation-

Q: For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12…

Q: Consider the following data. Period Rate of Return (%) 1 - 6.0 2 - 8.2 3 - 4.2 4 2.2 5 5.6 What is…

A: Given Period Rate of return 1 -6.0 2.…

Q: The Manager of a towel company needs to accurately forecast the demand for towels. If the supply of…

A: Forecasting

Q: Consider the following data: Monthly Profit of a Gym: Month & Profit: Jan-12: 5700 Feb-12: 5453…

A: The Monthly Profit of the Gym is given as : Month Profit Jan-12 5700 Feb-12 5453…

Q: Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS…

A: See the handwritten solution

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: In a table of “Sales as a % of Moving Average” over a 5-year period the average of the four entries…

A: Given Solution:

Q: 14. Given the following data for demand at the XYZ Company, calculate the monthly forecast using a…

A: The objective is to calculate the forecast error, absolute deviation, mean absolute deviation, bias…

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

A: See the handwritten solution

Q: From the following data, compute i. Laspeyre’s price index ii. Paasche’s price index Commodity…

A: Commodity Base Commodity Base Current period Current period Price (K) Quantity (Kg) Price (K)…

Q: Consider the following data:Monthly Profit of an Auto Repair Shop Month Jan-14 Feb-14 Mar-14…

A: The exponential smoothing forecast for the next time period (Oct-14) is 19,193.2 and it is…

Q: The average daily sales (in litres) of milk at a country store are shown in Table 4 for each of the…

A: Trend is the general tendency of the data set to increase or decrease during a long period of time.…

Q: Given the following demand for ten-period time frame as shown in the table below. Compute the…

A: For the given data Compute the three-period and five-period moving average forecasts. Plot the…

Q: The following table shows the daily receipts in millions of dollars of the movie "Avatar" for…

Q: Consider the following data. Period Rate of Return (%) 1 - 5.8 2 - 8.0 - 3.8 4 2.0 5 5.2 What is the…

Q: 2. The manager of a fabric company needs to accurately forecast the demand for fabric. If the…

A: The question is based on a time series Given :

Q: 6. Calculate a 7-months moving average for each month. What is the forecast for month 11? Months…

A: To Find: 7 months moving average for each month Formula using 7-month moving average…

Q: Considering the aggregated demand for coffee beans for the following months shown below, what would…

A: Data is given for 6 months, We have to calculate forcast for 8 th month. We will use 3 months moving…

Q: consider the following data. Period Rate of Return (%) - 5.8 2 - 7.8 3 -4.0 4 2.0 5.4 What is the…

A: E[x] =∑xp(x)

Q: Compute a simple aggregate price index. Use 2010 as the base period.

A: Let po be the base year prices. i.e 2010 And p1 be the current year prices i.e 2018

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

A: In statistics, a moving average is a calculation used to analyze data points by creating a series of…

Q: Using the'data given below, calculate Price Index Numbers for the year 1998 by (i) Laspeyre's…

A: Solution is given: '

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

Q: Total cost and number of units in the first seven months of 2020 are given below. According to this…

A: a. Y=16000+52*X

Q: A shop is planning an order for a popular Christmas festive season product. Demand for the product…

A: From the given information, Consider, Demand = X be a random variable. P (X=x) = p, 0< p<1…

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: The records shown in the table provide an excellent opportunity for you to assist them with their…

Q: Compute a simple aggregate price index. Use 2010 as the base period

A: Let po denote the base year prices. And p1 denote the current year prices.

Q: The Manager of a towel company needs to accurately forecast the demand for towels. If the supply of…

A: image is attached with detailed solution.

Q: Considering the actual demand values below for LCD TVs sold by a retailer per month, what is the…

A: The following information has been provided: Month Demand 1 42 2 40 3 43 4 40 5 41…

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: Table 3 shows the actual per liter prices for unleaded petrol for June of each year between 1978 and…

A: Inflation: An increase in the price due to the change in time is referred to as inflation. This…

Q: Make forecasts using the following fitted trend models for years 2017-2019. (Round your answers to…

A: The year 2007 can be labeled as 1, the year 2008 can be labelled as 2, and so on. The data inserted…

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

Q: From the following data construct Laspayres Price index number in 1989 with 1986 as base year.…

A: We have given the following data Let p0 and q0 denotes the price and quantity of base year 1986 and…

Q: The following table shows timber stumpage prices for pine pulpwood in two regions of the American…

A: Disclaimer: Since you have posted a question with multiple sub-parts, we will solve first three…

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: The following table shows quarterly demand (in thousand units) for a product over 4 years. Year 1…

A: Since, the exact question number is not specified, we'll be answering the first question. Please…

Q: Consider the monthly unit sales for 2019, the company's full year 2020 forecast, and year-to-date…

A: The data below contains the additional column for the absolute deviations of the monthly sales for…

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: Based on the information in the following table, use the Naïve Approach to forecast the demand for…

A: According to the Naive approach, the best forecast for a future period is given by the observed…

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: Given the following data, compute the MSE for the forecasts. Round your answer to two decimal…

A: Given : Actual Demand Forecast 16 19 19…

Q: Calculate Fisher's price index from the following data and check whether time Reverse Test is…

A: Given: Base Year (1990) Current year(1995) Commodity Price Quantity Price…

Q: Compute 3-yearly moving averages of the following data assuming the length Of business cycle as 3…

Q: Use tables to express and represent the descriptive statistics for the variables below. Years…

A: Given information: Years Nominal Exchange RateJ$ - US$1 Value of ImportsBillions USD Value of…

Q: 89 july 223 Feb 57 august 286 mar 144 sept 212 april 221 oct 275 may 177 nov 188 june 280 dec 312 a)…

A: Month Demand Jan 89 Feb 57 mar 144 April 221 may 177 June 280 July 223 august 286…

Question

Based on the information in the following table, use the THREE-MONTH MOVING AVERAGE
Approach to forecast the demand for periods 4 to 12.
PERIOD
MONTH
Demand
Forecast
1
Jan
129
--
Feb
57
3
Mar
66
Apr
138
May
183
Jun
54
Jul
141
Aug
216
Sep
51
10
Oct
102
11
Nov
213
12
Dec
78
2.
5.
7
9,

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

The following table shows predicted product demand using your particular forecasting method along with the actual demand that occurred: FORECAST ACTUAL 1,515 1,585 1,415 1,515 1,715 1,615 1,755 1,680 1,805 1,730 Compute the tracking signal using the mean absolute deviation and running sum of forecast errors.
Find out the next month after april income by using the forecasting method of the moving average method
A pizza chain has had sales for take-out food over the last four evenings—Monday, Tuesday, Wednesday, and Thursday—of 29, 25, 35, and 30 pizzas, respectively.What would be their forecast for Friday using an exponential smoothing forecastingapproach? Use α = 0.2 and a forecast for Monday of 28.
The Fast Track Ski Shoppe sells ski goggles during the four months of the ski season.Average demand follows: a. Calculate the deseasonalized sales and the seasonal index for each of the fourmonths.b. If next year’s demand is forecast at 1200 pairs of goggles, what will be the forecast sales for each month?
According to a high-profile realtor, houses in the sleepy town of Sun Beach have shown higher appreciation over the past three years than have houses in the bustling town of North Arden. To test the realtor's claim, an economist has found eight recently sold homes in Sun Beach and eight recently sold homes in North Arden that were owned for exactly three years. The following table gives the appreciation (expressed as a percentage increase) for each of the sixteen houses. Appreciation rates in percent Sun Beach 10.2, 9.7, 12, 10.4, 7.9, 10.9, 9.6, 13.3 North Arden 7.5, 12.8, 5.9, 8.5, 8.1, 9.3, 6.3, 13.4 Assume that the two populations of appreciation rates are normally distributed and that the population variances are equal. Can we conclude, at the 0.05 level of significance, that houses in Sun Beach have higher appreciation over the past three years than houses in North Arden? Perform a one-tailed test. The null hypothesis: H0:…
The accompanying dataset provides data on monthly unemployment rates for a certain region over four years. Compare 3- and 12-month moving average forecasts using the MAD criterion. Which of the two models yields better results? Explain. Find the MAD for the 3-month moving average forecast. MAD=? (Type an integer or decimal rounded to three decimal places as needed.) Year Month Rate(%) 2010 Jan 7.8 2010 Feb 8.2 2010 Mar 8.8 2010 Apr 9.1 2010 May 9.5 2010 Jun 9.3 2010 Jul 9.7 2010 Aug 9.6 2010 Sep 9.8 2010 Oct 10.1 2010 Nov 9.7 2010 Dec 9.8 2011 Jan 9.7 2011 Feb 9.9 2011 Mar 9.8 2011 Apr 9.9 2011 May 9.7 2011 Jun 9.4 2011 Jul 9.4 2011 Aug 9.3 2011 Sep 9.7 2011 Oct 9.3 2011 Nov 9.9 2011 Dec 9.5 2012 Jan 9.3 2012 Feb 8.8 2012 Mar 8.7 2012 Apr 9.1 2012 May 9.2 2012 Jun 9.2 2012 Jul 9.1 2012 Aug 9.1 2012 Sep 9.1 2012 Oct 8.9 2012 Nov 8.4 2012 Dec 8.3 2013 Jan 8.4 2013 Feb 8.1 2013 Mar 8.4 2013 Apr…
Given the following average demand for each month, calculate the seasonal indicesfor each month.
The following table shows the daily receipts in millions of dollars of the movie "Avatar" for successive Fridays after its opening on Friday 18 December 2009. Weeks $Receipts 2 68.49 4 42.785 6 31.28 8 23.611 10 13.655 12 6.526 14 2.047 16 0.844 18 0.92 20 0.425 22 0.188 24 0.076 26 0.045 28 0.028 Estimate the instantaneous rate of change of daily receipts 14 weeks after the opening day. Round to four decimal places..
Given the following data for demand at the XYZ Company, calculate the monthly forecast for 2003 using a 3-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error), Bias and the TS (tracking signal) .
Given the following data on the number of pints of ice cream sold at a local ice cream store for a 10-period time frame period. Demand 1 200 2 245 3 190 4 270 5 280 6 300 7 320 8 340 9 320 10 280 Use a 2-period moving average to forecast demand for period 11 Group of answer choices 310 330 300 290
Metropolitan Hospital has estimated its average monthly bed needs, N, as: N=460+9X�=460+9� where X = time period (months); (January 2002 = 0) Assume that no new hospital additions are expected in the area in the foreseeable future. The following monthly seasonal adjustment factors have been estimated, using data from the past five years: Forecast Metropolitan's bed demand for January, April, July, November, and December 2007. Month Adjustment Factor (%) Forecast January +5 April -15 July +4 November -5 December -25 Suppose the following actual and forecast values for June bed demands have been recorded. Year Forecast Actual 2007 1,045 1,139 2006 937 974 2005 829 895 2004 721 743 2003 613 656 2002 505 515 What seasonal adjustment factor would you recommend be used in making future June forecasts? 2.1% 5.5% 1.3%
John Kittle, an independent insurance agent, uses a five-year moving average to forecast the number of claims made in a single year for one of the large insurance companies he sells for. He has just discovered that a clerk in his employ incorrectly entered the number of claims made four years ago as 1,400 when it should have been 1,200.a. What adjustment should Mr. Kittle make in next year’s forecast to take into account the corrected value of the number of claims four years ago?b. Suppose that Mr. Kittle used simple exponential smoothing with a = .2instead of moving averages to determine his forecast. What adjustment is now required in next year’s forecast? (Note that you do not need to know the value of the forecast for next year in order to solve this problem.)