INVENTORY M

L
SKU Code Product Name

TY001 Baby Doll

TY002 Toy Guitar
TY003 Plush Puppy
TY004 Dollhouse
TY005 Mini Racetrack
TY006 Robot
TY007 Jr. Doctor Kit
TY008 Playhouse
TY009 Bouncy Ball
TY010 Airplane
TY011 Intermediate Paper
TY012 G-tech Pen
TY013 Mongol 2 Pencil
TY014 Notebook (Comp)
TY015 Color Pencils
TY016 Crayons
TY017 Construction Paper
TY018 Highlighter Pens
TY019 Erasers
 TY020 Sharpener
TY021 Potato Chips
TY022 Oatmeal
TY023 Biscuits
TY024 Chocolate Bars
TY025 Candies
TY026 Ice Cream
TY027 Softdrinks
TY028 Juice
TY029 Yogurt
TY030 Fresh Milk

INQUIRY SYSTEM
SKU CODE TY030
PRODUCT NAME Fresh Milk
CATEGORY Groceries
LOCATION Shelf 6-5
UNIT PRICE 42
QTY. IN STOCK 0
INVENTORY VALUE $ -
STATUS Out of Stock
QTY. IN REORDER 20
TOTAL COST $ 760.00
DELIVERY STATUS Delayed

Product Name Reorder Time Needed

 Toys 7
School Supplies 10
Groceries 5
TORY MANAGEMENT
LIST
Product Category Product Location

Toys Shelf 1-1

Toys Shelf 1-2
Toys Shelf 1-3
Toys Shelf 1-4
Toys Shelf 1-5
Toys Shelf 2-1
Toys Shelf 2-2
Toys Shelf 2-3
Toys Shelf 2-4
Toys Shelf 2-5
School Supplies Shelf 3-1
School Supplies Shelf 3-2
School Supplies Shelf 3-3
School Supplies Shelf 3-4
School Supplies Shelf 3-5
School Supplies Shelf 4-1
School Supplies Shelf 4-2
School Supplies Shelf 4-3
School Supplies Shelf 4-4
School Supplies Shelf 4-5
Groceries Shelf 5-1
Groceries Shelf 5-2
Groceries Shelf 5-3
Groceries Shelf 5-4
Groceries Shelf 5-5
Groceries Shelf 6-1
Groceries Shelf 6-2
Groceries Shelf 6-3
Groceries Shelf 6-4
Groceries Shelf 6-5

INVENTORY TRAC

Total Stock on Hand

Total Invty. Value

ORDER SYSTE
Quantity
Total

PURCHASE SYST
 Quantity
Total Cost
GEMENT

Unit Unit Price Quantity in Stock

pcs $ 100.00 0
pcs $ 150.00 30
pcs $ 120.00 0
pcs $ 250.00 30
pcs $ 180.00 30
pcs $ 145.00 30
pcs $ 215.00 30
pcs $ 357.00 30
pcs $ 50.00 30
pcs $ 268.00 30
pcs $ 75.00 100
pcs $ 79.00 100
pcs $ 10.00 50
pcs $ 32.00 100
pcs $ 25.00 40
pcs $ 20.00 100
pcs $ 25.00 100
pcs $ 15.00 30
pcs $ 5.00 100
 pcs $ 5.00 100
pcs $ 12.00 50
pcs $ 15.00 50
pcs $ 10.00 50
pcs $ 10.00 50
pcs $ 85.00 25
pcs $ 35.00 0
pcs $ 45.00 50
pcs $ 12.00 50
pcs $ 15.00 50
pcs $ 42.00 0

INVENTORY TRACKER

tock on Hand 1,435

Invty. Value $ 82,575.00

ORDER SYSTEM
Quantity 35
Total Out of Stock

PURCHASE SYSTEM
Quantity 550
otal Cost $ 26,750.00
Inventory Value Reorder Level Status

$ - 20 Out of Stock
$ 4,500.00 20 Available
$ - 20 Out of Stock
$ 7,500.00 20 Available
$ 5,400.00 20 Available
$ 4,350.00 20 Available
$ 6,450.00 20 Available
$ 10,710.00 20 Available
$ 1,500.00 20 Available
$ 8,040.00 20 Available
$ 7,500.00 75 Available
$ 7,900.00 75 Available
$ 500.00 75 Reorder
$ 3,200.00 75 Available
$ 1,000.00 75 Reorder
$ 2,000.00 75 Available
$ 2,500.00 75 Available
$ 450.00 75 Reorder
$ 500.00 75 Available
$ 500.00 75 Available
$ 600.00 30 Available
$ 750.00 30 Available
$ 500.00 30 Available
$ 500.00 30 Available
$ 2,125.00 30 Reorder
$ - 30 Out of Stock
$ 2,250.00 30 Available
$ 600.00 30 Available
$ 750.00 30 Available
$ - 30 Out of Stock

