Description
MIS can be useful in capturing transactions in warehouse and stores. It also lists the essential transactions to be captured by MIS.
PRODUCTION DEPARTMENT
PR
PR
PURCHASE
PO 1 PO 1 ACCOUNT S
Hell S o endin
g
GRN
GR N
CABINET/RACK, DRAWER/SHELF & BIN
INVENTORY LOCATED IN
Hell o
PO 1 VENDOR
Material & Invoice Material & Invoice
PRODUCTION DEPARTMENT
PURCHASE PO1 PR
ACCOUNTS
PO1 PR
STORE S
Material & Invoice
VENDOR
GR PO1 N
CABINET/RACK, DRAWER/SHELF & BIN
INVENTORY LOCATED IN
Cost Savings
Reduce Acquisition Costs! ? Reduce Receiving Costs ? Reduce Carrying Costs ? Reduce Purchasing Costs ? Eliminate Obsolete Inventory
300%
100%
Cost of Managing Tools Can Be As High As Three Times the Cost of Tools!
Cost of tools
Cost of managing tools - logistics, purchasing administration, accounting
Data from German aerospace customer
ITEM CODE ITEM DESC ORDER TYPE
PR NO
DATA REQUIRED TO GEREATE MIS
DELIVERY TIME
PO NO
QTY
STOCK, ROL, ORDER
UNIT PRICE
DATA REQUIRED ITEM CODE
ITEM DESCRIPTION PURCHASE REQUISITION NO (PR) PURCHASE ORDER NO. (PO) STOCK QUANTITY RE-ORDER LEVEL (ROL)
SOURCES OF DATA ITEM MASTER
ITEM MASTER PR MASTER PO MASTER ITEM STOCK MASTER ITEM MASTER
ORDER QUANTITY
UNIT PRICE DELIVERY TIME ORDER TYPE (STOCK / NON STOCK)
STOCK OUT REPORT / ITEM STOCK MASTER / USAGE REPORT
ITEM MASTER ITEM MASTER (as obtained from supplier) ITEM MASTER
Item Code
Description
PACKET SIZE
ITEM PRICE
SUPPLIER CODE
SUPPLIER PRICE
SUPPLIER DISCOUNT
RE-ORDER QTY
LEAD TIME (DAYS)
ORDER TYPE
2394935 2301403 2393428 2300695 2301723 2500572 2500532
PCHN 20-24-07243 * DGTL 25B-3D40 DGTR 12B-2D24SH SGSF 160-4-40K GM D100-4DG-22K HFHR 25-65-6T20 HELIIR 25C-305
1 1 1 1 1 1 1
25000 15000 14369 24560 21456 9846 12435
1 1 1 1 2 3 1
27778 16667 15966 27289 23840 10940 13817
10% 10% 10% 10% 10% 10% 10%
2 3 3 2 1 2 2
20 30 30 15 7 20 15
STOCK STOCK STOCK STOCK NON STOCK STOCK STOCK
2800347
2800226 2801039 2900038 2900051 2900098
GHIR 25-25-4
GHFGR 32-155-8 GEHIR 10-13-2 TGHN 32-3D TGIR 20C-3 TGDL 2020-4M
1
1 1 1 1 1
8978
6700 12110 9800 10980 10560
1
1 1 2 1 1
9976
7444 13456 10889 12200 11733
10%
10% 10% 10% 10% 10%
1
1 1 1 1 1
5
5 5 7 5 5
NON STOCK
NON STOCK NON STOCK NON STOCK NON STOCK NON STOCK
doc_100727578.pptx
MIS can be useful in capturing transactions in warehouse and stores. It also lists the essential transactions to be captured by MIS.
PRODUCTION DEPARTMENT
PR
PR
PURCHASE
PO 1 PO 1 ACCOUNT S
Hell S o endin
g
GRN
GR N
CABINET/RACK, DRAWER/SHELF & BIN
INVENTORY LOCATED IN
Hell o
PO 1 VENDOR
Material & Invoice Material & Invoice
PRODUCTION DEPARTMENT
PURCHASE PO1 PR
ACCOUNTS
PO1 PR
STORE S
Material & Invoice
VENDOR
GR PO1 N
CABINET/RACK, DRAWER/SHELF & BIN
INVENTORY LOCATED IN
Cost Savings
Reduce Acquisition Costs! ? Reduce Receiving Costs ? Reduce Carrying Costs ? Reduce Purchasing Costs ? Eliminate Obsolete Inventory
300%
100%
Cost of Managing Tools Can Be As High As Three Times the Cost of Tools!
Cost of tools
Cost of managing tools - logistics, purchasing administration, accounting
Data from German aerospace customer
ITEM CODE ITEM DESC ORDER TYPE
PR NO
DATA REQUIRED TO GEREATE MIS
DELIVERY TIME
PO NO
QTY
STOCK, ROL, ORDER
UNIT PRICE
DATA REQUIRED ITEM CODE
ITEM DESCRIPTION PURCHASE REQUISITION NO (PR) PURCHASE ORDER NO. (PO) STOCK QUANTITY RE-ORDER LEVEL (ROL)
SOURCES OF DATA ITEM MASTER
ITEM MASTER PR MASTER PO MASTER ITEM STOCK MASTER ITEM MASTER
ORDER QUANTITY
UNIT PRICE DELIVERY TIME ORDER TYPE (STOCK / NON STOCK)
STOCK OUT REPORT / ITEM STOCK MASTER / USAGE REPORT
ITEM MASTER ITEM MASTER (as obtained from supplier) ITEM MASTER
Item Code
Description
PACKET SIZE
ITEM PRICE
SUPPLIER CODE
SUPPLIER PRICE
SUPPLIER DISCOUNT
RE-ORDER QTY
LEAD TIME (DAYS)
ORDER TYPE
2394935 2301403 2393428 2300695 2301723 2500572 2500532
PCHN 20-24-07243 * DGTL 25B-3D40 DGTR 12B-2D24SH SGSF 160-4-40K GM D100-4DG-22K HFHR 25-65-6T20 HELIIR 25C-305
1 1 1 1 1 1 1
25000 15000 14369 24560 21456 9846 12435
1 1 1 1 2 3 1
27778 16667 15966 27289 23840 10940 13817
10% 10% 10% 10% 10% 10% 10%
2 3 3 2 1 2 2
20 30 30 15 7 20 15
STOCK STOCK STOCK STOCK NON STOCK STOCK STOCK
2800347
2800226 2801039 2900038 2900051 2900098
GHIR 25-25-4
GHFGR 32-155-8 GEHIR 10-13-2 TGHN 32-3D TGIR 20C-3 TGDL 2020-4M
1
1 1 1 1 1
8978
6700 12110 9800 10980 10560
1
1 1 2 1 1
9976
7444 13456 10889 12200 11733
10%
10% 10% 10% 10% 10%
1
1 1 1 1 1
5
5 5 7 5 5
NON STOCK
NON STOCK NON STOCK NON STOCK NON STOCK NON STOCK
doc_100727578.pptx