budget format 12-13

Upload: abdul-rahim

Post on 05-Apr-2018

219 views

Category:

Documents


0 download

TRANSCRIPT

  • 7/31/2019 Budget Format 12-13

    1/18

    S.# HEAD OF ACCOUNT TOTAL

    RUPEES

    1 FIXED ASSETS -

    2 SALARIES AND WAGES

    3 REPAIR AND MAINTENANCE

    4 STORES AND SPARES CONSUMED

    5 PRINTING AND STATIONARY

    6 VEHICLE FUEL AND REPAIRMENT

    7 ENTERTAINMENT

    8 PACKING MATERIAL

    9 LOCAL AND FOREIGN TRAVELLING

    10 FUEL & POWER

    11 COMMUNICATION

    12 FEES & SUBSCRIPTION

    -

    AL-ABBAS SUGAR MILLS LIMITED

    BUDGET 2012-2013

    SUMMARY SHEETDEPARTMENT NAME:

    TOTAL

  • 7/31/2019 Budget Format 12-13

    2/18

    Al-Abbas Sugar Mills Limited

    Budgeted Capital expenditure for the year 2012-2013 - Department wise

    Name of Department:

    FIXED ASSETS

    S.No Description of Item Category Cost center Quantity Rate A

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    Total

    7. Amount Quantity * Rate

    8. New or replacement Write 'new ' for the item to be purchased is new one

    Write 'replacement ' for the item to be purchased is the replacement of the old one

    9. Expected date of

    purchase Date at which the item is required by the respective department

    11. Reason for purchase Justification for the item to be purchased and i ts benefits to the Company.

  • 7/31/2019 Budget Format 12-13

    3/18

    AL-ABBAS SUGAR MILLS LIMITED

    MANPOWER BUDGET - FOR THE YEAR 2011-12

    FOR SUGAR AND DISTILLERY DIVISION

    EMPLOYEES WISE AND SECTION WISE INFORMATION

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    Name SECTIONDesignation Bonus

    STAFF

    Code No.

  • 7/31/2019 Budget Format 12-13

    4/18

    AL-ABBAS SUGAR MILLS LIMITED

    MANPOWER BUDGET - FOR THE YEAR 2011-12

    FOR SUGAR AND DISTILLERY DIVISION

    EMPLOYEES WISE AND SECTION WISE INFORMATION

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    Code No. Name Designation

    STAFF

    Bonus

  • 7/31/2019 Budget Format 12-13

    5/18

    AL-ABBAS SUGAR MILLS LIMITED

    MANPOWER BUDGET - FOR THE YEAR 2011-12

    FOR SUGAR AND DISTILLERY DIVISION

    EMPLOYEES WISE INFORMATION

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    Bonus

    STAFF

    Code No. Name Designation

  • 7/31/2019 Budget Format 12-13

    6/18

    AL-ABBAS SUGAR MILLS LIMITED

    MANPOWER BUDGET - FOR THE YEAR 2011-12

    FOR SUGAR AND DISTILLERY DIVISION

    EMPLOYEES WISE INFORMATION

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    Code No. Name Designation Bonus

    STAFF

  • 7/31/2019 Budget Format 12-13

    7/18

    AL-ABBAS SUGAR MILLS LIMITED

    MANPOWER BUDGET - FOR THE YEAR 2011-12

    FOR SUGAR AND DISTILLERY DIVISION

    EMPLOYEES WISE INFORMATION

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    STAFF

    Code No. Name Designation Bonus

  • 7/31/2019 Budget Format 12-13

    8/18

    PERMANENT

    Last year strength 0 0 0 0 0 0 0 0

    Budgeted strenght 0 0 0 0 0 0 0 0

    Approved strenght 0 0 0 0 0 0 0 0

    SEASONAL

    Current strength 0 0 0 0 0 0 0 0

    Budgeted strenght 0 0 0 0 0 0 0 0

    Approved strenght 0 0 0 0 0 0 0 0

    DAILY WAGES

    Current strength 0 0 0 0 0 0 0 0

    Budgeted strenght 0 0 0 0 0 0 0 0

    Approved strenght 0 0 0 0 0 0 0 0

    DAILY WAGES

    Current strength 0 0 0 0 0 0 0 0

    Budgeted strenght 0 0 0 0 0 0 0 0

    Approved strenght 0 0 0 0 0 0 0 0

    RETAINEE

    Current strength 0 0 0 0 0 0 0 0

    Budgeted strenght 0 0 0 0 0 0 0 0

    Approved strenght 0 0 0 0 0 0 0 0

    CASUAL

    Current strength 0 0 0 0 0 0 0 0

    Budgeted strenght 0 0 0 0 0 0 0 0

    Approved strenght 0 0 0 0 0 0 0 0

    SECTIONS*

    Mechanical General

    Mill House

    Boiler House

    Cane Field

    Cane Office

    Cane Yard

    Dispensary

    Clarification

    DESCRIPTION

    Human Resources Budget for the period from October, 201

    SECTION WISE

    Oct: Nov: Dec: Jan: Feb: Mar: April Ma

  • 7/31/2019 Budget Format 12-13

    9/18

    S.NO DESCRIPTION SPECIFICATION UNIT Quantity UNIT COST

    VALUE

    WITHOUT

    GST

    Quantity UNIT COST

    VALUE

    WITHOUT

    GST

    Quantity Amount Quantity Amou1

    2

    3

    4

    5

    6

    7

    8

    9

    - - -TOTAL COST

    CODE#

    OPENING PURCHASE

    Oct-12

    Al-Abbas Sugar Mills Limitedu ge e pera ona evenue xpen ure or year -

    Name od Department:

    Nov-12

  • 7/31/2019 Budget Format 12-13

    10/18

    JUSTIFICATION

  • 7/31/2019 Budget Format 12-13

    11/18

    AL-ABBAS SUGAR MILLS LIMITED

    DEPARTMENT:BUDGETED OPERATIONAL / REVENUE EXPENDITURE (Services ) FOR THE YEAR 2012-2013

    FUEL EXPENSES.

    Oct. 2012 Nov. 2012 Dec.2012 Jan.2013 Feb.2013 Mar.2013 April.2013 M

    Rupees Rupees Rupees Rupees Rupees Rupees Rupees R

    Sub Total (A)- - - - - - -

    Oct. 2012 Nov. 2012 Dec.2012 Jan.2013 Feb.2013 Mar.2013 April.2013 M

    Rupees Rupees Rupees Rupees Rupees Rupees Rupees R

    Sub Total (B) - - - - - - -

    TOTAL - - - - - - -

    PARTICULARS Vehicle No. In use of

    REPAIRS &

    MAINTENANCE.

    Vehicle No. In use of

  • 7/31/2019 Budget Format 12-13

    12/18

    Al-Abbas Sugar Mills LimitedBudgeted Operational / Revenue expenditure (SERVICES) for the year 2012-2013Departement NameFor the month wise

    This format to be used only and separately for each category and department wise. This format is to be used for each

    month separately too. Use the categories that are relevant;COST OF PRODUCTION DISTRIBUTION COST- Water, fuel and power - Sugar handling bags- Repairs and maintenance- Vehicle running expenses- Travelling and conveyance- Printing and stationary- Communication charges- Fees and Subscription- Newspapers and periodicals- Entertainment- Miscellanous expenses

    NOTE: Leave blank columns that are not relevant

    S.# ITEM DESCRIPTIONACCOUNT

    HEADS

    REQUESTING

    DEPARTMENTOct-12 Nov-12

    1

    2

    3

    0 0

    Provide supports and break up for each item

    categorised.

  • 7/31/2019 Budget Format 12-13

    13/18

    Al-Abbas Sugar Mills Limited

    Budgeted Unsual Repairm and maintenance for the year

    2012-2013

    Departement Name

    For the Month Wise

    This format to be used only and separately for each category and department wise. This format is to be used for eachmonth separately too.

    NOTE: Leave blank columns that are not relevant

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    - - - -TOTAL

    Nov-12 Dec-12 Jan-13S.No

    .

    Provide supports and break up for each item listed below

    FeOct-12Details of service

  • 7/31/2019 Budget Format 12-13

    14/18

    AL-ABBAS SUGAR MILLS LIMITEDBudgeted Cost Of Raw Material - Sugar Segment

    Budget for the year 2012 - 2013

    Oct-12 Nov-12 Dec-12 Jan-13 Feb-13

    Quantitative Data

    Cane Crushing in (Mds)Expected Cane price per 40 Kgs.

    Expected Cane payment.

    Cane Crushing in (MT)

    Expected Cane price per 40 Kgs.

    Expected Cane payment.

    WIP Cane Procurement Exp. -

    WIP Sugarcane Purchase/Consumpt

    WIP Cane Unloading Exp.

    WIP Road Cess Exp. 6.25

    WIP Market Fees Exp. 5.00

    WIP Subsidy On Cane - General E

    WIP Subsidy On Tpt Exp.WIP Premium On Cane Exp.

    WIP Rent Sector/Sub Sector Offi

    WIP Electri. Charg. Sector/Sub

    Wip-Salary Wages Field Allowanc

    Wip-Salary Wages Field Allowanc

    WIP Entertainment (Puva)

    WIP Other Charges Sector/Sub Se

    WIP Loading/Unloading Gen. Expe - 0 0 0 0

    0 0 0 0 0

  • 7/31/2019 Budget Format 12-13

    15/18

    AL-ABBAS SUGAR MILLS LIMITED

    Budgeted Production and Prices - Sugar Segment

    Budget for the year 2012 - 2013

    Oct-12 Nov-12 Dec-12 Jan-13 Feb-13

    PRODUCTION

    Crushing capacity per day

    - In Metric tons

    - In maunds - - - - -

    Capacity utilisation - #DIV/0! #DIV/0! #DIV/0! #DIV/0!

    Crushing days

    Recovery % (Month to date)

    Molasses % of Cane

    Production of Molasses (M.tons)

    Baggase % of cane

    Production of Bagasse (M.tons)

    Cane Crushed

    - In Metric tons

    - In maunds - - - - -

    Sugar production

    - In Metric tons

    - In bags - - - - -

    Sugar in process

    - In Metric tons

    PRICES

    Cane price to date (Rate / Maund)

    Molasses (Average transfer price)

    Baggase (Transfer price)*

    Particulars

  • 7/31/2019 Budget Format 12-13

    16/18

    *Bagasse produced will be used in full

  • 7/31/2019 Budget Format 12-13

    17/18

    Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13

    -

    0 -

    #DIV/0! #DIV/0!

    -

    #DIV/0!

    0.00%

    -

    0.00%

    -

    -

    0 -

    -

    - -

    -

    #DIV/0!

    -

    -

    Cane would not be available for crushing

    during this period due to off season

    2012-13

    Cane would not be available for crushing

    during this period due to off season

  • 7/31/2019 Budget Format 12-13

    18/18

    AL-ABBAS SUGAR MILLS LIMITED

    Budget for the year 2012- 2013

    Ethanol Production

    PRODUCTION

    Production Capacity

    Unit 1

    - In Metric tons 0 0 0 0 0 0- In liters 0 0 0 0 0 0

    Unit 2 0 0

    - In Metric tons - - - - - -

    - In liters - - - - - -

    Capacity utilisation %

    Unit 1

    Unit 2

    Operation days in a month

    Unit 1

    Unit 2

    Production (tons)Unit 1

    A grade - - - - - -

    B grade - - - - - -

    Unit 2

    A grade - - - - - -

    B grade - - - - - -

    KWH required to produce one ton #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/

    of ethanol

    Chemical consumption (tons) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/

    Yeild

    In liters - - - - - -In tons - - - - - -

    Fusel oil

    Production

    In liters - - - - - -

    In tons - - - - - -

    Sale

    In liters

    In tons

    Molasses required per ton #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/

    Molasses consumed (In M.tons)

    Unit 1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/Unit 2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/

    Feb-13Particulars Oct-12 Nov-12 Dec-12 Jan-13 Mar-13 Apr-1