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                                                                              Rates per Payroll
   43020010   Indirect Hourly - Base 40 hrs                  Avg Pay Rate                                                                              Rates per Payroll
   43010000   Salary Non-Exempt - Base 40 hrs                Avg Pay Rate                                                      9,360            18,720 Rates per Payroll + Interns ($18,720)
   43100000   Salary - Base 40 hrs                           Avg Pay Rate                                                                              Rates per Payroll
   43001020   Cola - Direct                                  Avg Pay Rate                                                                              Per Payroll (only for Dayton)
   43010010   Cola - Indirect                                Avg Pay Rate                                                                              Per Payroll (only for Dayton)
   43100169   Cola - Salary Non-Exempt                       Avg Pay Rate                                                                              Per Payroll (only for Dayton)
   43100170   Cola - Salary Exempt                           Avg Pay Rate                                                                              Per Payroll (only for Dayton)
   43000060   Vacation, Holiday & Sick - Direct                                                                                                        For 2009 Budget and 2009 Forecast included in Direct Hourly rate
   43020030   Vacation, Holiday & Sick - Indirect                                                                                                      For 2009 Budget and 2009 Forecast included in Direct Hourly rate
   43010020   Vacation, Holiday & Sick - Salary Non-Exempt                                                                                             For 2009 Budget and 2009 Forecast included in Direct Hourly rate
   43100030   Vacation, Holiday & Sick - Salary Exempt                                                                                                 For 2009 Budget and 2009 Forecast included in Direct Hourly rate
   43000180   Other Earnings - Direct Labor                                                                                        0
   43020040   Other Earnings - Indirect Labor                                                                                      0
   43010030   Other Earnings - Salary Non-Exempt                                                                                   0
   43100190   Other Earnings - Salary Exempt                                              1                                        0                 1 Expats allowances (with no travels)
   43005030   Overtime - Direct                              OT %                                                                                      According to workload - based on history
   43020020   Overtime - Indirect                            OT %                                                                                      According to workload - based on history
   43100020   Overtime - Salary Non-Exempt                   OT %                                                                                      According to workload - based on history
   43000110   Gain Sharing                                   Benefit Rate                                                                              Only for Dayton % provided by HR
   43000200   Bonus wages                                    Benefit Rate                                                                              % provided by HR
   44000000   Benefits - Direct                              Benefit Rate                                                                              % provided by HR
   44000200   Benefits - Indirect                            Benefit Rate                                                                              % provided by HR
   44000100   Benefits - Salary Non-Exempt                   Benefit Rate        2.00                                          9,360            37,440 % provided by HR
   44100000   Benefits - Salary Exempt                       Benefit Rate                                                                              % provided by HR
   43005140   Short Work Week - Hourly                                                                                             0                   Only for Dayton (for budget 2008 included in wages)
   43005100   Workers Compensation                           Benefit Rate                                                                              % provided by HR (column for total of the location)
   44000040   Short Term Disability - Hourly                 Benefit Rate                                                                              STD & Inactive employee costs provided by HR
   44000050   Long Term Disability - Hourly                  Benefit Rate                                                                              LTD & Inactive employee costs provided by HR
   44100030   Short Term Disability - Salary                 Benefit Rate                                                                              STD & Inactive employee costs provided by HR
   44100040   Long Term Disability - Salary                  Benefit Rate                                                                              LTD & Inactive employee costs provided by HR
   42000380   Employee Safety Equipment                                                                                                                Tool Stores + external requisitions
   45100060   Employee Functions                                                                                                                       HR only - for company events
   45100210   Relocation & other employee costs                                    4,000                                                         4,000 Apartment cost for German Interns (HR only - relocation of employees)
                                                                                                                                                       HR for company wide programs; all CC's for specific trainings. Tuition assistance
   45100230 Employee Development & Training                                                                                                            only in HR
   45100200 Recruiting Costs                                                                                                                           HR only - outside recruiting + related advertising

   42000100 Technical Support-Co.                                                                                                                      People from others Co. companies coming to help to solve technical problems
   45100430 Personnel Support - Co.                          Avg Yearly Rate      62,101                                           0                 0 Expats Social Security from Co. of Germany (provided by Finance)
   45100410 Temporary Labor - Non-production                                                                                                           According to needs - salary & indirect
   45100420 Temporary Labor - Direct                                                                                                                   According to needs - direct labor production help only!
            Sub-Total Personnel                                                                      0             0        18,720              60,161
   45100920 Professional Fees                                                                                                                   40,000 Professional Fees including legal
   45100940 Dues & Subscriptions                                                                                                                       All CC's
   45200230 Advertising & Promotion                                                                                                                    PR advertising - must be approved by Communications

   45100000   Travel - Lodging, Air & Ground                                                                                                    39,125 All CC's from Travel Calculator (include German Interns and expats if applicable)
   45100070   Travel - Meals                                                                                                                     4,125 All CC's from Travel Calculator
   45100040   Entertainment Expenses                                                                                                               500 All CC's from Travel Calculator
   45200240   Business Gifts Low Value                                                                                                           1,200
   20001000   Charitable Contributions                                                                                                                 Only in General Mgmt dept
               Sub-Total Received Services                                               0               0       0       84,950
    45000040   External Maintenance-IT only                                                                                       Only for IT depts (hardware & software maintenance)
    42000300   Mainten. Exp. Material
    42000320   Expendable Tools & Equipment                                                                              29,000 All CC's: withdraw from Tool Stores + external req's
    42000340   Solvents                                                                                                         Only mfg CC's: withdraw from Tool Stores + external req's
    42000370   Chemicals & Compounds                                                                                            Only mfg CC's: withdraw from Tool Stores + external req's
                                                                                                                                All CC's to budget only Special Orders standard supplies by Facility CC's. PC's
    42000390 Office Supplies                                                                                              3,200 to be budgeted at plan level.
                                                                                                                                Starting 2009 budget these will be charged to each Cost Center (fill tab "Software
    45000260   Software Licenses                                                                                          2,766 Lic")
    42000400   Operating Supplies                                                                                        53,500 Only mfg CC's: withdraw from Tool Stores + external req's
    45000030   Company Vehicle Expenses                                                                                   3,300 Only General Mgmt, Production and Security CC's
    45000500   Waste Disposal & Environmental                                                                                   Where applicable
    45100610   Telecommunication Costs                                                                                    3,300 Cell phones in all CC's
    45100720   Special Testing                                                                                                  R&D tests
    42000610   Freight in Foreign                                                                                               Logistic cc only - Freight on prod material imported from foreign countries
    42000620   Expedite Freight in                                                                                              All cc - Premium freight
    42000650   Customs Fees                                                                                                     Logistic only - Customs & duty fees on imports
    45200000   Freight Interplant                                                                                               All cc - reallocation of freight to other plants
    45200040   Expedite Freight out                                                                                             All cc - Premium freight
    45200430   Freight Out                                                                                                7,500 All CC's - Fed Ex for non-inventory
    45200440   Freight out Foreign                                                                                              Logistic cc only - Freight on goods exported to foreign countries
    42000600   Freight In                                                                                                       All CC's - non-inventory - freight
               Sub-Total Operating Expenses                                              0               0       0      102,566
    42000500   Utilities                                                                                                        Only for Facilities dept and wind tunnel in Troy
    42000520   Utilities - Natural Gas                                                                                          Only for Facilities dept
    42000530   Utilities - Water                                                                                                Only for Facilities dept
    45000010   Facility Maintenance                                                                                             Service contracts (lawn) + build maint + other external services
    45000020   Machinery & Equip Maintenance                                                                             17,300 Only mfg CC's: Order from Tool Stores + external req's
    45000190   Equipment Lease/Rental                                                                                           Company forklifts only in Logistics; rest by CC
    45000200   Data Processing Leases                                                                                           Only for IT depts (equipment)
    45000170   Building Rent & Storage                                                                                          Only for Facilities dept that is responsible for building space
               Sub-Total Machinery & Equipment                                           0               0       0       17,300
    40000453   Production Scrap                                                                                                 Only Production Cost Centers
                                                                                                                                Only Production and Type Specific Tooling CC's Tooling repairs and Purchases
    42001000   Tooling Expenses                                                                                                 no reimbursed and not capitalized
    42000630   Packaging Expenses                                                                                               Only Production Cost Centers packaging not included in BoM
    47100000   Depreciation                                                                                      0
    45000820   Insurance, Business                                                                                                Only in Controlling
    45000800   Insurance, Property                                                                                                Only in Facilities
    20000112   Bad Debt Expense                                                                                                   Should be budgeted in Cumulative Cost Center in Form B-31
    46000020   Taxes Property                                                                                                     Only in Facilities
Total Direct Costs                                                                       0               0   18,720     264,977


                                                 !! EXPLAIN IN NEXT SECTION WHY YOUR BUDGET IS HIGHER THAN TARGET !!
Explanation for 2010 budget higher than target
Account                                              Description                                                      Amount




For Cost Centers Reporting IPS Hours Only:
Resource Calculation
Total headcount for 2008:                                          13 people   (Including contractors)
thereof: number of heads not reporting                                people
              Persons reporting hours in 2008                      13 people
Expected activity volume per person for 2008    1,856 hours   Standard to be used
Planned activity volume for Cost Center        24,128 hours
 0.02 Merit %
1.015 Annualized
Travel Calculator - 2010 Travel Expenses                                   000000 Dept Cost Center                                                 BT1
                                                      No.
                                Trips /              Nites     Cost per
Project / Location               Year     Mileage   per Trip    Flight         Air           Car     Lodging         Meals     Entertainment           Total

xxxx
N. America                        9          0         2       $     750   $     6,750   $     900   $   1,800   $       900   $               -   $    10,350 Mexico 4
USA by Car (mileage)                                           $       -   $         -   $       -   $       -   $         -   $               -   $         -
USA by Car (rental car)                                        $       -   $         -   $       -   $       -   $         -   $               -   $         -
S. America                                                     $   1,500   $         -   $       -   $       -   $         -   $               -   $         -
Europe                            2          0         5       $   1,000   $     2,000   $     500   $   1,000   $       500   $               -   $     4,000
Asia                                                           $   2,500   $         -   $       -   $       -   $         -   $               -   $         -
Africa                                                         $   2,500   $         -   $       -   $       -   $         -   $               -   $         -
Australia                                                      $   2,500   $         -   $       -   $       -   $         -   $               -   $         -
Totals                            11         0         7                   $     8,750   $   1,400   $   2,800   $     1,400   $               -   $    14,350


xxxx
N. America                        8                   1.5      $     750   $     6,000   $     600   $   1,200   $      600    $               -   $     8,400 Mexico 7
USA by Car (mileage)                                           $       -   $         -   $       -   $       -   $        -    $               -   $         -
USA by Car (rental car)                                        $       -   $         -   $       -   $       -   $        -    $               -   $         -
S. America                                                     $   1,500   $         -   $       -   $       -   $        -    $               -   $         -
Europe                                                         $   1,000   $         -   $       -   $       -   $        -    $               -   $         -
Asia                                                           $   2,500   $         -   $       -   $       -   $        -    $               -   $         -
Africa                                                         $   2,500   $         -   $       -   $       -   $        -    $               -   $         -
Australia                                                      $   2,500   $         -   $       -   $       -   $        -    $               -   $         -
Totals                            8          0        1.5                  $     6,000   $     600   $   1,200   $      600    $               -   $     8,400


xxxx
N. America                        2                    3       $     750   $     1,500   $     300   $    600    $      300    $               -   $     2,700
USA by Car (mileage)                                           $       -   $         -   $       -   $      -    $        -    $               -   $         -
USA by Car (rental car)                                        $       -   $         -   $       -   $      -    $        -    $               -   $         -
S. America                                                     $   1,500   $         -   $       -   $      -    $        -    $               -   $         -
Europe                                                         $   1,000   $         -   $       -   $      -    $        -    $               -   $         -
Asia                                                           $   2,500   $         -   $       -   $      -    $        -    $               -   $         -
Africa                                                         $   2,500   $         -   $       -   $      -    $        -    $               -   $         -
Australia                                                      $   2,500   $         -   $       -   $      -    $        -    $               -   $         -
Totals                            2          0         3                   $     1,500   $     300   $    600    $      300    $               -   $     2,700


xxxx
N. America                        5                   1.5      $     750   $     3,750   $     375   $    750    $      375    $               -   $     5,250 Mexico 4
USA by Car (mileage)                                           $       -   $         -   $       -   $      -    $        -    $               -   $         -
USA by Car (rental car)                                        $       -   $         -   $       -   $      -    $        -    $               -   $         -
S. America                                                     $   1,500   $         -   $       -   $      -    $        -    $               -   $         -
Europe                                                         $   1,000   $         -   $       -   $      -    $        -    $               -   $         -
Asia                                                           $   2,500   $         -   $       -   $      -    $        -    $               -   $         -
Africa                                                         $   2,500   $         -   $       -   $      -    $        -    $               -   $         -
Australia                                                      $   2,500   $         -   $       -   $      -    $        -    $               -   $         -
Totals                            5          0        1.5                  $     3,750   $     375   $    750    $      375    $               -   $     5,250

New Quality Engineer
N. America                        2                   3.5      $     750   $     1,500   $     350   $    700    $      350    $               -   $     2,900
USA by Car (mileage)                                           $       -   $         -   $       -   $      -    $        -    $               -   $         -
USA by Car (rental car)                                        $       -   $         -   $       -   $      -    $        -    $               -   $         -
S. America                                                     $   1,500   $         -   $       -   $      -    $        -    $               -   $         -
Europe                                                         $   1,000   $         -   $       -   $      -    $        -    $               -   $         -
Asia                                                           $   2,500   $         -   $       -   $      -    $        -    $               -   $         -
Africa                                                         $   2,500   $         -   $       -   $      -    $        -    $               -   $         -
Australia                                                      $   2,500   $         -   $       -   $      -    $        -    $               -   $         -
Totals                            2          0        3.5                  $     1,500   $     350   $    700    $      350    $               -   $     2,900

New Customer Service Engineer
N. America                        4                   2.5      $     750   $     3,000   $     500   $   1,000   $      500    $               -   $     5,000 Mexico 2
USA by Car (mileage)                                           $       -   $         -   $       -   $       -   $        -    $               -   $         -
USA by Car (rental car)                                        $       -   $         -   $       -   $       -   $        -    $               -   $         -
S. America                                                     $   1,500   $         -   $       -   $       -   $        -    $               -   $         -
Europe                                                         $   1,000   $         -   $       -   $       -   $        -    $               -   $         -
Asia                                                           $   2,500   $         -   $       -   $       -   $        -    $               -   $         -
Africa                                                         $   2,500   $         -   $       -   $       -   $        -    $               -   $         -
Australia                                                      $   2,500   $         -   $       -   $       -   $        -    $               -   $         -
Totals                            4          0        2.5                  $     3,000   $     500   $   1,000   $      500    $               -   $     5,000

xxx
N. America                        3                    4       $     750   $     2,250   $     600   $   1,200   $      600    $               -   $     4,650 Mexico 1
USA by Car (mileage)                                           $       -   $         -   $       -   $       -   $        -    $               -   $         -
USA by Car (rental car)                                        $       -   $         -   $       -   $       -   $        -    $               -   $         -
S. America                                                     $   1,500   $         -   $       -   $       -   $        -    $               -   $         -
Europe                                                         $   1,000   $         -   $       -   $       -   $        -    $               -   $         -
Asia                                                           $   2,500   $         -   $       -   $       -   $        -    $               -   $         -
Africa                                                         $   2,500   $         -   $       -   $       -   $        -    $               -   $         -
Australia                                                      $   2,500   $         -   $       -   $       -   $        -    $               -   $         -
Totals                            3          0         4                   $     2,250   $     600   $   1,200   $      600    $               -   $     4,650

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -
Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $     750   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $       -   $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $       -   $   -   $   -   $   -   $   -   $   -   $   -
S. America                            $   1,500   $   -   $   -   $   -   $   -   $   -   $   -
Europe                                $   1,000   $   -   $   -   $   -   $   -   $   -   $   -
Asia                                  $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Africa                                $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Australia                             $   2,500   $   -   $   -   $   -   $   -   $   -   $   -
Totals                    0   0   0               $   -   $   -   $   -   $   -   $   -   $   -

Employee Name
N. America                            $    750    $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (mileage)                  $      -    $   -   $   -   $   -   $   -   $   -   $   -
USA by Car (rental car)               $      -    $   -   $   -   $   -   $   -   $   -   $   -
S. America                                     $   1,500   $        -   $       -   $       -   $       -   $   -   $        -
Europe                                         $   1,000   $        -   $       -   $       -   $       -   $   -   $        -
Asia                                           $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Africa                                         $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Australia                                      $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Totals                           0    0   0                $        -   $       -   $       -   $       -   $   -   $        -

Employee Name
N. America                                     $     750   $        -   $       -   $       -   $       -   $   -   $        -
USA by Car (mileage)                           $       -   $        -   $       -   $       -   $       -   $   -   $        -
USA by Car (rental car)                        $       -   $        -   $       -   $       -   $       -   $   -   $        -
S. America                                     $   1,500   $        -   $       -   $       -   $       -   $   -   $        -
Europe                                         $   1,000   $        -   $       -   $       -   $       -   $   -   $        -
Asia                                           $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Africa                                         $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Australia                                      $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Totals                           0    0   0                $        -   $       -   $       -   $       -   $   -   $        -

Employee Name
N. America                                     $     750   $        -   $       -   $       -   $       -   $   -   $        -
USA by Car (mileage)                           $       -   $        -   $       -   $       -   $       -   $   -   $        -
USA by Car (rental car)                        $       -   $        -   $       -   $       -   $       -   $   -   $        -
S. America                                     $   1,500   $        -   $       -   $       -   $       -   $   -   $        -
Europe                                         $   1,000   $        -   $       -   $       -   $       -   $   -   $        -
Asia                                           $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Africa                                         $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Australia                                      $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Totals                           0    0   0                $        -   $       -   $       -   $       -   $   -   $        -

Employee Name
N. America                                     $     750   $        -   $       -   $       -   $       -   $   -   $        -
USA by Car (mileage)                           $       -   $        -   $       -   $       -   $       -   $   -   $        -
USA by Car (rental car)                        $       -   $        -   $       -   $       -   $       -   $   -   $        -
S. America                                     $   1,500   $        -   $       -   $       -   $       -   $   -   $        -
Europe                                         $   1,000   $        -   $       -   $       -   $       -   $   -   $        -
Asia                                           $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Africa                                         $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Australia                                      $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Totals                           0    0   0                $        -   $       -   $       -   $       -   $   -   $        -

Employee Name
N. America                                     $     750   $        -   $       -   $       -   $       -   $   -   $        -
USA by Car (mileage)                           $       -   $        -   $       -   $       -   $       -   $   -   $        -
USA by Car (rental car)                        $       -   $        -   $       -   $       -   $       -   $   -   $        -
S. America                                     $   1,500   $        -   $       -   $       -   $       -   $   -   $        -
Europe                                         $   1,000   $        -   $       -   $       -   $       -   $   -   $        -
Asia                                           $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Africa                                         $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Australia                                      $   2,500   $        -   $       -   $       -   $       -   $   -   $        -
Totals                           0    0   0                $        -   $       -   $       -   $       -   $   -   $        -


Department Totals                35   0   23       0       $   26,750   $   4,125   $   8,250   $   4,125   $   -   $   43,250
Notes:
1) $100 night lodging, $50/day
meals, $50/day rental car.
N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500
N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500
N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750
S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500




N. America    750


S. America   1500
Europe       1500
Asia         2500
Africa       2500
Australia    2500
Employee Training & Development Schedule                                     BT2
                                                              000000
                                                              Dept Cost Center


                                                               Estimated
Employee Name                      Type of Session               Cost       # of days
XXX                                AIAG, Technical Training          900                2

XXXX                               AIAG Technical Training           900                2

XXXX                               AIAG Technical Training           900                2

XXX                                AIAG Technical Training           900                2

XXX                                AIAG Technical Training           900                2

New Quality Engineer               AIAG Technical Training           900                2

New Customer Service Eng.          AIAG Technical Training           900                2




                                   Total                      $    6,300




09f9f2eb-3488-4508-88fb-060a0ec049cd.xls                                                    4/10/2013
Type of Session choices:          Internal class
                                  Seminar - local
                                  Seminar - out of town
                                  Conference - local
                                  Conference - out of town

Estimated costs:                  Soft skills training         $250
                                  Computer software            $150
                                  Technical training           $900
                                  Seminar/conf (2-3 days)    $1,500


NOTE: Estimated costs do NOT include travel.




09f9f2eb-3488-4508-88fb-060a0ec049cd.xls                              4/10/2013
Software Licenses Costs to be charged to each Cost Center                                                      BT3
                                                                                            000000
                                                                                            Dept Cost Center

