Use the 29 CFR 1904 OSHA recordkeeping requirements (www.osha.gov) to identify the OSHA recordable injuries.
c. Fill out the federal OSHA 300 log for applicable injuries. Use the injury IDs provided on the injury table for each injury. You can make up employee names. Use the online MS Excel version of the 300 log (OSHA website). In addition, fill out the OSHA 300A summary sheet based on the injury information and work hours provided in Table 1.
d. Analyze the accident / incident data with the help of a MS Excel worksheet. Create the Table 1 provided below in MS Excel sheet with built-in formulas.
i. Calculate the first aid, recordable, and DART rates per 100 full-time workers for each month using work hours provided below.
ii. Find out the recordable and DART rate industry average for NAICS 336112 from the OSHA website.
iii. Create a line graph comparing the company’s average to the industry average for recordable and DART rates.
iv. Make sure to add additional columns for environmental and other incidents.
2. Create accident trending charts using MS Excel for Capstone Corporation using the accident log presented in Table 2. Provide detailed corrective actions.
a. Feed injury / incident classification (e.g., first aid, recordable, environmental incidents, etc.) information from item 1(a).
b. Classify the injury types under: Bruise, Sprain, Strain, Fracture, Laceration/Cut, Burn, Puncture, and others.
c. Classify the accident type under: struck-by, struck-against, contact-by, contact-with, caught-on, caught-in, caught-between, fall-to-surface, fall-to-below, exertion, bodily reaction, and exposure.
d. Classify the body part.
e. Create seven professional graphs for: (1) OSHA classification, (2) injury days, (3) injury time zones, (4) accident type, (5) body part, (6) supervisor, and (7) Area. For injury time, split the time into four zones (e.g., Zone 1: 6 am to noon).
f. Include the trends in your report and identify remedial measures.
3. Recommend a Corrective Action Plan (CAP) and an Accident Prevention Plan (APP):
Your manager wants your recommendation. Should Capstone Insurance Company insure Capstone Corporation after this detailed review?
i. If no, provide a detailed explanation justifying your decision.
ii. If yes, why, and what is the CAP you would want to see from Capstone Corporation as a condition of providing insurance?
iii. Provide recommendations for the company to create a workplace APP, including environmental management. If this company is located in Washington, what would be the major elements of the company’s APP? Develop the list based on the accidents / incidents suffered by the company and Washington Division of Occupational Safety and Health (DOSH) requirements? What should each element address based on the company’s injury history (provide at least one sentence explanation for each element)?