Question

Three weeks of data are available from a restaurant. Develop a forecast and explain why your approach is reasonable Demand 140 120 100 80 60 40 20 0

there is no additional information available. just the graph

Answer 1

As, The Graph Must be in MS Excel sheet, then we can check Value for each day, I have considered approximate value, those are Not to the scale, However, from MS Excel Sheet, we can take such value and Put in the below Excel sheet with Formula, as written below, so, we will be able to perform Trend Forecasting and the Reasonable side of Trend Forecasting, it uses past data from company, and examine such data and prepare Intercept and Slope value, using such value like Intercept, slope, we can predict forecast for any period, here, I have prepared forecast for Next week that means from 22 days to 28 Days, Trend forecasting is useful method in Many businesses,

1	B	C	D	E
2	Intercept	34.714	Slope	2.857
3	Day	Value	Trend forecasting
4	1.000	35.000	37.571
5	2.000	37.000	40.429
6	3.000	40.000	43.286
7	4.000	41.000	46.143
8	5.000	79.000	49.000
9	6.000	50.000	51.857
10	7.000	52.000	54.714
11	8.000	54.000	57.571
12	9.000	58.000	60.429
13	10.000	59.000	63.286
14	11.000	62.000	66.143
15	12.000	97.000	69.000
16	13.000	95.000	71.857
17	14.000	59.000	74.714
18	15.000	61.000	77.571
19	16.000	62.000	80.429
20	17.000	65.000	83.286
21	18.000	70.000	86.143
22	19.000	76.000	89.000
23	20.000	117.000	91.857
24	21.000	120.000	94.714
25	22.000		97.571
26	23.000		100.429
27	24.000		103.286
28	25.000		106.143
29	26.000		109.000
30	27.000		111.857
31	28.000		114.714

1	B	C	D	E
2	Intercept	=INTERCEPT(C4:C24,B4:B24)	Slope	=SLOPE(C4:C24,B4:B24)
3	Day	Value	Trend forecasting
4	1	35	=$C$2+($E$2*B4)
5	2	37	=$C$2+($E$2*B5)
6	3	40	=$C$2+($E$2*B6)
7	4	41	=$C$2+($E$2*B7)
8	5	79	=$C$2+($E$2*B8)
9	6	50	=$C$2+($E$2*B9)
10	7	52	=$C$2+($E$2*B10)
11	8	54	=$C$2+($E$2*B11)
12	9	58	=$C$2+($E$2*B12)
13	10	59	=$C$2+($E$2*B13)
14	11	62	=$C$2+($E$2*B14)
15	12	97	=$C$2+($E$2*B15)
16	13	95	=$C$2+($E$2*B16)
17	14	59	=$C$2+($E$2*B17)
18	15	61	=$C$2+($E$2*B18)
19	16	62	=$C$2+($E$2*B19)
20	17	65	=$C$2+($E$2*B20)
21	18	70	=$C$2+($E$2*B21)
22	19	76	=$C$2+($E$2*B22)
23	20	117	=$C$2+($E$2*B23)
24	21	120	=$C$2+($E$2*B24)
25	22		=$C$2+($E$2*B25)
26	23		=$C$2+($E$2*B26)
27	24		=$C$2+($E$2*B27)
28	25		=$C$2+($E$2*B28)
29	26		=$C$2+($E$2*B29)
30	27		=$C$2+($E$2*B30)
31	28		=$C$2+($E$2*B31)