A framework for building spreadsheet based decision models

Mather, Dineli R

doi:10.1057/palgrave.jors.2600672

Cited by 13 publications

(5 citation statements)

References 1 publication

Supporting

Mentioning

Contrasting

Order By: Relevance

“…One short sentence can be all it takes to let the reader know how or why some things are done in a certain way. Other useful methodological and design principles are debated in Conway and Ragsdale (1997) and Mather (1999).…”

Section: Structured Methodologymentioning

confidence: 99%

A Spreadsheet-Based Approach for Operations Research Teaching

Munisamy

2009

IES

View full text Add to dashboard Cite

This paper considers the use of spreadsheet for introducing students to a variety of quantitative models covered in an introductory Operations Research (OR) course at the University of Malaya, Malaysia. This approach allows students to develop skills in modeling as they learn to apply the various quantitative models in a spreadsheet. Indeed, imparting spreadsheet and modeling skills with OR skills will make students highly sought after in the modern workplace. This paper goes on to report on the experience in using spreadsheet in the Introductory OR course and students evaluations.

show abstract

Section: Structured Methodologymentioning

confidence: 99%

A Spreadsheet-Based Approach for Operations Research Teaching

Munisamy

2009

IES

View full text Add to dashboard Cite

show abstract

“…There is a considerable literature discussing what organizations should do. Classic recommendations lean toward application of good software engineering principles (Mather, 1999;Janvrin and Morrison, 2000;Grossman and Özlük, 2004) or formal theories (Isakowitz, Schocken, & Lucas, 1995). Kruck and Sheetz (2001) combed practitioner literature for practical axioms validated by empirical results, supporting aspects of the spreadsheet lifecycle theory (e.g., include planning / design and testing/debugging stages) and recommendations to decrease formula complexity.…”

Section: Review Of the Literaturementioning

confidence: 98%

Spreadsheet Errors and Decision Making

Caulkins

Morrison²,

Weidemann³

2007

Journal of Organizational and End User Computing

View full text Add to dashboard Cite

Spreadsheets are both ubiquitous and error-prone, but there is less evidence concerning whether spreadsheet errors frequently lead to bad decisions. We interviewed forty-five executives and senior managers / analysts in the private, public, and non-profit sectors about their experiences with spreadsheet errors and quality control. Almost all report spreadsheet errors are common. Most can report instances in which errors directly led to losses or bad decisions, but opinions differ as to whether the consequences of spreadsheet errors are severe. Quality control procedures are in most cases informal. A significant minority of respondents believe such ad hoc processes are sufficient because the “human in the loop” can detect any gross errors. Others thought more formal spreadsheet quality control could be beneficial.

show abstract

“…Excel spreadsheets are widely used in business today, including MSF. A third benefit is that by using a spreadsheet as a platform for the model, the users benefit from additional flexibility and reliability (Guerrero, 2010;Mather, 1999). In addition, this platform allows the model to be shared easily among staff.…”

Section: Figure 3 Inventory Movement Of Eprep Itemmentioning

confidence: 99%

The impact of Mean Time Between Disasters on inventory pre-positioning strategy

Saputra

Pots

Smidt-Destombes

et al. 2015

Disaster Prevention and Management

View full text Add to dashboard Cite

Purpose -This paper addresses the impact of Mean Time Between Disasters (MTBD) to inventory pre-positioning strategy of medical supplies prior to a sudden-onset disaster.Design/methodology/approach -We developed a trade-off model based on the operations of Médecins Sans Frontières (MSF) and implemented this in a spreadsheet-based platform to show the impact of MTBD on determining a pre-positioning strategy. This spreadsheet model identifies the most cost-efficient scenario out of a set of predefined pre-positioning scenarios. We implemented the model using a case study of a cholera outbreak in Zimbabwe.Findings -We are able to show the impact of MTBD on determining the pre-positioning strategy. In addition, we also capture the trade-off decisions in transport modes and end-of-shelflife policies. Moreover, from financial perspective, we show that an interaction between relief (emergency) and development (regular) programs can be beneficial.Research limitations/implications -We have some limitations on data access and availability. Some data (e.g. uncertainty in needs and lead-time) have to be collected for future research and, then, used to refine such decisions.Practical implications -The model can be used as a justification for selecting an inventory prepositioning strategy based on mean time between disasters (MTBD).Originality/value -We introduce relevant factors in a humanitarian organization's practice that have not yet received attention in literature (i.e. MTBD, inventory swap, and trade-off decisions in transport modes and end-of-shelf-life policies).

show abstract

A framework for building spreadsheet based decision models

Cited by 13 publications

References 1 publication

A Spreadsheet-Based Approach for Operations Research Teaching

A Spreadsheet-Based Approach for Operations Research Teaching

Spreadsheet Errors and Decision Making

The impact of Mean Time Between Disasters on inventory pre-positioning strategy

Contact Info

Product

Resources

About