ABCDEFGHIJK
1
2
🙋 EDIT CELLS IN THIS COLOR🙋
3
$291,160.00 âš  THESE CELLS DO CALULATIONS âš 
4
MonthlyYearly âš  DONT EDIT CELLS IN THIS COLOR âš 
5
Rent$4,000.00$48,000.00Hourly RateInitial Marketing$5,000.00Discounts?Discounts and Losses might help you take money off your tax bill, ask your accountant
6
Insurance$300.00$3,600.00Initial Repair Stock$10,000.00Losses?
7
CombinedTech Salary Lv 2 20hr$3,200.00$38,400.00$20.00Shop Buildout$20,000.00
8
$96,000.00Tech Salary lv 3 30hr$4,800.00$57,600.00$30.00Tools & Consumables$5,000.00If you have Comments, leave them! If not download this and USE IT!
9
CombinedManager Salary$3,500.00$42,000.00$21.88Website$1,000.00-$940.00$60.00
10
$84,000.00Owner/Director Salary$3,500.00$42,000.00$21.88Documents$2,000.00INSTRUCTIONS
11
$180,000.00Utilities$500.00$6,000.00Initial Cost$43,000.00Download or COPY then input all your shops information into this calculator to see what you need to be charging as a labor fee, business is always complex until you understand it, thats why YOU repair for other people its easy for you, not for them. Learn to run your business and make it easy, not hard to not only stay in bussiness, but to also grow and thrive.Feel free to leave comments on this sheet for me to see and Ill add things to the official download document. There will be a video about this with better information and instructions at some point. -Justin "The Art of Repair" For any other comments or thoughts, email me at Justin@artof.repair
12
Total PayoutShop POS$100.00$1,200.00Automation Savings?$42,060.00-$940.00
13
Monthly Shipping Costs$80.00$960.004x Overnightweekly orders should be accounted for, custom orders between these times fall on the client! Add to the bill!New Total
14
Shop Subscriptions$100.00$1,200.00VariablesVariables
15
Accountant/Book Keeping$500.00$6,000.00Lv 2 PM %Lv 3 PM %
16
Lawyer$100.00$1,200.00$10,266.71$23,100.09
17
Initial Cost Payback 10 Years$358.33$43,000.00
18
New Stock Parts Cost
19
🙋 EDIT CELLS IN THIS COLOR🙋Average
20
L2L3 âš  THESE CELLS DO CALULATIONS âš Level 3 Profit %90.00%
21
Total Monlthy Standard $21,038.33$31,809.96$18,976.58âš  DONT EDIT CELLS IN THIS COLOR âš Level 2 Profit % 40.00%
22
Monlthy Standard + Growth$25,666.77$41,066.83$28,233.44< -- 33k - 43k To be happy!LCDOLEDDo not mistake my salary numbers! these are a good way to see if your atleast paying someone enough to keep them long term, dont embaress the industry by paying people min wage to do tech work, and also use it to encourage techs to grow into level 3, no level 2 tech should make even close to that of a level 3 tech that can do both 2 and 3 work. Also if you live in a place that has extreme rent, account for that, make sure your techs are happy at home so they will be happy with you!
23
7%Taxes?$239.56$2,874.68$1,976.34Average Part Cost$75.0044.64%$200.0068.26%
24
10%Marketing 10% of Profit$2,103.83Labor $93.0055.36%$93.0031.74%
25
2%Breakage Budget +2%$420.77Totals$168.00$293.00
26
10%Savings 10%$2,103.83VariablesVariables
27
Total % Additions$4,628.43L2 L3
28
$10,771.63-$2,061.76
29
DO NOT EDIT THE CELLS BELOW UNLESS YOU KNOW HOW THEY WORK$15,400.06$2,566.68
30
Repairs per Day10.006.675.002.501.67
31
Upsell Targets via Services$42.78$85.56$256.67$427.78Use the info to the left to see how many repairs you need to reach your target goal! Remember its best to assume yourself a repair shop only then see how much you need to add in upsells and services to reach that goal. You can also see that the diffculty of reaching that goal is marked at the top. The upsell target brings your labor rate BACK to the lowest targeted labor rate. Pay attention to that!
32
Total Repairs3002001507550<---------->
33
LABOR RATE SCREWED$85.56$128.33$171.11$342.22$513.34
34
LABOR RATE GLUED + 10%$94.11$141.17$188.22$376.45$564.67🙋 EDIT CELLS IN THIS COLOR🙋
35
âš  THESE CELLS DO CALULATIONS âš 
36
âš  DONT EDIT CELLS IN THIS COLOR âš