Labor cost comparison of the burdened rates for a concrete mason and a concrete finisher. Must be completed in excel workbook. Concrete MasonProject hours for this trade is 10 hours/day and 6 days/week (Monday – Saturday)Base Wage: $27.00Base Hours: 50 hrs/wkOvertime Pay (after 50 hrs worked) = 1.5x base wageNo Weekend pay increaseFederal Tax = 8.5%Unemployment Tax = 6.4%Worker’s Compensation Insurance = $5/$100PL & PD Insurance = $3.50/$100Fringe Benefits = $3/hour Concrete FinisherProject hours for this trade is 10 hours/day and 6 days/week (Monday – Saturday)Base Wage: $34.80Base Hours: 40 hrs/wkOvertime Pay (after 40 hrs worked, M-F) = 1.5x base wageWeekend Pay = 2.0x base wageFederal Tax = 7.5%Unemployment Tax = 7.8%Worker’s Compensation Insurance = $10/$100PL & PD Insurance = $2.50/$100Fringe Benefits = $3/hour Concrete MasonThese numbersare taken fromBase WageBase HoursActual HoursFederal Tax27.00Pay Hours50608.50%the wordUnemployment Tax6.40%document->Worker Comp Insurance $0.05Total Pay HoursPL & PD Insurance$0.035Fringe Benefits$3.00Concrete FinisherThese numbersare taken fromthe wordBase WageBase HoursActual HoursFederal TaxUnemployment Taxdocument->Worker Comp InsurancePL & PD InsuranceFringe BenefitsLabor DescriptionsCalculationBase HoursWeekday OvertimeWeekend OvertimeAverage Actual WageFederal TaxUnemployment TaxWorker's Comp InsurancePL & PD InsuranceFringe BenefitsTotal Burdened CostCalculation for the ConcreteMason<-- Use this number inworksheet 2 for yourcomparisonPay HoursLabor DescriptionsAverage Actual WageFederal TaxCalculationBase HoursWeekday OvertimeWeekend OvertimeTotal Pay HoursUnemployment TaxWorker's Comp InsurancePL & PD InsuranceFringe BenefitsTotal Burdened CostCalculation for the ConcreteMason<-- Use this number inworksheet 2 for yourcomparison

Here's a detailed calculation for better understanding. Pay Hours Calculation:Base Pay: 50 hours ×…

Answered: Concrete Mason These numbers are taken…

6th Edition

ISBN:9781337630931

Author:KASSIMALI, Aslam.

Publisher:KASSIMALI, Aslam.

Chapter2: Loads On Structures

Section: Chapter Questions

Problem 1P

Related questions

Question

Labor cost comparison of the burdened rates for a concrete mason and a concrete finisher. Must be completed in excel workbook.

Concrete Mason

Project hours for this trade is 10 hours/day and 6 days/week (Monday – Saturday)
Base Wage: $27.00
Base Hours: 50 hrs/wk
Overtime Pay (after 50 hrs worked) = 1.5x base wage
No Weekend pay increase
Federal Tax = 8.5%
Unemployment Tax = 6.4%
Worker’s Compensation Insurance = $5/$100
PL & PD Insurance = $3.50/$100
Fringe Benefits = $3/hour

Concrete Finisher

Project hours for this trade is 10 hours/day and 6 days/week (Monday – Saturday)
Base Wage: $34.80
Base Hours: 40 hrs/wk
Overtime Pay (after 40 hrs worked, M-F) = 1.5x base wage
Weekend Pay = 2.0x base wage
Federal Tax = 7.5%
Unemployment Tax = 7.8%
Worker’s Compensation Insurance = $10/$100
PL & PD Insurance = $2.50/$100
Fringe Benefits = $3/hour