Accession Number : ADA267436


Title :   Applicability of Computer Spreadsheet Simulation for Solving Resource Allocation Problems


Descriptive Note : Master's rept.,


Corporate Author : NAVAL POSTGRADUATE SCHOOL MONTEREY CA


Personal Author(s) : Hicks, Dixon K


Full Text : https://apps.dtic.mil/dtic/tr/fulltext/u2/a267436.pdf


Report Date : Mar 1993


Pagination or Media Count : 141


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


Descriptors :   *COMPUTER PROGRAMS , *RESOURCE MANAGEMENT , *NAVAL BUDGETS , COMPUTERIZED SIMULATION , SCENARIOS , METHODOLOGY , UNCERTAINTY , DISTRIBUTION , TOOLS , UTILIZATION , COMPUTERS , COMPUTER PROGRAMMING , THESES , MATHEMATICAL ANALYSIS , ALLOCATIONS , RESOURCES , INVENTORY


Subject Categories : Economics and Cost Analysis
      Computer Programming and Software


Distribution Statement : APPROVED FOR PUBLIC RELEASE