ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
2
MARKETING EXECUTIVE DASHBOARD EXAMPLE
https://www.smartsheet.com/try-it?trp=11718&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Marketing+Executive+Dashboard+Example-google-sheet-11718&lpa=Marketing+Executive+Dashboard+Example+google-sheet+11718
3
User to enter information in the data tables below, completing non-shaded cells only.
Dashboard data and charts will automatically populate.
4
GROSS PROFIT MARGINOPEX RATIOEBIT MARGINNET PROFIT MARGIN
5
92%27%63%53%
6
7
INCOME STATEMENT REVENUE
8
Revenue $ 3,110,521
9
COGS $ 244,338
10
11
12
GROSS PROFIT $ 2,866,183
13
OPERATING EXPENSES $ 844,140
14
Sales $ 348,432
15
Marketing $ 233,471
16
IT $ 140,554 OPERATING EXPENSES
17
General & Admin $ 121,683
18
OTHER INCOME $ 2,169
19
OTHER EXPENSES $ 51,842
20
21
22
GROSS INCOME $ 1,972,370
23
Interest & Tax $ 323,054
24
25
26
NET PROFIT $ 1,649,316
27
28
29
DATA TABLES
30
REMINDER: Enter information in the data tables below, completing non-shaded cells only.
Dashboard data and charts will automatically populate.
31
REVENUE AND OTHER INCOME
32
 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD
33
REVENUE $ 229,254 $ 270,209 $ 225,209 $ 323,746 $ 198,227 $ 241,498 $ 334,224 $ 213,800 $ 285,710 $ 256,104 $ 248,840 $ 283,700 $ 3,110,521
34
OTHER INCOME $ 220 $ - $ 95 $ 642 $ - $ - $ - $ 1,100 $ 112 $ - $ - $ - $ 2,169
35
36
COGS AND OTHER EXPENSES
37
 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD
38
COGS $ 21,119 $ 19,181 $ 22,124 $ 17,346 $ 21,949 $ 21,188 $ 18,509 $ 22,433 $ 17,921 $ 19,814 $ 19,651 $ 23,103 $ 244,338
39
OTHER EXPENSES $ 4,611 $ 4,004 $ 4,624 $ 2,837 $ 5,044 $ 7,154 $ 5,610 $ 3,354 $ 1,185 $ 3,513 $ 5,322 $ 4,584 $ 51,842
40
41
INTEREST & TAX
42
 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD
43
INTEREST $ 19,979 $ 14,081 $ 14,702 $ 21,902 $ 19,094 $ 19,029 $ 22,847 $ 20,246 $ 12,893 $ 16,512 $ 13,917 $ 20,168 $ 215,370
44
TAX $ 9,989 $ 7,041 $ 7,351 $ 10,951 $ 9,547 $ 9,514 $ 11,423 $ 10,123 $ 6,446 $ 8,256 $ 6,958 $ 10,084 $ 107,685
45
46
OPERATING EXPENSES
47
 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD
48
Sales $ 30,435 $ 27,382 $ 29,250 $ 30,349 $ 30,526 $ 29,644 $ 28,787 $ 29,011 $ 29,641 $ 27,289 $ 27,625 $ 28,493 $ 348,432
49
Marketing $ 18,112 $ 24,712 $ 15,764 $ 13,931 $ 11,558 $ 26,196 $ 18,301 $ 23,858 $ 20,145 $ 22,988 $ 26,661 $ 11,245 $ 233,471
50
IT $ 15,000 $ 15,000 $ 9,500 $ 26,004 $ 8,500 $ 8,500 $ 8,500 $ 15,550 $ 8,500 $ 8,500 $ 8,500 $ 8,500 $ 140,554
51
General & Admin $ 8,810 $ 14,654 $ 13,242 $ 7,500 $ 7,500 $ 7,500 $ 6,246 $ 8,975 $ 15,046 $ 13,210 $ 9,500 $ 9,500 $ 121,683
52
 $ 72,357 $ 81,748 $ 67,756 $ 77,784 $ 58,084 $ 71,840 $ 61,834 $ 77,394 $ 73,332 $ 71,987 $ 72,286 $ 57,738 $ 844,140
53
54
CLICK HERE TO CREATE IN SMARTSHEET
55
56
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