A forecast sheet calculates: Question 13 options: Intervals. Future values. Moving averages. Summaries. Date and time.
Added by Kevin I.
Step 1
A forecast sheet is a tool used in data analysis to predict future values based on historical data. Show more…
Show all steps
Your feedback will help us improve your experience
Shyam P and 91 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
Compute the two-period and four-period moving average predictions for the data set. a. Prepare a line graph comparing the moving average predictions against the original data. b. Do the moving averages tend to overestimate or underestimate the actual data? Why? c. Compute forecasts for the next 2 years using the two-period and four-period moving average techniques.
Shyam P.
Year Demand 1 12 2 14 3 16 4 18 5 20 6 24 1) What is the forecast value for year 5 based on a 3-year simple moving average? 14 16 18 20 2) What is the forecast value for year 6 based on a 3-year weighted moving average in which demand in the most recent year is given a weight of 3 and demand in the other 2 years is each given a weight of 2? 14.29 16.29 18.29 20.29 3) Assume the last period's forecast for year 1 demand is 10 to begin the procedure. What is the forecasted value for year 3 for smoothing constant a=0.30? 10.60 11.62 12.93 14.45 4) What is the MAD (Mean Absolute Deviation) for the exponential smoothing method (a=0.30)? 4.27 4.38 4.71 9.42 5) Which one is the best forecasting method (simple moving average, weighted moving average, or exponential smoothing)? Simple moving average Weighted moving average Exponential smoothing None of the above
Adi S.
Emily Andrews has invested in a science and technology mutual fund. Now she is considering liquidating and investing in another fund. She would like to forecast the price of the science and technology fund for the next month before making a decision. She has collected the following data on the average price of the fund during the past 20 months: Month Fund Price 1 $55 3/4 2 54 1/4 3 55 1/8 4 58 1/8 5 53 3/8 6 51 1/8 7 56 1/4 8 59 5/8 9 62 1/4 10 59 1/4 11 62 3/8 12 57 1/1 13 58 1/8 14 62 3/4 15 64 3/4 16 66 1/8 17 68 3/4 18 60.5 19 65.875 20 72.25 a. Using a 3-month average, forecast the fund price for month 21. b. Using a 3-month weighted average with the most recent month weighted 0.5, the next most recent month weighted 0.30, and the third month weighted 0.20, forecast the fund price for month 21. c. Compute an exponentially smoothed forecast, using α=0.3, and forecast the fund price for month 21. d. Compare the forecasts in (a), (b), and (c), using MAD, and indicate the most accurate.
Recommended Textbooks
Horngren’s Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD