The applications of mobile wireless communication on the inventory process for large-scale market

illnurturedtownvilleΚινητά – Ασύρματες Τεχνολογίες

21 Νοε 2013 (πριν από 3 χρόνια και 11 μήνες)

85 εμφανίσεις

The applications of mobile wireless communication on the inventory
process for large-scale market2
Po-Hsian Huang
¤
Department of Computer Science and Information Engineering4
Yuanpei University
No.306,Yuanpei Street6
Hsin Chu 30015
Taiwan,R.O.C.8
Abstract
Most of shopping Malls used wickers to understand the storage effectively.Through10
wickers enter the product numbers;finish collecting product amount to handle the storage
effectively and exactly.This way not only could make down storage but also could12
understand product on list of storage situation.It could use information from collecting to
analyze benefit or lose for a section.14
There are many kinds of products in shopping mall.Checking is not easy in it,therefore,
nowadays shopping mall use stock management for using pens and papers or information16
collect machines to check product numbers,and then sending information to information
systemto save and antithesis,it’s not to promote efficiency and accuracy.So,if we could use18
wireless network to process manage and check for products.We believe that it should be
promote products manage effectively.20
Keywords and phrases:Shopping mall,storage management,wireless network.
1.Introduction22
For developing more effect manage and control to the large-scale
markets in goods.In research,we hope through wireless communication24
[1] to record stock value,and then return information to the server to
understand every stock condition of analysis and estimation sales value26
or using in other field in reduce stock manage and goods manage cost
and raise competition power.In research,we hope using PDA [9] to28
develop checking information framework and building systemfor system
¤
E-mail:phhuang@mail.ypu.edu.tw
——————————–
Journal of Information &Optimization Sciences
Vol.( ),No.,pp.1–15
c
° Taru Publications
2 P.H.HUANG
design [2].And then,we using this system framework to test staffs and
managers in large-scale in satisfied value and this systemfit large-scale to2
do stock check or not.In research objective,we hope could build wireless
communication to build wireless communication checking assignment4
system and framework.And through interview staffs and managers in
large-scale markets to understand wireless communication fit to using6
in it or not.We also hope it could be done reference by using wireless
communication in conducting and building in other industries.8
2.RFID(Radio Frequency IDentification)
RFID (Radio Frequency IDentification) is an embedded tag with could10
shoot frequency chip.It could storage thousand of A4 size script infor-
mation and could active send out the message.Let sensors around it in12
one thousand meters could receive it.According TIME magazine reported
in October,20.Before,grocery stores often in short supply with popular14
goods,but markets and manufacturers are the last know.In market is
always with every kind of goods.In management goods is also a very16
hard work,and the degree of accuracy and efficiency is the key to
promote.Besides,if all markets request all supply chains have to use RFID18
to do the tags in products to do products supply login.Not only could
affect products cost or freight process,but also could promote products20
checking efficiency.
The RFID research teams in Industrial Technology Research Institute22
according foreign report.In WAL-MART consume two thousand mil-
lion wickers in a month.Wickers was be found in 1973,although ever24
with someone develop two-dimension wickers and three-dimensional to
strengthen products.But according estimation,the world wickers encode26
rules will consume in tow years.If there is no more best identify system
be develop.The busy interflowof commodities,retails and manufacturers28
by wickers will into trouble.
2.1 Using RFIDin goods management30
By developing RFIDfunction.In the future,every products will with
RFID tags on it,every goods shelves will install sensors,when products32
left shelves into shopping cart,RFID on the products will action inform
shelves that products was left,and shelves will sent message to the34
computer in the market.The market could understand products direction,
INVENTORY PROCESS FOR LARGE-SCALE MARKET 3
arrange replenish the stock and avoid steal.Customers just prepare credit
cards when they shopping,when they leave market,RFID will through2
sensors in shopping cart and market to count all price and quantity.There-
fore,we hope to research about using RFIDto manage goods in the market4
[10] to build goods management system.And research maybe happen
problems and must to think factors for using RFID to manage goods in6
the market for do thinking in developing RFIDmanagement systemin the
future.8
2.2 Using RFIDin goods management could reach effect
Using RFID to manage products could replace wickers.Because of10
RFID could record large number data,and could use wireless to sent
information.So,it could raise effect on interflowof commodities and retail12
sale.Goods quantity can be recorded by RFID.The information [13] can
be sent and return to server to understand stocks management on every14
specified time.Sever is also could analyze and forecast sales volume or
other field to reduce stock management cost and product management16
cost,and reduce market competitive power.
3.Research method18
3.1 Research method
In this search,it uses research method that is Nuamarker (1991) to20
bring up.It is a systemdevelops research method in information field.Its
objective to verify through a set careful method to solves general formula22
or statistics to process model and framework.Final,using build model
system to the case to process model and framework discuss.We plan24
that after produce research object and then start to collect about wireless
communication related reviewand research.After building model system26
[7],we will use this model system to produce related questionnaire,
processing questionnaire,interview to the managers,staff in the market28
to estimate model system operation condition,and this model system
feasibility study.Final,we will get questionnaire result to analyze become30
research method.And then bring up this framework in large-scale and
other retails to process stock checking feasibility study direction.Its steps32
follow building concept framework,developing system framework,ana-
lyze design system,building model system,and observing and estimating34
system.
4 P.H.HUANG
3.2 Model systemanalysis
After discussing about systemframework and function to the advis-2
ers,we could understand the stocking with goods and checking goods for
the large-scale market that including planning checking sheet,processing4
delivery goods,and receiving information analysis.After collecting this
information,we could analysis complete system needed and planning6
mobile wireless communication checking homework framework.
Due to PDA is very light and handy and easy to support developing8
pattern tools.Using ADSL to do the transmission style could reach
high effect.Therefore,in this research,we bring up a set new checking10
stocks system through PDA [6] and ADSL to collect and transmission
information to the Server in the company.By connecting PDA and Server12
in this research,we use wireless to do the transmission style.The
framework [8,11,12] that uses mobile wireless communication lists in14
Figure 1.
16
Figure 1
The framework to mobile wireless communication
3.3 Estimation effect18
After this research to build a checking stock system for adopt large-
scale market.We believe it sure to supply large-scale market an effect20
system to manage stocks.This research should be done consult on other
industries to using wireless communication.22
4.Systemestablish
4.1 Systemanalysis24
After discussing with related field adviser could be known that large-
scale for replenishing stocks and checking stocks procedure and work-26
ing.Including checking sheets planning,delivering goods procedure,
INVENTORY PROCESS FOR LARGE-SCALE MARKET 5
receiving information analyze,stocks checking in the market,checking
timing plan...etc.After marshaling this information,we could analyze2
more complete system needed and plan framework for the wireless
communication [5].4
Due to PDA is very light and handy.In supporting developing
pattern tools is very popular and easy.Therefore,this research hope6
through PDA and local wireless communication combine to connect the
server with company.And then,there are many kinds of PDA and Server8
connect ways.In this research,we plan to use wireless to the transmission
mode.Besides,this systemdoes not limit any timing;proprietor could set10
their checking point to checking stocks.
PDA could download deliver information,and return difference for12
checking by local wireless communication network to check the deliver.
And checking quantity could be done sale analyze and sale difference for14
the server.At the same time,using local wireless communication network
could return data to the server right away.It could strengthen information16
effectiveness.
4.2 Systemdesign18
In this research,we plan to use belowtools to procedure systemdesign:
1.
Tools20
(1)
Software
I.
Pattern develop tools,eMbedded Visual Basic 3.022
II.
Behind Server database,SQL Server 2000
III.
Information access way,Remote Data Access24
(2)
Hardware
I.
PDA:Compaq iPAQ26
II.
WLAN:Hinet ADSL
III.
RFID28
2.
Information procedure way
(1)
Using SQL Sever CE Database Engine on PDA to record exchange30
information content,until PDA and SQL Sever connect,and then
process information upload.32
(2)
Using SQL Sever CE Clint Agent on PDA to manage any RDA
actions.All RDA pattern through this component to access SQL34
Server.
6 P.H.HUANG
(3)
SQL Server CE Server Agent is under IIS.After it receive request
from SQL Sever CE Clint Agent,message will through OLE DB2
Provider return to the SQL Server,SQL Sever is the same as CE
Clint Agent.Both of their communication agreement are HTTP to4
access information by push,pull,and SubmitSQL.
3.
Systemfunction6
System main function could difference new goods stocking,checking
stocks every day,processing information delay,inquiring stocks,setting8
system.
The main function for this system are new goods into stocking,10
checking daily,delay information processing,stock checking,system
setting.The model systemframework is list in Figure 2.12
Figure 2
The framework of model system
14
(1) New stock into socking
Users through this function to download delivery sheets and using16
connect inward all items,delivery information to the PDA.Final,pro-
cessing compare.The systemalso supply new checking into stocking old18
checking into stocking information to the server to understand really sale
amount and stock amount.The function is shown in Figure 3.20
INVENTORY PROCESS FOR LARGE-SCALE MARKET 7
(2) Checking daily
After checking,system will through ADSL to return result to the2
Server in the company.The part of checking sheets,due to limit to the
monitor of PDA.For harmony with typeface,it just put ten items in4
monitor,and using turn pages to spread out many items.The function
is shown in Figure 4.6
Figure 3
Newstock into socking
8
Figure 4
Checking Daily
10
(3) Delay information processing
If net won’t connect,PDA could process information through it,it12
includes Download delivery sheets,Return checking sheets.The function
is shown in Figure 5.14
8 P.H.HUANG
Figure 5
Delay information processing
2
(4) Stock checking
According to this function could understand nearly checking stock4
amount,and one of goods could be sent from Server in the company or
not.The function is shown in Figure 6.6
Figure 6
Stock checking
8
(5) Systemsetting
System setting include connect information,User ID of SQL Server,10
User password of SQL Server.The function is shown in Figure 7.
INVENTORY PROCESS FOR LARGE-SCALE MARKET 9
Figure 7
Systemsetting
2
5.Interviewand information analysis
5.1 Questionnaire design4
In this research,we plan to use this system to process the interview
and questionnaire to the staffs and managers to know system func-6
tion and adopt reality working deeply.We plan to analyze situation in
questionnaire nowadays and process question design questionnaire for8
understanding systemsatisfied,pushing effect factors.
The interview and questionnaire to the staffs and managers in the10
market is designed in the research.Table1 and Table2 showthat question-
naire design and explanations.In part of managers’ items were presently12
condition,system satisfied and carry out factors.In part of staffs’ items
were systemsatisfied and interface design factors.14
Table 1
Interviewcontent for the managers
At present situation
Question
number
Question design
compose
Items explain
Question 1
Checking
working way
Understanding checking stocks working way,
and howto collect every shelf to marshal and
collect
Question 2
Deliver situation
Understanding delivers time every day to
count and estimate transmission cost
Question 3
Checking cycle
Inquire stock checking and time to the man-
agers
(Contd.Table 1)
16
10 P.H.HUANG
Systemsatisfied
Question 1
Coordination in
working flow
Understating wireless communication check-
ing framework coordination working proce-
dure nowadays or not
Question 2
Satisfied in
collecting
information
Understanding model system to supply col-
lect information for business to use or not
Question 3
Combine in
formal infor-
mation system
Understanding wireless communication
adopt old server or not
Question 4
Security pass-
word and limits
of authority man-
agement
Understanding set security or limits of au-
thority management
Question 5
Transmission
information and
encryption
Understanding business respect to the trans-
mission information secretly
Question 6
Satisfied to the
model system
Understanding business satisfied to this
model systemand framework
Question 7
Accept for the
RFID
Understanding managers satisfied to use
RFIDin checking assignment
Question 8
Reduce artificial
repeat import
Understanding business using wireless com-
munication checking work could reduce arti-
ficial repeat import procedure mistakes
Question 9
Benefit to use this
system
Collecting business think that this system
and wireless communication checking work
framework could provide benefit
Carry out important factors
Question 1
Accept for recom-
mend
Understanding business accepts to build sys-
tem and wireless communication checking
work framework cost
Question 2
Accept for trans-
mission
Estimating business transmission cost,and
accept to the transmission in peacetime
Question 3
The way for
Import
Understanding business think that wireless
communication checking should adopt one
time overall import,phase import,or demon-
strate
Question 4
Import bottleneck
for
import
Understanding import this system maybe
met trouble
Question 5
Needed and
assistance for
managers
Understanding imports this systemthat man-
agers should have some characteristic in his
own
Question 6
Adjust for organi-
zation culture
Understanding imports this systemthat busi-
ness should adjust his own organization cul-
ture
INVENTORY PROCESS FOR LARGE-SCALE MARKET 11
Table 2
Interviewquestionnaire content to the staffs
Satisfied to the system
Question 1
Accept for work-
ing
flow
Understanding wireless communication
checking assignment in this research de-
sign could coordination working flow
nowadays
Question 2
Accept for system
response time
Understanding accepts to the staffs with
response in this system
Question 3
Accept for infor-
mation trans-
mission
Understanding accepts to the staffs with
information transmission time
Question 4
Accept for PDA
weight
Understanding the weight with PDA
could affect staffs process checking as-
signment
Question 5
Accept for the
entirety
Understanding staffs satisfied this sys-
temor not
Question 6
Accept for the
RFID
Understanding staffs satisfied to use
RFIDin checking assignment
Question 7
Promote for
expect checking
efficiency
Understanding staffs to use this system
promote expect checking efficiency
2
The part of managers in questionnaire framework that use wireless
communication to check assignment framework and analyze their de-4
mand,needed to replenish its insufficient.The part of staffs,in question-
naire framework using Likert five point quantity table to choice one of6
“very agree”,”agree”,”general”,“not agree”,”very not agree”.Choice
“very agrees” could get five units;choice “agree” could get four units,8
choice “general” could get two units,choice “not agree” could get two
units,choice”very not agree”could get one unit.Final,we count their10
average and standard error.
5.2 Interview object and interview result12
We process interviewand questionnaire to the staffs and managers in
the large-scale each three markets in north,middle,and south of Taiwan14
to understand wireless communication feasibility study in this research.
Through nine Taiwan large-scale markets [3,4] process interview and16
questionnaire.Their essential information list in Table 3.
12 P.H.HUANG
Table 3
Interviewobject essential information
Large-scale markets in Taiwan
Object
Area in Taiwan
Branch store
Capital
Staff total
Company A
North
17
1 billion
170
Company B
North
15
1.5billion
190
Company C
North
54
2.5billion
210
Company D
Middle
21
21.7billion
195
Company E
Middle
54
2.5 billion
210
Company F
Middle
15
1.5 billion
190
Company G
South
17
1 billion
170
Company H
South
54
2.5 billion
210
Company I
South
21
1.7billion
195
2
Interview result could be component two parts.One of them was
processing interview with the managers in the large-scale market.The4
other part of them was processing interview with the staffs in the large-
scale market.Their interviewresult list Table4.6
Table 4
Interviewwith managers in the large-scale
No.
Question
Result
At present analyze
1
The way to check-
ing assignment
These large-scales markets all use tradition paper
and write to record products quality or use infor-
mation collector
2
Delivery stocks
quality
Every large-scale market was with difference de-
livery stock quality
3
Checking cycle
Most of large-scale markets checking cycle pro-
cess checking cycle were every day
Satisfied to the system
1
Coordination to
working flow
All large-scale markets all think that this model
system could coordination formal work proce-
dure
2
Accept to use
RFID
Using RFIDto manage stocks could be accept
3
Combine with
formal system
One of the with four using information systemto
manage stocks.And it could accept this system
(Contd.Table 4)
8
INVENTORY PROCESS FOR LARGE-SCALE MARKET 13
4
Security password
and limits of
authority manage-
ment
Business hopes that staffs could use their staff
code name and password to login this system
5
Transmission infor-
mation encryption
Some of large-scale markets support encryption to
manage stocks
Because of it could avoid sale situation and data be stolen.
6
Satisfied to the
model system and
framework
All large-scale markets think this model system
could bring up their checking working efficiency
7
Reduce artificial
repeat import
All large-scale markets think this model system
could reduce mistakes be made
8
The benefit to use
this system
Using this model systemcould bring up manage-
ment efficiency in large-scale markets
9
Using RFID could
bring up checking
stock efficiency
Using FRID could bring up management effi-
ciency for checking stock working
Carry out important factors
1
Accept for
transmission cost
Estimating business transmission cost,and ac-
cepts to the transmission in peacetime
2
The way to import
system
Understanding business think that wireless com-
munication checking should adopt one time over-
all import,phase import,or demonstrate
3
Import bottleneck
for import
Understanding import this system maybe met
trouble
4
Needed and assis-
tance for managers
Understanding imports this systemthat managers
should have some characteristic in his own
5
Adjust for organiza-
tion culture
Understanding imports this system that business
should adjust his own organization culture
6.Conclusion2
Nowadays,using RFID on cheap goods is not economic but using
RFID sure could bring up checking stock management.Through this4
research,we found some discovery:
1.
Using wireless communication in large-scale markets really could6
bring up checking stocks management.
2.
Using RFID to the products tags coordination wireless communica-8
tion really could bring up stocks management in large-scale markets.
14 P.H.HUANG
In research processing interviewand questionnaire to the large-scale
markets could procedure some result.But this research maybe not adopts2
import in other field.It could process import in other field to research its
result.And electric wave interfere wireless communication is also could4
research and design more not interfere environment.The most important
is that wireless communication using in the large-scale markets checking6
stock management systemcoordination RFIDto the tag systemshould be
developed in the future.Because of this systemwill bring much economic8
beneficial result.
References10
[1]
J.Li and Z.R.Zhang,WAP Wireless Webpage Making Practice,Flag
Publish Company,2005.12
[2]
D.Z.Chen,The research that using PDA action business system
to reduces the requirement forecasting error to regard consuming14
the articles in people’s livelihood as the example,Master’s Thesis of
business institute of National Taiwan University,2001.16
[3]
L.F.Zhu,The way that domestic enterprises channel into ERP
system probes into and takes IC manufacturing industry as an18
example,Master’s Thesis of information management of National
Chengchi University,2000.20
[4]
F.G.Ke,The discussion of groups supports and develops imple-
ments of the key factor systematically,Master’s Thesis of Information22
Management of Tamkang University,1998.
[5]
W.F.Cai,From the wireless network applications to study 802.11a,24
The Network Communication Magazine,November,2001.
[6]
Y.G.Guo,PDA interface information transmits and the relation26
of works efficiency,Master’s Thesis of Communication of National
Chiao Tung University,2001.28
[7]
G.C.Xu and R.Sun,Bluetooth Technology,Wu-Nan Publish Com-
pany,2005.30
[8]
W.Curtis L.Sinton (1999),Securing the Global,Remote,Mobile User,
International Journal of Network Management,pp.9–21.32
[9]
R.Hoffman,Keeping PDAS in sync,Network Computing,pp.115–117,
2001.34
[10]
P.Kolter,Marketing management:Analysis,Planning,Implementation
and Control,Prentic-Hall,NewJersey,pp.563,1997.36
[11]
J.R.Nunamaker,J.F.Chen and T.D.M.Purdin,Systems develop-
ment in information systemresearch,Journal of Management Informa-38
tion System,1991.
INVENTORY PROCESS FOR LARGE-SCALE MARKET 15
[12]
R.S.Poore,????,Information Systems Security,Vol.11 (5),pp.4–9,
2002.2
[13]
U.Varshney,Location management support for mobile commerce
applications,in Proceedings of the 1st International Workshop on Mobile4
Commerce,p.2,2001.
Received January,2008;Revised June,20086