Page 225 - Accounting Information Systems

196 PART II Transaction Cycles and Business Processes

Total Inven Cost 300 200 600 1600 750 2800 850 Total Inven Cost 300 200 600 1580 750 2400 825

Standard Cost 1 2 3 2 3 4 1 Standard Cost 1 2 3 2 3 4 1

Vendor Number 25 25 18 25 18 18 25 Vendor Number 25 25 18 25 18 18 25

EOQ 500 200 500 1000 800 500 1000
EOQ 500 200 500 1000 800 500 1000 Qnty On Order 0 0 0 0 800 0 0

Original Inventory Master File Qnty On Reorder Order Point 0 100 0 20 0 150 0 100 800 300 0 60 0 200 New Inventory Master File Reorder Point 100 20 150 100 300 50 200

Qnty On Hand 300 100 200 800 250 700 850 Qnty On Hand 300 100 200 790 250 600 825

Update Fields Invoice Unit Amount Price 20 2 500 5 250 10 Description Description

Qnty Sold 10 100 25 Inven Num 11 12 13 14 15 16 17 Inven Num 11 12 13 14 15 16 17
ORDER Shipping Charges 5 20 10 PK PK

SALES

FROM Carrier Ship Date Code 011 12/24 011 12/24 011 12/24 Transaction File Sorted by Secondary Key to Primary

INVENTORY Order Date 12/22 12/22 12/22 Key of Master File

OF Sales Order Transaction File SK Inven Num 14 16 17
UPDATE Acct Num 4 7 1

PK Order #
E 1 2 3
R
U 4-24
FIG