2025 Supply Inventory.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AL	AM	AN	AO
1	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34
2									Deliveries														Utilization												PPMP by Year End
3	Item	Stock Card No.	Category	Unit	AVerage Unit Cost	Total Stocks Available	Re-order Point	Total Physical Count	Beginning Balance	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	In Stock / Purchased	Utilized	Not Used

4	Adhesive Tape 1" small	O1001	Tape	Rolls	19.00	4	5		5	0	5	0	0	0	0	0	0	0	0	0	0		0	0	4	2	0	0	0	0	0	0	0	0	10	6	4	60.00%
5	Adhesive Tape 24mm big clear	O1002	Tape	Rolls	34.00	3	5		0	0	5	0	0	0	0	0	0	0	0	0	0		0	0	0	2	0	0	0	0	0	0	0	0	5	2	3	40.00%
6	Adhesive Transparent tape 1"	O1003	Tape	Rolls	27.00	6	5		0	0	10	0	0	0	0	0	0	0	0	0	0		0	0	2	0	0	0	0	0	0	1	1	0	10	4	6	40.00%
7	Ballpen Retractable black	C1002	Writing Supplies	Pcs	11.88	0	10		17	0	25	0	0	0	0	0	0	0	0	0	0		0	7	2	5	10	3	0	0	0	6	9	0	42	42	0	100.00%
8	Batteries 9V (1pc/pack)	E1001	Electrical Supplies	Pcs	119.50	6	5		5	0	5	0	0	0	0	0	0	0	0	0	0		0	2	0	2	0	0	0	0	0	0	0	0	10	4	6	40.00%
9	Batteries AA (3-4 pcs/pack)	E1002	Electrical Supplies	Pcs	114.75	0	5		1	0	5	0	0	0	0	0	0	0	0	0	0		0	3	3	0	0	0	0	0	0	0	0	0	6	6	0	100.00%
10	Batteries AAA (3-4 pcs/pack)	E1003	Electrical Supplies	Pcs	125.50	-2	5		4	0	5	0	0	0	0	0	0	0	0	0	0		1	2	5	3	0	0	0	0	0	0	0	0	9	11	-2	122.22%
11	Batteries CR2032	E1004	Electrical Supplies	Pcs	79.00	4	5		10	0	0	0	0	0	0	0	0	0	0	0	0		3	0	2	0	0	0	0	0	1	0	0	0	10	6	4	60.00%
12	Binder Clip 1 1/4 (12 pcs./box)	B1001	Binders	Boxes	37.00	5	5		0	0	5	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	5	0	5	0.00%
13	Binder Clip 2"	B1002	Binders	Boxes	96.00	10	5		0	0	10	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	10	0	10	0.00%
14	Binder Clip 3/4 (12 pcs./box)	B1003	Binders	Boxes	17.00	8	5		38	0	0	0	0	0	0	0	0	0	0	0	0		0	0	30	0	0	0	0	0	0	0	0	0	38	30	8	78.95%
15	Binder Clip 32 mm	B1004	Binders	Boxes	14.70	0	5		94	0	0	0	0	0	0	0	0	0	0	0	0		0	0	94	0	0	0	0	0	0	0	0	0	94	94	0	100.00%
16	Board Paper White 180gsm Legal 10'	A1012	Paper	Reams	43.00	5	2	5	0	0	5	0	0	0	0	0	0	0	0	0	0		0	0	2	1	0	0	0	0	1	0	0	0	5	4	1	80.00%
17	Board Paper White 180gsm Letter 10'	A1013	Paper	Reams	37.50	5	2	5	0	0	5	0	0	0	0	0	0	0	0	0	0		0	0	0	2	0	0	0	0	1	0	0	0	5	3	2	60.00%
18	Bond paper (blue Long)	A1001	Paper	Reams	387.50	5	1		5	0	1	0	0	0	0	0	0	0	0	0	0		0	0	1	0	0	0	0	0	0	0	0	0	6	1	5	16.67%
19	Bond paper (blue short)	A1002	Paper	Reams	250.00	5	1		5	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	5	0	5	0.00%
20	Bond Paper (Green Long 75gsm, 100s'/Ream)	A1014	Paper	Reams	525.00	1	1	1	0	0	1	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0.00%
21	Bond paper A4 Substance 20	A1003	Paper	Reams	259.50	4	5		7	0	5	0	0	0	0	0	0	0	0	0	0		0	0	0	2	0	0	0	0	6	0	0	0	12	8	4	66.67%
22	Bond paper Long Substance 20	A1004	Paper	Reams	260.50	4	10		21	0	20	0	0	0	0	0	0	0	0	0	0		2	6	11	3	5	0	1	1	5	0	1	2	41	37	4	90.24%
23	Bond paper Short Substance 20	A1005	Paper	Reams	222.00	10	10		43	0	20	0	0	0	0	0	0	0	0	0	0		3	5	20	5	5	2	2	0	1	2	5	3	63	53	10	84.13%
24	Bond papers (pink Long)	A1006	Paper	Reams	387.50	5	1		4	0	1	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	5	0	5	0.00%
25	Bond papers (pink short)	A1007	Paper	Reams	240.00	4	1		4	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	4	0	4	0.00%
26	Brown Envelope Long	A6001	Envelopes	Pcs	4.00	52	10		50	0	20	0	0	0	0	0	0	0	0	0	0		0	0	7	3	0	1	1	0	0	1	0	5	70	18	52	25.71%
27	Brown Envelope Short	A6003	Envelopes	Pcs	3.38	39	10		25	0	20	0	0	0	0	0	0	0	0	0	0		0	0	0	5	0	0	0	0	0	1	0	0	45	6	39	13.33%
28	Cable tie 6"	B1005	Binders	Packs	56.00	14	5		9	0	5	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	14	0	14	0.00%
29	Cartolina assorted color	A1008	Paper	Pcs	16.00	10	5		10	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	10	0	10	0.00%
30	Clear Book, Legal, 40 pages	F1001	Folders	Pcs	151.95	24	5		14	0	10	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	24	0	24	0.00%
31	Clipboard acrylic	B1007	Binders	Pcs	100.00	3	2		6	0	5	0	0	0	0	0	0	0	0	0	0		0	2	5	0	0	0	0	0	1	0	0	0	11	8	3	72.73%
32	Copper wire (Flat cord #16)	E1006	Electrical Supplies	Meter	42.00	150	0	150	0	0	150	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	150	0	150	0.00%
33	Correction Pen 3.5 ML	B2001	Writing Supplies	Pcs	118.00	0	2		0	0	5	0	0	0	0	0	0	0	0	0	0		0	0	5	0	0	0	0	0	0	0	0	0	5	5	0	100.00%
34	Correction Tape, 8mm	C1003	Writing Supplies	Pcs	15.60	0	0		11	0	0	0	0	0	0	0	0	0	0	0	0		3	0	4	0	2	2	0	0	0	0	0	0	11	11	0	100.00%
35	Crepe paper	A1009	Paper	Pcs	20.00	0	5		10	0	0	0	0	0	0	0	0	0	0	0	0		0	0	10	0	0	0	0	0	0	0	0	0	10	10	0	100.00%
36	Cutter big heavy duty	B2014	Desk supplies	Pcs	65.00	1	0		0	0	5	0	0	0	0	0	0	0	0	0	0		0	3	0	0	0	0	0	0	1	0	0	0	5	4	1	80.00%
37	Double sided tape 1"	O1005	Tape	Rolls	73.00	6	5		6	0	10	0	0	0	0	0	0	0	0	0	0		0	0	5	0	2	0	0	1	0	0	2	0	16	10	6	62.50%
38	Duct Tape 2'' Silver	O1006	Tape	Rolls	153.00	2	5		2	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	2	0	2	0.00%
39	Duct Tape 3'' Silver	O1008	Tape	Rolls	480.00	1	5		0	0	5	0	0	0	0	0	0	0	0	0	0		0	1	0	0	0	0	0	0	2	0	1	0	5	4	1	80.00%
40	Electrical tape 5 m	O1009	Tape	Rolls	31.00	8	5		15	0	5	0	0	0	0	0	0	0	0	0	0		0	2	8	2	0	0	0	0	0	0	0	0	20	12	8	60.00%
41	Eraser	B2003	Desk supplies	Pcs	75.85	2	5		4	0	10	0	0	0	0	0	0	0	0	0	0		0	2	4	2	4	0	0	0	0	0	0	0	14	12	2	85.71%
42	Fastener Plastic Coated (50 sets per box)	B1009	Binders	Boxes	42.00	11	2		14	0	0	0	0	0	0	0	0	0	0	0	0		0	0	1	0	2	0	0	0	0	0	0	0	14	3	11	21.43%
43	Filling Box with cover	G1001	Office Storage	Pcs	250.00	1	2		3	0	0	0	0	0	0	0	0	0	0	0	0		0	0	2	0	0	0	0	0	0	0	0	0	3	2	1	66.67%
44	Filling Box without cover	G1002	Office Storage	Pcs	120.00	0	2		1	0	0	0	0	0	0	0	0	0	0	0	0		0	0	1	0	0	0	0	0	0	0	0	0	1	1	0	100.00%
45	Flanella Cloth	I1002	Cleaning Materials	Yard	110.00	5	1	5	0	0	5	0	0	0	0	0	0	0	0	0	0		0	0	5	0	0	0	0	0	0	0	0	0	5	5	0	100.00%
46	Folder Blue Long	F1003	Folders	Rolls	6.40	43	do not order		54	0	0	0	0	0	0	0	0	0	0	0	0		0	5	0	0	0	1	0	0	0	5	0	0	54	11	43	20.37%
47	Folder White Long	F1005	Folders	Pcs	6.25	0	10		85	0	50	0	0	0	0	0	0	0	0	0	0		0	45	81	0	9	0	0	0	0	0	0	0	135	135	0	100.00%
48	Folder White Short	F1006	Folders	Pcs	5.60	93	10		94	0	30	0	0	0	0	0	0	0	0	0	0		0	0	0	10	10	0	1	0	0	0	0	10	124	31	93	25.00%
49	Glue all purpose 130 gm	B1010	Binders	Bot	70.25	6	2		6	0	5	0	0	0	0	0	0	0	0	0	0		0	0	5	0	0	0	0	0	0	0	0	0	11	5	6	45.45%
50	Glue Stick 15 grams	B1011	Binders	Pcs	34.50	8	2		4	0	10	0	0	0	0	0	0	0	0	0	0		0	0	2	0	0	1	0	0	0	0	0	3	14	6	8	42.86%
51	Hand Trolley 300kg	Z1003	Miscellaneous	Pcs	12,500.00	1	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0		0	0	0	1	0	0	0	0	0	0	0	0	1	1	0	100.00%
52	Highlighter Assorted Color	C1005	Writing Supplies	Pcs	63.50	4	2		9	0	5	0	0	0	0	0	0	0	0	0	0		0	0	10	0	0	0	0	0	0	0	0	0	14	10	4	71.43%
53	Ladder 5 steps	Z1002	Miscellaneous	Pcs	4,800.00	1	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0		0	0	1	0	0	0	0	0	0	0	0	0	1	1	0	100.00%
54	Laminating Film 250 mic, legal	Z1001	Miscellaneous	Reams	1,500.00	1	0		1	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0.00%
55	Liquid Floor Finish Wax	I1003	Cleaning Materials	Gal	4,350.00	1	1	1	0	0	1	0	0	0	0	0	0	0	0	0	0		0	0	1	0	0	0	0	0	0	0	0	0	1	1	0	100.00%
56	Liquid Floor Stipper	I1004	Cleaning Materials	Gal	3,100.00	1	1	1	0	0	1	0	0	0	0	0	0	0	0	0	0		0	0	1	0	0	0	0	0	0	0	0	0	1	1	0	100.00%
57	Masking Tape 1"	O1010	Tape	Bot	12.00	0	3		9	0	0	0	0	0	0	0	0	0	0	0	0		0	3	3	0	0	0	0	0	0	0	3	0	9	9	0	100.00%
58	Masking Tape 2"	O1011	Tape	Bot	24.00	0	3		6	0	0	0	0	0	0	0	0	0	0	0	0		0	0	2	0	1	0	1	0	1	0	1	0	6	6	0	100.00%
59	Network Cable Wire Cat5 300m	E1009	Electrical Supplies	Boxes	6,500.00	1	1	1	0	0	1	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0.00%
60	Outlet 3 gang	E1007	Electrical Supplies	Pcs	89.00	10	0	10	0	0	10	0	0	0	0	0	0	0	0	0	0		0	0	10	0	0	0	0	0	0	0	0	0	10	10	0	100.00%
61	Packing Tape 2'' 50ms Brown	O1012	Tape	Rolls	34.00	8	3		10	0	0	0	0	0	0	0	0	0	0	0	0		0	0	2	0	0	0	0	0	0	0	0	0	10	2	8	20.00%
62	Packing Tape 2" 50m Clear	O1013	Tape	Rolls	50.00	1	3		1	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0.00%
63	Paper Filing Tray 3 layer	G2001	Office Storage	Pcs		0	3		0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.00%
64	Paperclip Vinyl Big	B2004	Desk supplies	Boxes	27.00	5	3		5	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	5	0	5	0.00%
65	Paperclip Vinyl Small	B2005	Desk supplies	Boxes	15.00	8	3		10	0	0	0	0	0	0	0	0	0	0	0	0		0	0	1	0	0	1	0	0	0	0	0	0	10	2	8	20.00%
66	Pencil Lead with Eraser	C1006	Writing Supplies	Pcs	73.88	10	5		18	0	5	0	0	0	0	0	0	0	0	0	0		0	4	0	5	2	2	0	0	0	0	0	0	23	13	10	56.52%
67	Permanent Assorted Marker	C1007	Writing Supplies	Pcs	48.88	15	5		1	0	15	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	1	0	0	0	16	1	15	6.25%
68	Photo paper glossy 20's	A1010	Paper	Packs	82.00	3	1		0	0	5	0	0	0	0	0	0	0	0	0	0		0	0	1	1	0	0	0	0	0	0	0	0	5	2	3	40.00%
69	Plastic Envelope Transaparent Legal	A6005	Envelopes	Pcs	23.00	0	1		0	0	10	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	10	0	0	0	10	10	0	100.00%
70	Plastic Envelope Transparent Legal with handle	A6006	Envelopes	Pcs	85.00	1	1		2	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	1	0	0	2	1	1	50.00%
71	Plastic Multipurpose drawers (3 layers)	G2002	Office Storage	Pcs		0	do not order		0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.00%
72	Plug	E1008	Electrical Supplies	Pcs	29.00	10	0	10	0	0	10	0	0	0	0	0	0	0	0	0	0		0	0	0	10	0	0	0	0	0	0	0	0	10	10	0	100.00%
73	Printer Ink Refill 001 Epson (Black)	P1001	Printing Supplies	Bot	675.00	4	2		0	0	5	0	0	0	0	0	0	0	0	0	0		0	0	1	0	0	0	0	0	0	0	0	0	5	1	4	20.00%
74	Printer Ink Refill 001 Epson (Cyan)	P1002	Printing Supplies	Bot	445.00	0	2		0	0	2	0	0	0	0	0	0	0	0	0	0		0	1	1	0	0	0	0	0	0	0	0	0	2	2	0	100.00%
75	Printer Ink Refill 001 Epson (Magenta)	P1003	Printing Supplies	Bot	445.00	0	2		0	0	2	0	0	0	0	0	0	0	0	0	0		0	0	2	0	0	0	0	0	0	0	0	0	2	2	0	100.00%
76	Printer Ink Refill 001 Epson (Yellow)	P1004	Printing Supplies	Bot	445.00	0	2		0	0	2	0	0	0	0	0	0	0	0	0	0		0	0	2	0	0	0	0	0	0	0	0	0	2	2	0	100.00%
77	Printer Ink Refill 003 Epson (Black)	P1005	Printing Supplies	Bot	435.00	0	5		5	0	10	0	0	0	0	0	0	0	0	0	0		0	2	3	2	1	0	1	0	6	0	0	0	15	15	0	100.00%
78	Printer Ink Refill 003 Epson (Cyan)	P1006	Printing Supplies	Bot	429.00	3	5		0	0	8	0	0	0	0	0	0	0	0	0	0		0	2	0	1	1	0	0	0	1	0	0	0	8	5	3	62.50%
79	Printer Ink Refill 003 Epson (Magenta)	P1007	Printing Supplies	Bot	429.00	2	5		0	0	8	0	0	0	0	0	0	0	0	0	0		0	1	0	1	1	0	0	0	2	1	0	0	8	6	2	75.00%
80	Printer Ink Refill 003 Epson (Yellow)	P1008	Printing Supplies	Bot	429.00	3	5		0	0	8	0	0	0	0	0	0	0	0	0	0		0	1	0	1	1	0	0	0	1	1	0	0	8	5	3	62.50%
81	Puncher Two hole heavy duty	B1012	Binders	Pcs	240.00	6	3		4	0	5	0	0	0	0	0	0	0	0	0	0		0	0	2	1	0	0	0	0	0	0	0	0	9	3	6	33.33%
82	Push cart			Pcs		0			0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.00%
83	Push pins	B2006	Desk supplies	Boxes	38.00	10	3		11	0	0	0	0	0	0	0	0	0	0	0	0		0	0	1	0	0	0	0	0	0	0	0	0	11	1	10	9.09%
84	Record Book 300 Pgs	A3001	Notebooks & Notepads	Pcs	92.95	8	3		11	0	5	0	0	0	0	0	0	0	0	0	0		0	0	2	0	0	0	0	0	6	0	0	0	16	8	8	50.00%
85	Rj45 Nozzle	E1005	Electrical Supplies	Pcs	15.00	100	20	100	0	0	100	0	0	0	0	0	0	0	0	0	0		0	0	100	0	0	0	0	0	0	0	0	0	100	100	0	100.00%
86	Rubber band	B2007	Desk supplies	Boxes	230.00	1	1		2	0	0	0	0	0	0	0	0	0	0	0	0		0	1	0	0	0	0	0	0	0	0	0	0	2	1	1	50.00%
87	Scissors 6"	B2010	Desk supplies	Pcs	45.00	-2	3		0	0	5	0	0	0	0	0	0	0	0	0	0		0	2	4	0	0	0	1	0	0	0	0	0	5	7	-2	140.00%
88	Sign pen .4mm black	C1008	Writing Supplies	Pcs	93.50	4	5		9	0	10	0	0	0	0	0	0	0	0	0	0		0	2	13	0	0	0	0	0	0	0	0	0	19	15	4	78.95%
89	Sign pen Gel Pen .5mm	C1009	Writing Supplies	Pcs	29.00	19	5		0	0	21	0	0	0	0	0	0	0	0	0	0		0	6	7	0	0	0	0	0	0	0	0	5	21	18	3	85.71%
90	Sign pen refill .4mm black	C1010	Writing Supplies	Pcs	57.50	38	5		29	0	10	0	0	0	0	0	0	0	0	0	0		0	0	1	0	0	0	0	0	0	0	0	0	39	1	38	2.56%
91	Stamp Pad	B2008	Desk supplies	Pcs	50.00	3	2		3	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	3	0	3	0.00%
92	Stamp Pad Ink	B2016	Desk supplies	Pcs	25.00	5	2		5	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	5	0	5	0.00%
93	Staple Heavy Duty Max	B1013	Binders	Pcs	354.00	2	5		0	0	5	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	3	0	0	0	5	3	2	60.00%
94	Staple Wire #35	B1014	Binders	Pcs	49.50	52	5		53	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	1	0	0	0	0	0	0	53	1	52	1.89%
95	Sticker Paper A4 10's	A1015	Paper	Packs	62.00	5	2	5	0	0	5	0	0	0	0	0	0	0	0	0	0		0	0	0	1	0	0	0	0	0	0	0	0	5	1	4	20.00%
96	Sticky Notes 3x3in 100leaves	A1016	Paper	Pcs	29.00	10	2	10	0	0	10	0	0	0	0	0	0	0	0	0	0		0	0	2	0	0	0	0	0	0	1	0	0	10	3	7	30.00%
97	Sticky Notes 3x4 in 100 leaves	B2009	Desk supplies	Pcs	35.00	3	2		1	0	10	0	0	0	0	0	0	0	0	0	0		0	3	2	0	0	0	0	0	0	0	3	0	11	8	3	72.73%
98	Thermal Paper 2's	A1011	Paper	Rolls	69.00	15	0		0	0	50	0	0	0	0	0	0	0	0	0	0		0	0	16	0	0	2	1	0	14	0	0	2	50	35	15	70.00%
99	Thermal Paper 2's	A1011	Paper	Rolls	69.00	50	10	50	0	0	50	0	0	0	0	0	0	0	0	0	0		0	0	16	0	0	2	1	0	14	0	0	2	50	35	15	70.00%
100	Toner Cartridge Black BP-FT201		Printing Supplies	Pcs	3,200.00		1		0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.00%