Project Specification Automation of Cylinder Booking, Delivery

1
Project Specification Automation of Cylinder
Booking, Delivery Customer Identification/Transa
ctionsUsing RF Card MODULE Version 1.1
Wednesday, 10 March2008
Guntur LPG Sales Area
2
HP Gas
Your Friendly Gas
Table of Contents
1. Introduction
1.1 Purpose 1.2 Main Modules 1.3 Intended
Audience 1.4 Key Performance
2. Refill Booking System
2.1 Present Refill System and Problems 2.2 The
Proposed RF Card System 2.3 Benefits Of Proposed
System
3. Delivery System
3.1 Present Delivery System and Problems 3.2 The
Proposed RF Validator System 3.3 Benefits Of
Proposed System
3
4. Transfer of Customers
4.1 RFID Applications 4.2 RFID Reader
Components 4.3 RFID Validator Components
5. RFID Technology
5.1 RFID Applications 5.2 RFID Reader
Components 5.3 RFID Validator Components
6. System Functional Flow
6.1 Flow Charts RFID Reader Flow Chart 6.2
RFID Validator Flow Chart 6.3 Existing and
Proposed Technology 6.4 Reports and Screens
7. Conclusion
7.1 Business Proposition 7.2 Support
4
1. Introduction
1.1 Purpose

• This document highlights the manual process
  involved in the present system and the problems
  faced.
• It provides a solution to automate the whole
  system and minimize redundancies, waste of
  resources/time.
• It describes the detailed design of the proposed
  RFID Module that can be adopted for Customer
  Transactions.

1.2 Main Modules

• Automation Of Refill Booking with RF Reader
• Automation Of Delivery with RF Validator
• Automation of TV OUT/TV IN

5
1.3 Intended Audience

• This document is intended as a reference of the
  RFID project for HP Gas Management staff/ HPGAS
  Distributors, Showroom Staff,Customers.

1.4 Key Performance

• System Process Change/Enhancement.
• Customer Innovation.
• System procedural Integrity.

6
2. Automation Of Refill Booking with RF Reader
2.1 Present Refill System

• Consumer is allotted a new connection or
  reconnection on payment of deposit.
• Book the refill order via telephone/manual.
• The refill is delivered on seniority based on
  availability.

• Problems
• Deposits are refunded every time on transfer.
• Refill booking can be done only during office
  hours.
• System not transparent as delivery confirmation
  is not available to Dealer nor Customer.
• Stationary is utilized Whenever customer
  transfers to new place.
• No Unique Id to Customer all his lifetime/thus
  not loyal.

7
2.2 Proposed RF Card System

• Allot new RF Card to consumer with a unique 10
  digit ID , local dealer specific consumer number
  pasted on RF card.
• Set RF Readers at Vantage points to read the RF
  consumer card any time.
• Alternatively Consumer books his refill order by
  showing his RF card to the RF Reader kept at
  Vantage points.
• RF Reader validates the card and if valid,
  Consumer can see the order number displayed on
  the screen a SMS is send to his Cell phone.
• If order is already booked, then corresponding
  message is shown on the RF Reader screen.
• At the time of delivery consumer shows his RF
  card to RF Validator which confirms delivery of
  Domestic Refill uploads to HPGAS software
  package at Day end.

8
2.3 Benefits of Proposed RF Card System
9
HP Gas
Allot card to new Consumer.
HP Gas
RF Card
Dealer
Consumer
10
3. Automation Of Delivery with RF Validator
3.1 Present System

• On the day of delivery the bills are printed.
• Delivery boy collects all bills and goes to
  customer.
• He manually enters the details in the DGCC.
• At the end of the day Show room Staff manually
  enters the day-end delivery data into the HPGAS
  software .
• Distributor believes that his Delivery Staff has
  delivered Refill to genuine Customer.

• Problems
• The day-end process is done manually taking
  2-3hrs everyday.
• Day end prone to Human errors.
• There is no guarantee that gas is delivered to
  the right person.

