| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||
2 | 🙋 EDIT CELLS IN THIS COLOR🙋 | ||||||||||
3 | $291,160.00 | âš THESE CELLS DO CALULATIONS âš | |||||||||
4 | Monthly | Yearly | âš DONT EDIT CELLS IN THIS COLOR âš | ||||||||
5 | Rent | $4,000.00 | $48,000.00 | Hourly Rate | Initial Marketing | $5,000.00 | Discounts? | Discounts and Losses might help you take money off your tax bill, ask your accountant | |||
6 | Insurance | $300.00 | $3,600.00 | Initial Repair Stock | $10,000.00 | Losses? | |||||
7 | Combined | Tech Salary Lv 2 20hr | $3,200.00 | $38,400.00 | $20.00 | Shop Buildout | $20,000.00 | ||||
8 | $96,000.00 | Tech Salary lv 3 30hr | $4,800.00 | $57,600.00 | $30.00 | Tools & Consumables | $5,000.00 | If you have Comments, leave them! If not download this and USE IT! | |||
9 | Combined | Manager Salary | $3,500.00 | $42,000.00 | $21.88 | Website | $1,000.00 | -$940.00 | $60.00 | ||
10 | $84,000.00 | Owner/Director Salary | $3,500.00 | $42,000.00 | $21.88 | Documents | $2,000.00 | INSTRUCTIONS | |||
11 | $180,000.00 | Utilities | $500.00 | $6,000.00 | Initial Cost | $43,000.00 | Download 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 Payout | Shop POS | $100.00 | $1,200.00 | Automation Savings? | $42,060.00 | -$940.00 | ||||
13 | Monthly Shipping Costs | $80.00 | $960.00 | 4x Overnight | weekly 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.00 | Variables | Variables | ||||||
15 | Accountant/Book Keeping | $500.00 | $6,000.00 | Lv 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 | L2 | L3 | âš 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! | LCD | OLED | Do 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.34 | Average Part Cost | $75.00 | 44.64% | $200.00 | 68.26% | |
24 | 10% | Marketing 10% of Profit | $2,103.83 | Labor | $93.00 | 55.36% | $93.00 | 31.74% | |||
25 | 2% | Breakage Budget +2% | $420.77 | Totals | $168.00 | $293.00 | |||||
26 | 10% | Savings 10% | $2,103.83 | Variables | Variables | ||||||
27 | Total % Additions | $4,628.43 | L2 | 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 Day | 10.00 | 6.67 | 5.00 | 2.50 | 1.67 | |||||
31 | Upsell Targets via Services | $42.78 | $85.56 | $256.67 | $427.78 | Use 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 Repairs | 300 | 200 | 150 | 75 | 50 | <----------> | ||||
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 âš | ||||||||||