Management Information Systems Homework – Spreadsheet Help?

Management Information Systems Homework – Spreadsheet Help?

Cindy Sanders, the Vice President of Human Relations at Milford, feels that programs encouraging employee interaction outside the work environment can help to both reduce turnover and improve employee moral. Such programs can help to strengthen social relationships between employees and help to build those relationships more quickly. The increased camaraderie created should also improve overall morale and reduce employee turnover.

One program that has come to Cindy’s attention is the offering of free or reduced-rate health club memberships to employees. Such a program would be offered through a health club facility very near the Milford office complex. This would make it easy for Milford employees to sue health club facilities before or after work, or even during the lunch hour. By promoting use of health club facilities around the time and place of work, it is felt that employees will schedule activities together or simply "run in to each other" in the health club facility. Another consideration in Cindy’s mind is the fact that several competing financial services firms have begun offering this "perk" to their employees. Cindy feels that it is time to investigate the costs of such a program.

She begins her investigation by examining the types of health club membership options offered by related forms in the area. She discovers that some larger forms have their own "in plant" facilities. Many firms do not offer health club services at all. The remainder offer free or reduced price memberships to a health club with at least one facility within the immediate area of their offices. When memberships are offered, they cover only the employees themselves, although health clubs often offer discounted rates for covered employees who want to establish family memberships.

Cindy also engages in some informal conversations with a variety of employees. These discussions suggest that free health club memberships would be viewed as a significant benefit by many employees, particularly if the membership included the availability of free aerobics classes. Based on these preliminary discussions, Cindy decides to investigate the cost of fully supporting memberships for all employees. She begins discussions with health clubs. She is able to find three health clubs with nearby facilities that are willing to offer a corporate membership for Milford employees.

Firm-It-Up operates a single facility which is located two blacks from the Milford offices. It offers a full range of health club services, although only very limited aerobics classes are offered. Firm-It-Up’s owner is willing to guarantee that additional classes will be added to meet Milford’s needs if Milford sings a contract with his club. The owner quotes Cindy a flat rate of per membership per month for a basic membership not including aerobics classes. He would charge for a premium membership including aerobics classes. Firm-It-Up would charge Milford only for those employees who signed up for memberships and would charge the premium rate only for those employees signing up for aerobics classes.
The Sweat Shop operates from a single, large-scale, facility which is located approximately 4 blocks from the Milford offices. It offers a full range of services and appears to have sufficient facilities to accommodate the needs of all Milford employees without further expansion. The ownership of the Sweat Shop quotes you a price of for each employee per month. For this fee every employee would receive a membership including access to aerobics classes. This rate is offered with the understanding that memberships will be issued to ALL employees and Milford will pay per month for all employees including those not using the health club.
The Fitness Factory operates five health facilities in the greater metropolitan area. The nearest facility is approximately one-quarter mile from the Milford offices. This facility currently offers only a limited number of aerobics classes, but all other facilities and services appear to be more than adequate. The ownership of The Fitness Factory is willing to commit to offering additional aerobics classes as needed if Milford signs a contract with them. The ownership quotes you a price of per membership per month. they would charge Milford only for those employees requesting membership cards from the club and would offer aerobics classes to all members.
In order to compa

Like this post? Subscribe to my RSS feed and get loads more!