Question: For the data below, based on a 4 period moving average forecasting method calculate the following: YearQuarterSales 1 1 3 8 4 2 3 2

For the data below, based on a 4 period moving average forecasting method calculate the following:
YearQuarterSales1138423243322430021343238233864380313182312339243104135323533387430351311238333264333
1) Calculate the mean absolute error.ANSWER TO 2 DECIMAL PLACES
2) Calculate the mean square error. ANSWER TO 2 DECIMAL PLACES
3) Calculate the absolute percentage error.ANSWER AS A PERCENT TO 2 DECIMAL PLACES...INCLUDE UNITS (I.E. THE PERCENT SIGN)
4) Predict the number of sales for the first quarter of year 6.

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!

Q:

Question 3 (4 points) ListenReadSpeaker webReader: Listen For the data below, based on a 4 period moving average forecasting method calculate the following: Year Quarter Sales 1 1 234 2 194 3 201 4...

Q:

For the data below, based on a 4 period moving average forecasting method calculate the following: YearQuarterSales 1 1 3 8 4 2 3 2 4 3 3 2 2 4 3 0 0 2 1 3 4 3 2 3 8 2 3 3 8 6 4 3 8 0 3 1 3 1 8 2 3 1...

Q:

For the data below, based on a 3 period moving average forecasting method calculate the following: Year Quarter Sales 1 1 154 2 130 3 186 4 182 2 1 145 2 118 3 145 4 120 3 1 114 2 149 3 183 4 103 4 1...

Q:

Question 1: The company has been concerned with the continued fluctuations in monthly demand witnessed over the past year. The company has a policy of using the exponential smoothing method for...

Q:

Note: You can use help from software such as MS Excel to solve the forecasting method and MS project Management. The knowledge is refered to Supply Chain Management Walmart Sales Data Time Period all...

Q:

The five period moving average is calculated using the following formula: [ Forecast for Period 8 = Period 1 + Period 2 + Period 3 + Period 4 + Period 5 ) / 5 ( 5 3 + 4 8 + 6 2 + 6 8 + 5 9 ) / 5 = 5...

Q:

Use the following table to answer the below question: Daily Customers at Cream Donuts DAY CUSTOMERS 1 76 N 85 3 85 4 106 Using the Moving Average forecasting method, calculate the 4-day moving...

Q:

Maryam, Mouza and Maitha (MMM) Ice Cream have sold the following number of ice creams for the last six months. Month Number of ice creams October 1200 November 1230 December 1450 January 1410...

Q:

15. The mix of equipment and human skills in a process determines the level of: A) process structure B) capital intensity C) customer involvement D) resource flexibility E) None of the above A...

Q:

On the "data and template" tab I am required to show work as well. A B D H M Holt-Winter's method Three-period moving average 1 Alpha Beta Gamma 0.200 0.100 0.200 MAD ME MAD ME Demand Base level...

Q:

Magna Lighting Inc. produces and sells lighting fixtures. An entry light has a total cost of $125 per unit, of which $80 is product cost and $45 is selling and administrative expenses. In addition,...

Q:

Marty and Mary have jobs and contribute to the household expenses according to their income. Marty contributes 75% of the expenses and Mary contributes 25%. Currently, their household expenses are $...

Q:

? _ _ _ _ _ _ _ r e c o g n i z e s t h a t f o r e v e r y t r a n s a c t i o n t h a t a f f e c t s a n a s s e t , a n e q u a l t r a n s a c t i o n m u s t a l s o a f f e c t e i t h e r a l...

Q:

-/1 View Policies Current Attempt in Progress The following amortization and interest schedule reflects the issuance of 10-year bonds by Bridgeport Corporation on January 1, 2014, and the subsequent...