MOTORCYCLE PARTS INVENTORY MANAGEMENT SYSTEM

Ailada Treerattrakoon Department of Industrial Engineering, Faculty of Engineering,

Kasetsart University, Thailand fengadt@ku.ac.th

Tanaporn Lersbuasin,

Department of Industrial Engineering, Faculty of Engineering, Kasetsart University, Thailand

tanapon.ler@hotmail.com

Abstract: The objective of this study is to design an inventory management system for motorcycle parts manufacturing in order to control inventory of raw material, forecast demand and schedule production planning. The system includes storage for inventory, an indicator for monitoring the motorcycle parts and reporting the level of current inventory of the items. The integrated information on the status of inventory is used to decide whether an order for the inventory should be made. This system helps to keep track the flow of products and supplies faster and reduce the total inventory cost. Keywords: motorcycle parts inventory, inventory management, inventory system, production planning

1367

1. INTR There iscontrol aof motormanageapplied There is all inform This resinventoryinventorymanufacinventoryestimate 2. PRO The motwhich ha Figure 1:

Source: A There arcalculatecategoriz Figure 2:

Source: A There areCNC milli

RODUCTIO

s a high comare importantrcycle part mment systemdue to entrenot an inven

mation in ord

search is aimy status any managemecturer. All invy manageme

e cost for eac

OBLEM AN

torcycle partas at least 11

: Anodized alu

A case study o

re more thaned. Make-to-zed by dema

: Product grou

A case study o

e 42 CNC maing machines,

ON

mpetition in st tools to optanufacturer

m causing pepreneur’s entory manager to make a

med to desind inventory ent system dventory recoent system, ch product.

NALYSIS

t manufactur10 types. Pro

uminum

of motorcycle p

n 945,000 pie-stock produand as figure

ups’ demand

of motorcycle p

achines which 10 drilling ma

small and mtimize utilizathas sufficienroduction eff

experience inement syste

a good decisi

gn the inveshortage w

esign is deveords have be

determine r

rer has moreoduct charac

part manufact

eces of workuction is base 2.

part manufact

h are 14 CNCachines, and 3

medium entertion of capacnt labor, macfficiency is nncluding rawem which proion for the en

ntory managwarning, inceloped to be

een applied traw material

e than 774 pcteristic is an

turer

k in process (sed on entre

turer

C turning mach3 cutting mach

rprises in Thcity, time andchine, experienot high. Maw material orovides inventntrepreneur.

gement systcluding forece easy use anto forecast rreorder poi

products. Theodized alum

(WIP) inventepreneur’s d

hines with feehines with layo

hailand. Prodd cost of prodence and ski

ake-to-stock rdering and tory record a

tem to recorcasting raw nd appropriaaw material nt and prod

e main raw inum as figu

tory. Productdecision. Pro

eding, 13 CNCout as figure 3

duction planduction. A caill, but lack oproduction hproduction snd status to

rd inventorymaterial in

ate for motorcinput, impleuction sched

material is are 1.

t cost has neoduct groups

C turning mac3.

nning and ase study of efficient has been schedule. integrate

, present put. The cycle part ement the dule, and

aluminum

ever been s can be

chines, 15

1368

Figure 3:

Source: A Producti Figure 4:

Source: A

: Machines lay

A case study o

on process f

: Production p

A case study o

yout

of motorcycle p

from raw mat

process

of motorcycle p

part manufact

terial to finis

part manufact

turer

h goods is as

turer

s figure 4.

1369

3. THE The inve Figure 5:

Source: A Raw mapoint, sacan be aarrives, traw matscheduleExcel file

3.1. R Capabilit Input: Qu Output: B There arData she AddmatD AddmatD

E INVENTO

entory manag

: The inventor

A case study o

aterial inventafety stock, eaccessed viatypes and quterial to fulfile production es.

Raw mater

ty: Presentin

uantities and

Balance, saf

re 3 spread eet.

Data sheet

Data sheet is

ORY MANA

gement syste

ry managemen

of motorcycle p

tory and noeconomic pra computer uantities of rll customer planning. T

rial

ng, warning, a

d date of rece

fety stock, EO

sheets in th

s used to reco

AGEMENT

em model is

nt system mod

part manufact

n-anodized roduction qunetwork in tequired prodorder and she designed

and forecast

eiving and us

OQ, and mon

is file which

ord quantities

T SYSTEM

as figure 5.

del

turer

products invantity (EPQ)the motorcycducts will be atisfy safety inventory m

ting inventory

sing raw mat

nthly forecas

are Addmat

s and date of

M DESIGN

ventory shou), and econocle part manconverted to

