0% found this document useful (0 votes)
120 views13 pages

Inventory System - School Supplies

Uploaded by

kenjy2022
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
120 views13 pages

Inventory System - School Supplies

Uploaded by

kenjy2022
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 13

Code Description A4 149

A1 ID Holder long 163


A2 Black Marker -Eagle short 138
A3 Popsicle Stick
A4 Tray - Medium
A5 Tray - Small
A6 Alcohol - Pure Protect
A7 Alcohol - Young
A8 Meter Stick
A9 Tape Measure
A10 POP It Toy
A11 Band Aid - Medicare
A12 Battery - Kimpower- AA
A13 Battery - Kimpower- AAA
A14 Thumb Tacks
A15 Eraser- Whiteboard
A16 Air Pump - Balloon
A17 Balloon - 12" -W/ Design
A18 Balloon- 12 -W/out Design
A19 Balloon - 10" -W/out Design
A20 Balloon - 5" -W/out Design
A21 Umbrella
A22 Cutter
A23 Cutter (Small)
A24 Plastic ware
A25 Face Mask (Blue)
A26 Face Mask (Black)
A27 Hanger
A28 Chalk
A29 Pad - Grade 1
A30 Pad - Grade 2
A31 Pad - Grade 3
A32 Pad - Grade 4
A33 Stationary Tape - Kingtape
A34 Stationary Tape - Hawk
A35 Stationary Tape - Armak
A36 Paper tape
A37 Double-sided Tape - 1inch
A38 Double-sided Tape - 2inch
A39 Puncher
A40 Scissors
A41 Brown Envelope - Long
A42 White Folder - Short
A43 White Folder - Long
A44 Clear Book - Small
A45 Clear Book - Big
A46 Highlighter
A47 Correction Tape - Small
A48 Correction Tape - Big
A49 White Glue
A50 Clear Glue
A51 Crayon - 8Colors
A52 Crayon - 12Colors
A53 Sharpener
A54 Eraser - Tebang
A55 Pencil
A56 Record Book - Pixel 150
A57 Record Book - Pixel 300
A58 Mini Record Book - 150
A59 Mini Record Book - 500
A60 Hook
A61 Whiteboard Pen - w/ Eraser
A62 Ballpen - 4pcs/pack
A63 Ballpen - 6pcs/pack
A64 Marker - 4pcs/pack
A65 Roller
A66 Stapler - No. 306
A67 Stapler - No. 10
A68 Sticker Paper
A69 Laminator
A70 Photopaper
A71 Weighing Scale
A72 Bond Paper - A4
A73 Bond Paper - Short
A74 Bond Paper - Long
A75 Joy Correction Tape
A76 Ord Inv Long
A77 Crayola - 8
A78 Crayola - 16
A79 Crayola - 24
A80 laminating film
A81 Duct tape
A82 Masking Tape
A83
A84
A85
A86
A87
A88
A89
186.25 190
203.75 205
172.5 175
NO INPUT

Date Supplier Description


