Excel Template for FY06 Midyear Variance Reports / FY07 Consolidated Forecast Submissions

Here is the Excel template units should use, in combination with Business Objects, to extract FY06 budget and actuals data, to prepare and submit your FY06 Midyear Variance Reports.

Right click on the hyperlink below to download the file and save it on your computer. You should go to the INSTRUCTIONS tab first.

Remember, when you run the Excel macro, it creates a new file each time you run it, so you can keep using the Excel template file over and over again. It works just the same way it did for the mid-year exercise, except, of course, that there is no column for a projection.

The variance columns are formatted to highlight for any variances of +/- 10% or +/- $500,000, whichever is greater. It would help our job immensely if you could use comments (the "post-its") to enter brief variance analysis descriptions on the appropriate cell. Of course, if you also want to submit a more detailed written description, please feel free to do so.

The analysis must be returned to Andrew Harker no later than Monday, April 10th . If you will have a problem meeting that deadline, please contact Andrew.

If you have any questions, please feel free to contact anyone in our office.

• Excel Template for FY06 Midyear Variance Reports / FY07 Consolidated Forecast