Based on the information in the following table, use the THREE-MONTH MOVING AVERAGE Approach to forecast the demand for periods 4-12 PERIOD MONTH Demand Forecast Jan 57 Feb 69 3. Mar 210 Apr 54 5. May 207 Jun 108 7. Jul 210 Aug 78 Sep 156 10 Oct 114 11 Nov 135 12 Dec 171

Based on the information in the following table, use the THREE-MONTH MOVING AVERAGE Approach to forecast the demand for periods 4-12 PERIOD MONTH Demand Forecast Jan 57 Feb 69 3. Mar 210 Apr 54 5. May 207 Jun 108 7. Jul 210 Aug 78 Sep 156 10 Oct 114 11 Nov 135 12 Dec 171

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: Predict the annual salary in dollars for a mathematics instructor with 10 years of experience.…

Q: A restaurant has tracked the number of meals served at lunch over the last four weeks. The data show…

A: Given a restaurant has tracked the numbers of meals served at lunch over the last four weeks.

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: Given the following history, use a three-quarter moving average to forecast the demand for the third…

A: See the handwritten solution

Q: Use this data and build a model to forecast annual maintenance expenses based on the weekly

A: Here annual maintenance expenses is dependent variable Y and weekly usage is independent variable X.…

Q: The table shows the inflation-adjusted annual income per person in 1990 and 2011 for each listed…

A: According to the given information, the given table shows the increase in annual income per person…

Q: Use this data and develop a model of a truck's annual maintenance expenses based on its weekly usage…

Q: If an asset declines in value from $5,000 to $2,600 over nine years, what is the mean annual growth…

A: Initial value = 5000 Final Value = 2600 Number of years = n = 9

Q: Compute the one-step-ahead 3-month and 6-month moving-average forecasts for July through December.…

A: Given information: The data presents the sample for the months January through December.

Q: Use this data and build a model to forecast annual maintenance expenses based on the weekly usage in…

A: Given the data to calculate the SSE.

Q: ek demand (tons) 1 1174.5 2 1316.2 3 1197 4 1127.3 5 1193.1 6 1260.7 7 1378.2 8 1273.7 9 1366.4 10…

A: Q

Q: Your manager is trying to determine what forecasting method to use. Based on the following…

A: MONTHACTUAL DEMAND162265367468571673776878978108011841285

Q: The following table shows the gold prices in recent 4 years: Price Price Index Year (USS per ounce)…

A: The following information has been given: Year Price Base year Price(2018) 2018 1328 1328…

Q: The table shows the sales revenue from the past 8 quarters. What is the 4-period moving average…

A: The given table shows the sales revenue from the past 8 quarters.

Q: Use this data and and generate a model of the annual maintenance expenses based on the age of the…

A: Obtain the regression equation The value of slope is obtained below as follows: From the…

Q: The following data show the average Home Price Index over a six-quarter period. Complete parts a…

Q: The table below reports the annual stock price in September for Apple from 2005 to 2014. Develop a…

A: Index number are used to measure the increase in price over a period of time. It is broadly…

Q: The table below contains the weekly actual demand and forecasted demand for a product. Week Actual…

A: Given the weekly actual and forecasted demand for the product.Want to calculate MAD, tracking…

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

A: To forecast the demand for the third quarter of this year using a three-quarter moving average, we…

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

A: Monthly actual and forecast demand levels for May to December for units of product manufactured by…

Question

Based on the information in the following table, use the THREE-MONTH MOVING AVERAGE
Approach to forecast the demand for periods 4-12
PERIOD
MONTH
Demand
Forecast
Jan
57
2.
Feb
69
3.
Mar
210
Apr
54
May
207
Jun:
108
7.
Jul
210
Aug
78
69
Sep
156
10
Oct
114
11
Nov
135
12
Dec
171

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 with 2 images

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

3. The Save More Rental Car Agency at the Cincinnati airport would like to examine records from last summer in order to plan for the coming summer demand. The data for last year's demand, broken down by type of vehicle requested, is shown in the table below. Vehicle Type Sub-compact Compact Full-size Frequency 545 892 740 360 280 168 2985 * Total is not equal to 1.000 due to rounding error. Relative Frequency 0.183 0.299 0.248 Luxury SUV Van Total 0.121 0.094 0.056 1.001* a) Construct a frequency and relative frequency bar chart for the data. b) Construct a pie chart to display the information. c) This summer's demand is expected to be 20% higher than demand for last summer. Approximately how many luxury cars are expected to be rented this summer?
Since the discovery of the tiger gar population in Lake Richmond, the population of bluegill fish has also shown significant change: 2016 2017 2018 2019 2020 2021 2,465 2,092 1,783 1,513 1,287 1,094 What is the multiplicative rate of change in the bluegill population?
Suppose seafood price and quantity data for the years 2000 and 2009 follow. Use 2000 as the base period. 2000 2000 Price ($/lb) 2009 Seafood Qty. (Ib) Price ($/lb) Halibut 75,090 2.01 2.33 Lobster 83,180 3.62 3.09 Tuna 50,779 1.87 1.97 (a) Compute a price relative for each type of seafood. (Round your answers to one decimal place.) Seafood Price Relative Halibut Lobster Tuna (b) Compute a weighted aggregate price index for the seafood catch. (Round your answer to one decimal place.) I 2009 - Comment on the change in seafood prices over the nine-year period. (Enter your percentage as a positive value. Round your answer to one decimal place.) Seafood prices have --Select--- v by % over the 9-year period according to the index.
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. ACTUAL June 150 July 190 August 220 a. Using a simple three-month moving average, what is the forecast for September? b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively? c. Using single exponential smoothing and assuming that the forecast for June had been 132, forecast sales for September with a smoothing constant alpha of 0.20.
Use the gas prices data set below to calculate a 3-month Weighted Moving Average (WMA) forecast for the average gas prices and predict the average retail gasoline price for February 2015. Use the weights of 0.6, 0.3, and 0.1 for the 3-month WMA, where the first weight is used for the most recent month and the last weight is used for the least recent month. Round your answer to two decimal places, if necessary. Month-Year Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Average Gas Price $3.766 $3.688 $3.565 $3.484 $3.255 $2.997 $2.632 $2.208 Copy Data
find the μX and the σx with the provided data
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note that the 1st quarter is January, February, and March; 2nd quarter April, May, June: 3rd quarter July, August, September; and 4th quarter October, November, December. Note: Round final answer to a whole number. JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER Last year 120 145 155 195 205 220 170 160 150 220 245 270 This year 145 155 175 210 215 210
Month Actual demand Forecasted Demand 1 950 1000 2 1070 1000 3 1100 1000 4 960 1000 5 1090 1000 6 1050 1000 For the dataset above, compute the overall MAPE.
Suppose that a firm's sales were $3,750,000 five years ago and are $5,250,000 today. What was the geometric mean growth rate in sales over the past five years?
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 exponential smoothing method to forecast the number of sales to expect next month. Use the following value of alpha: 0.2. Month Demand Forecast 1 308 349.2 2 388 340.9 3 344 350.3 4 400 349.1 5 341 359.3
The rent for tenants in a building in 1940 was $30 per month. The landlord changes the rent based on the CPI-U. Use the CPI-U chart below to calculate the current rent in 2019. Round to the nearest dollar. Year CPI-U 1940 14.0 1949 23.8 1983 99.6 2000 172.2 2005 195.3 2009 214.5 2014 236.0 2017 245.1 2019 255.7 2020 258.8