y stock. Prodmanagement

y of raw mate

terial (in and

sting of raw m

tData sheet,

f receiving an

uld provide somic order qnufacturer. Wo types and duction time system has

erial status.

out).

material.

Balance Ma

nd using raw

stock statusquantity (EOWhen customquantities ofwill be estibeen develo

at sheet, and

material as f

s, reorder Q) which

mer order f required mated to oped in 3

d Kg Mat

figure 6.

1370

Figure 6:

Source: A Balance Balance Figure 7:

Source: A Kg Mat D Kg Mat D

: AddmatData

A case study o

Mat sheet

Mat sheet p

: Balance Mat

A case study o

Data sheet

Data sheet pre

sheet

of motorcycle p

presents bala

t sheet

of motorcycle p

esents foreca

part manufact

ance of raw m

part manufact

asting of raw

turer

material as fig

turer

material as

gure 7.

figure 8.

1371

Figure 8:

Source: A

3.2 W Capabilit Input: Qu Output: Wof non-a Work in quantity Figure 9:

Source: A

3.3 P Capabilitproductio Input: Qu Output: and totaThere arDatabas

: Kg Mat Data

A case study o

Work in pro

ty: Presentin

uantities and

Work in procnodized prod

process inveof non-anod

: Work in pro

A case study o

Production

ty: Determinon time.

uantities of r

Required prl usage of prre 4 spread

se sheet, and

1. A

2. Add Re

sheet

of motorcycle p

ocess inven

ng, warning, a

d date of rece

cess balanceducts.

entory file wdized product

ocess invento

of motorcycle p

input

ning product

equired prod

roducts, requroduction timsheets in th

d PRD Order

Add EPQ line (

eproduction Po

3. A

part manufact

ntory

and forecast

eiving and us

e, reproducti

will present rets as figure 9

ory output

part manufact

tion schedule

ducts and pro

uired producme in selectedhis file whichr Print Out sh

(Auto run)

oint line

Add SS line

turer

ting inventory

sing non-ano

ion point, sa

eproduction 9.

turer

e and summ

oduction sch

tion time, tod period. h are PRD Inheet.

y of non-ano

odized produ

afety stock, a

point, safety

marizing req

edule.

tal usage of

nput Order s

dized produc

ucts (in and o

and economi

y stock, and

uired raw m

f raw materia

sheet, BOM

cts status.

out).

c production

economic p

material and

al in selecte

Database sh

n quantity

roduction

required

ed period,

heet, Mat

1372

PRD Inp PRD Inpsystem w Figure 10

Source: A When saperiod a Figure 11period

Source: A After tha Figure 12

Source: A

put Order she

put Order shwill calculate

0: Adding data

A case study o

aving file, all nd total usag

1: Total usag

A case study o

at the inventor

2: Production

A case study o

AdDa1

eet

heet is used required pro

a in PRD Inpu

of motorcycle p

data will colge of product

ge of raw ma

of motorcycle p

ry manageme

n status

of motorcycle p

dd ata

d to record aoducts, requi

ut Order she

part manufact

llected in dattion time in s

aterial in sele

part manufact

nt system will

part manufact

Total Mat. Requir

Material

and determiired producti

eet

turer

tabase to caselected perio

ected period

turer

present produ

turer

rement 45.49 m.

ne productioon time as fi

lculate total od as figure

and total usa

uction status a

on schedulegure 10.

usage of raw11.

age of produ

as figure 12.

. When add

w material in

ction time in

ing data,

selected

selected

1373

Producti Figure 13

Source: A 4. SUM Before aman that motorcycstatus, toto help wto checkschedule REFER

1. ApOn

2. Atprlev

3. BaTh

4. Bam98

5. GoIn

6. KaTh

7. KiAg

8. PeBa

9. SaMUn

10. Si(M

11. SuReUn

12. SuDe

13. ViDeUn

on operator

3: Production

A case study o

MMARY

applying the took long timcle part manotal usage ofworkers workk inventory se also has be

RENCE LIS

pisit Wiwatyone-warehousta Allah Talroduction sysvel constrainantita Jamjunhesis). Kasearriga, E. M.anufactured 8. opalakrishnaternational joarn Kankanhesis). Kasettisak Saen-gricultural Inpetch Kloumkangkok Metrasiprapa Lim

