Spreadsheet: 752291d1634691217-autopopulate-a-cell-on-one-sheet-based-on-a-calculation-on-another-sheet-frp-in-progress
Sheet: Labor Calculator

[NAME] Profit Point Calculator
Only fields that are [NAME] are intended for you to complete. Not Intended To Replace Professional Accounting Advice
Field Payroll Is Based On This Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary
# of Working Weeks In The Year: |  |  |  |  |  |  |  | 52
# Of Working Days Each Week: |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | Service Technician
# Of Paid Working Hours Each Day: |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | Hourly Labor Burden
Available Hours Per Year To Work: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hourly Overhead Burden:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hourly Break Even Point:
Billable Hours Per Day By Department |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual Break Even Point:
 |  |  |  |  |  |  |  | Hrs/Day |  | Hrs/Yr |  | Efficiency
Service Technicians |  |  |  |  |  |  |  | 4.5 |  |  |  |  |  |  |  |  | Installation Technician
Installation Technicians |  |  |  |  |  |  |  | 6.7309 |  |  |  |  |  |  |  |  | Hourly Labor Burden
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hourly Overhead Burden
Compensated Days Not Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hourly break Even Point
# Of Paid Vacation Days Offered: |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  | Annual Break Even Point
# Of Paid Holidays Offered: |  |  |  |  |  |  |  | 6
# Of "Personal" Days Offered: |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | Profit Pricing
# Of "Other" Paid Days Off: |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | Desired Profit Per Tech |  |  |  |  |  | 0.4
Total Compensated Days Off:
Total Compensated Paid Hours: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Selling Price Of Service Labor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per hour
Non-Productive Paid Days
# Days Spent on Training: |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | Selling Price Of Installation Labor
# Days Spent In Office: |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per hour
Total Non-Productive Paid Days
Labor Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *THINGS TO REMEMBER*
 |  |  |  |  |  |  |  | Cost Per year |  |  |  | Cost Per hour Paid |  |  |  |  | 1. Pay is based on all hours that your employees are on the clock, but your rates are based on their "productive" hours on the clock, when they are generating revenue
Annual Salary Of Highest Paid Tech: |  |  |  |  |  |  |  | 60000
FICA Tax Rate |  |  |  |  |  |  |  | 0.0765
FUTA Tax Rate |  |  |  |  |  |  |  | 0.06
SUTA Tax Rate |  |  |  |  |  |  |  | 0.03
Social Security Tax Rate |  |  |  |  |  |  |  | 0.062
Workers Compensation Rate: |  |  |  |  |  |  |  | 0.15 |  |  |  |  |  |  |  |  | 2. The hourly rate you charge in order to meet your financial obligations is directly proportional to the number of technicians you employ.  The overhead expense is divided among your field staff. This means that the greater the number of technicians, the lower your hourly rate will need to be to cover overhead.
Liability Insurance |  |  |  |  |  |  |  | 0.005
Provided Benefits
Medical Insurance |  |  |  |  |  |  |  | 14000
Education |  |  |  |  |  |  |  | 2500
Tool Allowance |  |  |  |  |  |  |  | 1200
Additional Per-Employee Expenses
Vehicle Payment/Lease |  |  |  |  |  |  |  | 300
Vehicle Insurance |  |  |  |  |  |  |  | 120
Cellular Phone |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  | 3. You will need to revisit this calculator on an annual basis. Expenses will rise and fall over time, and you will want to be sure you are charging enough to cover your costs. As a rule, this should be revisited quarterly
Laptop |  |  |  |  |  |  |  | 40
Hotspot |  |  |  |  |  |  |  | 40
Hand Tools |  |  |  |  |  |  |  | 500
Other |  |  |  |  |  |  |  | 0
[NAME]:
TOTAl Annual Labor Burden
Technician Count |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4. People are willing to pay more for a service so long as they feel they are getting what they pay for.  Do not be tempted to worry yourself with what your competition is charging. There is no such thing as "What The Market Will Bear". [NAME], Set The Bar, and [NAME] for your services!
Number Of Service Technicians: |  |  |  |  |  |  |  |  | 1
Number Of Installation Technicians: |  |  |  |  |  |  |  |  | 1
Total Technicians:
Overhead Expenses |  |  |  |  |  |  |  |  | Annual Cost
Rent & Utilities |  |  |  |  |  |  |  |  | 12500
Advertising |  |  |  |  |  |  |  |  | 7500
[NAME] |  |  |  |  |  |  |  |  | 2000
Insurances (Do Not Include Field Service Vehicles) |  |  |  |  |  |  |  |  | 2000
Donations (youth sports, candidates, churches...) |  |  |  |  |  |  |  |  | 1000 |  |  |  |  |  |  |  | 5. Many service organizations base their overall rates on the salary of the highest paid field technician. If you will use this method, be sure to leae the "Technician Count" section set to "1" for both service and installation technicians. This wil allow wiggle room in the budget for all technicians who are paid less than the highest rate, which will provide slightly higher profits on the labor for those technicians.
Legal & Accounting Fees |  |  |  |  |  |  |  |  | 1000
Business Licenses |  |  |  |  |  |  |  |  | 750
Annual Memberships |  |  |  |  |  |  |  |  | 1600
Office Employee Expenses |  |  |  |  |  |  |  |  | 75000
Other 1 |  |  |  |  |  |  |  |  | 25000
Other 2 |  |  |  |  |  |  |  |  | 0
Other 3 |  |  |  |  |  |  |  |  | 0
Total Non-Labor Overhead Expenses
Departmental Overhead Responsibility
Service Department
Installation Department |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6. Commissions not calculated here.