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?
-
What are the arguments for giving separate accounting recognition to the conversion feature of debentures?
-
Consider the circuit shown in Figure P9.19. (a) Determine the ideal output voltage \(v_{O}\) if \(v_{I}=-0.40 \mathrm{~V}\). (b) Determine the actual output voltage if the open-loop gain of the...
-
The Mann Corporation began operations in 2015.Information relating to the companys purchases of inventory and sales of products for 2015 and 2016 is presented below. Calculate the weighted-average...
-
1. If the variable cost per unit goes up, Contribution margin Break-even point a. Increases increases. b. Increases decreases. c. Decreases decreases. d. Decreases increases. e. Decreases remains...
-
Question 2-7 are based on the followingseries of futures price(F(0),F(1),...F(6)): Day 0:F(0)=$212 Day 1:F(1)=$211 Day 2:F(2)=$214 Day3:F(3)=$209 Day 4:F(4)=$210 Day5:F(5)=$202 Day6:F(6)=$200 Suppose...
-
Using suitable diagrams and the data in the case explain how Clive Jones could enlighten the board members about Modigliani and Millers
-
Inscribe a summary of a current event article related to activity-based costing and aviation. Like how American Airline has developed an activity-based costing system.
-
You hold a ruler that has a charge on its tip 4.00 cm above a small piece of tissue paper to see if it can be picked up. The ruler has -10.0 C of charge. The tissue has 5.00 g of mass. What is the...
-
A corporate bond (par value = 1000) is quoted at a price of $1020.00 with a current yield of 7.5 percent. What is the coupon rate?
-
Record the entry for insurance expense where an insurance policy, purchased on June 1 for $ 3 , 1 8 0 cash, provides coverage for 1 2 months. The insurance coverage since June has now been used up .
-
Woolard Supplies (a sole proprietorship) has taxable income in 2023 of $240,000 before any depreciation deductions ($179, bonus, or MACRS) and placed some office furniture into service during the...
-
Based on the situation outlined in this week's reading assignment about Dino Corp, use the Land text to build your answers to the following prompts: 1. Discuss two possible delegation barriers that...
-
During sprinting, the propulsive impulse lasts 2 times longer than the breaking impulse. The breaking impulse lasts 0.08 seconds. As a result of the breaking impulse the vertical velocity decreases...
-
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...
-
What is the formula for calculating the factory overhead applied rate?
-
Why are unit costs kept separate on the finished goods ledger card?
-
What is the name of the form used to authorize a seller to deliver goods with payment to be made later?
Study smarter with the SolutionInn App