Option #1: Wage Determination 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/5100 of base wage Public liability/property $2.50/$100 of base wage $2. 10/$100 of base wage damage 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