budget templates 2011 2012

63
www.teamglobal.in Budget 2011- 12 BUDGET – 2011-12 BRANCH – DATE –

Upload: teamglobalcorporate

Post on 29-May-2015

960 views

Category:

Business


0 download

TRANSCRIPT

Page 1: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

BUDGET – 2011-12

BRANCH –

DATE –

Page 2: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

BRANCH DETAILS

Address:

Date of Inception:

Staff Strength as of 01/04/2010 v/s28/02/2011: (as per the attached grade

chart)

1

Page 3: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

STAFF STRENGTH

Grade Designation Strength as on

1/4/11Strength as on

28/2/12

M3 General Manager    

M4 Dy. General Manager    

M5 Asst. General Manager    

M6 Sr. Manager    

M7 Manager    

M8 Dy. Manager    

M9 Asst. Manager    

E1 Sr. Executive    

E2 Executive    

E3 Jr. Executive    

S1 Officer    

S2 Supervisor    

S3 Assistant    

V Voucher Staff    

Total    

2

Page 4: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

ANNUAL EMPLOYEE TURNOVER

Sr. No

Opening Balance

No. Of Employees Joined

No . Of Employees Left

Closing Balance Attrition Rate

         

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

3

Page 5: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

PRODUCT WISE PRESENCE

• TEAM E-Console Express - Y □ / N □ • TEAM I-Console Express - Y □ / N □ • TEAM FCL Express - Y □ / N □ • TEAM Africa Express - Y □ / N □ • TEAM Project Express - Y □ / N □ • TEAM AIR Express- Y □ / N □

4

Page 6: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM E CONSOLE EXPRESS – MARKET SIZE

Sr. No. Name of the Player Volume in CBM

%age Of Total Volume

       

       

       

       

       

       

       

       

       

       

       

       

Source of Data: Note: Please take average monthly volume fm

Apr’11 to Jan’125

Page 7: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM E CONSOLE EXPRESS – TARGETED MARKET SHARE

We at TEAM GLOBAL _______ Branch wantto have ____ % in the local market forYear 11-12. The volume equivalent of thesame is _____ TEU/CBM per Month

6

Page 8: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM E CONSOLE EXPRESS – TARGETED MARKET SHARE

TRADE LANE WISE/VOLUME DISTRIBUTION

Sr #

Sector / Port

Volume and Revenue Quarter-wise

Q 1 (Apr-Jun ‘11)

Q 2 (Jul-Sep ‘11)

Q 3 (Oct-Dec ‘11)

