IT Department Budget Template - Download as Excel

Document Sample
IT Department Budget Template - Download as Excel Powered By Docstoc
					IT Department Budget Template Instructions

The IT Department Budget Template is an Excel spreadsheet that can be used to develop your annual IT
Department budget. There are four worksheet tabs:

1. Instructions
Read the instructions on this first tab before using this template to develop your budget.

2. Monthly Worksheet
This is an optional tab that you can use to better estimate the totals for indivual revenue and expense items over the year.
If you use this tab to help calculate the totals for some or all line items, simply transfer the numbers from the 'TOTALS'
Column into the corresponding line on the Department Budget tab. Inputting last year's budget is not required, but it
may help to estimate numbers for this year.

3. Department Budget
Use this tab to develop your department budget. Input any numbers from the Monthly Worksheet tab, and then fill in any
other numbers that are appplicable to your department.

4. Budget Summary and Graphs
Once you have completed your Department Budget, you can use this tab to analyze your results. The data for this tab is
automatically generated from the Department Budget tab.

Please note the following:
Only input numbers into cells that have a blue font color

To add or change line items in the Monthly Worksheet or the Department Budget, go to 'Tools' menu in Excel,
select 'Protection', and unprotect the sheet. Be sure to protect the sheet using the same steps once you have made these
changes so that you do not mistakenly input data into an incorrect cell.
                                                   Last Year's
IT Department Budget                                 Budget
                                                                 Month 1   Month 2   Month 3   Month 4   Month 5   Month 6   Month 7   Month 8   Month 9   Month 10   Month 11   Month 12   TOTALS   Comments/Assumptions

Monthly Worksheet                                  (Full Year)       Jan       Feb       Mar       Apr       May       Jun       Jul       Aug       Sep       Oct        Nov        Dec
DEPARTMENT REVENUES
Fees IT Charges for Services Performed                                                                                                                                                      $   -
Proceeds from Sales of Assets                                                                                                                                                               $   -
Other                                                                                                                                                                                       $   -
Total Department Revenue                           $      -      $     -   $     -   $     -   $     -   $     -   $     -   $     -   $     -   $     -   $     -    $     -    $     -    $   -

PERSONNEL
Headcount (People not Dollars)
 Full-Time
 Contract
 Other
Total Headcount                                           -            -         -         -         -         -         -         -         -         -         -          -          -

DEPARTMENT EXPENSES
Personnel Expenses (Dollars not People)
Full-Time Salaries                                                                                                                                                                          $   -
Temporary Workers                                                                                                                                                                           $   -
Bonuses / Other Compensation                                                                                                                                                                $   -
Employee Benefits                                                                                                                                                                           $   -
Consultants                                                                                                                                                                                 $   -
Outsourcing Contracts                                                                                                                                                                       $   -
Training / Seminars                                                                                                                                                                         $   -
Automobile Expense                                                                                                                                                                          $   -
Travel (e.g. Plane Tickets)                                                                                                                                                                 $   -
Accomodation (e.g. Hotels)                                                                                                                                                                  $   -
Meals                                                                                                                                                                                       $   -
Employee Relocation                                                                                                                                                                         $   -
Total Personnel Expenses                           $      -      $     -   $     -   $     -   $     -   $     -   $     -   $     -   $     -   $     -   $     -    $     -    $     -    $   -

Office Supplies
General Supplies                                                                                                                                                                            $   -
Media Costs (Diskettes, CDs, Tapes, etc.)                                                                                                                                                   $   -
Postage / Freight                                                                                                                                                                           $   -
Publication Costs                                                                                                                                                                           $   -
Total Office Supplies                              $      -      $     -   $     -   $     -   $     -   $     -   $     -   $  
				
DOCUMENT INFO
Description: Info-Tech's bundle of The Top 50 IT Templates are valuable tools designed to help you bank your most precious asset – time. Their ready-to-use format means that you can download and edit these tools whenever you need them to suit your specific IT and business needs.
BUY THIS DOCUMENT NOW PRICE: $49.95 100% MONEY BACK GUARANTEED
PARTNER Tuan Lam
Here at Info-Tech our goal, plain and simple, is to make IT leader's jobs a tad easier. We are able to do this in a variety of ways from our practical tools and templates to our research notes and customized consulting. All in all, we just want to be the first resource you think of when you need IT help. If you want to know more, check us out at wwww.infotech.com. Feel free to reach out to me personally at tlam@infotech.com if you're interested in partnering up with us or acquiring a membership of your own. Cheers! -Tuan