ss3-Department Budget 1

Remember: DO NOT type the $, commas or percent symbols

                 USE the format options available

Formulas:

The Change column:

    the difference between the 2012 budget number and the 2011 budget number

    Note that if the numbers go up from 2011 to 2012 the results should be positive

The % Change column:

    divide the change column by the original amount (2011)

    format to show no decimal places

Totals:

    Total the 2011,  2012  and the change columns

    The % Change column is determined by dividing the total Change by the total of the 2011 column