Spreadsheet: 675424d1588275946-problem-using-ifs-function-project-budget-template-blank-hourly-multirate
Sheet: Project Budget

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST | OT | DT
(1) | CUSTOMER |  |  |  |  |  |  |  | Overhead on Labor |  | 0.2 |  |  | BURDEN TABLE | FICA |  |  | 0.0765 | 0.0765 | 0.0765
 | SITE |  |  |  |  |  |  |  | Billable Per Diem Rate (Staff): |  | 125 |  |  |  | FUTA |  |  | 0.013 | 0.013 | 0.013
 | Quote Number |  |  |  |  |  |  |  | Billable Per Diem Rate (Craft): |  | 115 |  |  |  | SUTA |  |  | 0.0115 | 0.0115 | 0.0115
 | Project Manager |  |  |  |  |  |  |  | Payable Per Diem Rate (Staff): |  | 35 |  |  |  | Worker's Comp |  |  | 0.0355
 | Project Name |  |  |  |  |  |  |  | Payable Per Diem Rate (Craft): |  | 30 |  |  |  | General Liability |  |  | 0 | 0 | 0
 | Expected Start Date |  |  |  |  |  |  |  | 3rd Party [NAME]: |  | 0.05 |  |  |  | Vacation |  |  | 0.0567 | 0 | 0
 | Expected Finish Date |  |  |  |  |  |  |  | Tax Rate: |  | 0.0825 |  |  |  | Holiday |  |  | 0.0567 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Health Insurance/Sick/Medical |  |  | 0.0367
(2) | MANPOWER INFORMATION (STAFF) - MOBILIZATION & TRAVEL |  |  |  |  |  |  |  |  |  |  |  |  | LABOR COST |  |  |  | LABOR REVENUE
 | Position Description | Headcount | Base Wage | ST Bill | [NAME] | [NAME] | ST Hours | OT Hours | DT Hours | Total Hours | Per Diem (Y/N) | # of Days |  | Total Standard Cost |  | Per Diem |  | Total Billable Labor |  | Per Diem
 | MANPOWER INFORMATION (CRAFT) - MOBILIZATION & TRAVEL |  |  |  |  |  |  |  |  |  |  |  |  | LABOR COST |  |  |  | LABOR REVENUE
 | Position Description | Headcount | Base Wage | ST Bill | [NAME] | [NAME] | ST Hours | OT Hours | DT Hours | Total Hours | Per Diem (Y/N) | # of Days |  | Total Standard Cost |  | Per Diem |  | Total Billable Labor |  | Per Diem
(3) | MANPOWER INFORMATION (DAY SHIFT STAFF) - BILLABLE |  |  |  |  |  |  |  |  |  |  |  |  | LABOR COST |  |  |  | LABOR REVENUE
 | Position Description | Headcount | Base Wage | ST Bill | [NAME] | [NAME] | ST Hours | OT Hours | DT Hours | Total Hours | Per Diem (Y/N) | # of Days |  | Total Standard Cost |  | Per Diem |  | Total Billable Labor |  | Per Diem
 | Project Manager | 1 |  |  |  |  | 40 | 51 |  |  | Y | 7
 | Safety Supervisor | 1 |  |  |  |  | 40 | 51 |  |  | Y | 7
 | Cost Technician | 1 |  |  |  |  | 40 | 16 |  |  | Y | 7
 | MANPOWER INFORMATION ( DAY SHIFT CRAFT) - BILLABLE |  |  |  |  |  |  |  |  |  |  |  |  | LABOR COST |  |  |  | LABOR REVENUE
 | Position Description | Headcount | Base Wage | ST Bill | [NAME] | [NAME] | ST Hours | OT Hours | DT Hours | Total Hours | Per Diem (Y/N) | # of Days |  | Total Standard Cost |  | Per Diem |  | Total Billable Labor |  | Per Diem
 | Superintendent | 2 |  |  |  |  | 40 | 51 |  |  | Y | 7
 | Console Supervisor | 2 |  |  |  |  | 40 | 44 |  |  | Y | 7
 | Top Side Supervisor | 2 |  |  |  |  | 40 | 44 |  |  | N
 | Technician A | 7 |  |  |  |  | 40 | 44 |  |  | Y | 7
 | Technician A | 7 |  |  |  |  | 40 | 44 |  |  | N
 | MANPOWER INFORMATION ( NIGHT SHIF STAFF) - BILLABLE |  |  |  |  |  |  |  |  |  |  |  |  | LABOR COST |  |  |  | LABOR REVENUE
 | Position Description | Headcount | Base Wage | ST Bill | [NAME] | [NAME] | ST Hours | OT Hours | DT Hours | Total Hours | Per Diem (Y/N) | # of Days |  | Total Standard Cost |  | Per Diem |  | Total Billable Labor |  | Per Diem
 | Safety Supervisor | 1 |  |  |  |  | 40 | 51 |  |  | N
 | MANPOWER INFORMATION ( NIGHT SHIFT CRAFT) - BILLABLE |  |  |  |  |  |  |  |  |  |  |  |  | LABOR COST |  |  |  | LABOR REVENUE
 | Position Description | Headcount | Base Wage | ST Bill | [NAME] | [NAME] | ST Hours | OT Hours | DT Hours | Total Hours | Per Diem (Y/N) | # of Days |  | Total Standard Cost |  | Per Diem |  | Total Billable Labor |  | Per Diem
 | Superintendent | 2 |  |  |  |  | 40 | 51 |  |  | Y | 7
 | Console Supervisor | 2 |  |  |  |  | 40 | 44 |  |  | Y | 7
 | Top Side Supervisor | 2 |  |  |  |  | 40 | 44 |  |  | N
 | Technician A | 7 |  |  |  |  | 40 | 44 |  |  | Y | 7
 | Technician A | 7 |  |  |  |  | 40 | 44 |  |  | N
