Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

PROJECT 2: RJ CONSTRUCTION- PUTTING ALL THE CONCEPTS TOGETHER Please open the file you downloaded from Carmen named- RJConstruction.xlsx. The worksheets displayed in this workbook

PROJECT 2: RJ CONSTRUCTION- PUTTING ALL THE CONCEPTS TOGETHER\ Please open the file you downloaded from Carmen named- RJConstruction.xlsx. The worksheets displayed in\ this workbook (and on the last page of this lab) are all worksheets in a single workbook. You are using this\ workbook to keep track of labor costs for your companys construction project.\ The worksheet named Wages lists the hourly wages for each of the different craft-skills your company\ employs. Each craft-skill is uniquely identified by a job code.\ The benefit costs in dollars per hour are determined based on the hourly wage. Two worksheets,\ Benefits1 and Benefits2, outline this information. Both worksheets list the hourly benefits in dollars per\ hour that correspond to a specific range of hourly wages. For example: employees earning hourly wages\ of less than $25 will earn $2 in benefits per hour, employees earning hourly wages between $25 and\ $29.99 will earn $3 in benefits per hour, etc.\ The worksheet named Time lists the dates each crew worked for the current pay period. Hours are\ tracked by crew- every member of a crew will be paid the same number of hours on each day that crew\ worked. The number of hours a crew worked on a given day is listed in Column C. The hourly rate of pay\ is listed on the wage table (in dollars per hour) and varies based on the job code of the employee.\ The worksheet named Crew lists the Crew# and name of each person who worked, the date they were\ employed with the company, a TRUE/FALSE value to indicate if they have ever had a work-related injury\ while working for you and to which craft skill (Job Code) they belong.\ The worksheet named Summary is where you will summarize portions of your analysis.\ The Info worksheet includes some additional information that you may need for your calculations\ including the date of reference for calculating years of service in this analysis, the total budget amount\ allotted for this project and the proportion of the total project completed in each pay period

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

13th Edition

978-0697789938

Students also viewed these Accounting questions