BA Software Types       Costs     Costs      No. of         Total
                        Euros     USD        Users          Costs
SAP Overseas                165    219.45             4       877.80
SCIO Plato                  360     478.8             2       957.60
EDM User                     25     33.25                        0.00
EDM User Author              80     106.4             4       425.60
ProE Lic                    240     319.2                        0.00
Catia Lic                   240     319.2                        0.00
IPS User                     18     23.94                        0.00
Outlook 150MB                10       13.3        14          186.20
Internet                     10       13.3        14          186.20
External Access              50       66.5         2          133.00
                                                          $   2,766 Amount to be charged to this Cost Center




USD-EUR exchange rate      1.33
CoCode    Cost Ctr CE                   1         2         3         4         5         6         7         8         9        10        11        12
                      # of Month        1         1         1         1         1         1         1         1         1         1         1         1     12
        Hourly Direct Headcount         0         0         0         0         0         0         0         0         0         0         0         0      0
      Hourly Indirect Headcount         4         4         4         4         4         4         4         4         4         4         4         4     48
 Salary Non-Exempt Headcount            0         0         0         1         1         1         1         1         1         0         0         0      6
     Salary Exempt Headcount            8         8         8         8         8         8         9         9         9         9         9         9    102

          000000
missing CC in first tab 43000000         0         0         0         0         0         0         0         0         0         0         0         0         Direct Hourly - Base 40 hrs
          000000
