I don't really understand how to estimate revenue. I have been given revenues from previous years and I am being asked to estimate the revenue for FY2020 and explain my rationale. Please help thank you! Please show all relevant work so I can understand how you got to the answer. Thank yOU!
Year | Revenue Collections |
2002 | $ 329,687 |
2003 | $ 384,829 |
2004 | $ 378,109 |
2005 | $ 447,858 |
2006 | $ 523,845 |
2007 | $ 621,253 |
2008 | $ 824,460 |
2009 | $ 739,140 |
2010 | $ 821,729 |
2011 | $ 1,035,700 |
2012 | $ 901,902 |
2013 | $ 867,344 |
2014 | $ 857,415 |
2015 | $ 885,966 |
2016 | $ 963,744 |
2017 | $ 1,141,337 |
2018 | $ 1,201,877 |
2019 | $ 1,116,045 |
2020 | ?????? |
We can use simple moving average method to estimate the 2020 sales as it smooths the fluctuations in data and is dynamic.
Moving average method gives you the trend of data 3 year moving average has been calculated in excel
last moving average is the required estimate of sales in 2020
Year | Sales | 3 year Moving Average |
2002 | 329687 | |
2003 | 384829 | 364208 |
2004 | 378109 | 403599 |
2005 | 447858 | 449937 |
2006 | 523845 | 530985 |
2007 | 621253 | 656519 |
2008 | 824460 | 728284 |
2009 | 739140 | 795110 |
2010 | 821729 | 865523 |
2011 | 1035700 | 919777 |
2012 | 901902 | 934982 |
2013 | 867344 | 875554 |
2014 | 857415 | 870242 |
2015 | 885966 | 902375 |
2016 | 963744 | 997016 |
2017 | 1141337 | 1102319 |
2018 | 1201877 | 1153086 |
2019 | 1116045 | |
2020 | 1153086 |
I don't really understand how to estimate revenue. I have been given revenues from previous years...
Construct a normal probability plot for the residuals. Comment on the normality assumption. Use MINITAB package software/other software to compute and plot your data (No manual calculation is required) Value of $1000 Year 2014 1863 2013 1639 Year-X (Independent) Value of $1000 Y-Dependent 2012 1239 2011 1068 2010 1046 2009 909 719 2008 2007 1141 2006 1081 2005 934 2004 890 803 2003 624 2002 801 2001 2000 909 Value of $1000 Year 2014 1863 2013 1639 Year-X (Independent)...
Master of Science Master of Science Students Student Home Problem: estimate R&D costs for a NEW PROGRAM in $M FY 2016 Fiscal Inflation Year Rate % Raw Index Historical Helicopter Program R&D Costs 2002 0.83% 1.0000 SM FYT 2003 1.02% 1.0102 Chinook 512 2008 2004 2.02% 1.0306 Apache 452) 2005 2005 2.81% 1.0595 Cobra 756 2002 2006 3.10% 1.0924 Kiowa 245 2005 2007 2.70% 1.1218 2008 2.41% | 1.1488 2009 1.51%| 1.1662 2010 0.81% 1.1757 2011 1.99% 1.1990 2012 1.79%...
7.9 3.3 2. Consider the following data from 2001 - 2017, column 1 is the year, the 2nd column is the unemployment rate, and the 3rd column is the inflation rate. Plot the data using a scatter plot and argue whether in your opinion, the Phillips Curve has validity. 2001 5.7 1.6 2002 6.0 2.4 2003 5.7 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 4.1 3.0 0.7
Here are the number of domestic flights flown in each year from 2000 to 2016 Year Flights 2000 7,905,617 2001 7,626,312 2002 8,085,083 2003 9,458,818 2004 9,968,047 2005 10,038,373 2006 9,712,750 2007 9,839,578 2008 9,378,227 2009 8,768,938 2010 8,702,365 2011 8,649,087 2012 8,446,201 2013 8,323,938 2014 8,107,802 2015 8,061,158 2016 4,036,068 In turns out that the value reported for 2016 was only for the period January to June. What should we have done with that point?
2. Shown here are Caterpillar's annual global sales and revenue streams for the years 2004 through 2014. By observing the data graphically and analyzing the data statistically using techniques and concepts from this chapter, share your insights and conclusions about Caterpillar's annual global sales and revenue streams over this period of time. YEAR SALES AND REVENUE STREAMS ($ BILLIONS) 2004 30.31 2005 36.34 2006 41.52 2007 44.96 2008 51.32 2009 32.40 2010 42.59 2011 60.14 2012 65.88 2013 55.66 2014...
Please provide a guided answer or a brief explanation, your help is very appreciated. The figure below illustrates nominal (in current prices) and real (in prices of previous year) GDP of Estonia in 2000- 2015, in billion euro. Estonia 30 25 20 15 10 0 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 BGDP (constant 2010 USS) GDP (current USS) a) b) c) Using the figure above, highlight 4 stages of business...
The mean temperature for the month of July in Boston, Massachusettsis 73 degrees Farenheit. Plot the following data, which represent the observed mean temperature in Boston over the last 20 years. 1998 7 999 69 2000 78 2001 70 2002 67 2003 74 2004 73 2005 65 2006 77 2007 71 2008 75 2009 68 2010 72 2011 77 2012 65 2013 79 2014 77 2015 78 2016 72 a. Is this a normal distribution? Explain your reasoning. b. What...
0 5 10 15 30 - Country B ---Country A 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Unemployment Rate 14) (5 pts) Country A experienced higher cyclical unemployment than country B in the period 2005-07 15) (5 pts) Increasing international trade and financial globalization help explain why the two countries business cycles tend to move together 16) (5 pts) Country B experienced an increase...
1. You are given the following time-series of precipitation data for Dubai. Using the Moving Windows technique: (a) First plot your data. (b) Use overlapping 5-year windows, with the windows having 3 common years (for example if the first window is years 2000, 2001, 2002, 2003, 2004 then the second window is years 2002, 2003, 2004, 2005, 2006) and plot the 5-year moving averages. (c) Explain any pattern that you see. (d) Calculate the average of the series that is...
date value (Y) date value (X) date value (X) 01/01/1999 1.8 01/01/1999 3.5 01/01/1999 6.7 01/01/2000 1.7 01/01/2000 3.5 01/01/2000 6.3 01/01/2001 2.3 01/01/2001 4.2 01/01/2001 7.2 01/01/2002 2.9 01/01/2002 5.3 01/01/2002 8.4 01/01/2003 3.1 01/01/2003 5.5 01/01/2003 8.8 01/01/2004 2.7 01/01/2004 5.0 01/01/2004 8.5 01/01/2005 2.3 01/01/2005 4.7 01/01/2005 7.6 01/01/2006 2.0 01/01/2006 4.3 01/01/2006 6.8 01/01/2007 2.0 01/01/2007 4.4 01/01/2007 7.1 01/01/2008 2.6 01/01/2008 5.7 01/01/2008 9.0 01/01/2009 4.6 01/01/2009 9.7 01/01/2009 14.7 01/01/2010 4.7 01/01/2010 10.3 01/01/2010...