Question

Which of the following problems might be solved by using the Forecasting Sheet in Excel?  

	A.	Predicting future yearly income when the past data is quarterly.
	B.	Predicting income in future quarters based several years of past quarterly income.
	C.	Determining past quarters that did not fit a trend.
	D.	Predicting income in future quarters when past quarterly data is not available.

4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 Timeline Values Forecast Lower Confidence Bound - Upper Confidence Bound - 3/31/12 695,467 6/30/12 731,649 9/30/12 788,398 12/31/12 834,681 3/31/13 892,633 6/30/13 957,094 9/30/13 1,076,034 12/31/13 1,145,242 3/31/14 1,226,772 6/30/14 1,318,551 9/30/14 1,318,551 12/31/14 1,444,608 3/31/15 1,511,167 6/30/15 1,634,684 9/30/15 1,711,967 12/31/15 1,809,398 3/31/16 1,916,603 6/30/16 2,036,618 9/30/16 2,144,775 12/31/16 2,293,998 2,293,998 2,293,998 2,293,998 3/31/17 2,433,325 2,367,045 2,499,605 7/1/17 2,572,730 2,439,312 2,706,149 10/1/17 2,712,136 2,499,605 2,924,666 12/31/17 2,851,541 2,549,170 3,153,911 3/31/18 2,990,946 2,589,068 3,392,823 επέτειε 10/1/17 8T/TE/ 31530122015 12/31/17 Values Forecast - Lower Confidence Bound Upper Confidence Bound 6/30/12 9/30/12 12/31/12 3/31/13 6/30/13 9/30/13 12/31/13 3/31/14 6/30/14 9/30/14 12/31/14 3/31/15 12/31/15 3/31/16 6/30/16 9/30/16 12/31/16 3/31/17

Answer 1

Forecasting sheet helps in predicting the future data say sales, inventory etc.

Thus in the present case,

B is correct

Predicting income in future quarters based several years of past quarterly income.

(Past data and future predicted data should be of same time difference)

Do give your feedback! Happy learning :) :)