missing CC in first tab 43020010         0         0         0         0         0         0         0         0         0         0         0         0         Indirect Hourly - Base 40 hrs
          000000
missing CC in first tab 43010000         0         0         0      3120      3120      3120      3120      3120      3120         0         0         0         Salary Non-Exempt - Base 40 hrs
          000000
missing CC in first tab 43100000         0         0         0         0         0         0         0         0         0         0         0         0         Salary - Base 40 hrs
          000000
missing CC in first tab 43001020         0         0         0         0         0         0         0         0         0         0         0         0         Cola - Direct
          000000
missing CC in first tab 43010010         0         0         0         0         0         0         0         0         0         0         0         0         Cola - Indirect
          000000
missing CC in first tab 43100169         0         0         0         0         0         0         0         0         0         0         0         0         Cola - Salary Non-Exempt
          000000
missing CC in first tab 43100170         0         0         0         0         0         0         0         0         0         0         0         0         Cola - Salary Exempt
          000000
missing CC in first tab43000180          0         0         0         0         0         0         0         0         0         0         0         0         Other Earnings - Direct Labor
          000000
missing CC in first tab 43020040         0         0         0         0         0         0         0         0         0         0         0         0         Other Earnings - Indirect Labor
          000000
missing CC in first tab 43010030         0         0         0         0         0         0         0         0         0         0         0         0         Other Earnings - Salary Non-Exempt
          000000
