CON/CNE 271 Construction Safety HW #3: Calculations In this homework assignment, there are two scenarios where you must calculate the amount each contractor will be paying for workers' compensation for one (1) month's payroll, as well as calculate TRIR and LTIR. Please show all calculations/work for questions 1A, 1B, and 3, and then answer question 2. Answer all questions legibly as unclear answers will not get credit. If an excel spreadsheet is used, please include a copy of the formula sheet along with your answer sheet. Please staple your answer sheet(s) to this homework page (15 points possible). Contractors should provide a safe work environment (treat safety as a value), but there are other advantages when contractors promote safe work practices. These advantages come in the form of lower overhead costs which increases profits. The workers' compensation costs for each employee group are determined by the National Council on Compensation Insurance (NCCI) by state. Each task or job is given a class code and rate which is universal for all contractors within the states jurisdiction. The following job and rates are a very close representation of premiums an Arizona framing contractor would expect to pay per classification or job task and are listed as follows: Framing employees $17.35, Salesperson $.0.78, and Bookkeeper $0.22. The NCCI also assigns each contractor their individual Experience Modification Rate (EMR) based on past injury expenditures. 1. Given the following information, calculate company Workers' Compensation Costs for each: A. ABC Framing has 25 framing employees earning an average hourly wage of $22.50 and each framer is working a total of 165 hours for the month. ABC Framing has one (1) salesperson that makes a base salary per month of $4,000 dollars, and one (1) bookkeeper who earns a wage of $12.00 per hour, working a total of 176 hours for the month. The EMR assigned to ABC Framing by NCCI is 1.15. (3.5 pts) B. XYZ Framing has 30 framing employees earning an average hourly wage of $23.00, and each framer is working a total of 176 hours for the month. XYZ Framing has two (2) salespersons that make a base salary per month of $3,000 dollars, and one (1) bookkeeper who earns a wage of $16.00 per hour, working a total of 176 hours for the month. The EMR assigned to XYZ Framing by NCCI is 0.65. (3.5 pts) 2. Based on your analysis for monthly Workers' Compensation costs in $$, which contractor in problems #1 & #2 would have a better culture? (3.0 pts) 3. Calculate the 2016 TRIR (2.5 pts) and LTIR (2.5 pts) for a company that has the following: 240 workers; executed 42,634 hours in 2016; 22 First Aids; 2 MTI; 1 RWI; 1 LTI \f