Applicability of computer spreadsheet simulation for solving resource allocation problems
Hicks, Dixon Kendall
Liao, Shu S.
Milligan, Richard D.
MetadataShow full item record
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
Approved for public release; distribution is unlimited
Showing items related by title, author, creator and subject.
Beattie, Jodi C. (Monterey, California. Naval Postgraduate School, 2003-03);As mesoscale models increase in resolution there is a greater need to understand predictability on smaller scales. The predictability of a model is related to forecast skill. It is possible that the uncertainty of one scale ...
McLeod, Christopher W. (Monterey, California: Naval Postgraduate School, 2013-09);This thesis will examine the effect of nonlinearities on the propagation of orbit uncertainties in order to gain insight into the accurateness of the estimation of covariance with time. Many real-world applications rely ...
Relating tropical cyclone track forecast error distributions with measurements of forecast uncertainty Chisler, Nicholas M. (Monterey, California: Naval Postgraduate School, 2016-03);Tropical cyclone (TC) track forecasts will always contain uncertainty. This thesis relates ranges (bins) of uncertainty measurements with historical TC track forecast errors, to provide statistically distinct error ...