I'm fairly new to excel and cant comprehend these problems.

I need to

Use the Labor Hours spreadsheet to build on the table in the Data tab and get the actual cost of this project. To do this, complete the following steps:

1. Total the complete labor cost.
   • Make a column that totals the labor for each employee when you give the added information. (See the last two bullets in the scenario box below.)
   • Total the complete labor cost.
2. Think about what other costs could add to the overall cost of the project.
   • Below is a list to think about. Add more columns for these costs. (Note: Not all of these should be included; read each bullet carefully.)
     • The project is located 30 miles from the office, and the company pays the employees 54 per mile to drive to the worksite and back.
     • You are using $1,000 in materials left over from another project.
     • The worksite is in a remote location. Therefore, a portable office with restrooms had to be leased at a cost of $300 per day.
     • The company spends $350 per employee to provide each employee with a uniform and safety equipment. This equipment is replaced annually.
     • The company pays for a $60 food platter to be delivered to the site every day to feed all the workers.
     • Fuel to run the generator in the portable office costs $10 per day and is included in the lease agreement.
     • A security service had to be hired by the company to guard the worksite 24 hours a day. This costs $720 per day.
   • Total the entire project cost.
3. Create a new tab titled Actual. Write a summary statement that recommends lowering costs without lowering labor rates.

Scenario

You are looking at labor costs for a construction project using eight employees:

• The employees' names are Smith, Rodriquez, Daniel, Eli, Lee, Kim, Buster, and Green.
• Each employee worked eight hours a day for five days.
• The employees' wages per hour are as follows:
  • Smith: $8.95
  • Rodriguez: $11
  • Daniel: $14
  • Eli: $16
  • Lee: $19
  • Kim: $20
  • Buster: $25
  • Green: $40
• Green, Kim, Eli, and Lee are full-time employees, and the others are contract employees.
• The cost of overhead per hour for a full-time employee is 40% of their hourly rate.
• The cost of overhead per hour for a contract employee is 20% of their hourly rate.

Specifically, you must address the following rubric criteria:

1. Set up a spreadsheet and perform labor calculations correctly.
2. Choose the correct additional costs and calculate the total cost correctly.
3. Write a summary recommendation.