Biz Ops_Modeling Test
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRST
1
2
INSTRUCTIONS
3
Forecast the next twelve months of revenue based on the data set below. Assume no new product changes.
4
Be sure to note your assumptions and why you chose them
5
6
DATA
7
8
MonthImpressionsConversionsRevenue
9
1/31/151,000,000100,000$150,000
10
2/28/20151,030,000103,103$154,655
11
3/31/20151,050,600105,270$157,905
12
4/30/20151,055,853105,902$158,854
13
5/31/20151,055,853106,008$159,012
14
6/30/20151,055,853106,114$159,171
15
7/31/20151,045,294105,158$181,398
16
8/31/20151,024,389103,158$177,948
17
9/30/20151,055,120106,359$183,469
18
10/31/20151,065,671118,165$203,835
19
11/30/20151,060,343117,692$203,018
20
12/31/20151,007,326111,919$193,060
21
1/31/20161,108,059123,234$212,578
22
2/29/20161,141,300127,058$219,175
23
3/31/20161,164,126129,729$223,782
24
4/30/20161,169,947130,508$225,126
25
5/31/20161,169,947130,638$270,421
26
6/30/20161,169,947137,170$283,942
27
7/31/20161,158,247135,934$281,384
28
8/31/20161,135,082133,349$276,032
29
9/30/20161,169,135137,486$284,597
30
10/31/20161,180,826139,000$287,730
31
11/30/20161,174,922138,444$286,578
32
12/31/20161,116,176131,653$321,575
33
1/31/20171,227,794144,963$354,087
34
2/28/20171,264,627149,461$365,074
35
3/31/20171,289,920152,603$372,748
36
4/30/20171,296,370153,519$374,986
37
5/31/20171,296,370153,673$375,361
38
6/30/20171,296,370153,826$375,736
39
7/31/20171,283,406152,440$372,351
40
8/31/20171,257,738149,541$365,269
41
9/30/20171,295,470154,181$376,603
42
10/31/20171,308,425155,879$380,750
43
11/30/20171,301,883155,255$379,225
44
12/31/20171,236,788147,639$360,624
45
1/31/2018
46
2/28/2018
47
3/31/2018
48
4/30/2018
49
5/31/2018
50
6/30/2018
51
7/31/2018
52
8/31/2018
53
9/30/2018
54
10/31/2018
55
11/30/2018
56
12/31/2018
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...