0 0

Budget Template

ABOUT THIS DOCUMENT

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.

Reads: 2994 times
Used: 33 times
Pages: 24
Size: 435 kb
Format: Excel Spreadsheet

Text Version

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
Sign-up for Docstoc Premium
Registration enables you to experience on site recommendations of documents, articles, packages and courses as well as recommendation emails for the content we think you'll love the most
Already a member?
Don't have a Facebook account?
Register with E-mail

Enter a valid email address (xxx@xxx.com)
Preloader
By registering with docstoc.com you agree to
our privacy policy and terms of service
Sign-in
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Forgot Password?
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Don't have a Facebook account?
Login with your Docstoc account.


Email or Username

Preloader

1. Please rate your experience on the following scale:


2. Would you recommend Docstoc to a friend?


Submit

Would you be interested in taking a longer survey for a chance to win a 1-month free subscription to Docstoc Premium?