Question
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
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started