ABCDEFGHIJKLMNO
1
2
SAMPLE MOBILE DJ BUDGET - SINGLE OPERATOR - For more information, contact Gregg Hollmann at gregg@ambientdj.com
3
Color Codes: Blue - Overwrite with your own specific descriptions, Yellow - Overwrite with your own numeric data, Green- Do not type here - these are important figures / statistics. Do not overwrite white cells.
4
5
6
JanFebMarAprMayJunJulAugSepOctNovDecTotalTot/Revenue
7
(%)
8
Revenues:
9
# of Weddings00234445553136
10
# of Teen Dances22211111111216
11
# of Family Parties44443333333542
12
94
13
Average Price - Wedding$1,500$1,500$3,000$1,500$1,500$1,500$1,500$1,500$1,500$1,500$1,500$1,500jobs
14
Average Price - Teen Dance$600$600$600$600$600$600$600$600$600$600$600$600
15
Average Price - Family Party$500$500$500$500$500$500$500$500$500$500$500$500
16
17
Revenues- Weddings$0$0$6,000$4,500$6,000$6,000$6,000$7,500$7,500$7,500$4,500$1,500$57,00065.1%
18
Revenues - Teen Dances$1,200$1,200$1,200$600$600$600$600$600$600$600$600$1,200$9,60011.0%
19
Revenues - Family Parties$2,000$2,000$2,000$2,000$1,500$1,500$1,500$1,500$1,500$1,500$1,500$2,500$21,00024.0%
20
21
Total Revenues -$3,200$3,200$9,200$7,100$8,100$8,100$8,100$9,600$9,600$9,600$6,600$5,200$87,600100.0%
22
23
24
Marketing/Advertising:
25
WeddingWire1501501501501501501501501501501501501,8002.1%
26
The Knot1501501501501501501501501501501501501,8002.1%
27
Bridal Shows750750500000000040002,4002.7%
28
29
> total, Marketing/Advertising105010508003003003003003003003007003006,0006.8%
30
Supplies:
31
Music and Music Subscriptions7575757575757575757575759001.0%
32
Dry Ice0001000001000001003000.3%
33
Party Supplies0000150001500150004500.5%
34
Clothing / Dry Cleaning4040404040404040404040404800.5%
35
36
> total, Supplies1151151152152651151153651152651152152,1302.4%
37
38
Equipment Expenditures:
39
Pioneer Controller000002,0000000002,0002.3%
40
Lighting00002,0000500000002,5002.9%
41
Wires/Batteries/Repair2020202020202020202020202400.3%
42
43
> total, Equipment/Repair2020202020202,02052020202020204,7405.4%
44
45
Office:
46
Insurance000004000000004000.5%
47
Rent12512512512512512512512512512512512515001.7%
48
Office Supplies6060606060606060606060607200.8%
49
Continuing Education15000000060000007500.9%
50
Graphic Design/ Promo Materials0300003000030000300012001.4%
51
Web Design & Maintenance1500000015001,00000013001.5%
52
Professional Fees (Lawyer/Accountant)005000000000005000.6%
53
Cellphone10010010010010010010010010010010010012001.4%
54
Parking / Tolls / Travel3030304040404040404040404500.5%
55
Interest Expense (Credit Cards, Loans)2525252525252525252525253000.3%
56
57
> total, Office640640840350650750500125013503506503508,3209.5%
58
59
Total Expenses1,8251,8251,7758853,2353,1851,4351,9351,7859351,48588521,19024.2%
60
EXPENSES:
61
62
Net Profit1,3751,3757,4256,2154,8654,9156,6657,6657,8158,6655,1154,31566,41075.8%
63
64
Profit Margin (Profit / Revenues)43.0%43.0%80.7%87.5%60.1%60.7%82.3%79.8%81.4%90.3%77.5%83.0%75.8%
65
66
Profitability Metrics:
67
Average Revenue per Job$533$533$1,150$888$1,013$1,013$1,013$1,067$1,067$1,067$943$650$932
68
Avg. Total Expenses per Job$304$304$222$111$404$398$179$215$198$104$212$111$225
69
Avg. Profit per Job$229$229$928$777$608$614$833$852$868$963$731$539$706
70
Avg. Marketing/Advertising Per Job$175$175$100$38$38$38$38$33$33$33$100$38$64
71
72
Qualitative Indicators: (What Benchmarks are Important to You?)
73
Networking Events Attended11111111111112
74
# of Wedding Sales Consultations44444444444448
75
Staff Training Sessions Held1001001001004
76
Client Complaints/Refunds0000001000001
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127