Reference no: EM131651158
Question: WGI-Human Resources
WGI is a large international construction company with operations in 43 countries. The company has been a major player in the reconstruction efforts in Iraq, with a number of subcontracts under the major contractor, Haliburton, Inc. However, the company is also involved in many small projects both in the United States and around the world. One of these is a sewer line installation project in Madison, Wisconsin. The contract is what is called a "cost plus" contract, meaning that the city of Madison will pay for all direct costs, including materials and labor, of the project plus an additional fee to WGI. Roberta Bernhart is the human resources (HR) manager for the Madison project and is responsible for overseeing all aspects of employee compensation and HR issues. WGI is required to produce a variety of reports to the Madison city council on an annual basis. Recently, the council asked WGI to prepare a report showing the current hourly rates for the nonsalaried work crew on the project. Specifically, the council is interested in any proposed pay increases to the work crew that will ultimately be passed along to the city of Madison. In response to the city's request, Ro berta put together a data file for all 19 nonsalaried work crew members, called WGI, which shows their current hourly pay rate and theproposed increase to take place the first of next month. These data are as follows:
The city council expects the report to contain both graphic and numerical descriptive analyses. Roberta has outlined the following tasks and has asked you to help her.
Required Tasks: 1. Develop and interpret histograms showing the distributions of current hourly rates and proposed new hourly rates for the crew members.
2. Compute and interpret key measures of central tendency and variation for the current and new hourly rates. Determine the coefficient of variation for each.
3.Compute a new variable called Pay Increase that reflects the difference between the proposed new pay rate and the current rate. Develop a histogram for this variable, and then compute key measures of the center and variation for the new variable.
4. Compute a new variable that is the percentage increase in hourly pay rate. Prepare a graphical and numerical description of this new variable.
5. Prepare a report to the city council that contains the results from tasks 1-4.