COMPUTERISATION OF ASSET REGISTER

IN CENTRAL RAILWAY

 

COMPUTERISATION OF ASSET REGISTER

  • Taken up in 2000-01
  • Data Entry Software developed by CRIS
  • Co-ordination by MIS and EDP Centre, but responsibility for Data Integrity with the Department
  • In Central Railway, GM made the PHODs responsible and FA &CAO (F &B) as ‘Prime Mover’
  • Milestones laid down by CRB in his DO No. 98/EDF/RFFC/6/Std.Comm. Dated 8th Nov. 2000 were achieved

MONITORING OF THE WORK

THE MILESTONES WERE ACHIEVED AND THE CD AND THE REPORTS WERE SENT TO BOARD ON 5th APRIL 2001                ( TARGET- 15th APRIL 2001). THIS WAS ACHIEVED BY

 

 

        *   Organising Workshops for all departments on Data                        Entry

    *   Allowing field units to enter the data in EXCEL, with

         which they were familiar. Conversion from

    *   EXCEL to     ACCESS was done by Dy. CEE/ MIS

         *   Weekly monitoring by FA & CAO with HODs and                       fortnightly monitoring by GM with PHODs

  • Constant interaction with the Board

     (J.Viswanathan) and CRIS (Srivastava) for sorting out

     any problem

 

 

Coding Structure

  • Department : C(ivil), M(echanical) , E(lectrical)

S(ignalling) or T(elecom), H(ealth), R(PF- Security),

I(nventory-Stores) and P(RS and Computers)

  • Stock holder code: Designation of Stock holder
  • S. No. : A running serial number. Generated by program
  • Asset No. : Entered wherever available.
  •  
  • Group code : As decided by concerned Directorate in

                            Board.

  • Subgroup code:  ….do….
  • Description :       ….do….

 

Coding Structure (Contd.)

 

•      Quantity    :       As per units given in software

                                        LAND IN HECTARE : RAILS ,

                            SIGNAL & OTHER CABLES IN KM

                            MOST ASSETS IN NUMBERS 

•        Location :       Location of asset.

•        Year of purchase:

•        Year of installation:

•        Life :       Life in years.

•         Allocation      :    CAP, OLWR, DF, DRF                                                        NA where not available.

  •  

 

Coding Structure (Contd.)

  • Quantity : As per units given in software
  • Location : Location of asset.
  • Year of purchase:
  • Year of installation:
  • Cost : Taken from record wherever available

Wherever the cost of Asset is not available in the records, cost has been interpolated based on the cost available for earlier/later years.

Where no cost detail could be located to interpolate, cost of asset has been entered as zero.

 

•Status code    :  As per Software    N - Normal

                           C-Condemned,   T-Transferred

•           Remarks:

•           Updation date :  Date when data was sent by the              stock holder.

 

 

COST OF ASSETS OF ENGINEERING DEPARTMENT        (5 GROUPS)

 

 

GROUP                        QUANTITY        TOTAL COST(Rs.)

 

 

BRIDGES                             15868           2020275833

 

BUILDINGS                       239590           3122026620

 

LAND                              38490016               93675111

 

TRACK                            96422044         16204429436

 

TRACK MACHINES              10320                    155711

 

 

TOTAL                                                     2144,05,62,711

 

 

 

 

COST OF ASSETS OF ELECTRICAL DEPARTMENT         (10 GROUPS) 

GROUP                        QUANTITY        TOTAL COST(Rs.)

AC COACHES (Equipments)          317                         24845044

 

EMU                                               1091                     4024216241

 

GENERAL                                        958                        366527471

 

POWER SUPPLY                          4339                         236894113

 

TRD (Equipments)                      2417                         907410134

 

BG AC GOODS LOCO                     444                       9851700000

 

BG AC MIXED LOCO                      126                         896900000   

 

BG AC PASSENGER LOCO               49                       1161800000

 

AC-DC LOCO                                    65                                           0

 

DC LOCO                                          59                          271149706

TOTAL                                                     1774,14,42,709

 

 

 

COST OF ASSETS OF MECHANICAL DEPARTMENT       (63 GROUPS)

GROUP                     QUANTITY     TOTAL COST(Rs.)

