Mary Jean Solis

ABC Corporation InventoryMonitoring 2019 REORDER (outo-fill) ITEM NO. DATE OF LAST ORDER ITEM NAME VENDOR STOCK LOCATION DESCRIPTION COST PER ITEM STOCK QUANTITY TOTAL VALUE ORDER LEVEL NO. OF ITEM SOLD SELLING PRICE SALES COST OF ITEM SOLD ADDITIONAL CHARGES TOTAL COST OF GOOD SOLD REVENUE OK 001 01-2018 A ABC WH1 Item A decription $5.00 100 $500.00 50 50 $8.00 $400.00 $250.00 $10.00 $260.00 $140.00 REORDER 002 01-2018 B DEF WH2 Item B decription $3.00 50 $150.00 100 50 $6.00 $300.00 $150.00 $10.00 $160.00 $140.00 OK 003 01-2018 C GHI WH3 Item C decription $10.00 150 $1,500.00 100 100 $13.00 $1,300.00 $1,000.00 $10.00 $1,010.00 $290.00 REORDER 004 01-2018 D JKL WH4 Item D decription $15.00 20 $300.00 50 50 $18.00 $900.00 $750.00 $10.00 $760.00 $140.00 OK 005 01-2018 E MNO WH5 Item E decription $7.00 100 $700.00 50 100 $10.00 $1,000.00 $700.00 $10.00 $710.00 $290.00 REORDER 006 01-2018 F PQR WH6 Item F decription $8.00 200 $1,600.00 250 200 $11.00 $2,200.00 $1,600.00 $10.00 $1,610.00 $590.00 *** it can be modified base on your company's requirement