Studying Faculty Flows Using an Interactive Spreadsheet Model. AIR 1997 Annual Forum Paper.

Autor/in	Kelly, Wayne
Titel	Studying Faculty Flows Using an Interactive Spreadsheet Model. AIR 1997 Annual Forum Paper.
Quelle	(1997), (31 Seiten) PDF als Volltext kostenfreie Datei Verfügbarkeit
Sprache	englisch
Dokumenttyp	gedruckt; online; Monographie
Schlagwörter	Academic Rank (Professional); College Faculty; Computer Software; Decision Making; Early Retirement; Educational Finance; Faculty Mobility; Foreign Countries; Higher Education; Institutional Administration; Institutional Research; Markov Processes; Mathematical Models; Personnel Management; Personnel Needs; Predictive Measurement; Predictor Variables; Research Methodology; Spreadsheets; Strategic Planning; Teacher Salaries; Teacher Supply and Demand + Suchen Sie Ihr Suchwort? Fakultät; Decision-making; Entscheidungsfindung; Bildungsfonds; Ausland; Hochschulbildung; Hochschulsystem; Hochschulwesen; Institutionelle Forschung; Markowscher Prozess; Mathematical model; Mathematisches Modell; Personalmanagement; Personnel requirement; Personalbedarf; Prädiktor; Research method; Forschungsmethode; Spread sheet; Spredsheets; Spreadsheet; Tabellenkalkulation; Strategy; Planning; Strategie; Planung; Lehrerbesoldung; Lehrervergütung; Lehrerbedarf
Abstract	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)
Erfasst von	ERIC (Education Resources Information Center), Washington, DC