AIR COMPRESSOR                294            63006866

AXLE SHOP MACHINES             48            37682385

BAND SAWS                      15             1374639 

BEARING EXTRACTOR               1              138063 

BORING MACHINE                 30            21410332

COACH , BEML- MANN BOGIE       19             3562000

COACH,ICF TYPE (END-ON GEN)    51            60260000

COACH,ICF TYPE(SELF GEN)     2680          5845478200

COACH, IRS DESIGN(SELF GEN)    57              790000

COIL SPRING MANUF M/Cs         24            77991575

CRANES                       514             257729065

DG SETS                       17                904950

Diesel Crane (BG)             30             122314000

Diesel loco (BG)             665            6424123000

Diesel loco (NG)              41             264618000

DMU (BG)                       6              78000000

Diesel Rail Bus(BG)            1               2400000

DRILLING MACHINE             215              31641260

DYNAMIC BALANCING MACHINE      9               1381390

ELEC ARMATURE

ELEC COMMUTATOR MACHINES      20              20710454

ELECTRICAL MACHINES           79               4572557

ELECTRICAL TESTING MACHINES   16                921874

FORK LIFT TRUCKS              69              34796497

FURNACES                      86               7608929

GAS CUTTING                   25               3096753

GRINDING MACHINES            279              27288256

HAMMERS                       46              37241339

HEAVY DUTY UNIVERSAL           9              21007601

IMAGE SCANNING                 1                 35280

JACKS LIFTING                240              18370948

 

MACHINES                       5                130435

LAMINATED SPRING MANUF        57              33695358

LIFT                           6               1643342

MILLING MACHINES              43              12268570

MISCELLANEOUS M & P          995             128546994

PAINTING EQUIPMENT            22              14412134

PLASMA CUTTING                14               1608574

PLATEFORM TRUCKS             119              36840537

PRESSES                       72              25095742

PRINTING MACHINES             10                286916

RERAILING EQUIPMENTS          18              18946125

RESCUE DEVICE                 10               2722850

SHEARING MACHINE              55              26570178

SPECTROMETERS                  1               3422302

Steam Crane - Broad gauge     36               8020212

STRAIGHTENING MACHINE         12              10986586

SURFACE PREPARATION MACHINES  18               6705089

TESTING EQUIPMENTS           153              34748688

THREADING MACHINES            11               2235056

TRAVERSERS                     7              13475134

VACUUM EXHAUSTER             141               8318021

VEHICLES                     104              30216902

VERTICAL TURRET LATHE          8              28406797

Wagon BG 4 wheeler          5399             400606013

Wagon BG 8 wheeler         21541            6894396848

WASHING PLANT                121              24079229

WEIGH BRIDGES                  6               2815177

WELDING MACHINE              591              22076896

WHEEL LATHES                  20             259858772

WHEEL PRESS                    5              16644086

TOTAL                                                   2154,02,44,526

 

 

 

 

 

 

COST OF ASSETS OF S & T DEPARTMENT      (15 GROUPS IN SIGNALLING & 13 GROUPS IN TELECOM)

GROUP                     QUANTITY     TOTAL COST(Rs.)

SIGNAL

AUTOMATIC SIGNAL ASSETS       230              31662237

BLOCK WORKING EQUIPMENTS     1559             102008073

CARRIERS                       22                749390

CONTROL EQUIPMENTS           3379               4552423

GATE INSTRUMENTS            15137             313733576

LEVER FRAMES                 5821             258657021

PANEL INTERLOCKING ASSETS     179             207263633

POINT EQUIPMENTS            21772             537203228

POWER SUPPLY ASSETS         92638             194016512

RELAYS                     150493            538075120

RRI   ASSET                   119            349576742

SIGNAL ASSETS               49881            276551247

TRACK CIRCUIT EQUIPMENTS    54280           1102331002

TRANSMISSION MEDIA ASSETS   54648           2121038158

TELECOM

CONTROL ROOM EQUIPMENTS      3324             25185617

EQUIPMENT FOR DRVR-GD & TFC 20970            118279215

EXCHANGES                   27936            138940198

MULTIPLEXING EQUIPMENTS       186              73866780

OPTICAL FIBER CABLES          949             223670224