11
3.2 Proposed RF Validator System

• The staff prepares the daily area wise delivery
  data for delivery boy.
• The daily delivery data is directly uploaded from
  the HPGAS Software to RF Validator.
• The delivery boy reaches customer Residence. The
  RF Validator reads the RF card and validates.
• If the card number is in the list of deliveries
  for today, time stamp with successful entry is
  recorded.
• If invalid card then invalid card entry is
  recorded with time stamp.
• The delivery boy brings back the RF Validator and
  uploads the delivery data from validator to the
  HPGAS software.
• A report for day end deliveries is printed on the
  spot.

12
3.3 Benefits of Proposed RF Validator System
13
HP Gas
Delivery boy reach to Consumer home.
Delivery Boy
Consumer home
14
HP Gas
Consumer card validation
Validation Successful.
15
HP Gas
Consumer card validation
Invalid Consumer No
16
HP Gas
Delivery Report

• HP Gas
• --------------------------------------------------
  -------------------------------
• Date 24/09/2007 Delivery Boy Name J. Shekar
  ID E52104
• --------------------------------------------------
  -------------------------------
• Sr.No ID C.Name Area
  Place Validation Time
• --------------------------------------------------
  -------------------------------
• E51026 M. Venkat Arundelpet Guntur
  fail 1020AM
• E52024 K. Pandu Pedakakani Guntur
  Success 1105AM
• E51236 T. Kumari J.D. Nagar Guntur
  Success 1210PM
• E56222 S. Sujatha Arundalpet Guntur
  fail 1245PM
• E52100 B. Sivasyam Balanagar Guntur
  fail 0115PM
• --------------------------------------------------
  --------------------------------

17
4. RFID Technology
4.1 RFID Applications

• RFID stands for Radio Frequency Identification.
• RFID system consists of a card and a reader.
• In India applications of RFID include Employee
  Tracking, Products Tracking at Factory, Vehicle
  Entry/Exit Parking Management and in hospitals.
• For example, China has completed issuing each
  citizen with a national ID- RFID card.
• RF Cards require no internal power source, they
  are only activated when a reader is nearby to
  power them.

RFID Usage Growth
18
4.2 RFID Reader Components
RFID Cards
RFID Card Reader

• Technical specification
• RFID Reader Can read 125KHz RFID cards up to
  20cm wide and is wall mountable.
• Wide voltage range The readers can run on any
  voltage from 5 to 12.5 VDC.
• Externally programmable interface.
• RFID Cards 125KHz, EM compatible64 bits, ASK
  Manchester coding.
• Weather resistant.

19
4.3 RFID Validator Components
RFID Validator
USB Data Cable

• Technical Specification
• USB Interface Full compliance with the USB
  Specification V 1.1. The device uses a Virtual
  Serial Port Driver, making it appear to have the
  software like a standard RS232 Serial Port.
• LCD Display LCD type is FSTN. Dot arrangement is
  101 x 67 Dots Matrix LCD Module. Viewing
  direction is 6 Oclock.

20

• Technical Specification (continued)
• CLOCK Real Time Clock (RTC) module and back-up
  capacitor.
• Memory Size CMOS Serial Flash Memory 512K bytes
  Up to 8192 records ( 32 Bytes / Record)
• Battery Power Once fully charged, it stands for
  3 days. Single-cell alkaline, nickel-cadmium
  (NiCd), or nickel-metal, hydride (NiMH) battery.
• Power Supply USB Powered.
• Dimensions L 58 x W 20 x H 47 mm
• Environment
• Operating Temp 0 55 C grade
• Storage Temp -10 60 C grade
• Humidity 10 90 relative
• Data Access There are 2 levels of access to the
  PCR120. User and Supervisor. Supervisor
  level is protected by a Password. Sensitive data
  can be downloaded or altered only on the
  Supervisor level. General Terminal data is
  available on the User level as well.

21
5.1 RFID Reader Flow Chart
START
Consumer shows his RFID card to RFID Reader
RFID Reader reads the card Number
RFID Reader connects to HPGAS Database
CONTINUE
22
Is Consumer No existing in Consumer Table?
No
Yes
RFID Reader LCD displays Invalid Consumer No
Check Consumer No in Booked Order Table
Is Consumer No existing in Order?
Yes
No
RFID Reader LCD displays Order Is Already
Booked
CONTINUE
23
Collect required fields in Consumer Tbl, Param
Tbl and RefOrder Tbl
Pass new entry to RefOrder Tbl
RFID Reader LCD displays Order Confirmed. Number
is 3621
STOP
24
5.2 RFID Validator Flow Chart
START
Staff connects to HPGAS Database
Select required area
Select consumers who needs refill booking for
that day
Connect the RFID Validator to PC
Download all the consumers list data from PC
CONTINUE
25
Delivery Boy reaches the consumer home
RFID Validator reads the consumer card
Is Consumer No existing in list?
No
Yes
RFID Reader LCD displays Invalid Consumer No
RFID Reader LCD displays Valid Consumer
Record the time and success entry for the
consumer No
CONTINUE
26
Delivery boy comes back to dealer
Staff connects to HPGAS Database
Connect the RFID Validator to PC
Select upload option to transfer data from RFID
to PC
Generate Day-End report data
STOP
27
5.3 Existing Technology

• Existing system is developed in FoxPro. This
  system is used for designing front end
  applications.
• It is not suitable for embedded technologies.
• Developing embedded with FoxPro needs third party
  components which makes the system slow.

Proposed Technology

• Java is Platform Independent (Operating System
  independent)
• Java has built in RFID Software components.
• Java can communicate very efficiently with
  existing FoxPro Database.
• Java is free to use and is open source. Java
  supports networking which can help to share data
  in future.

28
5.4 Reports and Screens

• The list of consumers who booked refill gas thru
  RF Reader.

29

• Produce area wise consumer list for delivery by
  selecting Copy To Validator radio button.
• Copy bills data to RF Validator using Bills Copy
  To Validator button.

30

• Connect the RF Validator to PC and copy the day
  end delivery data to PC.

31
6. Conclusion
6.1 Business Solution/Process Improvement/Customer
Innovation

• RFID system eliminates all the manual work
  points in the gas distributorship and simplifies
  the booking and delivery process.
• Benefits of using RFID include the
• Unique HPGAS ID to a customer.
• Simplification of business process.
• Elimination of delivery inaccuracies.

• It provides an opportunity to grow business by
  handling the large consumer base.
• No mistakes in data entry at delivery process.
• The new refill system is accessible round the
  clock for consumer.

32

• The new system allows existing business to
  withstand the competition in the market.
• The automation of whole booking and delivery
  system leads to an overall business process
  improvement.

6.2 Support
Raman IT Software Hardware Design Support.
Implementation Pilot test done for 500
consumers at M/s.Chandra Gas Distributors ,HPGAS
distributorship at Guntur.
33
RFID Card
RFID Cards with Data
34
To be ImplementedPaperless /Nil Deposit
Refund Transactions on TV OUT.
Consumer Transfer Out Flow Chart
START
Consumer requests for transfer from city1 to
city2
Consumer deposits his equipment with dealer in
City 1
Dealer verifies consumer details against RF Card
Produced
CONTINUE
35
Is Consumer Data Valid?
No
Yes
City1 dealer transfers his details to Central
server ,No deposit refund
Stop Transfer
Staff connects to server
Post from-city, to-city, consumer-data and
dealer-data to server
Pass new entry to Transfer Tbl
CONTINUE
36
Consumer comes to city2
Consumer shows city1 RF card to city2 dealer
Verify consumer data on server
Confirm Transfer from city1
Yes
No
Dealer allots Equipment, Sticker with Local
Cons.No. is pasted on RF Card, Customer deposits
transferred from Server to Dealer Account
Stop transfer
STOP
37
 
Thank You