(4) | MANPOWER INFORMATION (STAFF) - NON-BILLABLE |  |  |  |  |  |  |  |  |  |  |  |  | LABOR COST |  |  |  | LABOR REVENUE
 | Position Description | Headcount | Base Wage | ST Bill | [NAME] | [NAME] | ST Hours | OT Hours | DT Hours | Total Hours | Per Diem (Y/N) | # of Days |  | Total Standard Cost |  | Per Diem |  | Total Billable Labor |  | Per Diem
 | MANPOWER INFORMATION (CRAFT) - NON-BILLABLE |  |  |  |  |  |  |  |  |  |  |  |  | LABOR COST |  |  |  | LABOR REVENUE
 | Position Description | Headcount | Base Wage | ST Bill | [NAME] | [NAME] | ST Hours | OT Hours | DT Hours | Total Hours | Per Diem (Y/N) | # of Days |  | Total Standard Cost |  | Per Diem |  | Total Billable Labor |  | Per Diem
 | Superintendent | 1 |  |  |  |  | 16
 | Console Supervisor | 1 |  |  |  |  | 16
 | Top Side Supervisor | 1 |  |  |  |  | 16
 | Technician A | 3 |  |  |  |  | 16
(5) | BILLABLE THIRD PARTY INFORMATION |  |  |  |  |  |  |  |  |  |  |  |  | BILLABLE COST |  |  |  | BILLABLE REVENUE
 | Subcontractors
 | [NAME] |  |  | Description of Service |  |  |  |  |  |  | Quoted Price
 |  |  |  | Dense Loading
 |  |  |  | Catalyst Sampling
 |  |  |  | Crane Operation
 |  |  |  | [NAME]
 | Rental Equipment
 | [NAME] |  |  | Description of Equipment |  |  |  |  |  |  | Quoted Price
 |  |  |  | Forklift(s)
 |  |  |  | Diesel Generator
 |  |  |  | Decontamination Trailer
 |  |  |  | Light Plants
 |  |  |  | 3 in 1 Fall Arrest & Retrieval Block(s)
 |  |  |  | Confined Space Entry Tripod(s)
 |  |  |  | Supplied Air Lines / Masks / Escape Packs
 |  |  |  | Self-Contained Breathing Apparatuses
 |  |  |  | Tube Sheet Loading Equipment
 |  |  |  | Tube Sheet DP Equipment
 |  |  |  | Mechanical Tools ( Impacts, Sockets, Wrenches, Etc. )
 |  |  |  | Mechanical Flange Spreader(s)
 |  |  |  | Mechanical Torquing Equipment
 |  |  |  | Mechanical Tensioning Equipment
 | Materials / Consumables (Billable)
 | [NAME] |  |  | Description of Item |  |  |  |  |  |  | Quoted Price
 |  |  |  | Tube Sheet Caps
 |  |  |  | Dry Ice
 |  |  |  | Breathing Air
 |  |  |  | Fuel
 | Reimbursable Travel
 | Type of Travel |  |  | Description |  |  |  |  |  |  | Price
 | Air Travel
 | Bus Travel
 | Hotels Not Included in Billed Per Diem
 | Mileage Paid To Employees
(6) | COMPANY OWNED EQUIPMENT INFORMATION |  |  |  |  |  |  |  |  |  |  |  |  | BILLABLE COST |  |  |  | BILLABLE REVENUE
 | Equipment Name |  |  | Units Used |  |  | Special Notes |  |  | Rate
 |  |  |  | 192 |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2
 |  |  |  | 60 |  | 2
 |  |  |  | 60 |  | 3
 |  |  |  | 60 |  | 1
(7) | NON-BILLABLE INFORMATION |  |  |  |  |  |  |  |  |  |  |  | (8) | PROJECT SUMMARY & BREAKOUT |  |  |  |  |  |  |  | Indirect Labor Revenue (Staff)
 | Description |  |  | Comments / Explanation |  |  |  |  |  |  | Amount |  |  |  |  |  |  |  |  |  |  | Direct Labor Revenue (Craft)
 | Hotels - Included in Billed Per Diem |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Revenue:
 | Consummables |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Costs: |  |  |  |  |  |  | Indirect Labor Hours (Staff)
 | Rental Radios - Billed as Company Owned |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Margin $:
 | Breathing Air Equipment Billed As Company Owned |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Margin %: |  |  |  |  |  |  | Direct Labor Hours (Craft)
 | Unbillable Fuel
 | [NAME] as Company Owned |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenue Per Hour |  |  |  |  |  |  | Per Diem Revenue
 | Loading Sock |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost Per Hour
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted Comp. Rate |  |  |  |  |  |  | Hotel & Per Diem Costs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor as a % of Revenue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Third Party as a % of Revenue |  |  |  |  |  |  | Company Owned Equip. Revenue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Co. Owned Equip. as a % of Revenue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Third Party Revenue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobilization & Demobilization ( Labor, Mileage, Flights ) |  |  |  |  |  |  | Third Party Costs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indirect Labor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Direct Labor |  |  |  |  |  |  | Total Manhours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Living Expenses (Per Diem & Hotels)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Company Owned Equipment |  |  |  |  |  |  | Cost per Manhour
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Third Party Billable Items
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenue per Manhour