PK xl/_rels/workbook.xml.rels
PK 0k xl/theme/theme1.xml
PK sI
xl/styles.xml
PK ɞ xl/worksheets/sheet1.xml
Job Profitability Worksheet
Enter the figures for one job in column B. Results are calculated below. Example values are shown.
Inputs
Job price1200
Labor hours (including drive time)6
Loaded labor cost per hour40
Materials and parts (your cost)380
Other direct costs (permit, subcontractor, disposal)60
Overhead per labor hour35
Results
Labor costB6*B7
Total direct costB13+B8+B9
Gross profitB5-B14
Gross marginIF(B5>0,B15/B5,0)
Overhead shareB6*B10
Net profitB15-B17
Net marginIF(B5>0,B18/B5,0)
Loaded labor cost = wage plus payroll taxes, insurance and benefits. Overhead per labor hour = monthly overhead divided by billable hours in the month. fieldservice.in
PK ` xl/metadata.xml
PK ~XLM M xl/workbook.xml
PK JjL L _rels/.rels
PK أe= = docProps/app.xml
SheetJSWorksheets1Job profitabilityPK ֒|Z Z docProps/core.xml
PK j [Content_Types].xml
PK xl/_rels/workbook.xml.relsPK 0k xl/theme/theme1.xmlPK sI
xl/styles.xmlPK ɞ )' xl/worksheets/sheet1.xmlPK ` $1 xl/metadata.xmlPK ~XLM M 4 xl/workbook.xmlPK JjL L S6 _rels/.relsPK أe= = 8 docProps/app.xmlPK ֒|Z Z 3; docProps/core.xmlPK j < [Content_Types].xmlPK
{ E