missing CC in first tab 43100190      0.08      0.08      0.08      0.08      0.08      0.08      0.09      0.09      0.09      0.09      0.09      0.09         Other Earnings - Salary Exempt
          000000
missing CC in first tab 43005030         0         0         0         0         0         0         0         0         0         0         0         0         Overtime - Direct
          000000
missing CC in first tab 43020020         0         0         0         0         0         0         0         0         0         0         0         0         Overtime - Indirect
          000000
missing CC in first tab 43100020         0         0         0         0         0         0         0         0         0         0         0         0         Overtime - Salary Non-Exempt
          000000
missing CC in first tab 43000110         0         0         0         0         0         0         0         0         0         0         0         0         Gain Sharing
          000000
missing CC in first tab 43000200         0         0         0         0         0         0         0         0         0         0         0         0         Bonus wages
          000000
missing CC in first tab 44000000         0         0         0         0         0         0         0         0         0         0         0         0         Benefits - Direct
          000000
missing CC in first tab 44000200         0         0         0         0         0         0         0         0         0         0         0         0         Benefits - Indirect
          000000
missing CC in first tab 44000100         0         0         0      6240      6240      6240      6240      6240      6240         0         0         0         Benefits - Salary Non-Exempt
          000000
missing CC in first tab 44100000         0         0         0         0         0         0         0         0         0         0         0         0         Benefits - Salary Exempt
          000000