For customer's orders

Quantity in Reorder Unit Cost Total Cost

10 78 $ 780.00
10 120 $ 1,200.00
10 100 $ 1,000.00
10 227 $ 2,270.00
10 165 $ 1,650.00
10 139 $ 1,390.00
10 195 $ 1,950.00
10 300 $ 3,000.00
10 37 $ 370.00
10 247 $ 2,470.00
25 60 $ 1,500.00
25 65 $ 1,625.00
25 8 $ 200.00
25 28 $ 700.00
25 20 $ 500.00
25 17 $ 425.00
25 22 $ 550.00
25 12 $ 300.00
25 3 $ 75.00
25 3 $ 75.00
20 8 $ 160.00
20 12 $ 240.00
20 8 $ 160.00
20 8 $ 160.00
20 76 $ 1,520.00
20 29 $ 580.00
20 35 $ 700.00
20 9 $ 180.00
20 13 $ 260.00
20 38 $ 760.00
Reorder time
Delivery Status
(Received)
5 Normal
5 Normal
6 Normal
7 Normal
7 Normal
8 Delayed
9 Delayed
8 Delayed
7 Normal
7 Normal
8 Normal
12 Delayed
11 Delayed
9 Normal
9 Normal
10 Normal
10 Normal
8 Normal
11 Delayed
10 Normal
5 Normal
4 Normal
6 Delayed
7 Delayed
7 Delayed
5 Normal
4 Normal
5 Normal
5 Normal
6 Delayed
SKU Code Product Name Product Category Product Location
TY001 Baby Doll Toys Shelf 1-1
TY002 Toy Guitar Toys Shelf 1-2
TY003 Plush Puppy Toys Shelf 1-3
TY004 Dollhouse Toys Shelf 1-4
TY005 Mini Racetrack Toys Shelf 1-5
TY006 Robot Toys Shelf 2-1
TY007 Jr. Doctor Kit Toys Shelf 2-2
TY008 Playhouse Toys Shelf 2-3
TY009 Bouncy Ball Toys Shelf 2-4
TY010 Airplane Toys Shelf 2-5
TY011 Intermediate Paper School Supplies Shelf 3-1
TY012 G-tech Pen School Supplies Shelf 3-2
TY013 Mongol 2 Pencil School Supplies Shelf 3-3
TY014 Notebook (Comp) School Supplies Shelf 3-4
TY015 Color Pencils School Supplies Shelf 3-5
TY016 Crayons School Supplies Shelf 4-1
TY017 Construction Paper School Supplies Shelf 4-2
TY018 Highlighter Pens School Supplies Shelf 4-3
TY019 Erasers School Supplies Shelf 4-4
TY020 Sharpener School Supplies Shelf 4-5
TY021 Potato Chips Groceries Shelf 5-1
TY022 Oatmeal Groceries Shelf 5-2
TY023 Biscuits Groceries Shelf 5-3
TY024 Chocolate Bars Groceries Shelf 5-4
TY025 Candies Groceries Shelf 5-5
TY026 Ice Cream Groceries Shelf 6-1
TY027 Softdrinks Groceries Shelf 6-2
TY028 Juice Groceries Shelf 6-3
TY029 Yogurt Groceries Shelf 6-4
TY030 Fresh Milk Groceries Shelf 6-5
 Unit Price Reorder Time in days
$ 100.00 7
$ 150.00 7
$ 120.00 7
$ 250.00 7
$ 180.00 7
$ 145.00 7
$ 215.00 7
$ 357.00 7
$ 50.00 7
$ 268.00 7
$ 75.00 10
$ 79.00 10
$ 10.00 10
$ 32.00 10
$ 25.00 10
$ 20.00 10
$ 25.00 10
$ 15.00 10
$ 5.00 10
$ 5.00 10
$ 12.00 5
$ 15.00 5
$ 10.00 5
$ 10.00 5
$ 85.00 5
$ 35.00 5
$ 45.00 5
$ 12.00 5
$ 15.00 5
$ 42.00 5