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. Click here to view the Excel. Raw Data includes: 1) 2) 3) 4) 5) 6) You have been asked to do the following: a. employee number and type (M=manufacturing and O- office); salary, excluding any benefits, production bonuses, or overtime pay; cost of paid leave (2-4 weeks per employee); total cost of required benefits (CPP, EI, statutory holiday pay, etc.); cost of current supplemental benefits, including pensions, health care, prescription drugs, vision care, life insurance, dental care, and disability insurance; and the results of an employee survey ranking the importance of these benefits. b. 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. 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.

The Outdoor Life Ltd, (TOU) 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 TOLI'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 manutacturing employees and 40 office workers. Clickhere to viencthe Excel. Raw Oatainsludes: 1) employee namber and type ( M - manufacturing and O - office): 2) solary, excluding amy beneffts, production bonuses, or overtime pry. 3) cost of paid lewe (2 - 4 weeks per employee): 4) total cont of required benefits (CPP, El,statutory holiday pay,etc): 5) cost of current supplemental benefits, including pensions, health care, prescription drugs, vision care, life insurance, dental care, and dinability insurance; and 6) the results of an enployee surver ranking the importance of these benefits. You huve been asked to do the following: 3. Eriefly describe the voualization tooh you could use for this ansiysis. See the Wileyplus Data Analytics and Accounting module on "Storytelling with Data" for more informution. b. Using the data and other information in wirypt ts, t1 analy se the emplovee survey data to determine which benefits plans are the mont 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 manoger has asked for, and (4) determine the average 'Flesible Benefits Allotment' that could be given to each employee without incressing Tolls overail compenution costs