missing CC in first tab43005100          0         0         0         0         0         0         0         0         0         0         0         0         Workers Compensation
          000000
missing CC in first tab44000040          0         0         0         0         0         0         0         0         0         0         0         0         Short Term Disability - Hourly
          000000
missing CC in first tab44000050          0         0         0         0         0         0         0         0         0         0         0         0         Long Term Disability - Hourly
          000000
missing CC in first tab44100030          0         0         0         0         0         0         0         0         0         0         0         0         Short Term Disability - Salary
          000000
missing CC in first tab44100040          0         0         0         0         0         0         0         0         0         0         0         0         Long Term Disability - Salary
          000000
missing CC in first tab42000380          0         0         0         0         0         0         0         0         0         0         0         0         Employee Safety Equipment
          000000
missing CC in first tab45100060          0         0         0         0         0         0         0         0         0         0         0         0         Employee Functions
          000000
missing CC in first tab45100210     333.33    333.33    333.33    333.33    333.33    333.33    333.33    333.33    333.33    333.33    333.33    333.37         Relocation & other employee costs
          000000
missing CC in first tab45100230          0         0         0         0         0         0         0         0         0         0         0         0         Employee Development & Training
          000000
missing CC in first tab45100200          0         0         0         0         0         0         0         0         0         0         0         0         Recruiting Costs
          000000
