Scenario # 2: Compensation and Benefits Administration You just finished analysing information for the current compensation and benefits program information. You find that some changes should be made, as the majority of employees (you have 120 employees) are unhappy with what is being offered. In fact, the plan had not been revised in over fifteen years, making it dated and definitely ready for some changes. One of the major points of contention is the Paid Time Off (PTO) the organisation offers. Employees feel the current system of sick time and vacation time offers too few options. For example, one employee says, “I often come to work sick, so I can still have my vacation time for my vacation.” Another employee says, “I have given nine years to this organisation, but I receive only three days more than someone who has just started.” Here is the current PTO offering: 1+ year 7 days 5+years 10 days 10+ years 14 days Propose a new plan to the board of directors. The plan should be in the form of a table (spreadsheet),  including PTO and other employee benefits.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 21P
icon
Related questions
Question

Scenario # 2: Compensation and Benefits Administration

You just finished analysing information for the current compensation and benefits program information. You find that some changes should be made, as the majority of employees (you have 120 employees) are unhappy with what is being offered. In fact, the plan had not been revised in over fifteen years, making it dated and definitely ready for some changes.

One of the major points of contention is the Paid Time Off (PTO) the organisation offers. Employees feel the current system of sick time and vacation time offers too few options. For example, one employee says, “I often come to work sick, so I can still have my vacation time for my vacation.” Another employee says, “I have given nine years to this organisation, but I receive only three days more than someone who has just started.”

Here is the current PTO offering:

1+ year 7 days
5+years 10 days
10+ years 14 days

Propose a new plan to the board of directors. The plan should be in the form of a table (spreadsheet), 
including PTO and other employee benefits. 

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Goal setting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Management, Loose-Leaf Version
Management, Loose-Leaf Version
Management
ISBN:
9781305969308
Author:
Richard L. Daft
Publisher:
South-Western College Pub