Smart Gujarat Hackathon 2017
Challenge Statement

 


Name of the Department: Ports and Transport Department

 

 

Challenge Title
( Must be one liner)

:

Online Store and inventory management

Challenge Description with context
(At least one Paragraph)

:

Ability to record and maintain item master list with availability of material number/code/part code as primary identifier for various material types including spares and consumables. Ability to generate material code automatically for item entry to item master as well as support manual entry. Ability to support alphanumeric material codes. Ability to capture detailed material information including the categories of data to support core material management transactions like goods receipt, goods issue etc.Ability to support item groups or categorization of material into material groups, type and location etc. Ability to support approval workflow and automatically trigger material data authorization upon material data entry. Ability to modify material details and resubmit for approval. Ability to track material authorization status pre and post approval. Ability to track changes made to material record with details of changes made, changing entity and approver of changes. Ability to reject material record and update material record status with Reasons. Ability to record whether material is moving or non-moving or obsolete delete a material record which are non-moving, obsolete. Ability to link material to vendor / supplier details. Availability of search functionality based on material numbers, wild card entries, partial item description, warranty period, specifications, etc. Ability to display partial or full material master information to users across functional areas and restrict display of all information based on user roles/display authorization levels. Ability to support multiple Units of Measure(UoM) for an item. Ability to create catalogues for different material types, spares and miscellaneous items. Ability to capture details regarding insurance of the materials. Ability to record multiple physical store locations, capturing individual store physical description details. Ability to record and track inventory status for Turnkey Contracts (these stocks are not held in WBSETCL stores, but materials are recognized by issuing SR and immediately transaction is completed by issuing SRV to Contractor). Ability to track and monitor stock at various store locations Central Stores , Area Stores, Sub-station Stores, at individual store level and at aggregate level. Ability to plan for inventory based on consumption pattern, present stock, procurement lead times, projected requirements etc. Ability to perform various kinds of inventory analysis like ABC analysis, XYZ analysis, Fast/Slow/Non-moving analysis, Min-Max analysis, etc. Ability to analyze inventory in terms of 'items reached re-order/ safety level' and 'critical' items and generate appropriate alerts when inventory reaches predefined re-order points. Ability to store shelf life details for items and display alerts when items reach end of life (user defined) and remains un-used. Ability to store material movement history in each store and for each item e.g. fast, slow moving and non-moving. Ability to classify inventory based on various inventory analysis like ABC Classification, etc. for various actions e.g. Stock taking, Criticality etc. Ability to classify inventory under bulk material, finished goods, capital items, job work and disposables. Ability to assign a service level to an inventory item e.g. 100% for critical items and this will be linked to re-order levels

What Exact Problem is being Solved?

:

 

Users

:

 

Expected Outcomes

:

1.        Data entry should be made for all material accordingly our requirement

2.        No material can be enter in DR without data entry

3.        Material entered in Daily Receipt should be automatically entered in Purchase register as well as in respective ledger. Material entered in Issue Note should be automatically enteredin Issue register as well as in respective ledger.

4.        Search of material can be made either material name wise or

5.        part no. wise

6.        Daily receipt No. & Issue note No. should be generatedautomatically.

7.        Fast moving materials should be identify differently.

8.        Rare utilizing materials should be identify differently

9.        Not utilizing materials should be identify differently

10.      Out of fast moving materials, any material becomes zero balance should be indicated

11.      Out of rare utilizing and not utilizing material already in store balance, if same is purchase should be indicated

12.      Above mention reports should be generated automatically Balance material list should be only view by all port store through inter connectivity

13.      Purchase register and Issue register of all port store should be only view by HO

14.      Store keeper can only enter the data, can view all records and can generate all reports but cannot edit quantity, rate or amount of DR & Issue note

Impact

: