Question

5-16 Using MAD, determine whether the forecast in Problem 5-15or the forecast in the section...

5-16 Using MAD, determine whether the forecast in Problem 5-15 or the forecast in the section concerning Wallace Garden Supply is more accurate.

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

Forecast error = Actual value – Forecast Value MAD = ∑ |Forecast error |/ n

MONTH ACTUAL SHED 3-MONTH MOVING SALES AVERAGE 3-MONTH ABSOLUTE DEVIATION 4-MONTH MOVING AVERAGE 4-MONTH ABSOLUTE DEVIATION 4

The 3-month moving average appears to be more accurate.

Add a comment
Know the answer?
Add Answer to:
5-16 Using MAD, determine whether the forecast in Problem 5-15or the forecast in the section...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • given forecast errors of -5, -10 and +15 the mean absolute deviation (MAD) is 5) _...

    given forecast errors of -5, -10 and +15 the mean absolute deviation (MAD) is 5) _ 5) Given forecast errors of -5, -10, and +15, the Mean Absolute Deviation (MAD) is: B) 30. C) 175 D) 0. E) 225 A) 10.

  • Problem 22 Consider the following forecast results. Caloulate MFE, MAD, and MAPE, using the data for...

    Problem 22 Consider the following forecast results. Caloulate MFE, MAD, and MAPE, using the data for the months January through June. Does the forecast model under- or overforecast? Actual Forecast Month Demand January February March 968 1,091 1,089 1,063 1,054 898 1,029 1,113 June 1,013 1.100 The MFE slag (Enter your response rounded to one decimal place and include The MAD is(Enter your response rounded to one decimal place,) a minus sign if necessary)

  • Use Solver to determine the alpha that minimizes the MAD for the exponential smoothing forecast for...

    Use Solver to determine the alpha that minimizes the MAD for the exponential smoothing forecast for the data that appear in this table. Use the actual demand of period 1 as the forecast for period 2 and then use the forecasts for periods 2 through 9 to calculate MAD. Period Demand 1 272 2 278 3 269 4 280 5 267 6 258 7 278 8 298 9 286 10 290 0.43 0.36 0.54 0.62

  • "The MAD for the forecast developed using a weighted​ 2-year moving average with weights of 0.45...

    "The MAD for the forecast developed using a weighted​ 2-year moving average with weights of 0.45 and 0.55 = __ miles ​(round your response to one decimal​ place).  ​(Hint: You will have only 3 years of matched​ data.)" Score: 0 of 1 pt 3 of 5 (1 complete) HW Score: 0%, 0 of 5 pts Problem 4.5 Question Help The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to...

  • Compute the forecast using exponential smoothing with a smoothing constant of 0.15 and a forecast for...

    Compute the forecast using exponential smoothing with a smoothing constant of 0.15 and a forecast for Week 1 of 20,000. What is the MAD? Week Miles 1                    21,000 2                    25,000 3                    24,000 4                    26,000 5                    22,000 6                    25,000 7                    24,000 8                    24,000 9                    22,000 10                    24,000 11                    23,000 12                    24,000 13                    23,000 14                    22,000 15                    24,000

  • Given the forecast demand and actual demand for 10-foot fishing boats and 15-foot fishing boats, determine...

    Given the forecast demand and actual demand for 10-foot fishing boats and 15-foot fishing boats, determine which forecast is more accurate 10-foot fishing boats Year Forecast Demand Actual Demand YEAR 1 78 71 YEAR 2 75 80 YEAR 3 83 101 YEAR 4 84 84 YEAR 5 88 68 YEAR 6 85 73 15-foot fishing boats Year Forecast Demand Actual Demand YEAR1 78 72 YEAR2 75 79 YEAR 3 93 101 YEAR 4 80 84 YEAR 5 88 75 YEAR6...

  • This is a table to show how to calculate a three-month moving average. Please use this...

    This is a table to show how to calculate a three-month moving average. Please use this same data to calculate a four-month moving average. ACTUAL SHED SALES 10 12 13 16 19 23 26 30 28 18 16 MONTH 3-MONTH MOVING AVERAGE January March (10+ 12 + 13)3 -11.67 (12 13+ 16/3-13.67 (13 + 16 + 19)/3# 16.00 (16 + 19 +23Y3- 19.33 19 +23 + 26V3-22.67 (23+26 +30/3-26.33 (26+30 +28)V3-28.00 (30 +28 + 18/3-25.33 (28 + 18 + 163-20.67...

  • A popular brand of fly fishing rods has had the following demand history by quarters for the past 16 quarters. Quarter Demand Quarter Demand 81 52 1 9 46 10 108 56 74 12 49 4 75 13 59 5 92 14 6 65 79...

    A popular brand of fly fishing rods has had the following demand history by quarters for the past 16 quarters. Quarter Demand Quarter Demand 81 52 1 9 46 10 108 56 74 12 49 4 75 13 59 5 92 14 6 65 79 102 15 7 50 60 16 73 Using the data above, forecast the demand for the next 8 quarters using Winter's Seasonal Model. Use Minitab to find a good fitting seasonal model (you must decide...

  • please explain your answer. 2:5-34 Resolve Problem 5-33 with a = 0.3. Using MAD, which smoothing constant provides a...

    please explain your answer. 2:5-34 Resolve Problem 5-33 with a = 0.3. Using MAD, which smoothing constant provides a better forecast? 3:5-35 A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data are com- piled, and the state comptroller uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. Four years of quarterly data (in $1,000,000s) for one par- ticular...

  • The monthly sales for Telco Batteries Inc., were as follows: Month       Sales                        &n

    The monthly sales for Telco Batteries Inc., were as follows: Month       Sales                                      20    21    15        14    13    16    17        18    20        20    21    23                Compute a five and a seven-month moving average for months 8 thru 12 Using the data from problem 2: Determine which of these forecasts are more accurate using the MAD. How would you explain MAD to your supervisor?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT