ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Monthly IC Service Mix Breakeven Forecasting
This document is view-only but can be downloaded as an excel file which you should be able to edit and fill in. Please download so that you can use the template as a tool.
2
Service Fees Estimated Labor (hours) Service Mix Forecast Potential Service Income
Potential Service Cost (labor)
3
Consultation $ 40.00 0.510 $ 400.00 $ 65.63
4
Citizenship $ 250.00 42 $ 500.00 $ 105.00
5
DACA/TPS/EAD $ 200.00 22 $ 400.00 $ 52.50
6
Adjustment of Status/Consular Processing $ 400.00 61 $ 400.00 $ 78.75
7
Family Based Petition $ 300.00 51 $ 300.00 $ 65.63
8
Humanitarian Parole $ 150.00 21 $ 150.00 $ 26.25
9
Other $ 400.00 101 $ 400.00 $ 131.25
10
 $ 2,550.00 $ 525.00
11
*Client Consultations (Set your goal) :10
*What's the magic number for our office to break even this month?
12
13
Expected Clients Returning for Services:7
(2/3 of clients expected to return on average)
14
Hourly Office Wage Cost: $ 13.13
15
Estimated Hours Spent on Casework:40.0
16
Total Expected Monthly Hours80
17
Non-Billable, Idle and Admin Hours40.0
18
Forecasted Profit/Loss Summary
19
Potential Revenue $ 2,550.00
20
Variable Costs $ 525.00
21
Gross Margin $ 2,025.00
22
23
Overhead $ 525.00
24
25
Profit (Loss) $ 1,500.00
26
Staff Pay Ledger
27
Name Hourly Wage Monthly Hours Total Earnings
28
John Joe $ 12.00 25 $ 300.00
29
Sally Sue $ 15.00 40 $ 600.00
30
Tony Tots $ 10.00 15 $ 150.00
31
 $ -
32
 $ -
33
 $ -
34
 $ -
35
 $ -
36
 $ -
37
 $ -
38
39
Totals:80 $ 1,050.00
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
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