Option #1: Determine Wages

A crew of five carpenters and two laborers will be used to build a concrete structure. Work is scheduled for 10 hours/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.

(See attachment for the table with all factors)

Deliverable:

You will deliver both:

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 the information in the tables changes and the final answer highlighted in yellow.

Show all of your work (at each step).

A two-page narrative to describe your findings and interpret your results:

Follow APA format

Include a cover page and reference page.

Support your work with at least two peer-reviewed, credible, and current scholarly articles.