A spreadsheet implementation of an ammunition requirements planning model for the Canadian Army

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.