Question: Generate forecasts for months 7 24 using a six period and a three period moving average Use MAD to compare the forecasts Month Sales Forecast

Generate forecasts for months 7 24 using a six period and a three period moving average Use MAD to compare the forecasts Month Sales Forecast 6 month Mooving Average Forecast 3 month Mooving Average 1 239 2 248 3 256 4 260 5 271 6 280 7 295 8 305 9 310 10 335 11 348 12 353 13 355 14 368 15 379 16 358 17 369 18 378 19 367 20 383 21 394 22 393 23 405 24 412 MAD For forecast round your answers to 1 decimal place the tolerance

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The forecast is shown below A 6 period moving average forecasting method can be used for calculating ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

The floor system used in a school classroom consists of a 4-in. reinforced stone concrete slab. Sketch the loading that acts along the joist BF and side girder ABCDE. Set a = 10ft. b = 30ft. -b

suppose Southern Mechanics has different demand forecast as follows: Please develop aggregate plan Forecast 1 2 3 4 5 6 Total 14 150 200 350 400 500/200 1,800

Complete the following ANOVA table. *Round your answer to 2 decimal places, the tolerance is +/-0.01. **Round your answer to 3 decimal places, the tolerance is +/-0.001. *** Round your answer to 2...

Period Average annual rate of inflation 3 months 5 2 years 6 5 years 8 10 years 85 20 years 9 a If the real rate of interest is currently 25 find the nominal rate of interest on each of the following...

The table on the following page lists the 50 states. (a) Obtain a simple random sample of size 10 using Table I in Appendix A, a graphing calculator, or computer software. (b) Obtain a second simple...

How hard is it to expand a set-covering model to accommodate new cities? Answer this by modifying the model in Figure 14.55. Add several cities that must be served: Memphis, Dallas, Tucson,...

In the original Western Airlines set-covering model in Figure 14.52, we assumed that each city must be covered by at least one hub. Suppose that for added flexibility in flight routing, Western...

A person exposed to an infectious agent, either by contact or by vaccination, normally develops antibodies to that agent. Presumably, the severity of an infection is related to the number of...

Susan is a ticket scalper. She buys tickets for Los Angeles Lakers games before the beginning of the season for $100 each. Since the games all sell out, Susan is able to sell the tickets for $150 on...

Last Chance Company offers legal consulting advice to prison inmates. Last Chance Company prepared the end-of-period spreadsheet shown at the top of the following page at June 30, 2019, the end of...

Hankuk Electronics started production on a sophisticated new smartphone running the Android operating system in January 2017. Given the razor-thin margins in the consumer electronics industry,...

Why do customers associate price with quality? When should prestige pricing be used?

White Guassian noise of zero mean and power spectral density N0/2 is applied to the filtering scheme shown in Figure a. The frequency responses of these two filters are shown in Figure b. The noise...

11 The longest side of a triangle is acm. The second side is bcm shorter than the first side. The third side is half as long as the second side. Write an expression, in its simplest form, for the...

The transactions and adjustments related to the first month of operations of Zoe Amelia Corp. were as follows: a. Issued common stock to the initial stockholders in exchange for their cash...

Along a supply curve, if the price of oil falls, what will happen to the quantity of oil supplied? Why?

Paterson Company,* a U.S.-based company, manufactures and sells electronic components worldwide. Virtually all its manufacturing takes place in the United States. The company has marketing divisions...

In Figure 3-9, the current position of the supply curve is S1, and the price of a portable power bank is $3. If suppliers anticipate a higher price of portable power banks in the future, will the...

At January 30, 2010, total assets were $33,652 and total stockholders' equity was $5,641. a. Calculate Dell, Inc.'s, working capital, current ratio, and acid-test ratio at February 3, 2012, and...

Use the graph of the function to find its domain and range. Write the domain and range in interval notation. -8 -7 -6 -5 -4 -3-2 -10 1 2 31 5 Provide your answer below: domain: range

Given the sales data from problem 23, generate forecasts for months 7-24 using a 6-period and a 3-period moving aver- age. Use MAD to compare the forecasts. Which forecast is more stable? Which is...

Given the sales data from Problem 23, generate forecasts for months 724 using a six-period and a three-period moving average. Use MAD to compare the forecasts. Which forecast is more stable? Which is...

4. The file Department StoreSales.xls contains data on the quarterly sales for a department store over a 6-year period. (27 pts) The time plot of the data is shown below. 120000 100000 80000 60000 /...

1. What did Pat and his team learn about the data patterns for orders and contacts per order from the time series plots and autocorrelation functions? 2. Fit an appropriate smoothing procedure to the...

1. All the coefficients of the dummy variables in Jame's regression are negative except that for Nov. Does this make sense? Explain. 2. Are you happy with Jame's regression model? What changes would...

You work at the private wealth management department of an investment bank. You are asked to generate demand forecasts for one of the popular investment advisory services. The demand data for the...