This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Revenue
Enter your total revenue for this department for the last year
Materials cost
Enter total material cost for this department for the same time period
Material Markup
%
Use either mark-up OR margin. NOT BOTH
Material Margin
%
Material Sales
Target Labor Rate
Enter your rate per hour that you build into your bids
Actual Billed Hours
This is the number of hours you were paid for in this department
# of techs
Enter number of techs that you have in this department
Billable Hours Per Tech
This is the billable hours per tech per year
Lost Hours Per Tech
Based on a 40 hour work week, this is the number of lost hours per tech
Print All Information
Please host the converted page in server to use Print All.
Reset
Print All