The Outdoor Life Ltd. (TOLL) manufactures outdoor furniture. Management is concerned about the cost of its employee benefits plans. Your manager has asked you to analyze the cost of compensation and benefits and prepare data visualizations for her to present to senior management. Specifically, she would like you to assess the costs of TOLL's current benefits compared with a flexible benefits plan from an insurance company. You do not need to consider management employees, as they would not initially be eligible. 

Your manager has given you anonymous information for 40 manufacturing employees and 40 office workers. Data includes (1) employee number and type (M = manufacturing and O = office); (2) salary, excluding any benefits, production bonuses, or overtime pay; (3) cost of paid leave (2–4 weeks per employee); (4) total cost of required benefits (CPP, EI, statutory holiday pay, etc.); (5) cost of current supplemental benefits, including pensions, health care, prescription drugs, vision care, life insurance, dental care, and disability insurance; and (5) the results of an employee survey ranking the importance of these benefits. 

You have been asked to do the following:

1. Briefly describe the visualization tools you could use for this analysis. See the WileyPLUS Data Analytics and Accounting module on “Storytelling with Data” for more information. 

2. Using the data and other information in WileyPLUS, (1) analyze the employee survey data to determine which benefits plans are the most (to least) popular by employee type, (2) determine the current average cost of salary and benefits by compensation category and employee type, (3) prepare the visualizations your manager has asked for, and (4) determine the average “Flexible Benefits Allotment” that could be given to each employee without increasing Toll's overall compensation costs. 

Instructions 

Go to WileyPLUS for additional instructions and materials to complete this question.