Q 4 (Jan-Mar '12)

Teus

CBM

Rev

($)

Teus

CBM

Rev

($)

Teus

CBM

Rev

($)

Teus

CBM

Rev ($)

1 - Free Hand

                       

- Routed                        

2 - Free Hand

                       

- Routed                        

3 - Free Hand

                       

- Routed                        

4 - Free Hand

                       

- Routed                        

5 - Free Hand

                       

- Routed                        

6 - Free Hand

                       

- Routed                        

Total Free Hand

Total Routed

Grand Total

Actual 2010-2011

% increase in Actual V/s Budgeted

7

Page 9: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM E CONSOLE EXPRESS – TARGETED MARKET SHARE

TRADE LANE 1 – CUSTOMER WISE / VOLUME DISTRIBUTION PER MONTH

Sr . #Customer Name

Monthly Volume

Budgeted Share

Actual Avg Per Month Support in 10-11

Strategy to Bridge Gaps/Gain Support

           

           

           

           

           

           

           

           

           

Note: •Separate Slide should be presented per trade lane.•Potential Customers currently not supporting TGL should be highlighted in Blue color.

8

Page 10: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM E CONSOLE EXPRESS – TARGETED MARKET SHARE

MARKETING PERSON WISE / VOLUME DISTRIBUTION PER CBM

Sr. No

Marketing

person

Budget for the month (CBM)

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

                          

                          

                          

                          

                          

                          

                          

                          

                          

  Grand Total

                      

9

Page 11: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

ParticularsQty/Amt In

INRBudgeted

Costs Advantages accruing from cost

Manpower:      

Sales      

CS      

Operations      

Finance      

Grand Total      

Branding:      

Advertising      

Trade Fairs      

Exhibition      

Events Sponsorship      

Grand Total      

Travel:      

Domestic      

International      

Grand Total      

TEAM E CONSOLE EXPRESS – RESOURCE REQUIREMENT

10

Page 12: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued… Qty/Amt in INR Budgeted Costs Advantages accruing from cost

Corporate Inputs:      

Sales Support      

Finance Support      

Reviews      

Overseas Sales Lead Management      

Grand Total      

Capital Expenditure:      

Computer      

Mobile Phone      

Other Capital Items      

Grand Total      

11

Page 13: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM E FCL EXPRESS – MARKET SIZE

Sr. No. Name of the Player Volume in Teus

%age Of Total Volume

       

       

       

       

       

       

       

       

       

       

       

       

Source Of Data:

Note : Please indicate FCL volume controlled by NVOCC’s. Please take avg monthly volume fm Apr’11 to Jan’12

12

Page 14: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

We at TEAM GLOBAL _______ Branch wantto have ____ % in the local market forYear 11-12. The volume equivalent of thesame is _____ TEU/CBM per Month

TEAM E FCL EXPRESS – TARGETED MARKET SHARE

13

Page 15: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM E FCL EXPRESS – TARGETED MARKET SHARE

TRADE LANE WISE/VOLUME DISTRIBUTION

Sr # Tradelane

Volume and Revenue Quarter wise

Q 1 (Apr-Jun ‘11)

Q 2 (Jul-Sep ‘11)

Q 3 (Oct-Dec ‘11)

Q 4 (Jan-Mar '12)

Teus Rev ($)

Teus Rev ($)

Teus Rev ($)

Teus Rev ($)

1 USA/ CANADA                

2 EUROPE & UK                

3 MED- EAST & WEST                

4 CIS                

5 GULF & RED SEA                

6 F. EAST AND ANZ                

7EAST & SOUTH AFRICA                

8 ISC                

9CENT. & SOUTH. AMERICA                

10 MCC                

 Total                

Actual 2010-11                

% increase in Actual V/s Budgeted                

14

Page 16: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM E FCL EXPRESS – TARGETED MARKET SHARETRADE LANE 1 – CUSTOMER WISE / VOLUME DISTRIBUTION PER

MONTH

Sr . #Customer Name

Monthly Volume

Budgeted Share

Actual Avg Per Month Support in 10-11

Strategy to Bridge Gaps/Gain Support

           

           

           

           

           

           

           

           

           

Note: •Separate Slide should be presented per trade lane.•Potential Customers currently not supporting TGL should be highlighted in Blue color.

15

Page 17: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM E FCL EXPRESS – (EXPORT) TARGETED MARKET SHAREMARKETING PERSON WISE / VOLUME DISTRIBUTION PER MONTH

Sr. No

Marketing

person

Budget for the month (TEUS)

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

                           

                           

                           

                           

                           

                           

                           

                           

                           

  Grand Total

                      

16

Page 18: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM E FCL EXPRESS – (EXPORT) RESOURCE REQUIREMENT

ParticularsQty/ Amt In

INRBudgeted

Costs Advantages accruing from cost

Manpower:      

Sales      

CS      

Operations      

Finance      

Grand Total      

Branding:      

Advertising      

Trade Fairs      

Exhibition      

Events Sponsorship      

Grand Total      

Travel:      

Domestic      

International      

Grand Total      

17

Page 19: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…Qty/Amt in

INR Budgeted Costs Advantages accruing from cost

Corporate Inputs:      

Sales Support      

Finance Support      

Reviews      

Overseas Sales Lead Management      

Grand Total      

Capital Expenditure:      

Computer      

Mobile Phone      

Other Capital Items      

Grand Total      

18

Page 20: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Sr. No. Name of the Player Volume in CBM

%age Of Total Volume

       

       

       

       

       

       

       

       

       

       

       

       

Note: Please take average monthly volume fm Apr’11 to Jan’12

Source of Data:

TEAM I CONSOLE EXPRESS – MARKET SIZE

19

Page 21: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

We at TEAM GLOBAL _______ Branch wantto have ____ % in the local market forYear 11-12. The volume equivalent of thesame is _____ TEU/CBM per month

TEAM I CONSOLE EXPRESS – TARGETED MARKET SHARE

20

Page 22: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM I CONSOLE EXPRESS – TARGETED MARKET SHARE

Trade lane

Volume and Revenue Quarter-wise

Q 1 (Apr-Jun ’11) Q 2 (Jul-Sep ‘11) Q 3 (Oct-Dec ‘11) Q 4 (Jan-Mar '12)

Teu CBM

HBL

Rev ($)

Teu CBM

HBL Rev

($)

Teu

CBM HBL

Rev

($)

Teu CBM

HBL

Rev

($)

- Free

Hand

                               

- Route

d

                               

- Free

Hand

- Route

d

- Free

Hand

- Route

d

- Free

Hand

- Route

d

Total Free Hand

                               

Total Routed

                               

Grand Total                                

Actual 2010-11

                               

% increase in Actual V/s

Budgeted

                               

21

Page 23: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM I CONSOLE EXPRESS – TARGETED MARKET SHARETRADE LANE 1 – CUSTOMER WISE / VOLUME DISTRIBUTION PER

MONTH

Note: •Separate Slide should be presented per trade lane.•Potential Customers currently not supporting TGL should be highlighted in Blue color.

Sr . #Customer Name

Monthly Volume

Budgeted Share

Actual Avg Per Month Support in 10-11

Strategy to Bridge Gaps/Gain Support

           

           

           

           

           

           

           

           

           

22

Page 24: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM I CONSOLE EXPRESS – TARGETED MARKET SHARE

Sr. No

Marketing

person

Budget for the month (CBM)

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

                          

                          

                          

                          

                          

                          

                          

                          

                          

  Grand Total

 

                     

MARKETING PERSON WISE / VOLUME DISTRIBUTION PER MONTH

23

Page 25: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

ParticularsQty/Amt in

INRBudgeted

Costs Advantages accruing from cost

Manpower:      

Sales      

CS      

Operations      

Finance      

Grand Total      

Branding:      

Advertising      

Trade Fairs      

Exhibition      

Events Sponsorship      

Grand Total      

Travel:      

Domestic      

International      

Grand Total      

TEAM I CONSOLE EXPRESS – RESOURCE REQUIREMENT

24

Page 26: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…Qty /Amt in

INR Budgeted Costs Advantages accruing from cost

Corporate Inputs:      

Sales Support      

Finance Support      

Reviews      

Overseas Sales Lead Management      

Grand Total      

Capital Expenditure:      

Computer      

Mobile Phone      

Other Capital Items      

Grand Total      

25

Page 27: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Sr. No. Name of the Player Volume in Teus

%age Of Total Volume

       

       

       

       

       

       

       

       

       

       

       

       

TEAM I FCL EXPRESS – MARKET SIZE

Note : Pls indicate FCL volume controlled by NVOCC’s. Pls take avg monthly vol fm Apr’11 to Jan’12.

Source Of Data:

26

Page 28: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM I FCL EXPRESS – TARGETED MARKET SHARE

We at TEAM GLOBAL _______ Branch wantto have ____ % in the local market forYear 11-12. The volume equivalent of thesame is _____ TEU/CBM per Month

27

Page 29: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Sr #

Trade lane

Volume and Revenue Quarter wise

Q 1 (Apr-Jun ‘11)

Q 2 (Jul-Sep ‘11)

Q 3 (Oct-Dec ‘11)

Q 4 (Jan-Mar '12)

Teus Rev ($) Teus Rev ($) Teus Rev ($) Teus Rev ($)

1 Singapore

- Free Hand                

- Routed                

2 Busan

- Free Hand                

- Routed                

3Newyork

- Free Hand                

- Routed                

4Hongkong

- Free Hand                

- Routed                

5 Taiwan

- Free Hand                

- Routed                

6Hamburg

- Free Hand                

- Routed                

Total Free Hand                

Total Routed                

Grand Total                

Actual 2010-11                

% increase Actual V/s Budgeted

               

TEAM I FCL EXPRESS – TARGETED MARKET SHARE

TRADE LANE WISE/VOLUME DISTRIBUTION

28

Page 30: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM I FCL EXPRESS – TARGETED MARKET SHARETRADE LANE 1 – CUSTOMER WISE / VOLUME DISTRIBUTION PER

MONTH

Note: •Separate Slide should be presented per trade lane.•Potential Customers currently not supporting TGL should be highlighted in Blue color.

Sr . #Customer Name

Monthly Volume

Budgeted Share

Actual Avg Per Month Support in 10-11

Strategy to Bridge Gaps/Gain Support

           

           

           

           

           

           

           

           

           

29

Page 31: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM I FCL EXPRESS – TARGETED MARKET SHARE

MARKETING PERSON WISE / VOLUME DISTRIBUTION PER MONTH

Sr. No

Marketing

person

Budget for the month (TEUS)

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

                          

                          

                          

                          

                          

                          

                          

                          

                          

  Grand Total

 

                     

30

Page 32: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM FCL EXPRESS – (IMPORT) RESOURCE REQUIREMENT

ParticularsQty/ Amt in

INRBudgeted

Costs Advantages accruing from cost

Manpower:      

Sales      

CS      

Operations      

Finance      

Grand Total      

Branding:      

Advertising      

Trade Fairs      

Exhibition      

Events Sponsorship      

Grand Total      

Travel:      

Domestic      

International      

Grand Total      

31

Page 33: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…Qty/ Amt in

INR Budgeted Costs Advantages accruing from cost

Corporate Inputs:      

Sales Support      

Finance Support      

Reviews      

Overseas Sales Lead Management      

Grand Total      

Capital Expenditure:      

Computer      

Mobile Phone      

Other Capital Items      

Grand Total      

32

Page 34: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Sr. No. Name of the Player Volume in CBM

%age Of Total Volume

       

       

       

       

       

       

       

       

       

       

       

       

TEAM AFRICA EXPRESS – MARKET SIZE

Source of Data: Note: Please take average monthly volume fm

Apr’11 to Jan’1233

Page 35: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM AFRICA EXPRESS – TARGETED MARKET SHARE

We at TEAM GLOBAL _______ Branch wantto have ____ % in the local market forYear 11-12. The volume equivalent of thesame is _____ TEU/CBM per Month

34

Page 36: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM AFRICA EXPRESS – TARGETED MARKET SHARE

Sr. No.

Trade lane Quarterly volume (in Teus)

Q1 (Apr-Jun 11)

Q2 (Jul-Sept 11) Q3 (Oct-Dec 11) Q4 (Jan-Mar12)

Teus

Rev ($) Teus Rev ($) Teus Rev ($) Teus Rev ($)

1 KENYA

2 TANZANIA

3 RWANDA

4 BURUNDI

5 ZAMBIA

6 CONGO

7 SOUTH AFRICA

8 MOZAMBIQUE

9 WEST AFRICA

TOTAL

TRADE LANE WISE/VOLUME DISTRIBUTION

35

Page 37: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM AFRICA EXPRESS – TARGETED MARKET SHARE

Sr . #Customer Name

Monthly Volume

Budgeted Share

Actual Avg Per Month Support in 10-11

Strategy to Bridge Gaps/Gain Support

           

           

           

           

           

           

           

           

           

TRADE LANE 1 – CUSTOMER WISE / VOLUME DISTRIBUTION PER MONTH

Note: •Separate Slide should be presented per trade lane.•Potential Customers currently not supporting TGL should be highlighted in Blue color. 36

Page 38: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM AFRICA EXPRESS – TARGETED MARKET SHARE

MARKETING PERSON WISE / VOLUME DISTRIBUTION PER MONTH

Sr. No

Marketing

person

Budget for the month (CBM)

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

                          

                          

                          

                          

                          

                          

                          

                          

                          

  Grand Total

 

                     

37

Page 39: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

ParticularsQty/Amt in

INRBudgeted

Costs Advantages accruing from cost

Manpower:      

Sales      

CS      

Operations      

Finance      

Grand Total      

Branding:      

Advertising      

Trade Fairs      

Exhibition      

Events Sponsorship      

Grand Total      

Travel:      

Domestic      

International      

Grand Total      

TEAM AFRICA EXPRESS – RESOURCE REQUIREMENT

38

Page 40: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…Qty/ Amt in

INR Budgeted Costs Advantages accruing from cost

Corporate Inputs:      

Sales Support      

Finance Support      

Reviews      

Overseas Sales Lead Management      

Grand Total      

Capital Expenditure:      

Computer      

Mobile Phone      

Other Capital Items      

Grand Total      

39

Page 41: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Sr. No. Name of the Player Volume %age Of Total Volume

       

       

       

       

       

       

       

       

       

       

       

       

TEAM PROJECT EXPRESS – MARKET SIZE

Source of Data: Note: Please take average monthly volume fm

Apr’11 to Jan’1240

Page 42: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM PROJECT EXPRESS – TARGETED MARKET SHARE

We at TEAM GLOBAL _______ Branch wantto handle ____ projects in the local market.

The Revenue equivalent of the same is Rs _____.

41

Page 43: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

• Name of the Project : Appx vol : Remarks

• Name of the Project : Appx vol : Remarks

• Name of the Project : Appx vol : Remarks

UPCOMING PROJECTS IN OUR REGION

42

Page 44: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Sr . #Customer Name

Monthly Volume

Budgeted Share

Actual Avg Per Month Support in 10-11

Strategy to Bridge Gaps/Gain Support

           

           

           

           

           

           

           

           

           

TEAM PROJECT EXPRESS – TARGETED MARKET SHARE

Note: •Separate Slide should be presented per trade lane.•Potential Customers currently not supporting TGL should be highlighted in Blue color.

TRADE LANE 1 – CUSTOMER WISE / VOLUME DISTRIBUTION PER MONTH

43

Page 45: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

We at TEAM GLOBAL _______ Branch wantto have ____ % in the local market forYear 11-12. The volume equivalent of thesame is _____ Tons for Air Export and

_____Tons for Air Import.

TEAM AIR EXPRESS – TARGETED MARKET SHARE

44

Page 46: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM AIR EXPRESS – TARGETED MARKET SHARE

TRADE LANE WISE/VOLUME DISTRIBUTION

Sr. No.

Trade lane Quarterly volume FOR AIR IMPORT (Tons)

Q1 (Apr-Jun’11) Q2 (Jul-Sept’11)

Q3 (Oct-Dec-’11)

Q4 (Jan-Mar’12)

Tons Rev ($) Tons Rev ($) Tons Rev ($) Tons Rev ($)

Sr. No.

Trade lane Quarterly volume FOR AIR EXPORT (Tons)

Q1 (Apr-Jun’11) Q2 (Jul-Sept’11)

Q3 (Oct-Dec-’11)

Q4 (Jan-Mar’12)

Tons Rev ($) Tons Rev ($) Tons Rev ($) Tons Rev ($)

45

Page 47: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Sr . #Customer Name

Monthly Volume

Budgeted Share

Actual Avg Per Month Support in 10-11

Strategy to Bridge Gaps/Gain Support

           

           

           

           

           

           

           

           

           

TEAM AIR EXPRESS – (EXPORT) TARGETED MARKET SHARE

TRADE LANE 1 – CUSTOMER WISE / VOLUME DISTRIBUTION PER MONTH

46

Page 48: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM AIR EXPRESS – (EXPORT) TARGETED MARKET SHARE

Sr. No

Marketing

person

Budget for the month (TONS)

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

                          

                          

                          

                          

                          

                          

                          

                          

                          

  Grand Total

 

                     

MARKETING PERSON WISE / VOLUME DISTRIBUTION PER MONTH

47

Page 49: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM AIR EXPRESS – (IMPORT) TARGETED MARKET SHARE

TRADE LANE 1 – CUSTOMER WISE / VOLUME DISTRIBUTION PER MONTH

Sr . #

Customer Name

Monthly Volume

Budgeted Share

Actual Avg Per Month Support in 10-11

Strategy to Bridge Gaps/Gain Support

           

           

           

           

           

           

           

           

           

48

Page 50: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM AIR EXPRESS – (IMPORT) TARGETED MARKET SHARE

MARKETING PERSON WISE / VOLUME DISTRIBUTION PER MONTH

Sr. No

Marketing

person

Budget for the month (TONS)

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

                          

                          

                          

                          

                          

                          

                          

                          

                          

  Grand Total

 

                     

49

Page 51: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

TEAM AIR EXPRESS – RESOURCE REQUIREMENT

ParticularsQty/Amt in

INR Budgeted Costs Advantages accruing from cost

Manpower:      

Sales      

CS      

Operations      

Finance      

Grand Total      

Branding:      

Advertising      

Trade Fairs      

Exhibition      

Events Sponsorship      

Grand Total      

Travel:      

Domestic      

International      

Grand Total      

50

Page 52: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…Qty/Amt in

INR Budgeted Costs Advantages accruing from cost

Corporate Inputs:      

Sales Support      

Finance Support      

Reviews      

Overseas Sales Lead Management      

Grand Total      

Capital Expenditure:      

Computer      

Mobile Phone      

Other Capital Items      

Grand Total      

51

Page 53: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Particulars

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

INR INR INR INR INR INR INR INR INR INR INR INR

E Console Express                        

Gross Revenue (Billing)                        

Operating Expense                        

E Console Express Income                        

Income as %age of Revenue                        

I Console Express                        

Gross Revenue (Billing)                        

Operating Expense                        

I Console Express Income                        

Income as %age of Revenue                        

GROSS REVENUE BUDGET

Income should tally with Income mentioned in Net Revenue & Expense Slide

52

Page 54: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

INR INR INR INR INR INR INR INR INR INR INR INR

FCL – Export Express                        

Gross Revenue (Billing)                        

Operating Expense                        

FCL – Export Express Income                        

Income as %age of Revenue                        

FCL – Import Express                        

Gross Revenue (Billing)                        

Operating Expense                        

FCL – Import Express Income                        

Income as %age of Revenue                        

53

Page 55: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

INR INR INR INR INR INR INR INR INR INR INR INR

Africa Express                        

Gross Revenue (Billing)                        

Operating Expense                        

Africa Express Income                        

Income as %age of Revenue                        

Air Export                        

Gross Revenue (Billing)                        

Operating Expense                        

Air Export Income                        

Income as %age of Revenue                        

54

Page 56: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

INR INR INR INR INR INR INR INR INR INR INR INR

Air Import                        

Gross Revenue (Billing)                        

Operating Expense                        

Air Import Income                        

Income as %age of Revenue                        

Project Express                        

Gross Revenue (Billing)                        

Operating Expense                        

Project Express Income                        

Income as %age of Revenue                        

55

Page 57: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

NET REVENUE & EXPENSE BUDGET

Particulars Charge Code

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Total %age

of Total INR INR INR INR INR INR INR INR INR INR INR INR INR

Income E Console

Express 1301010005                            

I Console Express 1301010016                            

FCL – Export Express 1301010010                            

FCL – Import Express 1301010015                            

Africa Express 1301010065                            

Air Export 1301050005                            

Air Import 1301050010                            

Project Express

1301010020 &

1301100005                            

Total Income                              

56

Page 58: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…Charge Code

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Total %age

of Total INR INR INR INR INR INR INR INR INR INR INR INR INR

Expenditure Employee Cost

                              Staff Salary & Wages (Basic)

1405050005                            

Staff Welfare14050500

80                            Employee

Engagement                             Property Cost

                             

Office Rent 14051000

05                            

Electricity Charges 14051000

50                            

Rates & Taxes 14051000

10                            

Security Charges 14051000

15                            

Office Insurance 14051000

20                             Repairs &

Maintenance Office 14051000

25                            

Repair & Maintenance Computer

1405100035 &

1405100040                            

57

Page 59: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…Charge Code

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Total %age

of Total INR INR INR INR INR INR INR INR INR INR INR INR INR

Communication Cost                            

Telephone 1405150005                            

Mobile 1405150015                            

Internet 1405150020                            

Postage & Courier 1405150025                            

Travel                            

Business Travel -

Domestic 1405200005                            

Business Travel -

International 1405200010                            

Accommodation 1405200012                            

Conveyance 1405200015                            

58

Page 60: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued… Charge

Code

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Total

%age of Total INR INR INR INR INR INR INR INR INR INR INR INR INR

Selling & Distribution Expenses

                              Advertiseme

nt & Publicity

1405250005                            

Business Promotion

1405250030                            

Office Expenses                              

Audit and Consultant

Fees1405400

031                            Printing & Stationary

1405300015                            

Subscription &

Membership 1405300

020                             Books &

Periodicals 1405300

025                             House

Keeping Expenses

1405300026                            

Donations 1405300

030                             Software Expenses

1405300040                            

MTO Insurance Charges

1305010032                             59

Page 61: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…

Charge Code

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Total %age

of Total INR INR INR INR INR INR INR INR INR INR INR INR INR

Vehicle Expenses                              

Car Parking Charges

1405350014                            

Vehicle Insurance

1405350015                            

Petrol Expenses

1405350016                            

Vehicle Repairs & Maintena

nce 14053500

30                             Vehicle

Hire Charges

1405350035                            

Finance & Other Expenses

                             

Financial Charges

1410010010,1410010030 &

1410010100                            

Bank Charges

1410050005                            

Bad Debts                              

60

Page 62: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

Continued…

Charge

Code

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Total %age

of Total INR INR INR INR INR INR INR INR INR INR INR INR INR

Notional Expenditure

                             

Interest On Working Capital                              

Corporate Expenses                              

Depreciation                              

Total Expenditure                              

Net Profit                              

61

Page 63: Budget templates 2011   2012

www.teamglobal.in

Budget 2011-12

THANK YOU!!!