Explore BrainMass
Share

Building a Simple Expert System for Retirement Planning

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

When employees at a company retire, they are given cash bonuses. These cash bonuses are based on the length of employment and the retiree's age. To receive a bonus, an employee must be at least 50 years of age and have worked for the company for 5 years. The following table summarizes criteria for determining bonuses:
Length of Employment............Bonus
<5 years..................................No bonus
5-10 years..............................20 percent of current annual salary
11-15 years............................30 percent of current annual salary
16-20 years............................40 percent of current annual salary
21-25 years............................50 percent of current annual salary
26 or more years...................100 percent of current annual salary

Using this information, build an Excel spreadsheet that calculates the correct bonus when given the required information.
-Set up spreadsheet so that users select the appropriate length of employment category from the above list.
-Set up spreadsheet so that the user cannot edit any values except the input fields.

Then use the "Scenario Manager" in Excel to set up the following What If Analyses:
Name........................Age .......Length of Service........Salary
John Smith................59...................12....................$120,000
G.I. Jane...................42...................20....................$40,000
Beth Goodfellow........51....................3.....................$97,000
Stephen Graham......58....................28....................$105,000
Kelsey Mattews.........67.....................6.....................$78,000
The spreadsheet should include, on a separate worksheet, the Scenario Summary for these scenarios.

© BrainMass Inc. brainmass.com October 25, 2018, 8:15 am ad1c9bdddf
https://brainmass.com/business/management-information-systems/building-simple-expert-system-retirement-planning-532853

Solution Summary

The expert builds a simple expert system for retirement planning.

$2.19
See Also This Related BrainMass Solution

Organizational pay and employment retirement plans

3.1) Traditional job interviews have demonstrated low validity and reliability, and are a relatively expensive method of personnel selection. Recommend steps that organizations can take to avoid these pitfalls.

3.2) How should a company assess readiness for learning? (Be sure to include characteristics of both the employee and the work environment

3.3) Discuss at least three different approaches to diversity training.

4.1) Discuss the importance of legal compliance with federal employment laws and regulations as well as ethical issues that govern appraisals and performance management. Provide examples.

4.2) Define the three broad purposes for performance management, and provide an example of a situation that relates to each purpose.

4.3) You have just been promoted to manager of your department. Your supervisor has asked that you review the current performance management system measures in place, and make any possible suggestions. Would you enlist input from the employees in your department? Why, or why not? List and interpret the criteria you would use to evaluate the current performance management system.

6.1) Compare and contrast the three common types of retirement plans offered by employers, and indicate whether they are contributory or noncontributory plans. What are the advantages and disadvantages of each one to the employee and to the employer?

6.2) Give a brief description of the 5 types of individual performance pay, and recommend which type of job would benefit by using which type of performance pay.

6.3) You are the HR Supervisor responsible for developing the company objectives that will be listed in the new benefits package. What needs to be considered when selecting employee benefits?

View Full Posting Details