Applicability of computer spreadsheet simulation for solving resource allocation problems

Abstract

This thesis investigates the possibility of employing computer spreadsheets as a sophisticated tool to resolve resource allocation dilemmas through simulation techniques. Microsofts Excel 4. 0 is used to analyzed three separate and unique resource allocation problems. First, an inventory distribution system involving different distribution points to illustrate the magnification of uncertainty as the distribution system is lengthened. Second queuing utilization problem faced by an emergency room of a hospital. The third scenario looks at the uncertainty in financial budgeting situation as reflected in the Navy's CHAMPUS budget. A spreadsheet macro using simulation techniques is created for each scenario to illustrate that computer spreadsheets are fully capable of analyzing resource allocation enigmas through simulation methodology