missing CC in first tab42000100          0         0         0         0         0         0         0         0         0         0         0         0         Technical Support-Co.
          000000
missing CC in first tab45100430          0         0         0         0         0         0         0         0         0         0         0         0         Personnel Support - Co.
          000000
missing CC in first tab45100410          0         0         0         0         0         0         0         0         0         0         0         0         Temporary Labor - Non-production
          000000
missing CC in first tab45100420          0         0         0         0         0         0         0         0         0         0         0         0         Temporary Labor - Direct
          000000
missing CC in first tab45100920    3333.33   3333.33   3333.33   3333.33   3333.33   3333.33   3333.33   3333.33   3333.33   3333.33   3333.33   3333.37         Professional Fees
          000000
missing CC in first tab45100940          0         0         0         0         0         0         0         0         0         0         0         0         Dues & Subscriptions
          000000
missing CC in first tab45200230          0         0         0         0         0         0         0         0         0         0         0         0         Advertising & Promotion
          000000
missing CC in first tab45100000    3260.42   3260.42   3260.42   3260.42   3260.42   3260.42   3260.42   3260.42   3260.42   3260.42   3260.42   3260.38         Travel - Lodging, Air & Ground
          000000
missing CC in first tab45100070     343.75    343.75    343.75    343.75    343.75    343.75    343.75    343.75    343.75    343.75    343.75    343.75         Travel - Meals
          000000
missing CC in first tab45100040      41.67     41.67     41.67     41.67     41.67     41.67     41.67     41.67     41.67     41.67     41.67     41.63         Entertainment Expenses
          000000
missing CC in first tab45200240        100       100       100       100       100       100       100       100       100       100       100       100         Business Gifts Low Value
          000000
missing CC in first tab20001000          0         0         0         0         0         0         0         0         0         0         0         0         Charitable Contributions
          000000
missing CC in first tab45000040          0         0         0         0         0         0         0         0         0         0         0         0         External Maintenance-IT only
          000000
missing CC in first tab42000300          0         0         0         0         0         0         0         0         0         0         0         0         Mainten. Exp. Material
          000000
missing CC in first tab42000320    2416.67   2416.67   2416.67   2416.67   2416.67   2416.67   2416.67   2416.67   2416.67   2416.67   2416.67   2416.63         Expendable Tools & Equipment
          000000
