Question

Calculate Forecasted Sales amounts for 2019 at an increase of 11 percent from 2018.

Calculate Forecasted Sales amounts for 2020 at a decrease of 4 percent from 2019.

Create a graph to illustrate sales for all four years.

		Sales 2017	Sales 2018	Forecasted Sales 2019	Forecasted Sales 2020
January		$      146,000.00	$      150,000.00
February		$      157,000.00	$      162,000.00
March		$      172,000.00	$      175,000.00
April		$      180,000.00	$      185,000.00
May		$      139,000.00	$      142,000.00
June		$      100,000.00	$        98,000.00
July		$      101,000.00	$      102,000.00
August		$      112,000.00	$      115,000.00
September		$      118,000.00	$      125,000.00
October		$      129,000.00	$      137,000.00
November		$      188,000.00	$      198,000.00
December		$      229,000.00	$      240,000.00

Answer 1

А B D E F G H K - L N - M 1 Sales 3,00,000.00 2,50,000.00 2,00,000.00 1,50,000.00 2 Sales Sales Forecasted Sales Forecasted Sales 3 2017 2018 2019 2020 4 January 1,46,000.00 1,50,000.00 1,66,500.00 1,59,840.00 5 February 1,57,000.00 1,62,000.00 1,79,820.00 1,72,627.20 6 March 1,72,000.00 1,75,000.00 1,94,250.00 1,86,480.00 7 April 1,80,000.00 1,85,000.00 2,05,350.00 1,97,136.00 8 May 1,39,000.00 1,42,000.00 1,57,620.00 1,51,315.20 9 June 1,00,000.00 98,000.00 1,08,780.00 1,04,428.80 10 July 1,01,000.00 1,02,000.00 1,13,220.00 1,08,691.20 11 August 1,12,000.00 1,15,000.00 1,27,650.00 1,22,544.00 12 September 1,18,000.00 1,25,000.00 1,38,750.00 1,33,200.00 13 October 1,29,000.00 1,37,000.00 1,52,070.00 1,45,987.20 14 November 1,88,000.00 1,98,000.00 2,19,780.00 2,10,988.80 15 December 2,29,000.00 2,40,000.00 2,66,400.00 2,55,744.00 16 17 18 1,00,000.00 50,000.00 March April January February 2017 2018 2019 2020 August September October November December

B D E F G Н. J K L M Sales 3,00,000.00 250,000.00 2,00,000.00 А 1 2 3 4 January 5 February 6 March 7 April 8 May 9 June 10 July 11 August 12 September 13 October 14 November 15 December 16 17 18 Sales 2017 146000 157000 172000 180000 139000 100000 101000 112000 118000 129000 188000 229000 Sales 2018 150000 162000 175000 185000 142000 98000 102000 115000 125000 137000 198000 240000 Forecasted Sales 2019 =C4*1.11 =C5*1.11 =C6*1.11 =C7*1.11 =C8*1.11 =C9*1.11 =C10*1.11 =C11*1.11 =C12*1.11 =C13 1.11 =C14*1.11 c15*111 Forecasted Sales 2020 =D4*0.96 =D5*0.96 =D6*0.96 =D7*0.96 =D8*0.96 =D9*0.96 =D10*0.96 =D11*0.96 =D12*0.96 =D13*0.96 D14*0.96 =D15*0.96 1.50,000.00 1,00,000.00 50,000.00 January February March April May June July August September October November December 2017 2018 2019 2020