NotesFAQContact Us
Search Tips
ERIC Number: ED410894
Record Type: Non-Journal
Publication Date: 1997-May-19
Pages: 31
Abstractor: N/A
Reference Count: N/A
Studying Faculty Flows Using an Interactive Spreadsheet Model. AIR 1997 Annual Forum Paper.
Kelly, Wayne
This paper describes a spreadsheet-based faculty flow model developed and implemented at the University of Calgary (Canada) to analyze faculty retirement, turnover, and salary issues. The study examined whether, given expected faculty turnover, the current salary increment system was sustainable in a stable or declining funding environment, and whether further early retirement incentives would be necessary. The model, called the Academic Staff Resource Projection Model, is based on the Markov chain approach to project faculty movement out four years. It was developed using Microsoft's Excel spreadsheet software. Nine alternative policies and assumptions were tested concerning: (1) retirements for ages 55 to 70; (2) resignation rates by years of service; (3) age distribution of newly hired staff; (4) annual attrition of one rank replaced by another rank; (5) overall attrition replacement ratio; (6) adjustments to allow for addition or elimination of academic programs; (7) starting salaries; (8) salary schedule information; and (9) rate of promotion to next rank. Six figures and flow charts illustrate the model and show the spreadsheet file structure and flows. Three appendixes include a policy variables worksheet, a salary schedule, and an age distribution schedule. (Contains 16 references.) (CH)
Publication Type: Reports - Evaluative; Speeches/Meeting Papers
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A