Question: Please develop TWO forecasts based on ABC Health Clinic's revenues from the previous years using: 1) percentage change forecast, and 2) a moving average forecast
Please develop TWO forecasts based on ABC Health Clinic's revenues from the previous years using: 1) percentage change forecast, and 2) a moving average forecast Percentage Charge Fiscal Year Collections 7 2008 $ 23,500.00 2009 $ 21,900.00 9 2010 $ 15,000.00 10 2011 $ 25,000.00 11 2012 5 23 200.00 12 2013 5 22 30000 13 20145 24,500.00 14 2015 $15.500.00 15 2010 5 34 300.00 16 201715 22 000 00 17 2018 5 33 580 2010050165000 19 2020 5 27.500.00 20 Future year 2021) 21 Future year 2022) 22 25 24 25 26 27 26 29 30 31 Fiscal Year 2008 2009 201015 2011 15 20125 2013 S 2014 $ 2015 2016 2017 2018 2010 20205 Future yar20201 Fire year 2022 Collections Moving Average 23,500.00 22.70000 21.00000 18.250.00 15 60000 20,100.00 2500000 24.100.00 23,200.00 22.000 22,300.00 23 00 00 24,500.00 30 000.00 15.500.000 24,900 00 34.30000 20,150.00 2200000 27.000 335.000 13,6150 3165000 29575.00 27500005 22 000 $24.456.15 Please develop TWO forecasts based on ABC Health Clinic's revenues from the previous years using: 1) percentage change forecast, and 2) a moving average forecast Percentage Charge Fiscal Year Collections 7 2008 $ 23,500.00 2009 $ 21,900.00 9 2010 $ 15,000.00 10 2011 $ 25,000.00 11 2012 5 23 200.00 12 2013 5 22 30000 13 20145 24,500.00 14 2015 $15.500.00 15 2010 5 34 300.00 16 201715 22 000 00 17 2018 5 33 580 2010050165000 19 2020 5 27.500.00 20 Future year 2021) 21 Future year 2022) 22 25 24 25 26 27 26 29 30 31 Fiscal Year 2008 2009 201015 2011 15 20125 2013 S 2014 $ 2015 2016 2017 2018 2010 20205 Future yar20201 Fire year 2022 Collections Moving Average 23,500.00 22.70000 21.00000 18.250.00 15 60000 20,100.00 2500000 24.100.00 23,200.00 22.000 22,300.00 23 00 00 24,500.00 30 000.00 15.500.000 24,900 00 34.30000 20,150.00 2200000 27.000 335.000 13,6150 3165000 29575.00 27500005 22 000 $24.456.15
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