OVER HEAD WIRES              9173             102184285

PA SYSTEMS/PASS. AMENITIES   9966              75164890

POWER PLANT EQUIPMENT       10518              65361907

RADIO EQUIPMENTS              505              54289091

TELEPHONE CABLES            79224            3238499326

TESTING MEASURING INSTRUMENTS 409               7840600

WAY STATION EQUIPMENT        5829              47656110

 

TOTAL                                                        1021,32,01,189

 

 

 

 

TOTAL COST OF ASSETS IN CENTRAL RAILWAY 

DEPT.                                               TOTAL COST(Rs.)

ENGINEERING DEPARTMENT                2144,05,62,711

 

ELECTRICAL DEPARTMENT                   1774,14,42,709

 

MECHANICAL DEPARTMENT                  2154,02,44,526

S & T DEPARTMENT                                 1021,32,01,189

 

SECURITY  DEPARTMENT                                75,78,286

MEDICAL  DEPARTMENT                               5,38,15,385

STORES  DEPARTMENT                                 2,80,37,423

PRS/ C&IS                                                       25,19,40,906

 

 

TOTAL                                                   7127,68,23,135

 

 

 

 

COST OF ASSETS OF S & T DEPARTMENT      (15 GROUPS IN SIGNALLING & 13 GROUPS IN TELECOM)

GROUP                     QUANTITY     TOTAL COST(Rs.)

SIGNAL

AUTOMATIC SIGNAL ASSETS       230              31662237

BLOCK WORKING EQUIPMENTS     1559             102008073

CARRIERS                       22                749390

CONTROL EQUIPMENTS           3379               4552423

GATE INSTRUMENTS            15137             313733576

LEVER FRAMES                 5821             258657021

PANEL INTERLOCKING ASSETS     179             207263633

POINT EQUIPMENTS            21772             537203228

POWER SUPPLY ASSETS         92638             194016512

RELAYS                     150493            538075120

RRI   ASSET                   119            349576742

SIGNAL ASSETS               49881            276551247

TRACK CIRCUIT EQUIPMENTS    54280           1102331002

TRANSMISSION MEDIA ASSETS   54648           2121038158

TELECOM

CONTROL ROOM EQUIPMENTS      3324             25185617

EQUIPMENT FOR DRVR-GD & TFC 20970            118279215

EXCHANGES                   27936            138940198

MULTIPLEXING EQUIPMENTS       186              73866780

OPTICAL FIBER CABLES          949             223670224

OVER HEAD WIRES              9173             102184285

PA SYSTEMS/PASS. AMENITIES   9966              75164890

POWER PLANT EQUIPMENT       10518              65361907

RADIO EQUIPMENTS              505              54289091

TELEPHONE CABLES            79224            3238499326

TESTING MEASURING INSTRUMENTS 409               7840600

TOTAL COST OF ASSETS IN CENTRAL RAILWAY 

ITEM                                                                                          TOTAL COST(Rs.)

TRACK                                                       1620,44,29,436

 

BUILDINGS                                                  312,20,26,620

BRIDGES                                                      202,02,75,833

LOCO-MECH                                                676,91,41,000

LOCO-ELEC                                               1218,15,49,706

CARRIAGE                                                   631,51,36,454

WAGONS                                                      733,19,20,062

EMU                                                               402,42,16,241

S & T                                                            1021,32,01,189

OTHERS (MECH,ELEC, RPF  ETC.)            300,12,51,483

 

TOTAL                                                   7127,68,23,135

 

 

 

 

 

COMPARISON OF ASSET REGISTER DATA WITH BLOCK ACCOUNT                                                    (Rs. In Crores)

                     C              CF       DF       DRF    OLWR   TOTAL

Block A/c         3139       887    711       1455       86    6280

on 31-03-2000

Asset Reg    3142       837      38       2523     246  7127**

** Includes Rs. 280 cr of Leased Assets and Rs 62 crores for which Allocation is not available .

 

If Leased Assets are excluded, the variation is 9.08 %, which is acceptable considering the fact that there are 1,28,577 Data Items. Further some data of OLWR and NA pertains  to Assets created out of Revenue. Some data may also pertain to 2000-01, as Data Entry was done between July and December 2000.

 

THANK YOU