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. ... Spreadsheet simulation, Resource allocation, Inventory distribution management, Queuing utilization, Financial budgeting, Simulation
Document Details
- Document Type
- Technical Report
- Publication Date
- Mar 01, 1993
- Accession Number
- ADA267436
Entities
People
- Dixon K. Hicks
Organizations
- Naval Postgraduate School