For this assignment, you will determine Davis Bacon wages for your area for brick and block work given the following scenario:

A crew of five (5) carpenters and two (2) laborers will be used to build formwork for a concrete structure. Work is scheduled for 10 hours (hrs)/day on Monday through Friday and 8 hours on Saturday. Overtime at a rate of one and one-half will be paid for all hours over 8 hours/day on Monday through Friday and double-time for all Saturday work. The base wage, taxes, and insurance rates are given below. Calculate the hourly, weekly, and monthly cost for the crew.

Item	Carpenters	Laborers
Base wage	$30.18/hr	$20.78/hr
Workers' compensation	$5.35/$100 of base wage	$4.75/$100 of base wage
Public liability/property damage	$2.50/$100 of base wage	$2.10/$100 of base wage
Social Security (FICA)	7.65% of actual wage	7.65% of actual wage
Unemployment tax	2% of actual wage	2% of actual wage
Fringe benefits	$2.40/hr	$2.15/hr

Deliverable: Upon completion of this assignment, you will deliver an Excel spreadsheet to include:

• Tables of all information (data) given in the problem
• Formulas that reference cells, thus creating dynamic formulas that will change if information in the tables changes
• The final answer highlighted in yellow.