Question: Directions Use the Labor Hours spreadsheet to build on the table in the Data tab and get the actual cost of this project. To

Directions Use the Labor Hours spreadsheet to build on the table in

Directions 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. A. 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.) B. Total the complete labor cost. 2. Think about what other costs could add to the overall cost of the project. A. 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.) i. 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. ii. You are using $1,000 in materials left over from another project. iii. The worksite is in a remote location. Therefore, a portable office with restrooms had to be leased at a cost of $300 per day. iv. The company spends $350 per employee to provide each employee with a uniform and safety equipment. This equipment is replaced annually. v. The company pays for a $60 food platter to be delivered to the site every day to feed all the workers. vi. Fuel to run the generator in the portable office costs $10 per day and is included in the lease agreement. vii. A security service had to be hired by the company to guard the worksite 24 hours a day. This costs $720 per day. B. 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. What to Submit Your assignment must be submitted as the same Microsoft Excel document you used for the Module One and Two assignments. Use 11-point

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Certainly Heres a stepbystep guide to complete the assignment using Excel Step 1 Calculate Total Lab... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!