6/13/24, 10:55 AM Assignment Information QSO 320 Module Four Assignment Guidelines and Rubric Overview For this assignment, you'll continue to build on your Labor Hours spreadsheet to look at the actual costs of a business project. 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 https://learn.snhu.edu/d2l/le/content/1614358/viewContent/33190528/View 1/2 12 6/13/24, 10:55 AM 。 Rodriguez: $11 o Daniel: $14 • Eli: $16 • Lee: $19 。 Kim: $20 0 Buster: $25 Assignment Information • 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 Calibri font. Criteria Labor Calculations Proficient (100%) Module Four Assignment Rubric Needs Improvement (70%) Additional Costs Summary Recommendation Sets up the spreadsheet correctly and performs calculations correctly Chooses the correct additional costs and calculates the total cost correctly Writes a summary recommendation https://learn.snhu.edu/d2l/le/content/1614358/viewContent/33190528/View Not Evident (0%) Value Shows progress toward proficiency, but with errors or omissions Does not attempt criterion 20 Shows progress toward proficiency, but with errors or omissions Does not attempt criterion 40 40 Shows progress toward proficiency, but with errors or omissions Does not attempt criterion 40 Total: 100% 2/2

Solved: 6/13/24, 10:55 AM Assignment Information QSO 320 Module Four Assignme

Home
questions and answers
6 13 24 10 55 am assignment information qso 320 module four assignment

Question

6/13/24, 10:55 AM Assignment Information QSO 320 Module Four Assignment Guidelines and Rubric Overview For this assignment, you'll continue to build on your Labor Hours spreadsheet to look at the actual costs of a business project. Directions Use the Labor Hours spreadsheet to build on the table in the Data tab and ge