This Article Full Text (PDF) References Alert me when this article is cited Alert me if a correction is posted Services Email this article to a friend Similar articles in this journal Alert me to new issues of the journal Download to citation manager Citing Articles Citing Articles via Google Scholar Google Scholar Articles by Hurley, W. J. Articles by Balez, M. Search for Related Content

A Spreadsheet Implementation of an Ammunition Requirements Planning Model for the Canadian Army

Department of Business Administration, Royal Military College of Canada, Kingston, Ontario, Canada K7K 7B4
Department of Business Administration, Royal Military College of Canada, Kingston, Ontario, Canada K7K 7B4
hurley-w{at}rmc.ca
matbalez{at}gmail.com

This paper describes our experience constructing a spreadsheet implementation of a dynamic ammunition requirements model for Canadian Army training. Each year, the Canadian Army offers a variety of training courses and expends approximately $40 million in ammunition costs to run these courses. It was budgeting over $60 million, and this created a number of organizational problems. The Canadian Army needed a planning tool to bring budgeted expenditures into line with actual expenditures. Our 14 MB spreadsheet implementation accomplished this objective, and the Canadian Army is very pleased with the result.

Key Words: military; logistics; software; system design/operation