Date Explanation Received IN Shipped OUT Balance on Hand
30-01-2019 10:00 Start Inventory 0 0 100
30-01-2019 08:00 Customer sale 0 10 90
31-01-2019 08:00 Customer sale 0 10 80
01-02-2019 08:00 Customer sale 0 10 70
02-02-2019 08:00 Customer sale 0 10 60
03-02-2019 08:00 Purchase 100 0 160
04-02-2019 08:00 Purchase 40 0 200
05-02-2019 08:00 Purchase 100 0 300
06-02-2019 08:00 Customer sale 0 50 250
06-01-2019 10:00 Customer sale 0 50 200
Stock Item Stock on Hand Stock on Sales Order Stock Available Reorder Level Unit Cost Stock on Hand Value Needs Reorder
Coca-Cola can 300mlX24 800 80 720 100 ₦650 ₦520,000 NO
Coca-Cola can 300mlX24 700 70 630 100 ₦655 ₦500,000 NO
Coca-Cola can 300mlX24 500 50 450 500 ₦700 ₦340,000 NO
Coca-Cola can 300mlX24 300 50 450 500 ₦400 ₦560,000 YES
Coca-Cola can 300mlX24 650 50 450 500 ₦400 ₦250,000 YES
Coca-Cola can 300mlX24 250 50 450 100 ₦400 ₦150,000 NO
Coca-Cola can 300mlX24 850 50 250 100 ₦700 ₦570,000 NO
Coca-Cola can 300mlX24 750 40 350 100 ₦650 ₦270,000 NO
Coca-Cola can 300mlX24 850 50 450 100 ₦750 ₦870,000 NO
Coca-Cola can 300mlX24 250 50 250 100 ₦750 ₦360,000 NO
Product Qty
Coca-Cola Can 33cl x 6
Coca-Cola Can 33cl x 12
Coca-Cola Can 33cl x 24
Coca-Cola Zero Can 33cl x 6
Coca-Cola Zero Can 33cl x 12
Coca-Cola Zero Can 33cl x 24
Coca-Cola Bottle 50cl x 6
Coca-Cola Bottle 50cl x 12
Coca-Cola Bottle 50cl x 24
Fanta Orange Can 33cl x 6
Fanta Orange Can 33cl x 12
Fanta Orange Can 33cl x 24
Fanta Orange Bottle 33cl x 6
Fanta Orange Bottle 33cl x 12
Fanta Orange Bottle 33cl x 24
Sprite Can 33cl x 6
Sprite Can 33cl x 12
Sprite Can 33cl x 24
Sprite Bottle 33cl x 6
Sprite Bottle 33cl x 12
Sprite Bottle 33cl x 24
Eva water bottle 75cl x 6
Eva water bottle 75cl x 6
Eva water bottle 75cl x 12
Eva water bottle 75cl x 24
Five Alive Orange 1L x 6
Five Alive Orange 1L x 12
Five Alive Orange 1L x 24
Schweppes Bitter Lemon Can 33cl x 6
Schweppes Bitter Lemon Can 33cl x 12
Schweppes Bitter Lemon Can 33cl x 24
Items to Transfer
Coca-Cola Can 33cl x 6
Coca-Cola Can 33cl x 12
Fanta Orange Can 33cl x 12
Sprite Can 33cl x 12
Sprite Can 33cl x 24
Ship From
Coca-cola - Apapa Depot Edit
Ship To
Coca-cola - Ikeja Depot Edit
Totals
Total Qty (Cases or Bags) 350
Total Weight (kg) 3,000
Date
18/11/2019
Shipment Name
Ikeja Shipment
No. of Units
300
Weight
2,000kg
Supplier
Date Stock Item No. of Units Received Supplier Status
30-01-2019 Coca-Cola Can 350mlX24 800 Accepted
30-01-2019 Coca-Cola Can 350mlX24 600 Accepted
30-01-2019 Coca-Cola Can 350mlX24 700 Accepted
30-01-2019 Coca-Cola Can 350mlX24 400 Accepted
30-01-2019 Coca-Cola Can 350mlX24 350 Accepted
30-01-2019 Coca-Cola Can 350mlX24 450 Accepted
30-01-2019 Coca-Cola Can 350mlX24 900 Accepted
30-01-2019 Coca-Cola Can 350mlX24 145 Accepted
30-01-2019 Coca-Cola Can 350mlX24 250 Accepted
30-01-2019 Coca-Cola Can 350mlX24 350 Accepted