A Chemical Consumables & Purchase Tracker is important because it helps a laboratory know what chemicals and consumables they have, what they need to buy, what they already ordered, and when deliveries are expected.

1. Used application was Google sheets and MS excel file also.
2. To easily track and manage prevent stocks from running low and when to reorder.
3. To prevent stocks from over-purchasing, known exactly the supplies needed for the month, quarterly or even annually.
4. To tracks purchasing history by provided purchasing records.
5. It can also help control costs by comparing and inquiring to different suppliers.
6. It tracks delivery information like Purchase Order Number, Supplier, Order date, Expected delivery and Status.
7. It also supports chemical chemical traceability including Material safety data sheet.
8. Lastly, it helps with expiration management and provide documentation for audits.