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.

b. 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.