Automated Excel Inventory Workbook

I would like a single Excel file that lets me track every movement of my raw-material inventory from purchase through consumption, while giving me an at-a-glance view of stock levels and upcoming expiries... (Budget: ₹12500 - ₹37500 INR, Jobs: Business Analysis, Data Entry, Data Management, Data Processing, Data Visualization, Documentation, Excel, Excel Macros, Inventory Management, Microsoft Word)