A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | Tot/Revenue | |
7 | (%) | ||||||||||||||
8 | Revenues: | ||||||||||||||
9 | # of Weddings | 0 | 0 | 2 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 3 | 1 | 36 | |
10 | # of Teen Dances | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 16 | |
11 | # of Family Parties | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 42 | |
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,500 | jobs | |
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,000 | 65.1% |
18 | Revenues - Teen Dances | $1,200 | $1,200 | $1,200 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $1,200 | $9,600 | 11.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,000 | 24.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,600 | 100.0% |
22 | |||||||||||||||
23 | |||||||||||||||
24 | Marketing/Advertising: | ||||||||||||||
25 | WeddingWire | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 1,800 | 2.1% |
26 | The Knot | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 1,800 | 2.1% |
27 | Bridal Shows | 750 | 750 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 0 | 2,400 | 2.7% |
28 | |||||||||||||||
29 | > total, Marketing/Advertising | 1050 | 1050 | 800 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 700 | 300 | 6,000 | 6.8% |
30 | Supplies: | ||||||||||||||
31 | Music and Music Subscriptions | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 900 | 1.0% |
32 | Dry Ice | 0 | 0 | 0 | 100 | 0 | 0 | 0 | 100 | 0 | 0 | 0 | 100 | 300 | 0.3% |
33 | Party Supplies | 0 | 0 | 0 | 0 | 150 | 0 | 0 | 150 | 0 | 150 | 0 | 0 | 450 | 0.5% |
34 | Clothing / Dry Cleaning | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 480 | 0.5% |
35 | |||||||||||||||
36 | > total, Supplies | 115 | 115 | 115 | 215 | 265 | 115 | 115 | 365 | 115 | 265 | 115 | 215 | 2,130 | 2.4% |
37 | |||||||||||||||
38 | Equipment Expenditures: | ||||||||||||||
39 | Pioneer Controller | 0 | 0 | 0 | 0 | 0 | 2,000 | 0 | 0 | 0 | 0 | 0 | 0 | 2,000 | 2.3% |
40 | Lighting | 0 | 0 | 0 | 0 | 2,000 | 0 | 500 | 0 | 0 | 0 | 0 | 0 | 2,500 | 2.9% |
41 | Wires/Batteries/Repair | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 240 | 0.3% |
42 | |||||||||||||||
43 | > total, Equipment/Repair | 20 | 20 | 20 | 20 | 2020 | 2,020 | 520 | 20 | 20 | 20 | 20 | 20 | 4,740 | 5.4% |
44 | |||||||||||||||
45 | Office: | ||||||||||||||
46 | Insurance | 0 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 0.5% |
47 | Rent | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 1500 | 1.7% |
48 | Office Supplies | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 720 | 0.8% |
49 | Continuing Education | 150 | 0 | 0 | 0 | 0 | 0 | 0 | 600 | 0 | 0 | 0 | 0 | 750 | 0.9% |
50 | Graphic Design/ Promo Materials | 0 | 300 | 0 | 0 | 300 | 0 | 0 | 300 | 0 | 0 | 300 | 0 | 1200 | 1.4% |
51 | Web Design & Maintenance | 150 | 0 | 0 | 0 | 0 | 0 | 150 | 0 | 1,000 | 0 | 0 | 0 | 1300 | 1.5% |
52 | Professional Fees (Lawyer/Accountant) | 0 | 0 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 0.6% |
53 | Cellphone | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1200 | 1.4% |
54 | Parking / Tolls / Travel | 30 | 30 | 30 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 450 | 0.5% |
55 | Interest Expense (Credit Cards, Loans) | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 300 | 0.3% |
56 | |||||||||||||||
57 | > total, Office | 640 | 640 | 840 | 350 | 650 | 750 | 500 | 1250 | 1350 | 350 | 650 | 350 | 8,320 | 9.5% |
58 | |||||||||||||||
59 | Total Expenses | 1,825 | 1,825 | 1,775 | 885 | 3,235 | 3,185 | 1,435 | 1,935 | 1,785 | 935 | 1,485 | 885 | 21,190 | 24.2% |
60 | EXPENSES: | ||||||||||||||
61 | |||||||||||||||
62 | Net Profit | 1,375 | 1,375 | 7,425 | 6,215 | 4,865 | 4,915 | 6,665 | 7,665 | 7,815 | 8,665 | 5,115 | 4,315 | 66,410 | 75.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 Attended | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | |
74 | # of Wedding Sales Consultations | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 48 | |
75 | Staff Training Sessions Held | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 4 | |
76 | Client Complaints/Refunds | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | |
104 | |||||||||||||||
105 | |||||||||||||||
106 | |||||||||||||||
107 | |||||||||||||||
108 | |||||||||||||||
109 | |||||||||||||||
110 | |||||||||||||||
111 | |||||||||||||||
112 | |||||||||||||||
113 | |||||||||||||||
114 | |||||||||||||||
115 | |||||||||||||||
116 | |||||||||||||||
117 | |||||||||||||||
118 | |||||||||||||||
119 | |||||||||||||||
120 | |||||||||||||||
121 | |||||||||||||||
122 | |||||||||||||||
123 | |||||||||||||||
124 | |||||||||||||||
125 | |||||||||||||||
126 | |||||||||||||||
127 |