This is a spreadsheet model and what it does is to present you with a template that asks for a small number of inputs that it then uses to give you these bits of information:

 

 

 

 

 

 

 

 

Summary Documentation

 

This model has been designed to run automatically and you should only change the variables as specified below.

 

You need to specify the number of MAN DAYS on a section by section basis is at the heart of the budget and only by changing the number of man days will the major part of the budget change. Once the number of MAN DAYS has been entered the budget then takes those values into account and is updated automatically.

 

Similarly, for the budget for 2 TRAINING ACCOMMODATION: the number of X,XXX is currently showing in the Input Sheet which is then automatically taken into the budget in the model's Working Sheet and it is then used in the same way as the man days, described above.

 

Updating the Numbers

 

All of these values are changeable according to your plans, targets and actual inputs; but please be careful!

 

The budget has been prepared in such a way that changes to the budgets are made only in the input sheet. For example, if the number of MAN DAYS for an in house with external trainer course change, make the changes ONLY in the relevant Input Sheet and the budget will change automatically to reflect your change.

 

The same is true with all other variables and rates. Just make the changes in the Input Sheet and the budget will change automatically.

 

In other words, we have created the budget in such a way that anyone can use it by following some simple guidelines, as summarised above.

 

 

 

 

Dr Tony Miller and Duncan Williamson