Hi Asif,
Creating an asset inventory for a college in Excel is a good idea for tracking and managing resources. Below is a simple template that you can use as a starting point. You can customize and expand it based on the specific needs and categories of assets your college has.
Asset ID Asset Type | Description | Location | Purchase Date | Cost Approx
Rs.
1 Computers Lab PCs Computer Lab 101 2022-01-15 10,00,000
2 Projectors Presentation | Lecture Hall A 2021-12-10 2,50,000
3 Furniture Office Desk Administrative Office 2022-03-05 80,0000
4 Printers Laser Printer Library 2022-02-20 1,20,000
5 Sports Basketball Sports Complex 2022-04-12 50,000
To regularly update the information in the spreadsheet to keep it accurate and useful. Additionally, you might want to consider implementing a system for tracking maintenance schedules, depreciation, and disposal of assets.
Thanks