Materials andniversity, Bariluk Piyatr

Master’s Thesurachate Teeduction. Aniversity, Baurat Suktoremands. (Mroj Petchkinemand in a niversity, Ba

can print out

order

of motorcycle p

inventory manme and was dnufacturer haf raw materiak faster and status has been reduced

ST

otinchai. (20se and Multi-leizadeh Sestem with stnt Journal on. (2013). Detsart Univers., J. G. Jeonhousing ind

an, P. (19ournal of phyok (2009)

etsart Univers-Un. (2009)put’s Retailekliange. (20ropolitan Areampakarn. (d Componenngkok.

raiphoom. (sis). Kasetsepkaew. (2A Case Studngkok. r. (2010).

Master’s Thesng. (2006).

Ceramics Tngkok.

t production

part manufact

nagement sysdifficult to dev

as necessaryal and total uentrepreneu

been reducefrom 30 min

011). Genet-retailer Systeyed Taghi tochastic scr

of ComputatioDevelopmentsity, Bangkong, M. Hastadustry. ASC

976). Invenysical distribu

VBA Spreasity, Bangko. A Developm

ers. (Master’s010). Invena. (Master’s(2013). Munts Inventory

2013). Matart University

2010). Appldy of Sanita

Setting Sasis). Kasetsa ImprovemeTableware M

order as figu

turer

stem, recordinvelop. After ay database wusage of produr make a riged from 30 mn to 3 min.

tic Algorithm tem. (MasteAkhavan N

rapped prodonal and Appt of MRP Frak.

ak and M. SCE, Journal o

ntory probleution & Logis

adsheet Simuk. ment of Invens Thesis). Kntory Manags Thesis). Kaultiple Itemsy Manageme

terial Inventoy, Bangkok.lication of Leary Fitting M

fety Stock Lart Universityent of InventoManufacturin

ure 13.

ng, calculatingapplying the which provideduction time,

ght decision dmin to 3 min

for Determinr’s Thesis).

Niaki (2010uction rate, plied Mathemamework for

yal. (2005).of Managem

ems in pubstics manageulation Add-I

ntory ControKasetsart Unigement of Hasetsart Univs Economic ent System.

ory Managem

ean ManufacManufacture.

Levels for Py, Bangkok.ory Policies

ng Company

g, and checkininventory ma

es production, and other ndue to updatn. Time to d

nation of RepKasetsart Un

0) Multipropartial back

matics, 233, 1Job Shop En

. Meterial cent in Engin

blic sector eement, 6, 135Ins for Micro

ol Flow Softwiversity, BangHousing Devversity, Bang

Production (Master’s

ment for Co

cturing Tech. (Master’s

Products wit

for Raw May. (Master’s

ng status wereanagement syn schedule, necessary infted informatidetermine p

plenishment niversity, Baoduct single-kordering and1834-1849. nvironment.

control systemneering 2005

enterprises 5-143 soft Excel

ware: A Casegkok. velopment Pgkok.

Quantity wThesis). K

orn Processin

hniques for Thesis). K

th High Vari

terials with Us Thesis). K

e made by ystem, the inventory formation ion. Time roduction

Policy in ngkok. -machine d service

(Master’s

m for the 5, 21, 91-

in India.

(Master’s

e Study of

Project in

with Raw Kasetsart

ng Plant.

Inventory Kasetsart

riability in

Uncertain Kasetsart

1374