budget templates 2012 2013 - imports
TRANSCRIPT
Annual Budget 12-13
Annual Budget ExerciseSea Imports
Budget 11-12, Performance 11-12
Budget 12-13
www.teamglobal.in1
Annual Budget 12-13
www.teamglobal.in
Branch Details
2
Branch –
Date –
Address -
Date of Inception-
Staff Strength as of 01/04/2011 v/s28/02/2012: (as per the attached grade chart)
Annual Budget 12-13
www.teamglobal.in
Staff Strength
3
Grade Designation
Strength as on 1/4/11
Strength as on 28/2/12
Projected strength 12-
13Targeted Training Man
Hours per Quarter
M3 General Manager 18
M4 Dy. General Manager 18
M5 Asst. General Manager 18
M6 Sr. Manager 18
M7 Manager 18
M8 Dy. Manager 18
M9 Asst. Manager 18
E1 Sr. Executive 18
E2 Executive 18
E3 Jr. Executive 18
S1 Officer 18
S2 Supervisor 18
S3 Assistant 18
V Voucher Staff 18
Total Note: Please refer to the budget guidelines for the working.
Annual Budget 12-13
www.teamglobal.in
Product Wise Presence
4
TEAM I -Console Express - Y □ / N □
TEAM I -FCL Express - Y □ / N □
TEAM Project Express - Y □ / N □
Annual Budget 12-13
www.teamglobal.in
Brief Summary for the FY 11-12 & 12-13
5
Segment wise
Projection for Feb & Mar 2012
Budget (11-12)
Annualized Actual (11-12)
Short Fall/Exces
s
Reasons for shortfall & Strategy For overcoming the
adverse factors and build on positive
factors Budget
2012-13
I-Consol (CBM)
I- FCL Express (TEUS)
Project Express (CBM)
Note : Annualized Actual is from April 2011-March 2012
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS –Market Size
6
Sr. No. Name of the Player Volume in Teus
%age Of Total Teus
Note : Please take average monthly volume fm Apr’11 to Jan’12
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS – Targeted Market Share
7
We at TEAM GLOBAL _______ Branch
want to have ____ % in the local market for
Year 12-13. The volume equivalent of the
same is _____ TEU/CBM per Month
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS -11-12 Performance & 12-13 Budget
8
Particulars
Annual Performance 2011-12 Against Budget 2012-13
Cbm/Teus Revenue (INR) Budget Yield (11-12)
Actual Yield (11-12)
Budget Yield (12-13)
Budget
Actual
%age achvd
Budget
% age growth
Budget
Actual
%age achvd
Budget
% age growth
(11-12)
(11-12)
(12-13)
(11-12)
(11-12)
(12-13)
I-Consol
I- FCL Express Projects Express
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS – Trade lane wise / Volume DistributionQuarter 1
9Note : Yield will be Revenue Divided by Sum of Cbm , Only Direct Svcs ports to Mention
Sr # Port
Volume and Revenue Quarter-wise Budget Performance Budget
Q 1 (Apr-Jun ‘11-12) Q 1 (Apr-Jun ‘11-12) Q 1 (Apr-Jun ‘12-13) Teus Cbm HBL Rev
($) Yield
Stowag
e
Teus Cbm HBL Rev ($)
Yield
Stowag
e
Teus
Cbm HBL Rev ($)
Yield
Stowag
eSECTOR 1
1
Free Hand
WWA Routed
MCC Total
Avg per
month
2
Free Hand
WWA Routed
MCC Total
Avg per
month
SECTOR 2
1
Free Hand
WWA Routed
MCC Total
Avg per
month
2
Free Hand
WWA Routed
MCC Total
Avg per
month
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS – Trade lane wise / Volume DistributionQuarter 2
10
Note : Yield will be Revenue Divided by Sum of Cbm , Only Direct Svcs ports to Mention
Sr # Port
Volume and Revenue Quarter-wise Budget Performance Budget
Q2 (Jul-Sep ‘11-12) Q2 (Jul-Sep ‘11-12) Q2 (Jul-Sep ‘11-12) Teus Cbm HBL Rev
($) Yield
Stowag
e
Teus Cbm HBL Rev ($)
Yield
Stowag
e
Teus
Cbm HBL Rev ($)
Yield
Stowag
eSECTOR 1
1
Free Hand
WWA Routed
MCC Total
Avg per
month
2
Free Hand
WWA Routed
MCC Total
Avg per
month
SECTOR 2
1
Free Hand
WWA Routed
MCC Total
Avg per
month
2
Free Hand
WWA Routed
MCC Total
Avg per
month
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS – Trade lane wise / Volume DistributionQuarter 3
11
Note : Yield will be Revenue Divided by Sum of Cbm , Only Direct Svcs ports to Mention
Sr # Port
Volume and Revenue Quarter-wise Budget Performance Budget
Q 3 (Oct- Dec ‘11-12) Q 3 (Oct- Dec ‘11-12) Q 3 (Oct- Dec ‘11-12) Teus Cbm HBL Rev
($) Yield
Stowag
e
Teus Cbm HBL Rev ($)
Yield
Stowag
e
Teus
Cbm HBL Rev ($)
Yield
Stowag
eSECTOR 1
1
Free Hand
WWA Routed
MCC Total
Avg per
month
2
Free Hand
WWA Routed
MCC Total
Avg per
month
SECTOR 2
1
Free Hand
WWA Routed
MCC Total
Avg per
month
2
Free Hand
WWA Routed
MCC Total
Avg per
month
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS – Trade lane wise / Volume DistributionQuarter 4
12
Note : Yield will be Revenue Divided by Sum of Cbm , Only Direct Svcs ports to Mention
Sr # Port
Volume and Revenue Quarter-wise Budget Performance Budget
Q 4 (Jan- Mar ‘11-12) Q 4 (Jan- Mar ‘11-12) Q 4 (Jan- Mar ‘11-12) Teus Cbm HBL Rev
($) Yield
Stowag
e
Teus Cbm HBL Rev ($)
Yield
Stowag
e
Teus
Cbm HBL Rev ($)
Yield
Stowag
eSECTOR 1
1
Free Hand
WWA Routed
MCC Total
Avg per
month
2
Free Hand
WWA Routed
MCC Total
Avg per
month
SECTOR 2
1
Free Hand
WWA Routed
MCC Total
Avg per
month
2
Free Hand
WWA Routed
MCC Total
Avg per
month
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS –- Tradelane Wise Top 20 Customers
13
Tradelane Name :Customer Category : Origin Freehand BUDGET 2012-13
S#Top 20
CustomersMarketing
Person NameCBM
Apr May Jun July Aug Sep Oct Nov Dec Jan Feb Mar1
2
3
4
5
6
7
9
10
11
12
13
14
15
16
17
18
19
20
Grand Total Note Please DO NOT include WWA 32 Customers Separate slide should be presented per Tradelane (Pls refer to
Direct Services)
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS – TradelaneWise WWA 32 Customers
14
Tradelane Name :Customer Category : WWA BUDGET 2012-13
S#
WWA Customers
Marketing Person Name
CBM
Apr May Jun July Aug Sep Oct Nov Dec Jan Feb Mar1 A.Hartrodt 2 Agility 3 AFL Dachser
4 APL
Logistics 5 BDP 6 Ceva 7 CH Robinson
8Crane
Worldwide
9Cargo
Partner 10 Damco 11 DHL 12 DSV 13 Dart Global 14 Expeditors
15
Fedex Trade Networks
16
Geodis Wilson
17 Hellmann
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS – TradelaneWise WWA 32 Customers
15
Tradelane Name:Customer Category : WWA BUDGET 2012-13
S#
WWA Customers
Marketing Person Name
CBM
Apr May Jun July Aug Sep Oct Nov Dec Jan Feb Mar
18
IJS /TVS Dynamic
19 JAS 20 Kintetsu 21
Kuehne & Nagel
22 Nippon
23
Phoenix International
24
Savino Del Bene
25 Schenker 26 SDV 27 Toll Group 28
NYK / YUSEN
29 Panalpina 30 UPS 31 UTI 32
Weiss Rohlig
Grand Total
Annual Budget 12-13
www.teamglobal.in
TEAM I CONSOLE EXPRESS – Marketingwise Budget 12-13
16
Sr #
Marketing Person Name
Customer Category
Monthly Avg for 11-12
BUDGET 2012-13CBM
AprMay Jun JulyAugSep Oct NovDec Jan Feb
Mar
1
Routed WWA
2
Routed WWA
3
Routed WWA
4
Routed WWA
5
Routed WWA
6
Routed WWA
7
Routed WWA
Total
Routed Total WWA
Grand Total
Annual Budget 12-13
www.teamglobal.in
TEAM I - FCL EXPRESS –Market Size
17
Sr. No. Name of the Player Volume in Teus
%age Of Total Teus
Note : Please indicate FCL volume controlled by NVOCC’s. Please take avg monthly volume fm Apr’11 to Jan’12
Annual Budget 12-13
www.teamglobal.in
18
We at TEAM GLOBAL _______ Branch want to have ____ % in the local market for Year 12- 13. The volume equivalent of the same is _____ TEU/CBM per Month
TEAM I-FCL EXPRESS – Targeted Market Share
Annual Budget 12-13
www.teamglobal.in
19
TEAM I FCL EXPRESS – Trade lane wise / Volume Distribution Quarter 1
Note : Yield will be Revenue Divided by Teu
Sr # Sector
Volume and Revenue Quarter-wise
Budget Performance Budget
Q 1 (Apr-Jun ‘11-12) Q 1 (Apr-Jun ‘11-12) Q 1 (Apr-Jun ‘12-13)
Teus HBL Rev ($)
Yield Teus HBL Rev ($)
Yield
Teus HBL Rev ($)
Yield
1
Free Hand
Routed
Total
Avg per month
2
Free Hand
Routed
Total
Avg per
month
3
Free Hand
Routed
Total
Avg per
month
4
Free Hand
Routed
Total
Avg per
month
Annual Budget 12-13
www.teamglobal.in
20
TEAM I FCL EXPRESS – Trade lane wise / Volume Distribution Quarter 2
Note : Yield will be Revenue Divided by Teu
Sr # Sector
Volume and Revenue Quarter-wise
Budget Performance Budget Q 2 (Jul-Sep ‘11-12) Q 2 (Jul-Sep ‘11-12) Q 2 (Jul-Sep ‘11-12)
Teus HBL Rev ($)
Yield Teus HBL Rev ($)
Yield
Teus HBL Rev ($)
Yield
1
Free Hand
Routed
Total
Avg per month
2
Free Hand
Routed
Total
Avg per
month
3
Free Hand
Routed
Total
Avg per
month
4
Free Hand
Routed
Total
Avg per
month
Annual Budget 12-13
www.teamglobal.in
21
TEAM I FCL EXPRESS – Trade lane wise / Volume Distribution Quarter 3
Note : Yield will be Revenue Divided by Teu
Sr # Sector
Volume and Revenue Quarter-wise
Budget Performance Budget Q 3 (Oct-Dec ‘11-12) Q 3 (Oct-Dec ‘11-12) Q 3 (Oct-Dec ‘11-12)
Teus HBL Rev ($)
Yield Teus HBL Rev ($)
Yield
Teus HBL Rev ($)
Yield
1
Free Hand
Routed
Total
Avg per month
2
Free Hand
Routed
Total
Avg per
month
3
Free Hand
Routed
Total
Avg per
month
4
Free Hand
Routed
Total
Avg per
month
Annual Budget 12-13
www.teamglobal.in
22
TEAM I FCL EXPRESS – Trade lane wise / Volume Distribution Quarter 4
Note : Yield will be Revenue Divided by Teu
Sr # Sector
Volume and Revenue Quarter-wise
Budget Performance Budget Q 4 (Jan-Mar ‘11-12) Q 4 (Jan-Mar ‘11-12) Q 4 (Jan-Mar ‘11-12)
Teus HBL Rev ($)
Yield Teus HBL Rev ($)
Yield
Teus HBL Rev ($)
Yield
1
Free Hand
Routed
Total
Avg per month
2
Free Hand
Routed
Total
Avg per
month
3
Free Hand
Routed
Total
Avg per
month
4
Free Hand
Routed
Total
Avg per
month
Annual Budget 12-13
www.teamglobal.in
TEAM I -FCL EXPRESS –- Tradelane Wise Top 20 Customers
23
Sector Name : BUDGET 2012-13
S#Top 20
CustomersMarketing
Person NameTEUS
Apr May Jun July Aug Sep Oct Nov Dec Jan Feb Mar1
2
3
4
5
6
7
9
10
11
12
13
14
15
16
17
18
19
20
Grand Total
Note: Separate slide should be presented each Sector
Annual Budget 12-13
www.teamglobal.in
TEAM I –FCL EXPRESS – Marketingwise Budget 12-13
24
Sr #
Marketing Person Name
Monthly Avg for 11-12
BUDGET 2012-13TEUS
Apr May Jun July Aug Sep Oct Nov Dec Jan Feb Mar
1
2
3
4
5
6
7
Grand Total
Annual Budget 12-13
www.teamglobal.in
TEAM PROJECT EXPRESS –Market Size
25
Sr. No. Name of the Player Volume in Teus
%age Of Total Teus
Note : Please indicate FCL volume controlled by NVOCC’s. Please take avg monthly volume fm Apr’11 to Jan’12
Annual Budget 12-13
www.teamglobal.in
26
We at TEAM GLOBAL _______ Branch
want to handle ____ projects in the local
market. The Revenue equivalent of the
same is Rs _____.
TEAM PROJECT EXPRESS – Targeted Market Share
Annual Budget 12-13
www.teamglobal.in
27
TEAM PROJECT EXPRESS – Targeted Market Share
• Name of the Project : Appx vol : Remarks
• Name of the Project : Appx vol : Remarks
• Name of the Project : Appx vol : Remarks
Annual Budget 12-13
www.teamglobal.in
Debtors FY 2011-12
28
S. No
Segment
Salesman Name
Customer Name
1-30 days
30-60 days
60-90 days
90-180 days Total
Remarks
1 5
2 1
321& 22
Note : Please prepare a separate slide for each segment
Annual Budget 12-13
www.teamglobal.in
Non –Recoverable Payments Recommended for Write Off FY 2011-12
29
S. No
Segment
Salesman Name
Name of Party
Ageing Days
Total Amount
Reasons for Non Recovery
1 5
2 1
3 21& 22
Note: To validate the reasons and H.O. to finalize the same by end 16th Apr 2012 , For every segment please prepare a separate slide
Annual Budget 12-13
www.teamglobal.in
Gross Revenue Budget
30
Particulars
Quarter for YR 2012-2013
Q1 Q2 Q3 Q4Budget Total 2012-2013
Budget 2011-2012
Actual 2011-2012
INR INR INR INR INR INR INR I Console Express
Gross Revenue (Billing) Operating Expense I Console Express Income
Income as %age of
Revenue FCL –
Import Express
Gross Revenue (Billing) Operating Expense
FCL – Import Express Income
Income as %age of
Revenue To Continue…
Annual Budget 12-13
www.teamglobal.in
Gross Revenue Budget
31
Continued …
Quarter for YR 2012-2013
Q1 Q2 Q3 Q4
Budget Total 2012-2013
Budget 2011-2012
Actual 2011-2012
INR INR INR INR INR INR INR
Project Express
Gross Revenue (Billing)
Operating Expense
Project Express Income
Income as %age of Revenue Income should tally with Income mentioned in Net Revenue &
Expense Slide
Annual Budget 12-13
www.teamglobal.in
Net Revenue & Expense Budget FY 12-13
32
Particulars
Quarter for YR 2012-2013
Q1 Q2 Q3 Q4
Budget Total 2012-2013
Budget 2011-2012
Actual 2011-2012
INR INR INR INR INR INR INR
INCOME
I Console Express
FCL – Import Express
Projects Express
TOTAL INCOME
To Continue…
Annual Budget 12-13
www.teamglobal.in
Net Revenue & Expense Budget FY 12-13
33
EXPENDITURE
Continued…
Quarter for YR 2012-2013
Q1 Q2 Q3 Q4
Budget Total 2012-2013
Budget 2011-2012
Actual 2011-2012
INR INR INR INR INR INR INR
Employee Cost
Staff Salary & Wages (Basic) Staff Welfare Stipend To Trainees
Employee Engagement
Property Cost
Rent Rates & Taxes Security Charges - Office Office Insurance Repairs & Maintenance Office
Repairs & Maintenance Office Equipments
Repair & Maintenance Computer Hardware
Repair & Maintenance Computer Software Electricity Charges
To Continue…
Annual Budget 12-13
www.teamglobal.in
Net Revenue & Expense Budget FY 12-13
34
Continued …
Quarter for YR 2012-2013
Q1 Q2 Q3 Q4
Budget Total 2012-2013
Budget 2011-2012
Actual 2011-2012
INR INR INR INR INR INR INR Communication Cost
Telephone Mobile Internet Postage & Courier
Travel
Travelling Expenses Conveyance
Selling & Distribution Expenses
Advertisement & Publicity Gifts & Sales Promotion Business Promotion
Office Expenses
Office , Miscellaneous & Sundry Expenses Printing & Stationary Subscription & Membership Books & Periodicals
House Keeping Expenses Donations Software Expenses MTO Insurance Charges To Continue…
Annual Budget 12-13
www.teamglobal.in
Net Revenue & Expense Budget FY 12-13
35
Continued…
Quarter for YR 2012-2013
Q1 Q2 Q3 Q4
Budget Total 2012-2013
Budget 2011-2012
Actual 2011-2012
INR INR INR INR INR INR INR
Vehicle Expenses
Vehicle Insurance Petrol Expenses
Vehicle Repairs & Maintenance Vehicle Hire Charges
Legal & Statutory Cost
Statutory Audit Fees
Legal & Professional Charges
Legal & Statutory Charges Audit Expense Corporate Expense
TOTAL EXPENDITURE NET PROFIT
Annual Budget 12-13
Executive Summary of the Branch
Budget 11-12, Performance 11-12
Budget 12-13
www.teamglobal.in36
Annual Budget 12-13
www.teamglobal.in
Brief Summary FY 12-13
37
PRODUCT
Q1 Q2 Q3 Q4
Teu CbmRev($)
Yield Teu Cbm
Rev($)
Yield Teu Cbm Rev($) Yield Teu Cbm Rev($) Yield
E-Consol(TEU&CBM)
E- FCL (TEU)
E- Africa (TEU) I–Consol (TEU&CBM)
I – FCL(TEU)
E- Air (TONS)
I- Air (TONS) Stuffing/Projects (TEU)
TOTAL INCOME(INR)
TOTAL EXPENSE
NET PROFIT
Note : Rate of Exchange needs to be clearly mentioned
Annual Budget 12-13
www.teamglobal.in
Net Revenue & Expense Budget FY 12-13
38
Particulars
Quarter for YR 2012-2013
Q1 Q2 Q3 Q4
Budget Total 2012-2013
Budget 2011-2012
Actual 2011-2012
INR INR INR INR INR INR INR
INCOME
E Console Express Income I Console Express Income
FCL – Export Express Income
FCL – Import Express Income Africa Express Income
Air Export Income
Air Import Income Project Express Income
Annual Budget 12-13
Net Revenue & Expense Budget FY 12-13
www.teamglobal.in 39
EXPENDITURE
Particulars
Quarter for YR 2012-2013
Q1 Q2 Q3 Q4Budget Total 2012-2013
Budget 2011-2012
Actual 2011-2012
INR INR INR INR INR INR INR Employee Cost
Staff Salary & Wages (Basic) Staff Welfare Stipend To Trainees
Employee Engagement
Property Cost
Rent Rates & Taxes Security Charges - Office Office Insurance
Repairs & Maintenance Office Repairs & Maintenance Office Equipments
Repair & Maintenance Computer Hardware
Repair & Maintenance Computer Software Electricity Charges
Annual Budget 12-13
www.teamglobal.in
Net Revenue & Expense Budget FY 12-13
40
Particulars
Quarter for YR 2012-2013
Q1 Q2 Q3 Q4Budget Total 2012-2013
Budget 2011-2012
Actual 2011-2012
INR INR INR INR INR INR INR
Communication Cost
Telephone Mobile Internet Postage & Courier
Travel
Travelling Expenses Conveyance Selling & Distribution
Expenses
Advertisement & Publicity Gifts & Sales Promotion Business Promotion
Office Expenses
Office , Miscellaneous & Sundry Expenses Printing & Stationary Subscription & Membership Books & Periodicals House Keeping Expenses Donations Software Expenses MTO Insurance Charges
Annual Budget 12-13
www.teamglobal.in
Net Revenue & Expense Budget FY 12-13
41
Particulars
Quarter for YR 2012-2013
Q1 Q2 Q3 Q4Budget Total 2012-2013
Budget 2011-2012
Actual 2011-2012
INR INR INR INR INR INR INR
Vehicle Expenses
Vehicle Insurance Petrol Expenses Vehicle Repairs & Maintenance Vehicle Hire Charges
Legal & Statutory Cost
Statutory Audit Fees Legal & Professional Charges Legal & Statutory Charges Audit Expense
CORPORATE EXPENSE
TOTAL EXPENDITURE Profit before Interest
& Dep Financial Charges Bank Charges Depreciation Bad Debts Total(Interest & Dep) NET PROFIT AFTER
INTEREST & DEPRECIATION
Annual Budget 12-13
www.teamglobal.in
42
THANKYOU !!!