Budget Template

Document Sample
Budget Template Powered By Docstoc
					Headcount Summary - Budget 2010                                                                                                                             Budget              Dept Manager                          Dept Cost Center
D = Direct Hourly; I = Indirect Hourly; N = Salary Non-Exempt; E = Salary Exempt                                                                             Temp               xxxx                                      000000


  Budget 2009                2009 Headcount                                                              2010 Budget Headcount by Quarter

      2009          As per 6/30           31-Dec                                    31-Mar               30-Jun                 30-Sep                       31-Dec                     Avg 2010               2010
 D    I   N     E D    I   N E D           I   N E                           D    I     N     E     D     I    N     E     D    I    N      E       D        I    N     E         D      I    N       E        Sum
  0        0     6 0 4 0 5                   4    5 Employees                  0    4     0     8     0     4    0     8     0    4    0        9       0      4    0       9         0    4    0         9     13
  0     0  0     0 0 0 0 0                           Expatriates               0    0     0     0     0     0    1     0     0    0    1        0       0      0    0       0         0    0    1         0      1
  0     0  0     0 0 0 0 0                           Temporary (Contract)      0    0     0     0     0     0    0     0     0    0    0        0       0      0    0       0         0    0    0         0      0
  0    0   0    6   0 4 0 5 0 4 0 5                                   Total    0    4     0     8     0     4    1     8     0    4    1        9       0     4    0        9         0     4    1        9     13
  0    0   1    0   0 0 1 0                   1      Students                  0    0     1           0     0    1           0    0    1                0     0    1                             1               1
                  Changes in 2009 must be explained on form 2a.             Changes in 2011 quarters must be explained on form 2b.


                   Headcount Change Form - Forecast 2009                                                                                                                        Cost Center Number:           000000             BTE-a
                                                                                                                                                                                                                                      Receiving
                                                           Effective Dates          Annual                                                                                                                                 Transfer     Cost
                  Position                                BEG         END            Wage         Type        Req #            Remarks:                     Addition                      Reduction           Transfer      Name       Center
                                                                                                    E
                                                                                                    E
                                                                                                    E
                                                                                                    E
                                                                                                    E
                                                                                                    I
                                                                                                    I
                                                                                                    I
                                                                                                    I




                   Headcount Change Form - Budget 2009                                                                                                                          Cost Center Number:           000000             BTE-b
                                                                                                                                                                                                                                      Receiving
                                                           Effective Dates          Annual                                                                                                                                 Transfer     Cost
                  Position                                BEG         END            Wage         Type        Req #            Remarks:                     Addition                      Reduction           Transfer      Name       Center
                                                                                                    E
                                                                                                    E
                                                                                                    E
                                                                                                    E
                                                                                                    E
                                                                                                    E                                                       XX
                                                                                                    E                                                       XX
                                                                                                    E                                                       XX
                                                                                                    E                                                       XX
                                                                                                    I
                                                                                                    I
                                                                                                    I
                                                                                                    I
Budget 2010                                                  000000                           Dept Cost Center                            BTE           xxxx
Account No.                                                                      Factor       Budget 09   Actual 6/30   FC 12/31       Avg Budget 10
              FACTORS
              Heads:                     D                   Hourly Direct                                                                              Heads: according to BTE tab
   SAP        Heads:                     I                   Hourly Indirect                                  4            4                4           Heads: according to BTE tab
              Heads:                     N                   Salary Non-Exempt                                                                          Heads: according to BTE tab
              Heads:                     E                   Salary Exempt                       6            5            5                8.5         Heads: according to BTE tab

              Cost Types                                         Desc
   43000000   Direct Hourly - Base 40 hrs                    Avg Pay Rate                                                                          
				
DOCUMENT INFO
Description: This Budget Template provides a spreadsheet that can be used to create a budget for a given cost center. The spreadsheet allows the department to calculate staffing levels and then provides a detailed breakdown by cost type. The spreadsheet is intended to be used by businesses with SAP management software. This template spreadsheet can be modified to best fit the needs of any company or department manager seeking to create a budget for anticipated costs.
This document is also part of a package Getting Small Business Loans 4 Documents Included