missing CC in first tab42000340          0         0         0         0         0         0         0         0         0         0         0         0         Solvents
          000000
missing CC in first tab42000370         0         0         0         0         0         0         0         0         0         0         0       0           Chemicals & Compounds
          000000
missing CC in first tab42000390    266.67    266.67    266.67    266.67    266.67    266.67    266.67    266.67    266.67    266.67    266.67  266.63           Office Supplies
          000000
missing CC in first tab45000260    230.53    230.53    230.53    230.53    230.53    230.53    230.53    230.53    230.53    230.53    230.53  230.57           Software Licenses
          000000
missing CC in first tab42000400   4458.33   4458.33   4458.33   4458.33   4458.33   4458.33   4458.33   4458.33   4458.33   4458.33   4458.33 4458.37           Operating Supplies
          000000
missing CC in first tab45000030       275       275       275       275       275       275       275       275       275       275       275     275           Company Vehicle Expenses
          000000
missing CC in first tab45000500         0         0         0         0         0         0         0         0         0         0         0       0           Waste Disposal & Environmental
          000000
missing CC in first tab45100610       275       275       275       275       275       275       275       275       275       275       275     275           Telecommunication Costs
          000000
missing CC in first tab45100720         0         0         0         0         0         0         0         0         0         0         0       0           Special Testing
          000000
missing CC in first tab42000610         0         0         0         0         0         0         0         0         0         0         0       0           Freight in Foreign
          000000
missing CC in first tab42000620         0         0         0         0         0         0         0         0         0         0         0       0           Expedite Freight in
          000000
missing CC in first tab42000650         0         0         0         0         0         0         0         0         0         0         0       0           Customs Fees
          000000
missing CC in first tab45200000         0         0         0         0         0         0         0         0         0         0         0       0           Freight Interplant
          000000
missing CC in first tab45200040         0         0         0         0         0         0         0         0         0         0         0       0           Expedite Freight out
          000000
missing CC in first tab45200430       625       625       625       625       625       625       625       625       625       625       625     625           Freight Out
          000000
missing CC in first tab45200440       625       625       625       625       625       625       625       625       625       625       625     625           Freight out Foreign
          000000
missing CC in first tab42000600         0         0         0         0         0         0         0         0         0         0         0       0           Freight In
          000000
missing CC in first tab42000500         0         0         0         0         0         0         0         0         0         0         0       0           Utilities
          000000
missing CC in first tab42000520         0         0         0         0         0         0         0         0         0         0         0       0           Utilities - Natural Gas
          000000
missing CC in first tab42000530         0         0         0         0         0         0         0         0         0         0         0       0           Utilities - Water
          000000
missing CC in first tab45000010         0         0         0         0         0         0         0         0         0         0         0       0           Facility Maintenance
          000000
missing CC in first tab45000020   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67 1441.63           Machinery & Equip Maintenance
          000000
missing CC in first tab45000190         0         0         0         0         0         0         0         0         0         0         0       0           Equipment Lease/Rental
          000000
missing CC in first tab45000200         0         0         0         0         0         0         0         0         0         0         0       0           Data Processing Leases
          000000
missing CC in first tab45000170         0         0         0         0         0         0         0         0         0         0         0       0           Building Rent & Storage
          000000
missing CC in first tab40000453   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67   1441.67 1441.63           Production Scrap
          000000
missing CC in first tab42001000         0         0         0         0         0         0         0         0         0         0         0       0           Tooling Expenses
          000000
missing CC in first tab42000630         0         0         0         0         0         0         0         0         0         0         0       0           Packaging Expenses
          000000
missing CC in first tab47100000         0         0         0         0         0         0         0         0         0         0         0       0           Depreciation
          000000
missing CC in first tab45000820         0         0         0         0         0         0         0         0         0         0         0       0           Insurance, Business
          000000
missing CC in first tab45000800         0         0         0         0         0         0         0         0         0         0         0       0           Insurance, Property
          000000
missing CC in first tab46000020         0         0         0         0         0         0         0         0         0         0         0       0           Taxes Property
                                                                                                                                         CHECK TOTAL 289777.4
se 40 hrs




Non-Exempt




oyee costs
& Training



production
nmental




enance
				
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