01-Nov-21 Beside Lead Trend ID Holder
01-Nov-21 Beside Lead Trend Black Marker -Eagle
01-Nov-21 Beside Lead Trend Popsicle Stick
01-Nov-21 Beside Lead Trend Tray - Medium
01-Nov-21 Beside Lead Trend Tray - Small
01-Nov-21 Beside Lead Trend Alcohol - Pure Protect
01-Nov-21 Beside Lead Trend Alcohol - Young
01-Nov-21 Beside Lead Trend Meter Stick
01-Nov-21 Beside Lead Trend Tape Measure
01-Nov-21 Beside Lead Trend POP It Toy
01-Nov-21 Beside Lead Trend Band Aid - Medicare
01-Nov-21 Beside Lead Trend Battery - Kimpower- AA
01-Nov-21 Beside Lead Trend Battery - Kimpower- AAA
01-Nov-21 Beside Lead Trend Thumb Tacks
01-Nov-21 Beside Lead Trend Eraser- Whiteboard
01-Nov-21 Beside Lead Trend Air Pump - Balloon
01-Nov-21 Beside Lead Trend Balloon - 12" -W/ Design
01-Nov-21 Beside Lead Trend Balloon- 12 -W/out Design
01-Nov-21 Beside Lead Trend Balloon - 10" -W/out Design
01-Nov-21 Beside Lead Trend Balloon - 5" -W/out Design
01-Nov-21 Beside Lead Trend Umbrella
01-Nov-21 Beside Lead Trend Cutter
01-Nov-21 Beside Lead Trend Cutter (Small)
01-Nov-21 Beside Lead Trend Plastic ware
01-Nov-21 Beside Lead Trend Face Mask (Blue)
01-Nov-21 Beside Lead Trend Face Mask (Black)
01-Nov-21 Beside Lead Trend Hanger
01-Nov-21 Beside Lead Trend Chalk
01-Nov-21 Beside Lead Trend Pad - Grade 1
01-Nov-21 Beside Lead Trend Pad - Grade 2
01-Nov-21 Beside Lead Trend Pad - Grade 3
01-Nov-21 Beside Lead Trend Pad - Grade 4
01-Nov-21 Beside Lead Trend Stationary Tape - Kingtape
01-Nov-21 Beside Lead Trend Stationary Tape - Hawk
01-Nov-21 Beside Lead Trend Stationary Tape - Armak
01-Nov-21 Beside Lead Trend Paper tape
01-Nov-21 Beside Lead Trend Double-sided Tape - 1inch
01-Nov-21 Beside Lead Trend Double-sided Tape - 2inch
01-Nov-21 Beside Lead Trend Puncher
01-Nov-21 Beside Lead Trend Scissors
01-Nov-21 Beside Lead Trend Brown Envelope - Long
01-Nov-21 Beside Lead Trend White Folder - Short
01-Nov-21 Beside Lead Trend White Folder - Long
01-Nov-21 Beside Lead Trend Clear Book - Small
01-Nov-21 Beside Lead Trend Clear Book - Big
01-Nov-21 Beside Lead Trend Highlighter
01-Nov-21 Beside Lead Trend Correction Tape - Small
01-Nov-21 Beside Lead Trend Correction Tape - Big
01-Nov-21 Beside Lead Trend White Glue
01-Nov-21 Beside Lead Trend Clear Glue
01-Nov-21 Beside Lead Trend Crayon - 8Colors
01-Nov-21 Beside Lead Trend Crayon - 12Colors
01-Nov-21 Beside Lead Trend Sharpener
01-Nov-21 Beside Lead Trend Eraser - Tebang
01-Nov-21 Beside Lead Trend Pencil
01-Nov-21 Beside Lead Trend Record Book - Pixel 150
01-Nov-21 Beside Lead Trend Record Book - Pixel 300
01-Nov-21 Beside Lead Trend Mini Record Book - 150
01-Nov-21 Beside Lead Trend Mini Record Book - 500
01-Nov-21 Beside Lead Trend Hook
01-Nov-21 Beside Lead Trend Whiteboard Pen - w/ Eraser
01-Nov-21 Beside Lead Trend Ballpen - 4pcs/pack
01-Nov-21 Beside Lead Trend Ballpen - 6pcs/pack
01-Nov-21 Beside Lead Trend Marker - 4pcs/pack
01-Nov-21 Beside Lead Trend Roller
01-Nov-21 Beside Lead Trend Stapler - No. 306
01-Nov-21 Beside Lead Trend Stapler - No. 10
01-Nov-21 Beside Lead Trend Sticker Paper
01-Nov-21 Beside Lead Trend Laminator
01-Nov-21 Beside Lead Trend Photopaper
01-Nov-21 Beside Lead Trend Weighing Scale
02-Jun-22 LYGUANA Bond Paper - A4
03-Jun-22 LYGUANA Bond Paper - Short
04-Jun-22 LYGUANA Bond Paper - Long
05-Jun-22 LYGUANA Joy Correction Tape
06-Jun-22 LYGUANA Ord Inv Long
07-Jun-22 LYGUANA Crayola - 8
08-Jun-22 LYGUANA Crayola - 16
09-Jun-22 LYGUANA Crayola - 24
10-Jun-22 LYGUANA laminating film
11-Jun-22 LYGUANA Duct tape
12-Jun-22 LYGUANA Masking Tape
Error
Error
Error
Error
Error
Error
NO INPUT NO INPUT
15,473.00
Item Code Qty In Qty Out Qty Net Price Total Selling Price
A1 10 10 10.00 100.00 13
A2 10 10 5.00 50.00 7
A3 1 1 15.00 15.00 19
A4 5 5 25.00 125.00 32
A5 5 5 12.00 60.00 15
A6 7 7 50.00 350.00 63
A7 1 1 35.00 35.00 44
A8 1 1 25.00 25.00 32
A9 3 3 10.00 30.00 13
A10 5 5 50.00 250.00 63
A11 2 2 25.00 50.00 32
A12 5 5 10.00 50.00 13
A13 5 5 12.00 60.00 15
A14 5 5 10.00 50.00 13
A15 5 5 20.00 100.00 25
A16 3 3 50.00 150.00 63
A17 1 1 100.00 100.00 125
A18 2 2 65.00 130.00 82
A19 3 3 60.00 180.00 75
A20 3 3 40.00 120.00 50
A21 5 5 110.00 550.00 138
A22 2 2 30.00 60.00 38
A23 3 3 10.00 30.00 13
A24 3 3 50.00 150.00 63
A25 1 1 40.00 40.00 50
A26 1 1 50.00 50.00 63
A27 3 3 40.00 120.00 50
A28 5 5 10.00 50.00 13
A29 10 10 12.00 120.00 15
A30 10 10 12.00 120.00 15
A31 10 10 12.00 120.00 15
A32 10 10 12.00 120.00 15
A33 5 5 20.00 100.00 25
A34 4 4 35.00 140.00 44
A35 10 10 5.00 50.00 7
A36 5 5 15.00 75.00 19
A37 4 4 10.00 40.00 13
A38 4 4 15.00 60.00 19
A39 4 4 25.00 100.00 32
A40 9 9 15.00 135.00 19
A41 22 22 6.00 132.00 8
A42 6 6 8.00 48.00 10
A43 5 5 10.00 50.00 13
A44 5 5 45.00 225.00 57
A45 5 5 50.00 250.00 63
A46 5 5 25.00 125.00 32
A47 5 5 12.00 60.00 15
A48 5 5 20.00 100.00 25
A49 5 5 25.00 125.00 32
A50 5 5 10.00 50.00 13
A51 5 5 10.00 50.00 13
A52 5 5 15.00 75.00 19
A53 9 9 10.00 90.00 13
A54 6 6 10.00 60.00 13
A55 24 24 5.00 120.00 7
A56 1 1 75.00 75.00 94
A57 2 2 110.00 220.00 138
A58 1 1 115.00 115.00 144
A59 2 2 65.00 130.00 82
A60 2 2 25.00 50.00 32
A61 2 2 50.00 100.00 63
A62 3 3 12.00 36.00 15
A63 3 3 20.00 60.00 25
A64 2 2 30.00 60.00 38
A65 2 2 20.00 40.00 25
A66 3 3 100.00 300.00 125
A67 5 5 30.00 150.00 38
A68 0 0.00 0
A69 0 0.00 0
A70 0 0.00 0
A71 0 0.00 0
A72 2 2 810.00 1,620.00 1013
A73 1 1 760.00 760.00 950
A74 1 1 900.00 900.00 1125
A75 20 20 18.00 360.00 23
A76 100 100 0.75 75.00 1
A77 12 12 21.00 252.00 27
A78 12 12 42.50 510.00 54
A79 12 12 57.50 690.00 72
A80 5 5 530.00 2,650.00 663
A81 10 10 50.00 500.00 63
A82 12 12 10.00 120.00 13
Remarks
15

20
35

60
45
35
15
60
2php/pc

15

65

85

140
40
15
65

65

15

45
10
20
15
20
35
20
10
15
60
65
35

35
15
15
20
15
15
10
95
140
145
85
35
65

40

40

1015 162 195


152 190
180 225
25
5
30
55
75
665
65
15

You might also like