Karnataka State Beverages

BUSINESS SITUATION

Huge volume of Data to synchronize, limited bandwidth.

The core activities of the Karnataka State Beverages Corporation Ltd.(KSBCL) are to procure liquor and spirit from manufacturers/suppliers and sell the same to wholesalers/licensees. Thus data consolidation from the 53+ branches at the HO was an important and required task. Also daily corporate MIS / DSS had to be generated. Thus a system to manage their business processes covering these tasks apart from Finance, Sales & Distribution, Purchasing & Inventory modules was the need of the hour.

CHALLENGES

Key challenge was to provide a system which is easy to use due to the nonavailability of skilled operators & lack of tech skill at the branches.
No broadband connectivity at many of the branches, even the dial-up connections present were weak. Huge volume of data from all the branches had to be synchronized at the HO, with this infrastructure, on a daily basis. (1000+ transactions from each branch daily)
To deploy the complete solution in less than 3 months elapsed time.

TECHNOLOGY AND TOOLS

PROFIT 5RM 6.2
P5 Sync Server/Client
Microsoft .Net Framework, ASP .Net, VB .Net, C#
Oracle 10g
Delphi
Microsoft Windows Server 2008
Linux

SOLUTION

Implemented the following modules:

Financial Accounting:

Apart from Depot updating the central server this module at HO is also been used for making regular financial accounting entries like – Payment / Journals / Contra / Debit – Credit Note etc …

Vendor Payment

Calculates – Brand wise , Supplier Wise , Item Wise Sales Quantity
Picks the Purchase Rate based on Sales Date and Calculates the Purchase value supplier wise
Adjustment towards excise duties and other recoveries
Generates suppliers / Bank Wise Advice for transfer of Funds

Demurrage Calculation

Calculates – Age of Stock more than 90 days
Applies Demurrage rate per case item wise , supplier wise where ever applicable

Pricing

Basic Declared Price – Excise + Additional Excise Duty is calculated
Margin is added and KSBCL Purchase and selling Price is derived
MRP of Retailer Per Bottle is Calculated o Purchase
Based on weekly payment module a detailed report of Purchase value is generated
Interface for entering Purchase Voucher

OFS / TON

3rd party generates the Order for Supply [ OFS ] and provides it to our database which is converted into actual data and sent through synchronization to respective depot
TON Interface is provided between depots
On approval the document is populated to both Send / Receive depots.

Sales

Generation of Sales Indent after confirming the availability of Items
Checklist for Loading [Materials]
Generation of Invoice – After validating the availability of Funds in Party Accounts and calculation of TCS [Tax Collected at Source]

BENEFITS

Online information available to stakeholder

Excise, retailers, manufacturers, and government
Information highway opened to manufacturers

Basic & Consolidated view at HO of all depots

Sales
Inventory
Purchase
Receipts
Payments
Financial Accounting

Accurate & Online inventory information

Decision-support MIS on Supplies, stock movement and fund management

Issue OFS (order for supply) with digital signature over the web.