e-procurement web application prototype for automotive...
TRANSCRIPT
li'
E.PROCUREIT{ENT WEB APPLICATION PROTOIYPE FOR
AT'TOMOTTVE INDUSTRY
CHOI,ATISSM4
Vili [tr] a,oumip, &irm sux $s
of
tirufi gtllr urd'u mnltr urfru r.r fi sra
A THESIS SI]BIIflTTED IN PARTIAL MoF Tm REQUTREMENTS FOR
THE DEGREE OF MASTEROF SCIENCE
(IECHNOLOGY OF II\TFORMATION SYSIEM MANAGEMENI)
FACT'LTY OF GRADUATE STT]DIES
MAHIINL I]NTI/ERSTTY
2002
rsBN 974-044227-6
COPYRIGHT OF MAHIDOL T]NTVER,STTY
3 r 00T 2002 I
I
TH
C It+X L&o0L
\,\\ f""r
, )''(e,
Copyright by Mahidol University
Thesis
entitled
E.PROCTIREMENT WEB APPLICATION PROTOTYPB FOR
AUTOMOTTVE INDUSTRY
Ufueklr.Cholatis Srikanttrimarak
Candidate
44.
Prof, Nuttawan Yoswaftam,
Prof. Liangchai Limlomwongse, Ph-D
D@nFaculty of Gradtrate Studies
../1M,Assoc. Prof, Monfihee ChilasamaYa,
Ph.D., N{.D.Co-Advisor
Lect. Thanakom Uan-on, D.FnS.ChairI\[aster of Scie,lrce Programme inTechnology of Information SYstem
N{anage,ment
Facuhy of Engineering
lJ* (;)1'l-*...-.-...--,.._
.........../.....
i
Ph"D.
N{ajor-Advisor
Copyright by Mahidol University
tThesis
eNrtitled
o
E.PROCTIREMENT WEB APPLICATION PROTOTYPE FOR
AUTOMOTI\TE II\IDUSTRY
was s$mitted to the Faculty of Graduate shrdies, Naahidoluniversiry
for the degree of lvlaster of Science
(Techology of Infotmation Syste'm lvlamgemetr)
on
w26,2002
/ d-trr-l-Mr. Cholatis SrftatrhimarakCandidate
hof Nuttawan Yoswathana,
Ph.D.Chair
o
J:lHProf Liangchai Limlomwongsg Ph.DDeanFaculty of Graduate StudiesIvlabidol University
a
........ n.. "..*.'--1f..**.#d'"^'Assoc. Prof. Monthe Chiasanaya'Ph^D., M.D.MemberPu:Mr. Rushpan Panchatree, N{.Sc.
Member
Lect. Thmakorn Uan-on, D.Engr.
DeanFaculty ofEagineeringIvtuhidol University
Copyright by Mahidol University
I
o
ACKNO1VLEDGEMENT
I would like to express my sincere gratitude and deep appreciation to Asst'
Prof, Nuttawan Yosurathara, Assoc. hof. Monthree Chulasamaya' my research
advisorso for their valuable advice, supervision, gUidance, encouragement' &lld
reconmendation, which enabled me to carry out this research zucces$rlly. They were
never lacking in kindness and zupport.
Moreovetr, I wish to thank all of my friends for their encouragement
thnoughout this study. In particular, I would like to tbank Mr. Rushpan Panchatee,
Network Engineer of General Electronic Cornmerce Services Co.,Ltd., wbo gives me
usefut ffirmation and strggestion for E-procurement. All the conrments and
suggestions are veryuseful iniryroving the developed system.
Finatly, the merit of this paper is dedicated to my parents and teachers uihose
inspiration has nurtured my life and knowledge.
Cholatis Srikanthimarak
a
aCopyright by Mahidol University
ThsiJivFao. of Grad. Studiesr lvlahidol Univ'
o
.o
o
o
4I36I32EGTI/1VI ! MAJOR : TECHNOLOGY OF INFORMATIONSYSTEM MANAGEMENT ; M.Sc' (TECil{OLOGY o['INFORMATION SYSTEM MANAGEMENT)
KEY WORDS : E.PROCT]REMENT /DELTVERY ORDER/ESTIMATEORDER / ACTUAL SHIPPING NOTICE /AUTOMOTTVE INDUSTRY
CHoLATIS SRIKANTHIMARAK : E.PRoCI]REMENT wEB
APPLICATION PROTOTYPE FOR AUTOMOTTVE INDUSTRY' THESIS
ADVISORS : IrIUTTAWAN YOSWATHANA, Asst Prof' Ph'D.o
iwox-rgRpu CHTILA5AIVTAYA, Ph.n., M.D., RUSpAN PANSHATREE'
M.Sc., 99 P.ISBN 974444227-6
IMajor problems of data exchange btween automotive Odginal
Equipment frfu"'if*too. (OEVIS) an{ their zuppliers is the delay of tansfer data
and loses of data that occus tom using faditional system such as the FAX In a
[ryrtitir" perio{ theV reevaluate theirlorporate structures in order to reduce the
,"drry*r" qrrairy *A io.,*"" productivity. This thesis aims to study, arralyses,
;;;ie ;rd develop an E-procurenent web application prototlpe for automotive
in61[fti. fnir p.ototype uses the Internet us tne channel in cornmrmication The
;;t"Ep" Aevebffit was based on the analysis of OEMs and suppliers
i"q"irir""ts in orOer to too* the excbangeable data and all reports that are used in
this business.The prototlpe was developed by using the firndame'ntal of the
Software Development Life Cycle (SDLC)'fn" **lt of ihis
'ttoay is a prototlpe of e-procurement web
application, whioh is provided for agtomotive industies. There ffs main firnctions
itiri"aiog Detivery order, Estimate Order, Actuat Shipping Notice (4st't1, Web-'
toara ia wortirg calendar. This prototlpe works properly via Internet and
supports tasks fromboth of OE\[s and suppliers'
Copyright by Mahidol University
ThcidvFac. of Grad" Sfirdies' lvlahidol Univ.
o
o
a
o
4136[32EGTIA[ :crtlem:rnnlulailomffoomtsuualtffitms; ?n'il'
0nnlulallnffi ffo R"lttsuuart6urilfl )
raG a sii ffarfi ursnd, ruudmo{tsuu o'lt ffo ds6 16 0n tofi nlo s
ftlrunturlruqneidrunrqfiu drnsultsllunantssud 1n-PROCUREMENT WEB
APPLICATION PROTOTYPE FOR AUTOMOTM INDUSTRY) n u s
Rrrttfl1:n?uqru?nurfinud : a|grttar sstlqturAsst Prof. Ph.I)., fiunt qacfis'
Ph.I)., n.u., Yrfiu{ fiu{trofi, ?il.t|. 99 mr?r. rSBN 97+a4'2227-6
ilq nrudn ro{R t,,rafl rildou {oqanr: H6o lc ?rdrlfrru6n',ooud(OUVft
fiufif,orirflorqau6ooarrurir#rtunr:drdoryauasfilsqq14rutot{ouad,firdro'to5silu
ruirniu udndrfludu lunrasdfinr:urirduqt riofi^Arttutflfrnritfinr:rliulo:sa$Nsqr{
n:rdoasduqu rliurlqqil:sfimr^nlo uur,fiuil?urunr:nfirr SYrsrfinudoriu{ifiqnEit
laail il.t s tu o f, R u 1 ? rn i 1s # o o n uu u ua s r{or u r: su u du uu u n r : fln do 6tf; n m : o u^ n I o s
Iil:un:url:vqndniruvrrutu drniulrwrun6o:auud loe,t#duroofrfi odudotnrqluA , i I .a!--.-.^&--,^. a .1 -----! I t o 9v-
R1iflqoodod.lr 5uililfiulmuflflu1tu0'rRfllt?m:rsfinaru6osRr:{otll4tlffHantlaufl0o
ciq rdodorvrtrudt{oqafifi o1r,,un,rJduuf,u u$oildas:rusrueirsllunr:t#tru
nrrr{murduuuudrndrrd, rfi unrruudnRr:qlot Software Development
Life Cycle (SDLC) flanr:e^f,uds:suudurrllllRlif,odo6rf;nvr:ofinInsItJrttflsll
rJ : v gn d d 1 #aru iu I: r{ r u na'n : n u u d ds il I v n ou hJ da ufl t d#u u dnl 6o tu dq fi u dr
@elivery Order), tuilrcil r$ 6ru:u n r: dttu dr @stimate Order), to narsdu fru nlcds
fi u dr (Actual Shipping Notice: ASN), r6u uo fn uavrl 6^fi u nu rirt ru, r m d' "" d
rirmuld6nirumrtdutsro#r{|fl uac: ouiusrur,{uvrrsfl tfrarfio uau fifloris
Copyright by Mahidol University
cCONTENTS
ACKNOWLEI}GEMENT
ABSTRACT
LIST OF TABLES
LISIT OF FIGI]RES
CHAPTER
I INTRODUCTION
1.1 Backgrormd and Statement ofProblems
1.2 Objective of StudY
1.3 ScoPes ofStudY
1.4 StePs of StudY
1.5 ExPected Results
tr LITERATIIRE REVIEW
Page
lll
tv
ix
x
o
1
I
2
a2.1 Business Review:
2.1.1 Supply Chain and Logistic lvlanagement
2. 1.2 Just-in-Time lvlanufrcturiag
2. 1.3 Definition of Procueme,lrt Concept
2.2 TechnicalReview:
2.2.1 OpnDatabase Connectivity (ODBC)
2.2.2 T.}r;er"-Tier Software Architectue
2.2.3 Active Server Pages (ASP)
2
3
4
t
5
5
8
11
15
15
19
2toCopyright by Mahidol University
vtl
a
CHAPTER
CoNTENTS (CONT.)
Page
2.3 Related Research:
2.3.1 Business Models for Internet-based E-procurement
Systems and B2B Elecrfionic Markets: An Exploratory
Assessnetr
RESEARCH METHODOLOGY 24
3.1 Steps and ResearchMethodology 24
3.1.1 CollectingRelatedlnformation 24
3.1.2 Anal1larrgSYstem 25
3.1.3 DesigPing SYstem 30
3.1.4 DeveloPing SYstem 31
3.1.5 Testing and Improving System. 34
RESI]LTS 35
4.1 Designing Resuhs 35
4.1.1 User Interfrce Design (First Tier: Web Semro) 35
4.1.2 Application Design (Second Tier: Application 35
Serner)
22
22
o
o
a
4.1.3 Database Desip (Third Tier: Database Server)
4.2 Development Results
4.2.1 Supplier Sestion
4.2.2 OEIll.[ Section (Adminisratofl
DISCUSSION
5.1 Shengths
u45
45
65
7t
78Copyright by Mahidol University
vn
aCoNTENTS (CONT.)
CHAPTER
5.2 Weaknesses
5.3 The Benefits of an E-procurement Web Application Prototlpe
for Automotive Industries
VI CONCLUSION AND RECOMMENDATION
O 6.1 Conclusion
6.2 Recornmendations
REFERENCES
APPENDD(
A MEAI\IING OF FMLD IN DELIVERY ORDER
B ALL REPORTS TYPE
BIOGRAPHY
Page
81
82
83
83
84
E6
88
90
99
o
oCopyright by Mahidol University
oLIST OF TABLES
Table 4.1
Table 4.2
Ertimate Order LaYout
Delivery Order LaYout
Page
37
38
o
o
oCopyright by Mahidol University
o
o
Figure 2.1
X'igure 2.2
Figure 2.3
Figure 2.4
Figure 2.5
Figure 2.6
Figure 2.7
Figure 3.1
Figure 3.2
X'igure 3.3
Figure 3.4
Figure 3.5
Figure 3.6
Figure 3.7
Figure 3.8
Figure 3.9
Figurc 4.1
Figure 4.2
Figure 4.3
LIST OT'FIGI]RES
The logistics network
Pwchasing process model and some related concepts
Wew of the ODBC intedace
ODBC biver Configwation I
ODBC Driver Configwation 2
ODBC Driver Configwation 3
Three tier s distributed client/serter architectwe
System Darclopment Life Cycle Diagram
Flowch.ort for entering to application
Flowchan for wpplier qpli cation
Flowchan for automottve O E M application
Architecfire design
First Tier
Second Tier
Third Tier
Web Application Flow Control
Data Flow Diagrom of File Handling Process Level0
Dats Flov, Diagram of File Handling Process Level I(Check Integrity)
Data Flow Diagrarn of File Handling Process Level I(Sep arate file s for e ach supplier)
Page
5
13
16
t7
18
t9
20
24
27
28
29
30
32
32
33
34
40
4l
M
o
oCopyright by Mahidol University
xl
o
Figure 4.4
Figure 4.5
Figure 4.6
Figure 4.7
Figure 4.t
Figure 4.9
Figure 4.10
Figure 4.11
Figure 4.12
Figure 4.13
Figure 4.14
Figure 4.15
f igure 4.16
Figure 4.17
Figure 4.18
f igure 4.19
Figure 4.20
Figure 4.21
Brgure4.22
Figure 4.23
Figune 4.24
Figure 4.25
Figure 4.26
Lrsr oF FTGTIRES (CONT.)
List of memtftmctionfor both OEM and &rpplier
Home page of e'Ttroarementweb application
Home pagewith error rnessqge
Web boardfimaion afier wpplier login
No reply message
Message thot has to rePlY
Colendm -visu, by month
Calendar -view by Year
Order Instraction function
Weu, content in delivery order textfile
Downloadtextfile
Select report Wefor generate reports
Report that generated ofter click daa $pe button
There is no dato type to generate report
Today parts delivery function
Est mote Arderfimction
Wstv content in estimate order textfile
Dowriload estimqte order textfile
Generate reportfrom estimate order textfile
Actrul Shipping Notice function
Fill irwoice number and specify delivery quantities
Confirmation page ffier submit ASN
Cancel iwoicefunction
Page
43
45
46
46
47
48
48
49
50
50
51
52
53
53
o
a54
55
55
56
56
57
58
58
59
oCopyright by Mahidol University
oLIST OF FIGTIRES (CONT.)
Confinnotion page of cancel irwoiceft'mction
Port Claimfunction: select due date
Port Claim function: vieilt reruh
The Automotive Pwt Information fimction
The Automotive Part Infonnation fmction: seorch by
lceyword
The Change Password function
Theweb poge afier change Password
Web boord after login as admin
Post New Message
Detail of message andrePlY message
&tb-fiincti on of UPdate Cslendor
Display all non'working day of each comPony
Add new non-working daY
Editnon workingday
Delete non-working doY
Yicvv culendor
Sub-function of Supplier Infonnation
Displry all supplier irformotion
Add New Supplier Information
Edit Supplier Information
Delete Supplier Information
Wew &ryplier Information
xll
Page
60
61
X'igure 4.27
Figure 4.28
Figure 4.29
Figure 430
Figure 4.31
Figure 432
Figure 433
Figure 434
Figure 435
Figure 436
Figure 437
Figure 43E
Figure 4.39
Figure 4.40
Figure 4.41
Figure 4.42
Figure 4.43
X'igure 4.44
f igure 4.45
Figure 4.46
X'igure 4.47
Figure 4.48
61
62
63
o 63
64
6s
66
65
67
68
69
69
70o
o
70
7l
72
73
73
74
74Copyright by Mahidol University
xiii
a
['igure 4.49
Figure 4.50
f igure 4.51
Figune 4.52
Lrsr oF FTGTIRES (CONT.)
Actusl ShipPing Notice for admin
File Stafixftmction
Wew detail of textfile
Download tqtfile
Page
75
76
76
77
o
o
aCopyright by Mahidol University
aFac. of Grad. Studies, Mahidol Univ. M.Sc.(Tech. of Inform. Svs. Manag.) / I
CHAPTER I
INTRODUCTION
1.1 Background and Statement of Problems
Over the last 100 years, the automotive industry has created products which
are too complex. The design cycle times are simply too long for response the
consumers' ever-changing requirements. The challenges which are created by the
complex market and consumer trends have forced automotive Original Equipment
Manufacturers (OEMs) to further pressure their supply base to assemble more
automobiles, whereas cost of production is reduced,
Supply chain management is a main concept to improve operation through
continually advanced collaboration with suppliers. For many years automotive OEMs
have pressured their supply base continually to reduce costs. They used Just-In-Time
(JIT) philosophy applied to purchasing in order to exactly make the required materials
at exactly the time when they are needed, so that the value is added only to the product
that is to be manufactured, and indirect costs are avoided.
The JIT approach is characterized by regular and constant quantities which
are delivered frequently such as several times delivery in a day. To achieve this, the
supplier is kept inform of the production planning and related purchasing requirements
on a daily or weekly basis. In this way, suppliers are able to anticipate on automotive
OEMs' future requirements. Hence, they will be able to plan their production and
material requirements more effectively.
o
a
oCopyright by Mahidol University
oCholatis Srikarthimarak lntroduction / 2
Previously, there are 2 methods that suppliers can receive orders from OEM.
Firstly, telephone, fax or messenger delivery is used for transfer orders to suppliers.
This method takes a long time and may have error from accuracy of data. Secondly,
the classical EDI allows only point-to-point connections between the OEM and big
suppliers. They require the dedicated EDI servers and necessitate costly program
developments. Therefore, only the bigger suppliers able to connect by using this
system.
For that reason, Internet technology is an important role to reduce the
problem which suppliers confront. Therefore, automotive OEMs use Internet to
integrate their supply chain and support two-way communication of data. This method
increases transfer speed of data, reduces the cost from EDI and the error from
paperwork.
1.2 Objective of Study
To design and develop the E-Procurement Web Application Prototype for
automotive industry both automotive OEM side and supplier side.
1.3 Scopes of Study
The scopes of this study are as follows:
(t) Use the simulation data because the company's data is privacy.
(2) This research consist of the business function below:
- Estimate Order (Forecast automotive parts requirement) - send
automotive parts requirement for next three month to supplier
o
o
oCopyright by Mahidol University
aFac. of Grad. Studies, Mahidol Univ. M.Sc.(Tcch. of lnform. Sys. Manag.) / 3
- Delivery Order (Automotive parts requirement) - send automotive
parts requirement for 4 day to I week to supplier before
production line begin
- Actual Shipping Notice (ASN) - supplier send confirmation back
to automotive OEMs
- Web Board - two-way communication for automotive OEMs and
suppliers
- Working Calendar - inform working day of automotive OEMs
(3) Report printing from Web application
1.4 Steps of Study
(1) Collect related information
Supply Chain Management concept
Just-in-time concept
Procurement of automotive manufacturing concept
Work flow of automotive manufacturing
Related research
(2) Analyze and design
(3) Develop application
(4) Testing and implementation
(5) Conclude and recommend
(6) Generate research document
o
o
aCopyright by Mahidol University
aCholatis Srikanthimarak
lntroduction / 4
1.5 Expected Results
The outcomes of this thesis will be "E-Procurement Web Application
Prototype for automotive industry" that enables two-way communication for
automotive OEMs and supPliers.
a
a
eCopyright by Mahidol University
aFac. of Grad. Studies, Mahidol Univ. M.Sc.(Tech. of Inform. Svs. Manag.) / 5
CHAPTER II
LITERATURE REVIEW
This research involves both business review and technical review. This chapter is
classified as following:
2.1 Business Review
2.1.1 Supply Chain and Logistic Management [11
Supply Chain Management
Supply chain management is a set of approaches utilized to effrciently
integrate suppliers, manufacfurers, warehouses, and stores, so that merchandise is
produced and distributed at the right quantities, to the right locations, ancl at the right
time, in order to minimize systemwide costs while satisfying service level
requirements.
\tarc.houses anddis(rii)utj(r[ ((rttr]ril
o
I'la.trulacturr:rr'
,.- - *-*!ry'e
(-lrrst'trrrcrs
o
Iln\...rttlory costs
Figure 2.1 the logistics networka
-cur-'lil ic-rs
'..@Copyright by Mahidol University
aCholatis Srikanthimarak
Literaturc Review / 6
This definition leads to several observations. Firstly, supply chain
management takes into consideration every facility that has an impact on cost and
plays a role in making the product conform to customer requirements; from supplier
and manufacturing facilities through warehouses and distribution centers to retailers
and stores. lndeed, in some supply chain analysis, it is necessary to account for the
suppliers of suppliers and the customers of customers because they have an impact on
supply chain performance.
Secondly, the objective of supply chain management is to be efficient
and cost-effective across the entire system; total systemwide costs, from transportation
and distribution to inventories of raw materials, work in process, and finished goods,
are to be minimized. Thus, the emphasis is not on simply minimizing transportation
cost or reducing inventories, but rather, on taking a system approach to supply chain
management.
Finally, because supply chain management revolves around efficient
integration of suppliers, manufacturers, warehouses, and stores, it encompasses the
firm's activities at many levels, from the strategic level through the tactical to the
operational level.
Logistics Management
Logistic management is the process of planning, implementing and
controlling the effrcient, cost effective flow and storage of raw materials, in-process
inventory, finished goods, and related information from point-of-origin to point-of-
consumption for the purpose of conforming to customer requirements.
Both definitions place greit emphasis on the integration of the
different components in the supply chain. Indeed, it is only through supply chain
a
o
oCopyright by Mahidol University
aFac. of Grad. Studics, Mahidol Univ. M.Sc.(Tcch. of Inform. Sys. Manag.) / 7
integration that the firm can significantly reduce costs and improve service levels.
Unfortunately, supply chain integration is difficult for two main reasons:
l. Different facilities in the supply chain may have different,
conflicting, objectives. For instance, suppliers typically want
manufacturers to commit themselves to purchasing large quantities
in stable volumes with flexible delivery dates. Unfortunately,
although most manufacturers would like to implement long
production runs, they need to be flexible to their customers' needs
and changing demands. Thus, the suppliers' goals are in direct
conflict with the manufacturers' desire for flexibility. Indeed,
since production decisions are typically made without precise
information about custorner demand, the ability of rnanufacturers
to match supply and demand depends largely on their ability to
change supply volume as information about demand arrives.
Similarly, the manufacturers' objective of making large production
batches typically conflicts with the objective of both warehouses
and distribution centers to reduce inventory. To make matters
worse, this latter objective of reducing inventory levels typically
. implies an increase in transportation costs.
2. The supply chain is a dynamic system that evolves over time.
Indeed, not only do customer demand and supplier capabilities
change over time, but supply chain relation ships also evolve over
time. For example, as customers' power increases, there is
increased pressure placed on manufacturers and suppliers to
o
a
oCopyright by Mahidol University
aCholatis Srikanthimarak Literature Rel'iew / 8
produce an enoffnous variety of high-quality products and,
ultimately, to produce customized products. Also, even when
customer demand for specific products does not \/ary greatly,
inventory and back-order levels fluctuate considerably across the
supply chain.
Just a few years ago, most analysts would have said that these two
objectives, improved service and inventory levels, cannot be achieved at the same
time. Indeed, traditional inventory theory is to increase service level, the firm must
increase inventory and therefore cost. Surprisingly, recent developments in
information and communications technologies, together with a better understanding of
supply chain strategies, has lead to innovative approaches that allow the firm to
improve both obj ectives simultaneously.
2.1.2 Just-in-Time Manufacturing [2-41
'Just-in-time' is a management philosophy and not a technique'
It originally referred to the production of goods to meet customer
demand exactly, in time, quality and quantity, whether the 'customer' is the final
purchaser of the product or another process further along the production line.
It has now come to mean producing with minimum waste. "waste" is
taken in its most general sense and includes time and resources as well as materials.
Elements of JIT include: Continuous improvement.
' Attacking fundamental problems - anything that does not add
value to the product.
' Devising systems to identifu problems.
a
o
oCopyright by Mahidol University
Fac. of Grad. Studies, Mahidol Univ. M.Sc.(Tcch. of Inform. Sys. Manag.) / 9
Striving for simplicity - simpler systems may be easier
understand, easier to manage and less likely to go wrong.
A product oriented layout - produces less time spent moving of
materials and parts.
Quality control at source - workers are responsible fc'r the quality
of their own output.
Poka-yoke -'foolproof tools, methods, jigs etc. prevent mistakes
Preventative maintenance, Total productive maintenance -
ensuring machinery and equipment functions perfectly when it is
required, and continually improving it.
Eliminating waste. There are seven types of waste:
Good housekeeping - workplace cleanliness and organization.
Set-up time reduction - increases flexibility and allows smaller
batches. Ideal batch size is litem. Multi-process handling - a
multi-skilled workforce has greater productivity, flexibility and
job satisfaction.
o
a
a
aCopyright by Mahidol University
aCholatis Srikanthimarak Litcrature Revicw / l0
Leveled / mixed production - to smooth the flow of products
through the factory.
Kanbans - simple tools to 'pull' products and components through
the process.
Jidoka (Autonomation) - providing machines with the autonomous
capability to use judgement, so workers can do more useful things
than standing watching them work.
Andon (trouble lights) - to signal problems to initiate corrective
action.
JIT - Background and History
JIT is a Japanese management philosophy which has been applied in
practice since the early 1970s in many Japanese manufacturing organisations. It was
first developed and perfected within the Toyota manufacturing plants by Taiichi Ohno
as a means of meeting consumer demands with minimum delays . Taiichi Ohno is
frequently referred to as the father of IIT.
Toyota was able to meet the increasing challenges for survival
through an approach that focused on people, plants and systems. Toyota realized that
JIT would only be successful if every individual within the organization was involved
and committed to it, if the plant and processes were arranged for maximurn output and
efficiency, and if quality and production programs were scheduled to meet demands
exactly.
JIT manufacturing has the capacity, when properly adapted to the
organization, to strengthen the organization's competitiveness in the marketplace
I
a
oCopyright by Mahidol University
aFac. of Grad. Studies. Mahidol Univ. M.Sc.CIech. of Inform. Sys. Manag.) / I I
substantially by reducing wastes and improving product quality and efficiency of
production.
There are strong cultural aspects associated with the emergence of JIT
in Japan. The Japanese work ethic involves the following concepts.
' Workers are highly motivated to seek constant improvement upon
that which already exists. Although high standards are currently
being met, there exist even higher standards to achieve.
t Companies focus on group effort which involves the combining of
talents and sharing knowledge, problem-solving skills, ideas and the
achievement of a common goal.
' Work itself takes precedence over leisure. It is not unusual for a
Japanese employee to work l4-hour days.
' Employees tend to remain with one company throughotrt the course
of their career span. This allows the opportunity for them to hone
their skills and abilities at a constant rate while offering numerous
benefits to the company
These benefits manifest themselves in employee loyalty, Iow turnover
costs and fulfillment of company goals.
2.1.3 Definition of Purchasing Concept [51
The purchasing function traditionally encompasses the process of
buying. It involves determining the need, selecting the supplier, arriving at a proper
O price, specifying terms and conditions, issuing the contract or order and following up
to ensure proper delivery. In short, the purchasing function should obtain the proper
a
o
Copyright by Mahidol University
aCholatis Srikanthimarak
Literatue Review / 12
equipment, material, suppliers and services of the right quality, in the right quantity' at
the right price and from the right source. In this description' the purchasing function is
regarded primarily as an operational activity'
In practice, as well as in the literature, many terms and concepts are
used in the area of purchasing. However, no agreement exists about the definition of
these terms. Terms like procurement, purchasing, supply and logistics management is
used interchangeablY.
Therefore definition of purchasing is the obtaining from external
sources all goods and services that are necessary for running, maintaining and
managing the company's primary and support activities at the most favorable
conditions.
The purchasing function in this definition covers the responsibility for
those activities aimed at
. Determining the specification (in terms of required quality and
quantities) ofthe goods and services that need to be bought
. 'selecting the most suitable supplier
. Preparing and conducting negotiations with the supplier in order to
establish an agreement
. Placing the order with the selected supplier
. Monitoring and control of the order (expediting)
' After-care and evaluation (settling claims, keeping product and
supplier files up-to-date in terms of documentation and ranking).
Figure 2.2 schematically illustrates the main elements within the
purchasing function. It shows that these activities are closely interrelated.
o
o
oCopyright by Mahidol University
aFac. of Grad. Studies. Mahidol Univ. M.Sc.(Teclr. of Inform. Sys. Manag.) / l3
The purchasing function does not include the responsibility for
materials requirements planning, materials scheduling, inventory management,
incoming inspection and quality control. However, in order to effective, purchasing
operations should be closely linked and interrelated to these materials activities.
Purchasing function
Tactical purchasing order function
oDetermining \ Selecting \ Conhactinospecification/ supplier / '
Expedisng \ After-careOrdering)and)and
evaluation/ evaluation
a
Figure 2.2 Purchasitlgprocessmodelandsonxerelatedconcepls: * (JSA' ** ' llK'
From definition of purchasing, it may be derived that this covers all
activities from which the company receives and invoice from outside parties' Hence
purchasing includes intercompany business, countertrade arrangements, hiring of
temporary personnel from out side agencies. However, many of the activities, for
which the company may receive invoices from suppliers, may be arranged for without
interference of the purchasing department. Therefore the scope of the purchasing
function is usually much broader than that ofthe purchasing department.
With the term ordering, it refers to the placing of purchase orders at a
supplier against previously arranged conditions. Furthermore, this term used when
purchase orders are placed directly, without questioning the supplier's conditions.
Call-off orders fall into this category as telephone orders for products bor'rght from a
supplier catalogue. Ordering is a part of the purchasing process. In fact, it relates to theo
Copyright by Mahidol University
aCholatis Srikanthimarak Literature Revicw / 14
last three steps of the purchasing process. On the other hand, the term 'tactical
purchasing' refers to the first three steps.
From Figure 2.2, procurement is a somewhat broader term. It
includes all activities required in order to get the product from the supplier to its final
destination. It encompasses the purchasing function, stores, traffic and transportation,
incoming inspection, and quality control and assurance. Some firms also consider
salvage and environmental issues as part of procurement. This task is expected to
become more important in future years, with the increasing impact of environmental
pollution.
It is diffrcult to find a description of buying in management literature.
It differs from purchasing in the sense that it does not encompass the first step of the
purchasing process. This term is most often referred to the practice of'trading and
retail companies (e.g. department stores). Here, discussions about the specifications of
products to be purchased are more limited when compared to industrial companies,
because of in many cases these products are defined by the supplier.
Another term often used in the materials area it is supply. This is
somewhat more difficult to grasp, because it appears that there are differences in
connotation between North America and Europe. In America 'supply' covers the
stores function of internally consumed items such as offrce supplies, cleaning
materials, etc. However, in the United Kingdom and Europe, the tenn supply seems to
have a broader meaning to include at least purchasing, stores and receiving. The
governmental sector also uses this broader interpretation.
A term that is becoming more popular in the materials area
sourcing. It includes the following activities under this term. finding sources
o
o
ls
ofo
Copyright by Mahidol University
aFac. of Grad. Studies, Mahidol Univ. M.Sc.(Tcch. of Inform. Svs. Manag.) / l5
supply, guaranteeing continuity in supply, ensuring alternative sources of supply,
gathering knowledge of procurable resources. Most of these activities relate to the
second step of the purchasing process, i.e. finding and selecting adequate suppliers.
2.2 Technical Review
2.2.1 Open database Connectivity (ODBC) [61
Open database Connectivity (ODBC) is a standard devised by
Microsoft to enable any application to communicate with any database manager. The
standard of ODBC is based on the work of the SQL-Access Group, a group of
interested hardware, software and networking vendors who defined a common
database access method to simplify client/server computing. A key objective of this
group was defined as an SQL syntax that could be con'lmon to all datahase engines.
Microsoft has taken the core set of the Group's output and developed a call-level
interface that it has called Open Database Connectivity (ODBC). Now, most key
database server vendors and the suppliers for many desktop products provide an
ODBC interface via which the end-user has access to centrally stored data directly
from the desktop products. With the leverage, Microsoft currently has on the market
place and ODBC dominates client/server database connectivity.
o
o
oCopyright by Mahidol University
aCholatis Srikanthimarak Literature Rwiew / 16
ODBC Architecture
Figure 2.3 View of the ODBC: interlace
Desktop Applications make calls to a standard Microsoft-supplied
DLL called the Driver Manager. This driver manager loads the appropriate database
driver and passes calls to it. The data is accessed in relational form by passing SQL
command strings.
There are two main types of driver, the single-tier clriver which
manipulates database files directly - typically drivers are used for native PC databases
e.g. xBase or Paradox; and multi-tier drivers which generate SQtr- requests to be
processed by the RDBMS server. The multi-tier drivers come in many forms, some of
which requiie the use of the database system vendor's networking software (e.g.
IngresA.{et or SQL*Net). The driver is a Windows DLL loaded by the ODBC driver
manager. This DLL passes the SQL request to the database vendors network software
that communicates with the network software on the host. This conFrguration is
illustrated in ODBC Configuration below.
i'.
o
o
tr
ODBC Driver Manager
Copyright by Mahidol University
Fac. of Grad. Studies, Mahidol Univ.
Desktop Ipplication
ODBC Driuer ManagerIngres GDBC lOracle CDEC
DrirrEr Driuer-aE5l dgtaBaseCDBC Eriuer
M.Sc.(Tech. of Infornr. Svs. Manag.) / 17
Desktoplrlarhine
DatahaseSenrer
o
o
Figure 2.4 ODBC Driver (lortfigtratiort I
Drivers using this configuration are the Oracle drivers fiom Microsoft
and Oracle, the Ingres drivers distributed by Computer Associates and the Data Direct
(Q+E) drivers from Intersolv. Other drivers do not require the database vendors
networking software. They have one or more components that run on the client
machine and there is a component that nrns on the database server.
o
oCopyright by Mahidol University
aCholatis Srikanthimarak Literature Rcview / lE
Typical configurations are illustrated below
Ilmktop Application
DmldoplVhc}ine
I I I r - l - -- r l a lDrtalFae*trrg
Figure 2.5 ODBC Driver (.onfiguration 2
This figure shows the configuration of IXl-Visionware's SQL-
Retriever. One particular advantage of this software is that only one driver is used on
the client, regardless of the number of database servers that connecting to its.
The Openlink configuration, ODBC compliant applications establish a
session with the generic ODBC driver. The request agent on the client establishes a
database session via the request broker on the host. The request broker spawns or
replicates one or more database agents and associates with the request agent. The
database agents are the only database specific components. These act as clients to the
database server processes of the relevant database. The Openlink configuration
supports multiple concurrent client applications through a single driver instance.
Configuration 3 shows the Techgnosis Sequelink configuration. It should be noted
o
o
ODBC Driver
oCopyright by Mahidol University
3Fac. of Grad. Studies, Mahidol Univ. M.Sc.(Tech. of Inform. Sys. Manag.) / 19
that Sequelink also provide access to the data using other proprietary APIs as well
ODBC.
Datah.ase$errer
o
o
Figure 2.6 ODBC Driver (.orfiguration 3
2.2.2 Three-Tier Software Architecture [71
The three tier software architecture (three layer architectunes) emerged
in the 1990s to overcome the limitations of the two tier. The third tier (middle tier
server) is between the user interface (client) and the data management (server)
components. This middle tier provides process management where business logic and
rules are executed and can accommodate hundreds of users (as compared to only 100
users with the two tier architecture) by providing functions such as queuing,
application execution, and database staging. The three tier architecture is used when an
effective distributed client/server design is needed when it is compare to the two tier,
increased performance, .flexibilily, maintainabiliryt, reusability, and scalability,
whereas hiding the complexity of distributed processing from the user
These characteristics have made three layer architectures a popular
choice for lnternet applications and net-centric information systems.
o
sEquELink API
Hort Sptmiselion snd Netrror& Seruite s
Copyright by Mahidol University
aCholatis Srikanthimarak Literahre Review 120
A three tier distributed client/server architecture (as shorvn in Figure
2.7) includes a user system interface top tier where user services (such as session, text
input, dialog, and display management) reside.
Three Tiers
User System Intedace
Process Management
Database Management
Figure 2.7 Three tiers distrihuted client,'server archilecture
The third tier provides database management functionality and is
dedicated to data and file services that can be optimized without using any proprietary
database management system languages. The data management component ensures
that the data is consistent throughout the distributed environment through the use of
features such as data locking, consistency, and replication. It should be noted that
connectivity between tiers could be dynamically changed depending upon the user's
request for data and services.
The middle tier provides process managenlent services (such as
process development, process enactment, process monitoring, and process resourcing)
that are shared by multiple applications. The middle tier server (also referred to as the
application server) improves performance, flexibility, maintainability, reusability, and
o
a
cCopyright by Mahidol University
aFac. of Grad. Studies, Mahidol Univ. M.Sc.(Tech. of lnform. Svs. Manag.) / 2l
scalability by centralizing process logic. Centralized process logic easily makes
administration and changes management by localizing system functionality so that the
changes must only be written once and placed on the middle tier server to be available
throughout the systems. With other architectural designs, a changeable function
(service) would need to be written into every applications.
The first tier receives requests from the Internet clients and generates
html using the services provided by the business layer. This additional layer provides
further isolation between the application layout and the application logic.
2.2.3 Active Server Pages (ASP) [E-91
An Active Server Page (ASP) is an HTIvIL page that includes one or
more scripts (small-embedded programs). The scripts are processed on a Microsoft
Web server before the page is sent to the user. ASP is somewhat similar to a Server-
Side Include (SSD or a common gateway interface (CGI) application that involve
programs run on the server and usually tailors apage for the user. Typically, the script
in the Web page that runs at the server received input as the result of the user's request.
Then, this input is sent through database and builds or customizes the page on the fly
before sending to the requestor.
ASP is a feature of the Microsoft Internet Information Server (IIS). It
is used for replace the traditional server-side scripts that just building a regular HTML
page. ASP file can be created by including a script written in VBScript or JScript in an
HTML file or by using ActiveX Data Objects (ADO) program statements in the
HTML file. The HTML frle is given name with the ".arp" file suffrx. Microsoft
o
o
aCopyright by Mahidol University
oCholatis Srikanthimarak Literature Review / 22
recommends the use of the server-side ASP rather than a client-side script where there
is actually a choice, because the server-side script will result in an easily displayable
HTML page. Client-side scripts (for example, with JavaScript) may not work as
intended on older browsers.
2.3 Related Research
23.T BUSII\If,SS MODELS FOR INTERNET.BASED E-PR.OCUR.EMENT
SYSTEMS AND B2B ELECTRONIC MARI(ETS: AN
EXPLORATORY ASSESSMENT [l0l
Information technology (IT) has long been applied to support the exchange
of goods, services and information between organizations. Early ofl, when
interorganizational inf,ormation systems (IOIS) Iike EDI systems were introduced,
electronic markets emerged for business purchasing. However, it is only with the
advent of Internel.-based e-procurement syslenrs and business-to-husine,ss (B2B)
electronic markets that the real opportunities for arry-to-any (A21t) online transactions
have opened up across space and over time. The extensive connectivity has been
offered by online trading networks creates value in lowering communication and
search costs. But this benefit is just an aspect that is desired by adopting firms. The
other aspect is that purchasing firms expect to maintain established long-term
relationships with preferred suppliers. As a result, privalc aggregating antl negotiating
mechanismr are being adopted for Iarge quantity business supply purchases while
public market mechcmisms are more often adopted by firms face uncertain and high
variance demand. This study draws on information system and economics theory to
o
a
aCopyright by Mahidol University
oFac. of Grad. Studies. Mahidol Univ. M.Sc.(Tech. ol-lnform. Sys. Manag.) / 23
investigate the motivation for the various online business models, and the adoption
requirements of purchasing firms, through the examination of a set of mini-cases.
o
a
oCopyright by Mahidol University
OCholatis Srikanthimarak Resarch Methodolory/24
CHAPITRIII
RESEARCHMETHODOLOGY
3.1 Steps and Resmrch Methodology
In doing application, steps and research methodologf are based on the
Softrnare Development Life Clcle (SDLC) consisting of the processes as shoum in
Figure 3.1 below.
Figure 3.1 System Darclopment Life Cycle Diagrmr
3.1.1 Collecting related infomation
In this step, the developer studies the existing system to find the
problem feasibility aud objectives sfthis research
The problem: The automotive industries are a lot of automotive parts
which have to acquire from suppliers. Some suppliers delivered parts for assembly in
several times a day. Therefore, automotive OEh[s inf,orm production plarming and
prnchasing requirement on a daily or weeHy basis to theh suppliers. The information
o
a
Copyright by Mahidol University
o
o
c
o
Fac. of Grad Studies, IMahidol Univ. I![.Sc.(Ttrh. of Inform. grs. Ivlanag.) / 25
to supplier is Telephone, Fax or Messenger delivery. There methods take a long time
and may occur the mistake in transferring data for planning theh production and
materials requirement. Moreover, their efects are the assembly plan and reliability of
coryany.
Obiective: The developme,nt of the e-procurement application
provides two-way corrrmunication between agtomotive OEIVIS and their suppliers. It
inchrdm forecast of material requirement @stimate Order), material requirement
bfore assembly line bgin (Delivery Order), delivery confirmation from suppliers
(Actual Shipping Notice), web board and calendar.
Data gathering: The datathat gafhered fromautomotive OEIVIs are:
- Estimate order text file layour thee-month forecasted data will be
send to zuppliers.
- Delivery order text file layout: 4-day to l-week in advance data
before assembly line begins.
- Actual Shipping Notice (ASN) text file layoufi delivery
confirmation from suppliers.
- Work flow of automotive manu&cturing.
- Format report from automotive OEIv[s.
3.1.2 Analping System
The analysis is the next step for identifying application It considers all
users inthe sJrstem. There are 2 types ofuser efthis application
. Supplier usenr
Copyright by Mahidol University
Cholatis Srikanthimarak Resqrch Methodology / 26
The zupplier usenl are responsible for receiving information such as
requirement (delivery order), informed message and working catendar from
automotive OEIvIs. Each srpplier receives information that differentiates. The
receiving information is essential for automotive OEItv(s. Therefore, the application
should be secured. Only the arrhorired person can aooess to the application as shoum
in figrre 3.2. After tbat zuppliers can access to system, modules that have been
granted is show:r in below (see Figure 3.3):
Estimate order module: this module can view, download estimate
order and print report from estimate order
Delivery order module: this module can view, download delivery
order andprint reports fromdelivery order
Actual Shipping Notice modulq this module can send delivery
confirmation (ASI9 back to automotive OEIVIs
Cancel order module: this module can cancel delivery
confirmation (ASN) in case ofthe mistake is happened
Web board module: this module can receive informed messages
from automotive OEIvIs and canreply ifthey specified
Calendar module: this module can view working calendar from
artomotive OEM
o An Automotive OEM user
The automotive OEM user is responsible to follow status of
delivery order that is sed to each supplier. The information of supplier zuch as status
for opeiring, status of downloading and detail in Delivery Order is shown to OEM
user. Therefore, the application has to secure. The user must have username andCopyright by Mahidol University
a
o
a
o Flowchart for entering to application
Fac. of.Grad, Studisr tvlahidol Univ.
a.
tvlSc.(teh. of Inform. Sys. Ivlanag.) / 27
password to a1ess. The modules that have been granted loy OEM user is shown in
below (see Fieure 3.4)
- File status module: this module can show the status of file such as
opene4 downloaded.
- Achul Shrpprng Notice module: this module can show ASN fiom
suppliers, which can be sorted loy zupplio
- Web board module: this module can post messages that require
answer or informed nrcssage to suppliers
- Calendar module: this module can view the working calendar and
ad{ update and delete non-working day into it
- Supplier Information module: this module can view
information of suppliers and adq update and delete
information of zupplier into it
Enter to supplier applicaUon
ves--rQ!
Enter to autornoWe OEIIIapplicaUon
Yes--)tt,
the
the
Figure 3.2
Copyright by Mahidol University
Reserch Methodolosr / 28Cholatis Srikanthimarak
s.rpplier appllcaton
No,fu,zselectWorHng\\ cals#'v/
No
.,,\/w,o*\( setectssumre )---Kry''
YNox
,a>..t( seect oeltvery)-\qer'9r
YNo
/N,"seleCemraN\.$rtpptre ttstce,/-
No
No
u:g"ut- )
X'igure 33 Flowchan for wpplier opplicationCopyright by Mahidol University
a
a
a
o
Figure 3.4 Flowchortfor automotive OEM a2rylication
Fac. ofGrad- Studis, I!fiahidol Univ. IvLSc.(Tech. of Inform. Sp. lvlanag.) / 29
aubmotive OEIvI applicaUon
Copyright by Mahidol University
o
a
a
o
Cholatis Srikanthimarak R€s@rch Methodolory/ 30
3.1.3 Ilwigning System
Application design is dividd into tbnee parts:
- Architectrne desigp
The architectrne design based on actual proce$ flow. Firstln
arsomotive OEM retrieves Estimate Order or Delivery Order fiom
its back office and traosforms the order into text file. TherU the
text file is sent thoWh the e-procurement application Secondly,
the application uses program in order to exEacting data from tos
file and store it into database. Finally, suppliers can login and use
the application to exchange information with their OEM via a web
browser as shown in Figure3.5.
i
Figure 3.5 Architecfire design
Copyright by Mahidol University
Fac. ofGrad. Studies, Ivlahidol Univ. lvlsc.(Tech. of Inform. Sp. Ivlanag.) / 3l
Database desrgn
The database design is based on relational database management
system (RDBIvIS). For storing Delivery Order or Estimate Order,
the stnrcture of table in database is the same structure of text file
that is sent from OEM and add some necessry field zuch as
delivery quantity, 41Jlr[ flag, etc.
Application design
The application desip ruN on Windows environment and
coryatible with Internet E:rplorer version 5 or higher
3.1.4 DevelopingSystem
This research is based on tle Three Tien Softryare Architecture
consisting of a Web Server, Application Server and Database Server. The System is
designed for automotive manufrcturer that has many zuppliers. It uses centalize
application which every data in server process is sent and displayed information via
web bnowser.
Tier of the system
o First Tier :)r Second Tier :). Third Tier :>
Web Server
Application Server
Datahse Server
First Tier: Web Server
This tier coryoses of 4 odects: Service Object, Presentation Object,
Control Object and Comect Object as showninFigure 3.6
Copyright by Mahidol University
Choldis Srikanthimarak Research Methodology / 32
Serute ObJect PrenfaHmGF @ntrol ObJett
AonnectObJed
Figure 3.6 First Tier
o Service Object
Service object is the tool developed in the form of GUI
(Graphic user interfrce), the user-friendly gaphic tool, information and
performing system configtration
o Presentation Object
Presentation olqiect is the tool for generating follow-up reports
for users
o Control Object
Control object is.the tool for configrrmtion of the system" The
control of the rystem will cover user profiles and accessibility levels,
user permission, system configuration and system security.
o Connect Object
Connect object provides connection betlr'een any tier such as
API, ODBC.
Second Tier: Application Sener
This tier comFoses of 2 objects: Online Application Object and
Connect Object as shown inFigure 3.7
(xrltneApplldqr Oryect
CqmecOBJec
Figure 3.7 SecondTierCopyright by Mahidol University
o
o
o
o
I% AY,;.:,1' .rYrlqY. | .l
?,\ r;\ t): / rt,g!7.(1,3ruliiu9
lvlSc.(Tec.h. oflnform. Sp. tvlanag.) / 33
o Online Application Object
Online Application Ofiect routes the requested message
request forms) to the application After finished processing,
reqDnse is sent to users.
o Connect Object
Connect Object provides connectinity for the Datahse.
Thid Tien Database Sener
This tier comlnses of 2 objects: Database Oqiect and Comect Object
as shown in Figrne 3.8
EtEDasoGied
@uertOblect
X'igure 3.t Third Tier
r Database Object
Database Object is used to contain all hckup/restore data inthe
syste,m" Storage capacity can h expanded which is depending on user
requirements and actual nansactions.
The three-tier web applicaion flow coffiol coryoses of Web Server,
Application Server and Database Server as shown in Figrre 3.9
(ie.
the
i rrrt p.f rt
Copyright by Mahidol University
Cholatis Srikanthimarak Resarch Methodolory/ 34
Figure 3.9 Web Application Flow Control
3.1.5 Teting and Improving System
This step involves verification and ralidation Verification is the
process of ensring the accuracy for the acqrdred data, while validation is used to
check the accuracy of process of each module. Simulated data is used for testing flow
of application and detecting the bug from application
Copyright by Mahidol University
a
o
o
o
Fac. of Grad. Studies, Mahidol Univ. M.Sc.(Tech. of Inform. Sys. Manag.) / 35
CHAPTER tV
RESULTS
This chapter is divided into 2 parts there are the designing results and the
development results.
4.1 Designing Results
This research use concept of three-tiers software architecture as the original
structure of system that will be explained as following.
4.1.1 User Interface Design (First Tier: Web Selver)
User Interface Design is used to join the connection between second-tier and
third-tier. The information that shows on web page is retrieved from Database Server.
The Web Server generated the content can be change according to the need of user and
developer without changing of database structure and Application Server. The content
can be decorated by using 'style sheet' such as font, color, alignment, etc.
Furthermore, this tier can control accessibility level and permission using username
and password that is separated as supplier user and OEM user.
4.1.2 Application Design (Second Tier: Application Server)
Designing application has 3 major components that are Input, Process and
Output. Firstly, Input of system is a text file that contains automotive parts data using
in production sector. It can be divided into 2 types: Estimate Order and Delivery
Order. Estimate Order provides a forecast data of automotive parts, which requires 3Copyright by Mahidol University
oCholatis Srikanthimarak Results / 36
months in advance. While Delivery Order provides acfual requirement of automotive
parts and contains data such as due date, due time, receiving plant, receiving dock and
etc. In both text files, all line of data contains 'Data Type' field. It used for
classification data which are:
MA : WeeHy Order - Delivery confirmation especially parts that are ordered
o
weekly in advance
MB = Weekly (Time
production begin
Delivery) - Due time confirmation of MA before
o
MC : Weekly Estimote - Valid only Estimate Order text file
MD = Daily Parts Order - Delivery confirmation especially parts that are
ordered 4day inadvance
ME: Emergency order - Parts that are damaged by oEM or emergency parts
MF: Claim Order - Parts that are damaged by suppliers
MG = Order Cancel
MH: Order Due Date Change
MK: Part Supply Schedule - Informs consignee about parts that will receive
from suppliers
RA : Actual Shipping Notice (ASN) - Informs OEM about invoice number,
delivery date, time and amount of part from suppliers
The other data contains in each text file as shown in table below:
oCopyright by Mahidol University
a
c
a
o
Fac. of Grad. Studies, Mahidol Univ.
Table 4.1 Estimate Order Layout
Estlmate Order
M.Sc.(Tech. of Inform. Sys. Manag.) / 37
ForecastDATATYPE,A2 MC 53 w30TY6.S5 to7 w100TY.s6
1 /ENDOR,A5 54 W3TOT,S8 108 w11oTY.562 /ENDOR NAME,AzO 55 W4SDAT,S8 109 ,V12OTY.563 PI.ANNER,A5 56 W4DAT1,S8 11C n 13QTY,S64 RECETVING PLANT.A6 5E W4DAT3,S8 111 :1TOT,59E RECEIVING DOC,Az 59 w4DAT4,S8 tt2
=2TOT,596 PART NO.,A1O 6C W4DAT5.S8 113 TSSUE DATE,SS7 PART CONDMON,AI 61 ,V4DAT5,SB LL4 TROCURE CODE,A6I PART NAME,A3O 62 ,1,4QTY1,56 115 REFERRENCE,AlOI NEW PART CODE,AI 63 ,v40TY2.56
10 CONSIGNEE,A6 64 A,4QTY3,5611 NME DEUVERY CODE, A1 65 yV4QTY4,56
L2 FACTORY CODE,Az 66 uV4QTY5,S613 W1S.DAT,S8 67 uV4QTY6,56L4 W1DAT1,58 68 yV4TOT,58
15 w1DAT2,S8 69 w5sDAT,S81€ W1DAT3,S8 7A WsDAT1.S8L7 W1DAT4,S8 7t W5DAT2,S81E W1DATs,S8 72 W5DAT3,S819 W1DAT6.S8 73 W5DAT4,S82C W1QTY1,56 74 W5DAT5,S82L W1QTY2,S5 75 W5DAT6,5822 w10TY3.56 7e W5QTY1,562? W1OTY4,S6 77 W5QTY2,S624 w1oTYs,s6 7E W5QTY3,562l w1QTY6,S5 79 W5QTY4,562C w1TOT,S8 8C w5QTY5,S627 W2SDAT,S8 81 W5OTY6,S52t W2DAT1,S8 82 W5TOT,S829 l,v2DATz,58 83 w6sDAT,S83( ff2DAT3.S8 84 W6DAT1,S831 ff2DAT4,S8 85 W6DAT2,S832 w2DATs,S8 8€ W6DAT3.S833 W2DAT6,58 81 ,1/5DAT4,S834 tv20TY1.56 8[ u1r6DATS-S835 W2QTY2,S6 8! fT,6DAT6,S836 W2QTY3,56 90 W6QTY1,5637 w20TY4,S6 91 w6QTYz,S638 w20TY5.56 92 w6QTY3,S639 W2QTY6,S5 93 W6QTY4,564C w2TOT,S8 94 W6QTY5,564L w3sDAT,S8 95 W5OTY6.5642 W3DAT1,S8 96 w6T0T,S843 w3DAT2,S8 97 W7SDAT.S844 W3DAT3,S8 9E w8sDAT,584E W3DAT4,S8 99 W9SDAT.S84e W3DAT5.S8 10c WlOSDAT,SS47 w3DAT6,S8 101 w1lSDAT,S84t W3QTY1,S5 to2 W12SDAT,S849 n/3QTYz,56 103 W135DAT,S85C ,V3QTY3,56 LO4 W7OTT,S651 ,v3QTY4,56 105 w8oTY.S652 n 3QTY5,S6 10€ w9l
Copyright by Mahidol University
Cholatis Srikanthimarak
Table 4.2 Delivery Order Layout
Results / 38
Order
DOS D/TAG P/TAG CDBlSOP CDB182PP/supplySched.
CanceuChgCIBO2lP
1 DATATYPE,A22 CRDER NO.,A1O L4 8 8 7 6 10 63 PRODUCTION MONTH,564 ORIGINAL ORDER NO-AIO t7 t7 155 CONSIGNEE,A6 L2. 7 7 15 16 1 156 NME DEWERY CI.ASS,AI 10 t2 t2 13 137 PART NO.,A1O I 9 9 9 I 3 II PART CONDMON,AI 9 10 10 10 9 4 99 KD/Local, A1 9
1C INSTALL AREA,Az 2011 ITEM SUFFIX,AIt2 DUE DATE,As 13 11 11 t2 L2 t2 1313 ORDER QTY,S6 15 14 t4 15 15 l4t4 PART NAME,A3O 11 15 t6 11 10 5 1015 ITEM CLASS,A216 Procure code,A6 1 4 3 3t7 WAREHOUSE LOCATION,AT 1918 YENDOR,AS 5 4 4 2 1 11 119 PIANNER,As 2 11 6 112C RECEIVING PIANT.As 3 2 2 5 4 13 42L RECEIVING DOC,A2 4 3 3 6 5 t4 522 NEW PART CODE,AI 7 6 6 8 7 723 PACKAGE CODE,As L724 PACKAGE VOLUME,S5,O 182a RECORD DELETE CIASS,AI2C RECORD UPDATE FI.AG,A127 REASON FOR ORDER,Al8 20 20 L72E DUE TIME,S4 1629 DUESHIFT,Al 13 13 14 L43C =ACTORY CODE,A231 SUPPLY DATE.AE 732 sUPPLY QTY,P5 I33 TECEIVED QTY,S634 ]RDER STATUS,AI35 /ENDOR NAME,AzO 6 5 5 3 2 2 236 t4oDEL,A8 1 16 L7 27 18 1837 roT FROM,A3 l> 10 TIMES t7 18 22 19 1938 toT To,A3 ' 18 19 2339 )rect dellvery mark,Al 1540 llag,a2 1 1 147 CId Due-Date , A8 t242 lssue Date, 58
Copyright by Mahidol University
Fac. of Grad" Studies,Ivlahidol Univ. lv{.Sc.(tech. oflnform. Sp. Ivlanag.) / 39
Estimate Order and Delivery Order file name is an iryortant thing to shout
where the file froq which tlpe of the file and when is the file received. The structure
offile name is shoumbelow:
Charactet l-2
Character 3
Character 4-5
Chmacter G7
Character 8-9
Character 10
: Coryany (Factory) ofOEM
: F/E (type ofthe file ie. E - Estimate Order,
F -Delivery Order)
: Year (1ry)
:Month(*)
:Date (dd)
: Sequence No. (tlow many files that sent in each day)
Besides, there is a schedule using for sending files from OEM to zuppliers.
Theywillrecognize a sending time regularly.
Secondly, Process is a method using to transform text file data into database.
The process that will run fiom script depends on seirding file schedule. The script will
check integrity of file before doing a task. The progress of ss:ript is shoum in DID
(Data Flow Diagram) as following:
Type oforder Schedule
Weekly Order Every Week (Thrsdan 12:30)
Daily Order (4 days advance) Everyday (12:30)
Emergency/Claim Order 2 times/day (12:.40, 1 5:40)
Time Delivery Order Everyday (12:30)
Copyright by Mahidol University
Results / 40Cholatis Srikanthimarak
Sq)
q)t'-1
uiq)q)
PA.go
t.\SNq)
rio'
so0el
a=oE\I\s(3
at-,1!tr6)hEO
fEr
Lo,=CLEL
=t€IEo,L
esrtraIEa
gs9:
#sb.,)cL -c
{E:-E
-vI-cLI-ld
Copyright by Mahidol University
Fac. ofCrrad" Strdies, tvlahidol Univ.
EaEfigEadcz'
!r{.Sc.(T€ch. of Infum. $n. tvlanag.) / al
Bt-b0s).S
"a$\)sa-
sr\){4%s)(^)
I\bo
Es.\Strs)
Eb.'
soos3
a3olqs(laG!t6)LaEO
h
I
EIaEl.sltEttt\
e l\sEl 'Ele
IE6
EEEB€Eclt
Ego(7
EE
EEEEe?
oL
8.EINj
c,cot!lE o
3BE
=E*6
Copyright by Mahidol University
oooo
oItot9
u,
0E+EI
EtsEF
Input data flles
1.2.3)ffisJppllsdownl@d
files
Suppller &wnload file odst
78IA
AN)
1.2.1)Opgl lrwtflles
wmllercode lnUne of hput data
Line of data Irs€rt Uneb DatabasesuppllerIf Data type ls
MA,MD, ME MF, MK
1.2.21) Opsts4pllerdowttlod
ard wrlE ltnelnWtffi If Data type ls
1.2.6)u&bDaEbceof
trigure 4,3 Data Flow Diagram of Flle Handling Process Level I (Separatefilesfor each supplier)
Copyright by Mahidol University
Hr e 'fiir ':f$l!r*rs fe&. Hr+-.;:,
Hc E*.i,:$rt fgEcgt :IcEb' H*+fic*,r'r.+,,r 6,6 td | &teq$ grarmr .6,trt
wdcomB to B-prwr:rament WehApplication SystemPlBaEe rEply me, if Youhave rEcBiv6d thismESSage
o Fac. ofGrad. Sfirdis, IUahidol Univ. M.Sc.(Tech. of Inform. Sys. Manag.) / 43
Finally, Output is a Web Application that provides information exchange
between OEM and suppliers. Both of them can login via a home page of Web
Application After loggrng irL the function lists are shown on left pane and separates
by OEM and suppliers as shown in Figure 4.4.
Figure 4.4 List of menufunctionfor both OEM and Supplier
o
a
ICopyright by Mahidol University
o Cholatis Srikanthimaak Rsults / 44
4.13 l)atabase Deign Ghird Tien Database Server)
- Datafrom OEM
Database is designed for store data from a text file. It relies on the text file
layout because data is separated by itself, Therefore, Database is created from this
layout and adds some field for zuitable usage.
For store data in database, Supplier code is si imFortant thing that b'rought
to create a table. A table nanre is composed of the text file type and appends with
supplier code zuch as FTAB - Delivery order of zupplier TAB, EJBT - Estimate order
of zupplier JBT. In both tables, they will add 'filename' field for store file name'
Particularly, delivery order table will add 'delivery quantity' field for store amount of
delivery parts. Moreover, uften text file is receive4 there will be creating a new table
for each zupplier to store stafus of text file. The name is comFosed of 'FILE' and
appends with supplier code such as FILEJBT'
The suppliers can not change or edit the information from OEM; they have
only view permission
- Web board
Web board function uses table omessage' and oanswer' to store data that is
sent to supplier and received from zupplier.
- Calendar
Calendar function uses table 'non-working' for define holiday of company.
It is brought to build working calendar for each coqpany'
Copyright by Mahidol University
Fac. of Grad. Studieq Ivlahidol Univ.
4.2 Development Results
M.Sc.(Teh. of Inform. Sys. Ivlanae-) / a5
This work has been devetoped to be the prototlpe of an internet-based e-
procurement web application which seryes 1o sxshanging data between OEM and
zuppliers thnough the Internet. This prototlpe can be divided into 2 sections:
4.2.1 SuPPlier Section
The home page as shown in Figrne 4.5 is the first page that requires
usenrame and password for login to application If username or password is invali{
the application will disptay home page with elror message as shown in Figrre 4'6
Figure 4.5 Home page of tlrc e-procarenlent web application
Copyright by Mahidol University
Cholatis Srftmfrinrak Results / 46
e - p rorurnment
W.l, -4 ppf u,tion S yiln,n
P*.,xf-i set'nl
Figure 4.6 Home pagewith an etnor rnessage
After sgpplier log ,o, the application defauh page will turn to b the
web board fimction as shown in Figrre 4.7-
fiinrfiiily't"l4lt:!iitl1:li
M,@&'ff
*,,te* lmr. ,1l€:- tnb
supDllor
Figure 4.7 Web boardftntction after supplier login
Copyright by Mahidol University
Fac. of Grad- Studies, Ivlahidol Univ. M.Sc.(Teh. of Inform. Sys, Manag.) / 47
If OEM sends message to zupplier, it will display in the web board
page. The default message is a today message. But zupplier can see a previous
message by select date from the list box. When zupplier click on message, it will link
to display content of message as shown in Figure 4.8. If message has to reply, it will
display reply icon as shown in Figure 4.7 aadin content of message that will have text
box for reply as shown in Figrre 4-9.
N4CT2 DIB+|2BB2
Walcome to s-pro8lrErrartt web ADpllcatotrSyltsm
: DBa SuppEBr, welEamB tB B{roErsms-nt WBbnpptication syLtem. This is a prouvps foraltomotite indusEy.
Figure 4.8 No replY message
Copyright by Mahidol University
.-O,, ,.,uh, rf8lgr-ts r'.8r* fi*
:IMCT. Dlo4lzooz
Plsase rgpt, ms, If you h6!ra trcalced ttls message
: Dear suppfier, Plaase reply me, if you hava receivedthk messaqa. Thank You'
Cholatis Srika!ilhimrak Rmults/48
month
Figure
Figure 4.9 Message'las to rePlY
Next function is calendar, it can display in 2 views that are viewed by
and viewed by year. It can change month and year by list bx as shown in
4.10 and 4.11.
figure 4.10 Calendar - view by monthCopyright by Mahidol University
o
o
a
a
Fac. of Grad. Studies,Ilfahidol Univ. M.Sc.(Tech. of Inform. Sys. lvlanag.) / 49
X'igure 4.ll Cqlendar - view by year
Next function is an Order Instruction, it display delivery order text file
that received from OEM and shows status of text file too. Suppliers can select a list
box of status, company and date by seeing the text file that they want. Besides, they
can view, download and generate reprt from text file that is selected as shown in
Figure 4.12.
$fi*' v'e r@'E d frne*dr Ersnfi*. Sr@y l]*;'& @1,i E;l'.r
. l Januu, tlapgr FJew Year
. 14 Fabmrt ?elendnc Day
. z0 lil€rch t4y Birthday
. 1l{ay LaborDsr
Copyright by Mahidol University
o
o
a
a
6* E&,,$it+ fififfic. $d, Efu
!i @Ed@r SsBstrElcEEon rcstabs CoEpaDy DltE
,(HrracHrcHEMrcaLAUr) 16 d lfr,'= loFiru-3
o tfiflrzoeilr2.Txr firvru:-@t2u3s &C rfiFtrrr43rt3.Txr 30r!4lul - (zr2ot39 Sf fiFE04:ltl4.TXT 30rD4lIE - IU.2O!39 &
$"d- lRp-tl
Cholais Srikailhimarak Rgults / 50
Figure 4.12 Order Instruction function
When text file is selected and click a button named 'view', it will
display content oftext file as shown in Figure 4.13
:l &sder EmetcEEcEEoEE :;mo ID @mp@y Dd.Tlps
.{r-+911I ruFmo4ao4.rxrIi?T lMFmo43o4,rxr IMcr FIi.]
lp.f9q1=] Noxt,> pasa I d t3
MD 04/05/02 T 11117 8972357791 NOZZLE ASmiDEFRO
MB 04rtSJ.02 T l3:f 897a5r7gl NOZ.E ASH,DEFRO
MD 04/051tr2 T 14rL7 Ag7z3sTrfiNozzl-E ASN,DEFRO
liD 04/05rU T 15.27 $fifi4ifmlgJ$ozj ASH;DEFRO
MD tl4l05y'02 T 16125 89723577A! NOZZ-E ASHIDEFRO
HD 04r051tr2 T 1tt17 8923587,{l DUCT AEHTSIDE w/tlD 04/05y'02 T 13!17 8972l,50?rlo DUCT AS$l;slDE W/EID 04105rtr2 T 14!U 8972!t!i0740 DUCT AsslrsIDE !E/MO O{ffsru2 T 15:27 Bg7z,sg74,JOUCf AST{,SIDE tt/MD @r!5r!2 T 16:25 8i7zt5t7r0 DUCT ASM'SIDE tu/MD (l4/os/Dz r 11:17 ogz3587&l DUCTAsfttrsIDE W/ldD 04105/02 T 13117 097zItSl78O DUCT As!,lrstDE w/HD 04/05102 T 14117 80723s87&, DUCT ASI'trStDE WHD 041!51tr2 T 15!, 8912158780 DttCT AsBlrsIDE w/
04/-05y'02 T 16:25 897zt587Gtl DUCT ASil;sIDE w/
0 DD24041873 gE92 IHCT 05o DD24041874 S@92 IHCT 050 DD24041875 90092 IHCT 0so DD2404L576 gn92 rilCT 05o DD2404!.O77 9tlt92 lttcT 05O DD2zlltrtl@,. gallgz MCT l!5o DD24041@2 gne2 IICT 05o DD2A@I&3 En92 llllcT trlio DD24II41884 qm92 IIqCT 05o DD24041&5 qn92 tt{CT 05o DD24I!41E9 9r[r92 IHCT 0sO DD24O{!B9O B@92 ll.lcT lrE
o DD24@1891 qD92 MCT 0s0 oD24O41892 9@92 [riCT 05
X'igure 4.13 Wew content in delivery order textfileCopyright by Mahidol University
4ffitltu'ee'*
Fac. ofGrad. Studim, I!{ahidol Univ. M.Sc.(Tech. oflnform. Sp. IManag.) / 5l
. From Figure 4.12, if click a button named 'download', text file will h
downloaded and store it into harddrive as shown in Figrre 4.14. Supplier can
download for backup data or print reprt from external software.
Figure 4.14 Download textfile
The last button named oreport' is clicked for ge,nerated reprt from a
text file. After clicked, it will display page for the selected report that wants to
generate as shown in Figrre 4.15.
Copyright by Mahidol University
o
o
e
a
Choluis Srikmthimrak Results / 52
.flgu". 4.15 Select:ePort \rpefor generate reports
After selected report, zupplier has to click button for select data type
that want to generate report. When zupplier click it, report will be display as shown in
Figrre 4.16. If there is no dara, it will display message 'No data asi you selected' as
shown in Figure 4.17.
Copyright by Mahidol University
o
o
a
o
E& g;*t'Fd# t{*'':ttb
vBndor VendorNsmeHCAT HITACFIICHE!'IICALATT
Due-DateBqasl@ T
Fac. ofGrad- Studic, Ivlahidol Univ.
DELTVERY TAG
C0 *@rqt#Ei*iktitdtthasdsel|Et.
M.Sc.(Tech. oflnform. Sfn. Manag.) / 53
ilqiitlilpA m,1tE:;;ffi 6il++q;,I l'6ersqrEErt;.1 Tt"q?fl:$.i.&@@&8
Figure 4.16 Report thd generated after clickdotatltpe button
st @rder EmststaetBoss ::
s: @rder EgESETEEeEEoEB :sms ID CottrP8!fl RsPott:IYPa
HCAT,(HITAcHICHEMIcALAUT) rmFo2o4alz.Txr rmcr l@ffiCffi-=
"No Doa as you sslectsil"
'gi ll l '# g e I I tt,:.--qe ;; [ ft lqr s"./ri"'f
Figure 4.17 There is no dda gtpe to generate report
Copyright by Mahidol University
Choldis Srikmthimrak Results / 54
shown parts that have toNext firnction is a today part delivery, it
send today shown in Figure 4.18.
Frgure 4.18 Toduy parts deliveryfunction
Next function is an estimate order, it displays the estimate order text
file that receives from OEM and showl status oftext file too. Suppliers can select a list
box of status, company and date for seeing the text file that they want. Besides, they
can view, doumload and generate reprt from the text file that is selected as shown in
Figure 4.19,4.20,4.21 and 4.22.
llt
dt , fifi, '$6t :.'Fa#i rf"c*'' 1l*
Supdk: D|!ED&: Com[sry! DEbTrPe:
,(HrrAcHr cHEMrcaLAur) allo4loz ffil ld.-l
0rrt4/!zrro:st mn aezrroooerffifR,Ri''*' oDDzsogolE t{cr olt
m/o4lozroorso mr aezoroooer$$P,ii''*t oDDzsto@$tcr os
ovo4rlzrrorss un o:zsroorm$fR,[i*'*t oDDzsmerrrncr .rl
ory'D4rtarosrse mr eeurromoS$R,ffit'*' oDDz3ooqrrsstcr 05
ol.,Rlrlz T 10t5E mH 897910074tt GRT|IETSPEAIGR:RH 0 0D2SO9146 IrilCT tls
Or&4rt2 T GBtEe BrH 89791007.10 GRIIIETSPEAKEnTRH 0 DD"3O@!EB lltlcT lE01..!4r!2T1Or55 r,lH 897910075{,GRIIIETSPEAKERTLH 0 DD23O0920gl}lcT G0tltr4r!2T0ar89 rqH SgTglo0TgtGRItlErSPEAKERrLH ODD2SIBOZI2 tritCT 05
0t/o4r!2T10r85 irH 8979105741COVERS!DEDEF ODD20092mtilCT 05
oliD4rlz T mr59 I'lH 0979105141 COVER SIDE DEF o DD23OO9274 lIilCT aF
0184/UT10:55 mH 8979t05r51 COVER SIDE DEF 0 DD2SD9IE2 IlilCT (F
01y'04fu2T@:59 MH 8979t0t St COVER SIDE DEF 0 DDZ$0*,ll6 lllicT G0ry'D4r!2T10:55 NH 897910701OBOXTR!m PADTDOOR 0 DDZS09394 lIilCT 05
0IO4r!2T@r59 t{H 8979!0?@OBO8TR!irIPAD:DOOR 0 DDZSA,llgS [nCT 05
300
300
300
30
30
30
30
30
30
30
303030
3tt60
60
I ffi.,Sell
Copyright by Mahidol University
Fac. ofGrad Studic, lvlahidol Univ. M.Sc.(Tech. oflnform. Sys. Manag.) / 55
.Hi :[.dt thirrr,ffiiills* 'fii*: :fl*
r: Es&Es{Bate Srder:rsEpEtlsr stabs cor!pa[, D&HcAr,(HrrAcHrcHEMIcALAlrI ) F-- lF= @l
C II{E02IEi,51.TXT o5!O4l@-a!,27,L4 *sarl' i#ruoag I ii,rin'l
f igure 4.19 Estimate Orderfunction
RB e !!q FEpbs Tod, H*
cr EstErsaaEed Srder $BB6@EmaEE@B! s!
Ta[dor cods :HCAT, ( HIfAcHl CHEMICAL At I )
E1iltt08lE51 893:ISPB42BRACKETiRRDoOR 'ISZTttICT0l, NM22O O 0 0 0
ElrtootrfiE2 89gl5PB52 BRACKET,RR DOOR t ISZT IltlCT E 2@,t2 D O 0 0 0
E14000G'Ii3 9723C?7rO NOZZIE ASIH,DEmO rgr tmcT 6 mou22 270 870 1050 1230 12[
El4{nrfiXrlr4 8929S273 GRnl-E ASFIiRADIA rSET IIICT 05 Z0OZ04Z 0 90 90 210 A6t
ElilttltlllIfF trtla3s/:n3 GRIUE ASfiiReDn ' EZT tMcf B ZOWZZ' g O O 0 0
E140lr0&Er6 8972358343 GRtttE ASI{;RADIA t ISZT IliiCT 6 Mfr4a fi 3E 90 210 33t
e1zm00Gl57 8972318740 DUCTASI'I.;SIDEW rszT tficT a5 aouD 270 070 1050 1230 12t
El.tO0OGrsS €O7235a7@ DrrcT ASM'STDE w tgT tlicT 6 ANMZL 270 870 1(E0 1230 12t
E1.$n0u69 89723S810 DUCTASI{TVENTILA ISZT EICT G 2Nm/[22 270 870 105t1 1230 12t
Elro0otr6o 89723S4{1 DUCTASFITUENTII-A rSZT IHCT 6 "WA
270 870 1050 1230 tAC
El.lOoOqE'l 8!172358861 DUCTaSm;VENTILA IIZT ttitcT AS m@U 270 878 1050 1230 tZC
E[4trtotrr6z &t?affi6?2, FASCTATFBONTEUFI ISZT ltilcT & Nfr4nat o 870 1050 1Z3O lzte14lr00txt63 &t?2372g,O! REINFORCEnEMT AS rSZT mCT B mON22 0 0 60 100 30t
E!l@0G64 89,72i7ZAZL RETNFORCEI{ENT AS ISZT tficT 6 MA, Zm 870 990 1050 90t
El4ormGl6s @7z3sLo6z m?KFr,Box tszr tucr 6 ?ottuz2 Bl0 1740 2100 2460 24c
EllltfitlIl66 ldfti?38,,A9/0 COVERTINSTRUMEIfi tSzT tt{CT tE aIlaD{aZ 0 30 90 210
l@@#Hill
X'igure 420 View content in estimate order textfile
Copyright by Mahidol University
Choldis Srikanthimrak Rsults/ 56
l El 6s # $ ll ffiH*n,:..l GF.**.'l
Figure 4.21Download estimate order textfile
,*,'E&..,11r**..f;nsEc 'I!*r,tl&
L-NO.COE54oF 6IU[ArE (mnHmllrm -c
t@bcdffi rclT 0f,Il(I{Clgrctl.Aur)
:u05
4m5
5'U5
8'06
7/D5
210
210
ztoli6
270
i 230
00
80
t50-i6o
120
510
trlffiBS lt
Figure 4.22 Generate reportfrom estimate order textJile
Copyright by Mahidol University
Fac. ofGrad. Studie, Ivltridol Univ. M.Sc.(Twh" of Inform. Sys. Manag.) / 57
Next function is an Actual Shipping Notice (ASN), if zuppliers want to
send parts to OEM, they have to fill in this page to inform OEM as shoum in Figure
4.23
f filwo2 08,00 MA 8972359622FASC1A;FROi{TBUH
r @/04/112T13347 MD 8r723:F710 DUCTASmiSDE w
f @lwliz'tl4t47 ttD 8,t723gi'74O DUCTASM;SIDEW
f @tAlOZT LO:dI IrlD 89723587811 DUCT ASM;SIDE ry
f @laAlOzI LLAT MD 8!,723S780 DUCT AsM,SloE W
r 3O/tXl02T 13!47 MD 89723587&t DUCTASMiSTDE w
f fil04loaT L4|,.? ftlD s9723$780 DUCT asMisIDE W
f glIB4r02Tt0!47 MD 8912358810 DUCTASI{;YENTILA
r 3,J,lo4lo?r ,I|p7 MD B,7Z35AB10 DUCTASmiVENTITA
T Sr04/02T13!47 i{D 89723S810 DUCTASm|VENTILA
0atEwo00 tI030glJE@o 003ostTHltoo 0t!1030880!0 00lr
0gt7tro@ m3
0:EEWO00 002
0s8B@1, @2
0s0cE000 003
mzrooo moglEuro0o 002
lxmBlflm 00?
0scElmo {to3
0ar7fru00 @3
o DD24tn6803 IHC
o 0D.?4@9lvt
0 DDa4@9184 ltt(0 DDZ4@9185 rnc
0 Dm4eg186 IJ'iC
0 DD24n291.88 lll(0 DD24019189 mC
o oD24@9190 liic0 DD24@9191 lltic
o DD2402C193 ItiC
f igure 4.23 Actual Shipping Notice fimction
When zuppliers select parts that they want to send in one da5 they have
to tick in checkbox ofthat parts and click 'submit ASN' button After click the button,
zuppliers have to fill invoice number and speciff delivery quantities of parts as shown
nFigur:e 4.24.
OCopyright by Mahidol University
Cholatis $ikmthimarak Rssults / 58
30 sn F. :$ 30 s]_-30 30 hD-
filwozfifi,/02slw02
fiD 09ret587.r0
fllD 0'9zxt58?.lo
mD 8974587&'
DUfiASMJSTDEw/ DDZ4O?gLSI
DUCTASm;SIDEw/ OOZCO2gteg
DUCT AStitjStOE w DDZ4OV,IB6
lffi] 6.dl
eg s lt.ffitirh* i;lFfqraJ
Figure 4.24 Fill irnoice rumtber and specify delivery quantities
After click the ozubmit' button, it will display confirmation page
datathat filled as shown in Figrne 4.25.
:: &CEEAE SEE &loE6ce (eSffi) ll
6f, :; qfi::: :ffi :farrrE,,'fads tl&
DUCT AS[ilislDE w/DUCT ASI!;SIDE W/DI,CTASHiSIDE W
;r &c&uaE SErEppEsne ffioEEce (&SF{} ::: HCAT, ( HITECHI CHEIIIICAL tuf ) Companu: llllcT
DdtE: 3oro4loz'ifre:. t', . 17 2 22Nombsr: tltxll.o
Rso[rd: 3 rocord(s)
@I#S,sll
X'igure 4.25 ConJirmation page afier submit ASNCopyright by Mahidol University
o
o
a
a
:! eameeE EmvoEce :e
II|solE6NoDbt
l@=ll'r@:l
HCAT 3O/04/Oe 03r19!Gt DDZ40enTL Ca7z36773o ilozzlEAs[rirDEFRo
HCAT &r/04/!2 O3:19ltxl DD24OZ'173 897235791 NOZaE ASMiDEFRO
l:@',@& & ll
Figure 4.26 The cancel irwoicefunction
Fac. ofGrad- Studies,lGhidol Univ. M.Sc.(Tech. of Inform. S1a. Manae.) / 59
Next function is a cancel invoice, if some part, which is sent, has some
error, it can be cancelled and re-sent again For cancellation, it can be selected from a
list box of date and invoice number until the required information is found. Then, the
web page displays the ASN information that is sent as shown in Figue 4.26.
After click the 'Cancel Order' button, it will display confirmation page
as shown mFigure4.27.
Copyright by Mahidol University
Choldis Srikamthimarak Results / 60
Frgure 4.27 Confirmation page of the cancel irwoice function
The next function is a part claim; it diqplays automotive part that is
claimed from OEM (only MF). The claimed part has cause of damage from supplier.
This firnction can select dateto view data as shown in Figure 4-28 ail4.29
;: eamceE Esnwo6ee eostftrmaE9sm rc
ilrmDrr: Htlolle rccard(s)
Oozqzgtu gI/ryw m728:8740 DUcTAsMrstDE w/ !['DD2.llt29185 frlw\2 89?e35s740 DUCT ASH,SIDE !fl/ g)
oDz402fl8e golfF,E/-. s97z:UE?s0 DttcTAsMiStDE M 14
Copyright by Mahidol University
o
o
o
3
Fac. ofGrad. Studies, Ivlahidol Univ. M.Sc.(Tech. of Inform. Sys. Manag.) / 6l
il ll@ ,8,e'll
Figure 4.28 The part claimfttrrction: select due date
dl qii erF.6le, g!*r 19 @ - tEI e
:: Fart CEaEscB s:
br: I,ugD!E: CoEPoor:
,(HrrAcHrcHEMrcALAur) lroo@- (ooumvg F-=
rdlF 89?94t!9O82 BUmPERjFRoNTIVFOX il 0 DD248O0282
rdF 8079409090 BUmPER;B.ACI(,MFOX tl 0 ODA4B0II283
MF 8979409110 BuHPEniFRolr,WlFOX ftl 0 DD2480I1284
MF 8979.18600 BUHPERiFRORT,UFOX Td O DD24BO@85
tHcT 07 2 0ItriCT 0? 3 0IilCT 07 1 0
MCT87 4 0
Figure 4.29 77rc Port Claimfurrction: view result
Copyright by Mahidol University
Choldis Srikmthimrak Results / 62
The next function is Autopart Information; it is used for viewing the
name and number of automotive.part. When accessing this function, the defrult web
page will drsplay all of automotive parts that used with this supplier as shown in
Figure 4.30.
Figure 4.30 The Automotive Part Informationfunction
This function can search automotive part by filling the name or only
few of character fromthe beginning of automotive part name as shown in Figrne 4.31.
ffi , .8*' $t,::id&ih::..Etrk !l*
:: &*EoFasE gmf@rEriattem :c
@.--.--_'id'6".'l
Copyright by Mahidol University
ffiEh:i:E*:flt$: f$l{tFq, fqC+, H&.
cs &uE@PesE EraformaEEom c;
F"".-.._'s*di':'l
Fac. of Grad. Studies,lvlahidol Univ. M.Sc.(Tech. of Inform. Sys. IUanag.) / 63
Figure 4.3lThe Afiomotive Part Infomationfunction: setrchfu lceyword
The last firnction is change password; it is used for change supplier's
password. When zupplier code is set up, the defauh password is the supplier code. The
web page sfthis function is shown in Figure 4.32.
&, afi, ilr F,tiif,B ,Iodi E&
ee Chamge Fassword ;r
EnorotdPcs{ordr F-Er*ErH# Pcflord, F-
R€fyps Nm P*soa, F--
Figure 4.32 The Change PasswordfunctionCopyright by Mahidol University
Choldis Srikanthimrak Results / 64
After clicked zubmit bgtton, this function will veri$ old passurord that
has to valid. Theq it will match the word that fill in new passryord field and retlpe
password field. If both of its is the same value, the function will update to database
and display the confirmation page as shown in Figure 4'33
flgr* aSl The web page after change password
Copyright by Mahidol University
a Fac. ofGrad. Studic, Ivlahidol Univ. M.Sc.(Tech. of Inform. Sys. Manag.) / 65
4.2.2 OEM Section (Administrator)
From the login page in Figure 4.5, user of oEM logs in as an
administator of system- The defrult page of application will be web board as shown
in Figure 4.34.
tfrh,11:tat
conpanelfr'lPostllewHesge
suppfierP-l
a WBlcome ta B-pmcurEment WebApplication systBm
PlBesE r6Fly me, if Youheve rec€ived thismBssage
29tAf2@Z
29lA+dW.
mcr All N
ritcr all Y
DslBto
Delete
a
r-I6'iffi----*;
Figure 4.34 Web board ofter login as admin
From that page, OEM can post a new message that has to send through
suppliers. OEM can do it by clicking at a oPost New Message' link. After click link,
this page will be dlsplay in Figtre 4.35-
oCopyright by Mahidol University
o
o
o
a
Choldis Srikanthimarak Results / 66
: lffil: FEsrnasryryp
:l-E;EG
Figure 4.35 Post New Message
OEM can speciry supplier or company by selection from the list box.
Then user fills the subject and detail of message. If OEM wants their suppliers
receiving this message, replies it, OEM will tick a'Reply' checkbox. After that, user
clicks the'Send Message' button for sending message'
From Figure 4.34, tf OEM wants to see detail of the message, user
clicks link on this mesmge. Figure 4.36 shows detail of message and replies message
from zuppliers.
Copyright by Mahidol University
EEcbE@ HCAI
Fac. ofGrad. Studic, IVlahidol Univ. M.Sc.(Tech. of lnform. Sp. Manag.) / 67
EECbE@ HCAT REplrDe ?5fiElilfilDcl8t EAI ctlqray D& !€colEd essa0E-
rT,
Figure 436 Detail of message andreply message
Next function is Update Calendar, it has 2 zub-function ie. update
calendar and view calendar as shown in Figrne 4.37.
H?,. E*'r glid '' Piwi**'. f,oqb E#
rc eaEemdar c:
updete calBndar
viff celmder
Figure 4,37 Subfurrctionof Update CalendwCopyright by Mahidol University
Cholatis Srikmthimarak R6ults / 68
After click 'update calendar' sub function, page will display all non-
working day of each company shown in Figure 4.38.
f igure a38 Displuy all non-working day of each compalry
User of OEM can adq edit and delete non-working day by click on
link. When user clicks the 'Add ne\r non-working day' tmlq the web page will display
form for add non-working day into database as shown in Figure 4.39. If user clicks on
the edit or delete link at the end of non-working day, the web page will display form
for edit or delete non-working day as shown in Figure 4.40 and4.41 respectively.
c: CaEeBBdar::
Updets calBndar
viEW calerdsr
Copyright by Mahidol University
Fac. of Grad- Studie, Ivlahidol Univ-
giil F${frs I!4" E+
M.Sc.(Tech. of trnform- Sys. Manag.) / 69
@@
Update CalEndar
view calendar
* "-t*rEi
Update calsndar
Vis$ calsndar
Figure 439 Add new non-working daY
Figure 4.40 Edit non'wor6ng daY
Copyright by Mahidol University
Choldis Srikanthimrak Results / 70
Figure 4.41Delete non-working day
From click 'View Calendar' subfunction, it will display calendar page
for viewing some change that happen from 'Update Calendar' as shown in Figure
4.42.
a
qdt ,Xlt,..F,ers.r?i 'Ic*- {*- '.rr r: I:'i , ,i:
E ' *.iffi'@'6,11Q @taru&s
gc Catsegadar sr
Updetg calEndar
View Cdsdar
Date Al1/ZgO2 : IEMTvou surs you went to dBl8ta iE?
oYes cNo i*bl
Figure 4,A View calendarCopyright by Mahidol University
,gp,. Ert Ui*:''f.Amt*,., trrob.,; fl&' "
.pih*?.,*,; @ #}&**O 6r ' '.I,Ei€r@,rifil,,#
:! g$ppgl@r Esa6orrgcatgem rs
Fac. ofGrad. Studies, Ivlahidol Univ. M.Sc.(Tech. oflnform. Sys. Ivlanae.) / 7l
Next function is a Supplier Information; it is divided into 2 zub
functions that are update supplier information and views supplier information as
shown in Figure 4.43.
Figure 4.43 Sub-fimction of Supplier Information
After user clicks the 'update supplier information' zub function, the
web page will display all non-working day of each company as shown in Figure 4.44.
Copyright by Mahidol University
a
o
a
o
Ee.'8* ,ffiir ,,.F,p. ,,IC*', HS
;! SuppEE€E Em$@rrdBeta@ss eE
Choldis Srikarthimarak Results / 72
Figure 4.44 Display all supplier information
User of OEM can adq edit and delete supplier information by clicks on
link. When user clicks the 'Add new Supplier Informatioa' link, the web page will
drsplay form for adding new supplier as shown in Figure 4.45. If user clicks onthe edit
or delete tink at the end of zupplier code, the web page will display forrr for editing or
deteting zupplier information as shown in Figure 4.46 and4.47 respectively-
Copyright by Mahidol University
Fac. of Grad. Studies,lvlahidol Univ. M.Sc.(Tech. of Inform. Sys. tvlanag.) / 73
Figure 4.45 AddNew &tpplier Information
a: SaappEEer Im$ermatEeca x
de' :Eft,'.:!Ef, .FS{dix It& eb6l flei$ BFa,mi' 5tt*ci l€ @l - El r
:t soappBBer EmSorgBatB€BEi r:
f igure 4.46 Edit Supplier Information
Copyright by Mahidol University
o
o
o
o
Cholatis Srikmthimrak Results / 74
Hb .ga'.,i Firld-ss e*
Suppller 3M
you surE ,su wEnt to dBldE it?
ttves C No p.bGl
Figure 4.47 Delete Supplier Information
After user clicks 'view supplier Information' zub-function, the web
page will display information of zupplier as shown in Figrre 4.48.
ll Sar ppEEer EBBE@ rrya'qlesr_li
Eer E&.,sF-i:rsqfir !* EsffilE;E At.Os"*o sraatss 6te, l6'.g,@j'B-z
rr SarppEEer Eru$ornaaatteet :j
Doda ,K,atrdcN@ flAI STORAGE BATTERY
td&rs IO? HOO 4 SOt PATANA 3 SUKHTJMUIT RD,BANGP@I{D.EST.PRTEKASA
Dny iAI{UIPRIKARII
Pori L0240
mtrBb
hrmlEr nr. sBibrat KmF0ltfiimIYTEtrEIINIE tr. AnanEtrt Pamit
r*zd[d3.ryG&D irr. AnrnErat PanJit
E :OMPAO sct
rc EFEC Pm 933 mHz.l.lDD: ZO GB, e4 lilD
trED E otslF IETSCAPE
tslt'rarllrdoEtrocidsNam
.EIEST VERSTON
ISIIIET ACI>EEING SEI.EC
Jra .EESED UNE
Figure 4.48 View Supplier InformationCopyright by Mahidol University
Fac. of Grad- Studies,Ivlahidol Univ. M.Sc.(Tech. of tnform. Sys. Ivlanag.) / 75
Next function is an Actual Shipping Notice (ASI.[), user of OEM can
view data of automotive parts that received from zupplier by selection company and
zupplier fiom a list box as shown in Figrre 4.49.
Hoo[F filtqbzH@03 @MOzHuxr4 @lwtzH@n4 3,0l\4d02
HB05 *lwvzH0oos filwo2H!806 @lw@Hdro? sMozHdtD? mrt4/02Hooo8 filwazHOOD0 gMtzHrtrto8 sMozH0009 slufrzHsrlo wwo2H00r0 frlw@H@10 filwoz
DDz4egl7t SE aSrTsO tlozaE ASNTDEFRo 3ll lEDD24@1r173 6972357130 NozzLEASmrDEmo 30 glDD24U6013 8v,:l0a6,qt BEZEL @ 30
DDz4lEIrr7! 897235771t0 NOZZTE ASFIiDEFRO 30 15
DD24E6fit8 8!r*XX2U41 BEZEL 30 3lDD24@9(74 gq?z,3577fi NOZaTASmTDEFRo 30 AlDD24{P9161 8974n88740 DUCTASI!',SIDEV 30 18
DD249r0715 Ag??3,ETrgo NOzztEASHiDEFRo 3ll 30
DD24Anta6 S9?e35'nfi HOZZIE ASH,DEFRO 30 @
DD24IEq,,S A97reT73rr IIOZZIE ASHTDEmO 30 glDD240lC16l 8972359140 DUCTASM'sIDEW gl 16
DD24@0r83 8972358740 DUCTASHTSTDEW 30 AlDDz4urgr8l 89r"358?40 DUCTASHTSIDEW 30 t4DD24@9t84 89723E6740 DucTAsril,slDEV 30 slDD24@0188 897235t740 DUCTAStITSIDEW 30 g,DD24l,e3786 8972358740 DUCTASI'iisIDEwl 3ll 30
DDa4&?C184 89121t58740 DUCTASMTSIDEW 3ll sDD24@9rss 8Cr235O740 DUCTASM,SIDEW 3!l 30
H@t1H@11
wwo2wwoz
Figure 4.49 Actual ShippingNoticefor admin
The last function is a File Status, it displays status of file that is sent to
spppliers. User can view information by select company, zupplier and sent date from a
tist bx as shown in Figure 4.50.
:; &cEuaB Slc
Copyright by Mahidol University
il& ,Eft, $x,. ti lith d*
!ficT HCAT It-IFOZO{rr02.rr g0trott/E @:m
r]ncr HCAT trnmzo.(l!3'TxT 30lul@,@t20t!{CT HCAT tl{Fozlt4llort.TxT WUI@@,Zo
Cholais Srikmthimrak Results / 76
Figure 4.50 File Statusfunction
User can view the detail and download text file by click on the link at
the end of line as shown inFigure 4.51and4-52-
<<PrcYiffi
MD ll4lo5/02T[:17rdD 04lDE!2Tff1:UHD lral0s/lPT14:17MD r,4rt5rD2T15:27rrrD 04/05182 T15:25r'lD 07/ItV02 T 08!37MD 07^lvD2 T Olr:37
HD 07n5/1IZ Tto!47HID M/05m4T11:17frD 0.Y05102 Tilrrl7!'lD 04/05/mT14:17mD @05r!2 T15!27MD 04/05y'02T16:25mD 0?/t5,,EZ T (E!37
$D OilOEnZTtI,t37mD 07t!5ruT10:47MD 04/05rtZT11:17MD 04/t6r!ZTl3!17mD 04lu5l0z T14:17
paqo 1 d t3
lp"gt1.]
8912957130 NoZZI-E ASHiDEmo6EielIi7rfi ?nozn E ASII,DEFRo
AE 2357,30 $OZZIE ASll;DEFRo
Bqn23i5779l, NOZZIE ASMTDEFRO
Aqr?is:n 3l NOZZI.E ASm, DEFRo
6974t577it0 NOZZLE ASIIiDEFRO
69'2357130 NOzZtE AsI'l jDEFRO
SrraFn:to NoZZLE ASiii;DEFRO
897e88740 DUCT Agq,slDE WBt z3rm740 DUCTASldrStDE lil8972356140 DUCT AStt,StDE w/89721t5tr 40 DUCT ASftirStDE !il/8I'7235T'40 DUCT ASMiSIDE w/Errarssr4o Ducr AsrsloE wavrzJ58740 DUCT ASI{;SIBE WfBT,E6T,4O DUCT ASFI;SIDE W,897EFO?BO DUCT ASI4'SIDE w/sgilz3srrE0 DUCT As[rlrslDE w/EY,235E7EO DUCT ASMiSIDE W
0 DD2rtO41873 90092 IIICT ttso D.o2406.t8i4 901192 MCT 050 DD2rtO41675 90092 Il'lCT ll5n DiD24,,,.ta76 9tn92 MCT llso DD2.lMl87' 90892 IIiICT tli0 DD24041678 90092 BiCT G0 DD24041879 90092 t!'lCT IE0 DDZ{l410&l 90092 lItlCT tEi
0 DD24041801 90092 lrilcT 05
0 DD2rUI418A 9tn92 l!{CT (E0 0Dzrt0418Er 90092 ltncT 05
0 0Da4041884 9tn!r2 tllcT lls0 DD2r{l4rE6 90S92 lllcT t!5
0 DD24041866 90892 [!CT lE0 DD2.{!41EE7 900C2 trnCT tE0 DDZIII}0IEE gElrgz InCT lts0 DDz.ltElSa!, Sg09Z [rlCT tE0 DD2rrO4l6Xr gm92 trCT Gt0 DD2.1041691 90092 tFtCT IE
Figure 4.51View detail of texttileCopyright by Mahidol University
o Fac. of Grad- Studic, lvlahidol Univ. M.Sc.(Tech. of Inform. Sys- Manae.) / 77
o
raeea
Figure 4.52 Download text file
o
ffi6 , edl .'!i*st':'Fdrt{n;*t Ti'dk ::f{d}F
oCopyright by Mahidol University
Cholatis Srikanthimarak Discussion / 78
CHAPTERV
DISCUSSION
E-procgreme,lrt Web Application prototlpe for automotive industries is a
business model that is doing business online. This model is offered to be one soh$ion
of dara exchange for agtomotive indushies that involve OEM (Original Equipment
Ivlanufrctudng) and zuppliers. For OEIvIs, ttre developed protot5pe provides the
services of ordoing automotive parts and receiving delivery confirmation from their
sqppliers. For zuppliers, this prototlpe provides the service of receiving automotive
parts for requirement of OEM and sending ASN (Actuat Shrpprng Notice) for confirm
automotive parts quantity that will be delivered to production plaut. In this way, this
prototlpe has many intoesting points, uftich are analped below.
5.1 Strengths
1. From traditional systeq the ordering parts fiom zuppliers can perform
by frcsimile or attach the orders with carrier, but these methods take a time. Unlike the
proposed system, this prototpe oftrs the process in providing the service of
exchangeable data via Internet. The suppliers can receive the data irnmediately
thnough web application and convince the accuracy of data With the concept of
applylng the Intemet tecbnology, this prototype accommodates the exchangeable data
Mr*,een OENIs and strppliers.
Copyright by Mahidol University
Fac. of Grad. Studic,lvlahidol Univ. NLSc.Cfech. of Inform. Sys. Ivlanag.) / 79
Z. This developed prototlpe is a way of the reduction of paper work in
process. The mditional system used tons of paper for sending order via frcsimile or
attaching it with carriers.
3. This prototlpe can reduce cost of system implementation If corporate
want to implement thir ryrt -, they must prepare network and system infrastructure
becagse this system is a client-server application The information of hardware and
software specification is shoum below:
Ilardware Cost
- Web server and Dafabase seryer whichrunning onthe same machine
Itrel Pentinmm L26 GlIzCPU:
RAIvT I28 MB
Ilarddisk SCSI 18.2 GB
Monitor: SVGA Monitor 15'
Periph€rals: Keybar4 Mouse, CD-ROM Driveo NICFast
Ethernet
Prices 64.500 baht
- Application Server that run process of file handling, ASt{ and FT?
scheduler
CPU:
RAIVI:
Ilarddisk:
Monitor:
Idel Pentinmm 1.26 Gllz
128 MB
SCSI 18.2 GB
SVGA Monitor 15'Copyright by Mahidol University
a
o
o
o
Cholatis Srikanthimarak
Peripherals: Keyboar4 Moure,
Ethernet
Prices 64.500 baht
Total price is 129,A00 baht*
Software Cost
- Mictosoft Windows 2000 Selrrer (S-client)
- IUasromedia Dreamn'eaver 4.0
- lvlacromedia Homesite 5.0
- Adob Photoshop 6.0
Total price is 136,50a baht*
Discnssion/ 80
CD-ROM Drive, MCTast
36,000 baht
54,500 baht
16,300 baht
4,200 baht
25,500 baht
- Mcrosoft SQL Server 2000 Standard Edition (5-client)
Iv{an-day Cost '
This web application used 90 man-day for dweloping and testing. The
price is 1,200 hht/man-day. So total price of all man-day is 90*1200
: 108,000 baht
* pioo fiom Ek-Karaj Computer Co.Id.
and@/lumwamaancm
If Return on Invesfuent (ROD is 3 year, the net cost of system
implementation is (129,000+136,500+108,000y3 :124,500 bahuyear. Theq the cost
is plus by margin on top 50%. The net cost plus margin is 124,500+0.5(124,500) :
186,750 hht/year. On the other hand, EDI has montlly fee 1,500 baht and transactionCopyright by Mahidol University
Fac. ofCrrad" Studies, Ivlahidol Univ. tvlSc.(Tech. oflnform. Sp. Idanag.) / 81
fee is 4 bah/KB. Therefore, the cost of e-procurement web application is cheaper thm
EDI and the range of price that supplier will pay a month is shoum below:
5.2 Weknwses
1. The developed system is just a prototlpe which offers the model for
doing the business, it is not yet a corylete system" The script for handling text files
(delivery order or estimate order) has to activate by schedule program ufiich depends
on the file transfer t' ing. On the other han4 after ASN is sent completely, the qrctem
will have File Transfer Protocol (FTP) prograrn for transfer file from suppliers to
OEM immediately.
2. If the text file that receives from OEM is a large file (-lMB) for one
suppliern there is a problem in viewing data and printmg reports from web application
The system will slow doum from loading both data and reports via Internet. The
sohrtion for this proble,m is using software for printing reports that has to install into
client computer. Then, the next process use the download firnction from web
application to download text file(s) into client coryrfier and load it into printing
software for generating reports.
3. This prototype can not handle muhiple conrmrmity. Each supplier can
suppty automotive parts to multiple OEM. But the format of dafa and reports that send
Supplier amount Price fromEDI
(bahUmonth)
Cost from Web Application
(baht/month)
100 1,500 186,750/100112:156
300 1,500 186,7501300112: 52
Copyright by Mahidol University
Cholatis Srikanthimamk Discussion / 82
and receive is not the same. Then, web application will be modified for appropriate
work of zupplier. While EDI is zupport multiple corrmuoity using document mapping
software.
4. There is other cost tbat raise from this web application It is the cost of
time. The zupplier has to invest eryloyee to check for the order that is sent from
oEl{.
53 The benefits of an e-procurement web application prototype for automotive
industries
This developd prototype offers business model which apply advantage of
internet technology to the automotive business. It has many bnefits uftich are:
1. This prototlpe enables any organization or company to otfiain the
exchangeable data conveniently. It provides the service that helps those organizations
reduce the cost and time from traditional method. Furthermore, It does not consider
where the organization or company is locate4 because they can get the services by
usirg Internet.
2. This prototype reduces cost of system irylementation that shown in
Stength section Moreover, It uses concept of JIT for reduction of stock holding cost.
The cost reductionbenefit for automotive OEI!{.
3. If zuppliers fmd some error in dara they can infotm OEM to re-send
that dilaimediately.
Copyright by Mahidol University
o
o
o
o
Fac. ofGrad. Strdies, lvlahidol Univ. M.Sc.(tech. of Infmm. Sys. lvlanag.)/ 83
CEAPTERVI
CONCLUSION AND RECOMMEIITDATION
6.1 Conclusion
An e-procurement web application prototyp for automotive indusAy is one
of blsiness model applying Idemet technology to exchangeable data betwee'n OE}vIs
and zuppliers via Iffemet. The developed prototlpe is ofrered as one way to solve the
problem of high consrytion sf many kfods of resources zuch as paper, money and
time from the traditional method. Moreover, this proto6pe conveniently accesses from
everywhere using Internet.
This prototlpe can be regarded as a tlpe of e-Business. So the research
methodology considers business model that involves t\is prototlpe. There are 2 tlps
of involved business ie. OEMs and strppliers. OEIvIs are coqpaoies t.hat assemble
automotive parts from planned model Suppliers are produce$ of automotive parts that
supply OEhlb. Therefore, OEIvIs do involve abundant automotive parts in each
production For this reason, OEMS are production plamers who calculate the
requirement of automotive parts for each supplier. This requiremetr is called 'order'
aod divided in 2 tpes which are the estimate order and the delivery order. The
estimate order is forecast 3 months in advance for quantity of ar$omotive parts. While
the delivery order is astual automotive parts requireme,ff that specify quantity, due
date and due time. Both orders are sent in accordance with umge requiremed. They
have been sending schedule such as once a week or everyday which depends on the
tpe of thgt part. On the other hanq after suppliers received delivery order, they haveCopyright by Mahidol University
oCholatis Srikanthimarak Cmclusion / 84
to confirm actual quantrlies that wilt send though OEIvIs. Because OEM will find
another supplier, ifthat order has some problems (erergency order).
In ths development step, the prototlp is developed on Windows 2000
operating syste,m and uses Internet Infomation System for web sewer. About
Datahse, NIS SQL Server is usd. As it can manage a lot of data more effectively. In
the developrent tools, lvlacromedia theamweaver is used for design interfrces and
ASP scrbts isused indevelop webhsed application
The result, the protoffi can show handling data that received fiom OEIt[s
and stored it into Datahse. Moreover, tlis prototlpe shows web interfrrcs that
conveniently data exchange befirveeNr OEIvIs and zuppliers. This method can make the
accurate data and prevelrt losing dda Besides, system stores receiving date and time
and inclldes ASN se,nding date and time. This storage will be benefit in tracking data
whenthe eror occurs.
Finally, the developed proto6pe was tested by data posting fiom several
zuppliers into rystem to veriff accuracy. Moreover, it was tested via Internet by
dedicate host to erxiure prototype working proper$ via Internet.
62 Recommendations
1. In report printing of large records (-llvlts), supplier can doumload text
files and uses reprt printing softrrane instead of printing from web. Becatse report
loading vialnternet take more time.
2. Security is another important frctor in doing online busine.ss. The
security system must be considered in the fu rank of doing online business. It will
create confidence inthe users that using web application
o
o
aCopyright by Mahidol University
o
o
o
O
Fac. ofGrad- Studie, ldahidol Univ. M.Sc.(Tech. oflnform. Sys. lvlmag.) / 85
3. This prototlpe can be supprted the handling of multiple corr'-unity.
Because each supplier can send the same automotive part to another OEM. Supplier
wiltnot change the wayto receive orders from several OEIvI.
' 4. This prototlpe can be adapted to another business that involves the
supply chain qualification zuch as retail business, health cae business, etc.
5. In the aptual syste,m implementation, th€re will be a schedule for
sending text files (estimate order or delivery ordeD from OEM to suppliers.In order to
check the order from web application in each day, zuppliers can recognize time from
the schedule.
Copyright by Mahidol University
o
o
o
c
Cholatis Srikanthimarak Referencc / 86
RETERENCES
1. Simchi-Levi, D.o P.tcaminslry, andE. Simc,hi-Levi, Designingmd Mmagingthe
Strppty Chain Concepts, Strategies, and Case Smdies.2000: McCrraw-tfill
Book Coryanies,Inc.
2. Suzaki, Y*, The New Mam{acturing Chall mge : te chniErc s for contimtous
improvement.1987, Londoa The Free Press.
3. Monden, Y., Toyoto Production Systen: ond integrated qproach to Just'in-Time.
Second ed. 1993, Norcross, Georgia: Industrial Engineering and lvlanage'msnt
Press, Instihrte of Indusuial Engineers.
4. TCE, C. and S. Podolslry, Just-in-Time Mamdacfining- an intro&rction.1993,
London: Chapman and tlalL
5. Van Weele LJ., Parchasing Management. 1994: Chapman & HaIL IIK
6. EdelsteirU H., "(Jnraveling Client Serter Architectwes." mDBlvIS 7.NIay 1994.
p.7.
7. Eckerson, W.W., 'Tlree Tier Client/Sener Architechne: AchievingScalability,
Pedormarrce, and Efficiency in Client Sertter Applications." mOpen
hformation Systems I0. January 1995.p.20.
8. Cluts, N.W., An ASP You Can Grasp: The ABCs of Active Senter Poges. Mcrosoft
Corporation, 1997.
9. Active Sener Page. http://searchwin2000.techtarget. conr/sDefinition.
Copyright by Mahidol University
Fac. ofGrad- Studi6, tvlahidol Univ. fuLsc.(Tec,h. of Inform. Sp. Ivlanag.) / 87
10. Dai, Q. and RJ.Ituutuan, BUSINESS MODEI-S FOR NTERNET-BASED E-
PROCUREMENT SWTEMS AND B2B ELECTRONIC trVTII,RKETS: AN
UTnLOMTORY ASSESSMENT. the 34th llawaii International Confere,lrce on
Systems Scie,nceo 2000(January 2001).
11. Pressman, kS., Sofiwoe Engineering: A practitioner's Approach, d- Ath- 1997:
The McGRAW-HILL Coryanies. 852P.
12. Sctrmelzer, W.A., Trends in tlrc Automotive Supply Chain.
13. Baker, G., d aL, An exchanging advantage: &Wly clain innwation in the neut
economy. The White Paper series, 2000. Number2.http://www.itpapers.com.
14. Wondefware , Avantis e-Proctrement Strategt. Wonderware CanadaCorporatioq
200 I .http://www.wonderware. com.
15. KOEDRABRI]EN,P.,A PROTOTWE OF RETAIL BANKNG SERWCE
SWTEM ON INTEENET,MTECIINOLOGY OF NFOKIdATION SWTEM
IIANAGEMENT. 2A01, I\{AHIDOL . p. 162.
Copyright by Mahidol University
o
o
C
o
Srikanthimamk
APPENDD( A
MEAI\ING OF FIELD IN DELI\IERY ORDER
AppendixA/ 88
X'ield Meaning
DATA TYPE T1p of datathat setr to strPPlier
ORDERNO. the number of order that refer to automotive part (l Order
No.:lPartNo.)PRODUCTIONMONTH Month that production begin
ORIGINAL ORDERNO. neference Oraer No. in case of Claim Order normally will
be blank
CONSIGNEE Vendor supply parts to OEM
TIME DELTVERY CLASS Specifftime t' or blank for each data type e.g. IdA with
oT' meanthis part will be specified time later
PART NO. The code ofautomotive part
PART CONDITION Sp*rry part e.g. '0': Corylete part, o5': Subassembly part
KD/LOCAL Specily where automotive part from e-9. oP': Local, 'K':
IryortINSTALLAREA Specfy instatl area after receive from supplier
DI.]E DATE Specrfy date that will receive part from zupplier
ORDERQTY Spectfy quantity
PARI NAME The name ofpart
ITEMCLASIS Specfi one character ofpalment company
PR@T'RE CODE Specrfy code ofpalment comPany
WAREHOUSE
LOCATION
Specfy location of warehouse
VE}IDOR Code ofvendor
PLANNER Code ofpart tacking person
RECEIVTNGPLAI{T Place for part receiving
RECETVINGD@ Area ofplace for part receivingCopyright by Mahidol University
o
o'
o
o
L
Fac. ofGrad- Shrdieq tvlahidol Univ. M.$c.(Tech of Inform. Sys. Ivlanag.) / 89
NEWPART CODE Speciff which part is new e.g. '*': New par! ": Old part
PACKAGE CODE Unit of container
PACAGE VOLI.]ME auaotity in each coutaining
SI.JPPL'YDATE Specfy'date that consignee will receive part. Use with
CONSIGNEE
SUPPLYQTY Spwi& quatrity that consignee will receive. Use with
CONSIGNEE
\IENDORNAME Name ofvendor
Copyright by Mahidol University
o
o
o
o
Cholatis Srikanthimarak
APPEI\DD( B
ALLREPORTS TYPE
This appendix shows all reports that valid inthis research.
AppendixB / 90
Copyright by Mahidol University
o
o
a
o
Fac. of Grad- Strdies, Ivlahidol Univ. Ivlsc.Cfech of ldorm"
OLl08lO2 P.C = 1LIVERY TAG
Rr
IN
:.PlanVDoc.
T02Vendor VendorName
AAA AAA MIqNUFACTURING
New Code Conslgnee
Or
Nler No.
10000001
Part-No. Cond.
8979105741 0lu[[u[ilflrzuu[ruuflilrilrfl[[
Dt
Lie-Datet0u02
Order QtY30
Pi
G
rt Name
ILLE:SIDE DEF:LH
Due-Time
0:
o0z]0007
**t E-prormemed prddYIE *'*
Sys. Ivlanag;) / 91
Copyright by Mahidol University
o
o
a
o
P
Choldis Sdkamhimmak
OL|0S|OZ P.C = IR(
Ii:.PlanvDoc.:T. 02
VendorAAA
Vendor Name
AAA MANUFASTURING
New Code Conslgnee
Or
A/
ler No.
10000001
Part-No. Cond.
8979tO5741 0
Dr
tte-Datetgil02
Order Qty30
Pi
G
t Name
ILLE:SIDE DEF:LH
Pllot Package
PTB
NF
30WH
2A 000
InstallT4
0;
o
*t' E-Inocuemod DrototYP6 r'r*
AppendixB /92
Copyright by Mahidol University
Fac. of Grad" Studies, tvlahidolUriv.
ORDER S}IEET
MSc.(Tech. of Inform" Sys. Ivlanag;) / 93
oOLl08lO2 P.C = 1
Vendor VendorName
AAA AAAMANUFACTURING
**' E-pmsuronotri Dl'otdy;p **r
Copyright by Mahidol University
ooao
L.NO. CDBl82P
Vendor Code/Name: AAA (AAA MANUFACTURING)
{.,}* DAILY PART ORDER SHEET {c'r{3
Recelv, Plant: IMCT Recelv.Doc: 02Procure: TI5
Elg Part Name
O PANEL SUB ASM;INS. W
O PANEL SUB ASM;INS. W
O PANEL SUB ASM;INS. W
O PANEL SUB ASM;INS. W
O PANEL SUB ASM;INS. W
ot loEloz tPlanner: 90092
Ord-No.
AAl0000025AA10000026
AA10000027
AA10000028
AA10000029
Part-No.
897921299089792L2990897921299089792L299089792L2990
OrderDue-Tlme qty.
T 11:50 30
T t3:53 30
T OBt22 30
T 11:50 30
T 13:53 30
NewP-No,
ConslgneeCode
Orlglnal 11OrdCr No. Model Lot No. Reason For orde f
010zJ000 o47 B.olozBooo o7t u'
olozAooo oe3 EFolozjooo 048 HolozBooo o72 E
E!oEtl"
Due-Date
1.2tO7lO2
L2lO7lO2
L2lO7lO2
1.2lO7lO2
L2lO7lO2*** fi6(ofllgt ***
ttEEIIxtd\oF
Copyright by Mahidol University
oooo
L.NO. CDB1SOP :r{.:r. DELMRY ORDER SHEET (EIIIERGENCY ORDER) *rc:*
V€ndor Cod3/t{.ma: A A (AAA IiANUFACIURII{G) Procursr ISZT RftqlY. Plane CT R.l.tlv'Doc: 05 Pllnn r: 9Om2
NewOrd-No. P-No. Part-No. PIS Part Name
Order Conslgnee Orlglnal EDue-Date Due-Time aty. -SOde Order No. Model Lot No. Reason For Ordet S
AA10OOo031 8972939151 0 COVER;INSTRUMENT LZ|OT|OZ T 1
AA1OOOOO32 89792t299O 0 PANELSUBASM,INSW L2lO7lO2 T 1
AA1OOO0033 89794A7382 O GRILIE:MDIATO&IN-W L2lO7lO2 8
M10OOOO34 89794fl9082 0 BUMPER;FRONT,WFOX M 1'2lO7lO2 6
*:r* ln3l Of L|3t **tr
0u08/02 1!
030cF000 001 wMAsz qolozMooo 2L4 wIvlTR3 AS2 0olozEooo 810 Dc crc F.0102E000 810 Dccrc ?Eo.
b.o0<Er'b'o.oHcElB.
Fat)
aFqBFaa,
kbr'tD'
\o(r.
Copyright by Mahidol University
oooo
--NO. CIB021P
/endor Code/Name: AAA (AAA MANUFACTURING)
*,T'T ORDER CANCEL/DUE DATE CHANGE C}IECK LIST ***Recelv. Plant: IMCT Recelv.Doc: 05Procure:
PIE Part Name
O DUCTASM;SIDE W0 DUCTASM;SIDE WO DUCTASM;VENTILA
O DUCT ASM;VENTILA
O DUCTASM;VENTILA
Old NewDue-Date Due-Date Due-Tlma
LZIOTIOZT LL't'L7
t2lOTlOZT L1.;L7
tzlOTlOZT ttzLTtzlOTlOZT LtzLT
LAATIOZT tLzLT
**!r End of Llgt **r:
Planner: 90092
Conslgnee OrlghalCode Order No.
OVAS|O2 15:38:17
Page: 1
CommentCANCEL ORDER
CANCEL ORDER
CANCEL ORDER
CANCEL ORDER
CANCEL ORDER
Ord-No.
AAl0000041AA10000042AA10000043
AA10000044AA10000045
Part-No.
8972358740897235878089723588108972358841
8972358861
t)ongEi.v,alt.ts!,ltBEb,B,f
NewP-No.
Order4ry.30
30
30
30
30
B?l,ELxEO
\o(r\
Copyright by Mahidol University
aooo
L.NO. CDBOTOP
Conslgnee: AAA (AAA MANUFACTURING)
,r'r'i PART SUPPLY SCHEDULE *{.* OVABIOZ 15:39:45
Page: 1
Rocelvlng Recelvlng H,Plant Doc. FAAA 01 PiAAAolgAAA 01 FAAA 01 AgAAAolFAAA 01 P
Br'
a.o
EI
Paft-No.
9941.2279L2894L2279t2894L2279L2894t227gLz894L229662894L229662
AS Part Name
CAP;BEARING,REAR AS
CAP;BEARING,REAR AS
O\P;BEARING,REAR AS
CAP;BEARING,REAR AS
QIP;PEARING,FRONT AS
CAP;BEARINGIFRONTAS
Planner Supply DateSuoolvOW. KD/Local Order No. Vendor570 P KK10000001 TNrC
570 P KK10000002 Tmrc570 P KK10000003 TNIC
570 P KK10000004 TNIC
LTLO P KK1OOOOOO5 TNIC
LTLO P KK1OOOOOO6 TNIC
:r*:r lnjl of L|3t ***
910239102391023910239102391023
1"LlO7lO2
L6lO7lO2
22lO7lO2
3OlO7lO2
tlloTlo2L6lA7lO2
Due-Date Due-llmetuaTlo2t2lo7lo2L2107lO2
L2lO7lO2
L2lO7lO2
L2lO7lO2
FapllIFqlfBFav,
kE'tF'ga
\o{
Copyright by Mahidol University
aooo
L-NO. CDBfiOP
VendorCode/Nanre: AIAA
ESTIIIIATED ORDER INFORIiATION
(AAA ITIANUFACTURING Co)
PAGE: 1
ouaato2
oIta!iEt?n
a!l.FEEF
ItHF
)lnr., Rec.Plant Docrart No. PIC T,art Name[ew. Conslonee
w1L5tO7lO2
w222lO7lOZ
w329lO7lO2
w4oslosl02
W5Lzl08l02
w6L9loeloz
N2 N3
97109, IMCT 058972r50s20 A DRUBBER ASM;BUMPE
tsloT 300 23107 360 ?oto7 360 06/08 240 tzlo8 2180 19/08 480 26108 2760 30tog 3240
L6lO7 300 24t07 360 31.107 360 07108 360 13/08 360 20l08 420 02t09 4080 07tlo 2700
t7lo7 480 . zstoT 480 01/08 424 08/08 360 t4lo8 420 2UOe ts80 09tog 2&O
t8l07 300 25tO7 350 02/08 180 09/08 480 1sl08 480 22108 480 16/09 2700
t9lo7 480 27107 420 03/08 480 10/08 420 16/08 rt80 23t08 420 23tO9 2700
20to7 360 t7lo8 ,180
ootal) 1920 1980 1800 1860 2700 2280 14880 5940
97109, INCT 05a972:r49660 0 DRUBBERBN;BUMPE
t5tol 30 23t07 30 30lO7 30 )6/08 30 tzlo8 30 19/08 30 26t08 2N 30/09 240
t6t07 30 24107 60 3Llot 90 J7tO8 90 t3l08 60 20/08 60 0aa9 go 07llo 450
25t07 30 01/08 60 l8/08 60 t4to8 60 2LtO8 30 09tog 390
L8l07 30 26107 60 o2l08 60 t9/08 30 r.5/08 30 zuas 30 L6l09 390
27107 60 03/08 60 10/08 30 r.6/08 30 23loa 60 23109 390
20107 30 L7lO8 60
ffotall 90 24 300 2N 270 zLO 1950 590
97709, IMCT 058972:149670 0 DRUBBERA9M;BUMPE
t5l07 30 23107 30 30t07 30 r6/08 30 L2lO8 30 19/08 30 z6to8 240 30/09 2NL6l07 30 24107 60 3tta7 90 c7to8 90 r,3/08 60 2Al08 60 02t09 540 oTllo 4s0
25t47 30 01/08 60 38/08 60 L4t08 60 2L108 30 ,9/09 390
LBl07 30 26t07 60 o2lo8 60 t9/08 30 t s/08 30 2UOe 30 16/09 390
27107 50 03/08 60 10/08 30 16/08 30 23108 60 23t09 390
20107 30 L7lO8 60
fTotall 90 2N 300 240 27A zto 1950 590
EEEIEtXID
\oa
Copyright by Mahidol University
Fag. ofctrad" Studic, Ivlahidol Univ.
NAME
DATE OF BIRTE
PLACE OF BIRTH
INSTITUTIONS ATTENI)
POSITION & OFFICE
I4Sc.(Teh. of Inform. Sys. Ivlanag.) / 99
BIOGRAPHY
Mr. Cholatis Srikanthimarak
20M[arch" 1976
Bangko( Thailand
Thamasat University, 1994.1998:
Bachelor of Electical Eagineering
lvlahidol UniversitY, 1998'20A2:
lvlaster of Science (fechnology of Information
Systemlvlanagement)
2OOl-2002, Data Weaving Solution Co.Itd'
Position: System Engineer
Copyright by Mahidol University