There was a step by step assist for this question in the resources and it not super
Fantastic news! We've Found the answer you've been seeking!
Question:
There was a "step by step assist" for this question in the resources and it not super unhelpful.
For all the yellow, it is a fixed sheet and we can not use data analytics, so it must be solved with an equation. For ES Forecast (Column C), I have tried several formulas and none of them are proving correct in the self check box. I know that the first box in the ESForecast is the revenue from the year before.. but after that nothing I input is correct.
Transcribed Image Text:
Excel File Edit View Insert Format Tools Data Window Help Modules 27-30, Budget Tools-4 (1).pdf Page 57 of 96 - Edited Search Rank Page Order Assignments Exponential smoothing is a technique applied to time series data to produce forecasts. There is a different version of exponential smoothing for trending data. Trending exponential smoothing is known as Holt exponential smoothing. TABLE 29.1 Northland: Special Revenue Fund For SES solutions, use a = 0.1. For Holt solutions, use a = 0.95 and = 0.01. 1. Recall the forecast produced for assignment 3 in Module 28 for the Northland special reve- nue fund. The original data are provided in Table 29.1. 1996 1997 1998 1999 2000 2001 2002 2003 2004 a. Using the same initial data and assumptions, refine the forecast using the exponential smoothing method appropriate for nontrending data. i b. Produce a graph showing the original data, the 5-year moving average forecast from Mod- ule 28, and the forecast produced using the exponential method. c. Which forecast would you recommend using, and why? 53,421,417 64,600,858 BUDGET TOOLS 67,053,747 24,316,124 66,110,642 93,389,137 49,686,023 20,706,410 81,238,032 DO V SES 2005 2006 2007 2008 2009 2010 2011 2012 2013 Found on 25 pages 4 C O A 2. Recall the forecast produced in assignment 5 in Module 28 for River County's property tax revenue. The original data are provided in Table 29.2. 49,055,130 124,202,747 a. Using the same initial data and assumptions, refine the forecast using the exponential smoothing method appropriate for trending data. 141 86,126,170 27,862,519 85,704,726 81,483,730 45,459,605 22,672,732 58,226,034 b. Create a matrix showing the ME and RMSE for the three scenarios of moving-average fore- casts from Module 28 and the ME and RMSE produced using the exponential method. c. Which forecast would you recommend using, and why? APR 1 57 < > X Jul 28, 2022 - To snap a screenshot of specific Mac windows, press an S Done Home C8 From From New Database HTML Text Query X fx 23 67 3 Special Revenue 4 5 8 9 10 11 12 3 45 A B 1 To show the cell checking, put a check here: 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Year AutoSave OFF Insert Draw 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Ready S Page Layout Refresh All Put graphs here 53,421,417 64,600,858 67,053,747 24,316,124 66,110,642 93,389,137 49,686,023 20,706,410 81,238,032 49,055,130 124,202,747 86,126,170 27,862,519 85,704,726 81,483,730 45,459,605 22,672,732 58,226,034 =80 V 8: tv Revenue ESForecast C a Connections Properties Edit Links 1 53,421,417 TRUE Formulas Put text answer here Exercise 29.1 Error D X Data Review View Stocks Geography Error SQ D E Check AL 2Y & Clear E Sort Filter Reapply Advanced Z F Assignment 4 - NP-Week 2 - BT 2e Module 29 Exercise W G Mean RMSE 5 yr MA & Error H X Text to Flash Remove Columns Fill Duplicates Validation Error SQ A E I Data Consolidate J K All Coman What-If Analysis L Grade Graph 1 Grade Graph 2 Judicial Watch Wright * Group W V @ 2 Ungroup Subtotal M Percent Correct Google N Grade Text Answer Sat Apr 1 7:39 PM Search Sheet Show Detail Hide Detail O Share ? Data Solver Analysis P Comm 1% + 12 Excel File Edit View Insert Format Tools Data Window Help Modules 27-30, Budget Tools-4 (1).pdf Page 57 of 96 - Edited Search Rank Page Order Assignments Exponential smoothing is a technique applied to time series data to produce forecasts. There is a different version of exponential smoothing for trending data. Trending exponential smoothing is known as Holt exponential smoothing. TABLE 29.1 Northland: Special Revenue Fund For SES solutions, use a = 0.1. For Holt solutions, use a = 0.95 and = 0.01. 1. Recall the forecast produced for assignment 3 in Module 28 for the Northland special reve- nue fund. The original data are provided in Table 29.1. 1996 1997 1998 1999 2000 2001 2002 2003 2004 a. Using the same initial data and assumptions, refine the forecast using the exponential smoothing method appropriate for nontrending data. i b. Produce a graph showing the original data, the 5-year moving average forecast from Mod- ule 28, and the forecast produced using the exponential method. c. Which forecast would you recommend using, and why? 53,421,417 64,600,858 BUDGET TOOLS 67,053,747 24,316,124 66,110,642 93,389,137 49,686,023 20,706,410 81,238,032 DO V SES 2005 2006 2007 2008 2009 2010 2011 2012 2013 Found on 25 pages 4 C O A 2. Recall the forecast produced in assignment 5 in Module 28 for River County's property tax revenue. The original data are provided in Table 29.2. 49,055,130 124,202,747 a. Using the same initial data and assumptions, refine the forecast using the exponential smoothing method appropriate for trending data. 141 86,126,170 27,862,519 85,704,726 81,483,730 45,459,605 22,672,732 58,226,034 b. Create a matrix showing the ME and RMSE for the three scenarios of moving-average fore- casts from Module 28 and the ME and RMSE produced using the exponential method. c. Which forecast would you recommend using, and why? APR 1 57 < > X Jul 28, 2022 - To snap a screenshot of specific Mac windows, press an S Done Home C8 From From New Database HTML Text Query X fx 23 67 3 Special Revenue 4 5 8 9 10 11 12 3 45 A B 1 To show the cell checking, put a check here: 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Year AutoSave OFF Insert Draw 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Ready S Page Layout Refresh All Put graphs here 53,421,417 64,600,858 67,053,747 24,316,124 66,110,642 93,389,137 49,686,023 20,706,410 81,238,032 49,055,130 124,202,747 86,126,170 27,862,519 85,704,726 81,483,730 45,459,605 22,672,732 58,226,034 =80 V 8: tv Revenue ESForecast C a Connections Properties Edit Links 1 53,421,417 TRUE Formulas Put text answer here Exercise 29.1 Error D X Data Review View Stocks Geography Error SQ D E Check AL 2Y & Clear E Sort Filter Reapply Advanced Z F Assignment 4 - NP-Week 2 - BT 2e Module 29 Exercise W G Mean RMSE 5 yr MA & Error H X Text to Flash Remove Columns Fill Duplicates Validation Error SQ A E I Data Consolidate J K All Coman What-If Analysis L Grade Graph 1 Grade Graph 2 Judicial Watch Wright * Group W V @ 2 Ungroup Subtotal M Percent Correct Google N Grade Text Answer Sat Apr 1 7:39 PM Search Sheet Show Detail Hide Detail O Share ? Data Solver Analysis P Comm 1% + 12
Expert Answer:
Answer rating: 100% (QA)
Here are the steps to solve this using exponential smoothing 1a Refine the forecast for Northland special revenue fund using simple exponential smooth... View the full answer
Related Book For
Introduction to Algorithms
ISBN: 978-0262033848
3rd edition
Authors: Thomas H. Cormen, Charles E. Leiserson, Ronald L. Rivest
Posted Date:
Students also viewed these finance questions
-
Assume the role of a marketing communication consultant hired to plan an integrated digital marketing campaign for the ICOME2022 conference. The Faculty of Management Studies has already launched the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
How does national culture relate to business structures?
-
Job costing, process costing. In each of the following situations, determine whether job costing or process costing would be more appropriate. a. A CPA firm b. An oil refinery c. A custom furniture...
-
Why is float a valuable resource, and why is free float more valuable than total float?
-
Shareholder value is cash-oriented. Do you agree with this statement? Give reasons.
-
Speier Company estimates that 240,000 direct labor hours will be worked during 2012 in the Assembly Department. On this basis, the following budgeted manufacturing overhead data are computed. It is...
-
In 2007, DART was $1 B short for building a new suburban rail line out to Irving and Rowlett. One of the reasons for this budgetary shortage was high inflation in heavy construction sector in 2004,...
-
Gas absorption or gas scrubbing is a commonly used method for removing environmentally undesirable species from waste gases in chemical manufacturing and combustion processes. The waste gas is...
-
As the lead Process Engineer at DYECHEM Industrial (pty) Ltd, you required to write a program using OCTAVE that shows how the unit step response Cn (t) becomes more sluggish as n increases from 1 to...
-
Define process. Describe the contents of a Process Control Block (PCB).
-
Tanner-UNF Corporation acquired as a long-term Investment $170 million of 6% bonds, dated July 1, on July 1, 2024. Company management has the positive Intent and ability to hold the bonds until...
-
Evaluate and analyze the use of Modern/Theory Y types of practices and theory (McGregor and Rieger) in this case....
-
2. For each of the following transactions, state two things: (1) which section of the Statement of Cash Flows (SCF) would this transaction be reported in; and (2) would it be ADDED or SUBTRACTED?...
-
1) Analyze the rental process given in the case study. What are the factors that affect the throughput rate, throughput time, and inventory at each stage of the process (available, delivery, pickup...
-
Proposed Business Analytical solution for AIR ASIA Discuss the business transformation scope The Business Intelligence architecture Business Intelligence Architecture Diagram and description Business...
-
Discuss whether responsible human resources management should apply different standards for the home company and suppliers, for developed countries and developing countries, and for large companies...
-
Give an efficient algorithm to convert a given -bit (binary) integer to a decimal representation. Argue that if multiplication or division of integers whose length is at most takes time M(), then we...
-
Your knowledge of algorithms helps you obtain an exciting job with the Acme Computer Company, along with a $10,000 signing bonus. You decide to invest this money with the goal of maximizing your...
-
Show how OS-SELECT (T.root, 10) operates on the red-black tree T of Figure 14.1. Figure 14.1 26 20 17 41 E--- 12 7 14 21 30 47 -------- -------- E---- ----- --- 4 1 16 2 (14 (10 19 21 28 38 4 2 1 12...
-
A Ltd owns 100% of the issued share capital of B Ltd and 70% of the issued share capital of C Ltd. C Ltd owns 70% of the issued share capital of D Ltd. (a) Which companies are associated with A Ltd?...
-
S1 Ltd and S2 Ltd belong to the same capital gains group. In May 2020, S1 Ltd transferred a chargeable asset to S2 Ltd. The original cost of this asset to S1 Ltd was 10,000 and its market value in...
-
The ordinary share capital of W Ltd (which is a trading company) is owned 30% by X Ltd, 25% by Y Ltd and 45% by Z Ltd. All of these companies are UK resident and they prepare accounts to 31 March....
Study smarter with the SolutionInn App