Question: Here is the data for the past 9 months for actual sales of a particular product: Month Sales, $1,000 monthly, Sales, $1,000 quarterly: January: 275

Here is the data for the past 9 months for actual sales of a particular product: Month Sales, $1,000 monthly, Sales, $1,000 quarterly:

January: 275 , February: 375 , March: 350 , April: 425 , May: 400 , June: 350 , July: 350 , August: 275 , September: 350 ,

October: November: December:

Develop a forecast for the fourth quarter (Oct-Dec) using a three-quarter, weighted moving average. Weight the most recent quarter 0.5, the second most recent 0.25, and the third 0.25. Solve the problem using quarters, as opposed to forecasting separate months.

2. Calculate the Mean Absolute Deviation (MAD) based on the actual and forecasted demand over the first six months of the year shown in the following table:

Here is the data for the past 9 months for actual sales

MonthDemandMovingAverageForecast Deviation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 General Management Questions!

G 1 Problem 1. Here are the data for the past 21 months for actual sales of a particular product: K M N 0 400 Last Year This Year January 300 225 February 400 375 March 425 350 April 450 425 May 400...

1. What is the term for forecasts used for making day-to-day decisions about meeting demand? 2. What category of forecasting techniques uses managerial judgment in lieu of numerical data? 3. Given...

Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar: 2nd quarter Apr May Jun: 3rd...

4. Here are the data for the past 21 months for actual sales of a particular product: 300 LAST YEAR THIS YEAR January 275 February 400 375 March 425 350 April 450 425 May 400 400 June 460 350 July...

Problem 1. Here are the data for the past 21 months for actual sales of a particular product: Last Year 300 This Year 275 375 400 350 425 450 425 400 400 January February March April May June July...

1 )Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 345 290 February 395 375 March 470 365 April 460 475 May 400 440 June 470 325 July...

Given the data for the past 21 months for actual sales of a particular product below. LAST YEAR THIS YEAR 300 400 January February March April May 275 375 350 425 400 350 350 275 350 425 450 400 460...

Chapters 1. 2.3.5.7 0 Saved Here are the data for the past 21 months for actual sales of a particular product: January February March April May June August September October November December LAST...

3. Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note that the Ist quarter is Jan, Feb. and Mar: 2nd quarter Apr May, Jun;...

2. A company records reported below indicate monthly sales data for Z Company. Use the below mentioned techniques to help the administration: Month Sales (units) October 9 November 11 December 11...

Find the coordinate vector for w relative to the basis S= {u1, u2} for R2. U1 = (2, - 4), u2 = (3, 8); w = (1, 1)

In a computer program for the WangHenke bubble-point method, 10,100 storage locations are wastefully set aside for the four indexed coefficients of the tridiagonal-matrix solution of the component...

High quPART A Which TWO of the following best identify the central ideas of this text The nature of truth Justice and fair trial Growing up Mental illness and its relationship to crime PART B Which...

2. The force of interest 8 is a function of time and at any time t, measured in years, is given by the formula: 8(t) = 0.02 +0.0020 8(t) = 0.03 +0.005t Osts5 5 st s 10 a) Calculate the discount...