Simple Asset Management Tool

Job ID: 37786212

Budget: $30 – $250 USD

I'm looking for an adept freelancer to develop a user-friendly asset management system to keep track of various items within our conference rooms and classrooms. The simplicity of the system is crucial to accommodate volunteers of varying tech skill levels. Here is a concise breakdown of what the project entails:

- **System Preferences**:
The system could be designed in Excel, Access, or MySQL. The key consideration is ease of use for individuals with minimal technical background.

- **Assets to Manage**: The primary focus will be on efficiently managing numerous assets including computers, printers, projectors, and various additional items detailed in an accompanying spreadsheet.

- **Functionality Requirements**:
+ Track the quantity of each asset
+ Monitor the specific location of each asset within multiple spaces
1. Simple entry field for item received, installed, stock. or surplus (sent away as expired
2. Create Dashboard for total inventory cost by a. vendor, b. room, and c. PO#
3.Most of my inventory items are expired, replaced or upgraded on a 5-year lifecycle to ensure our operations run smoothly without any hiccups. I want to simplify how I receive and account for each items.

- **Ideal Experience and Skills**:
+ Strong proficiency in Excel, Access, or MySQL, with examples of previous simple database or spreadsheet projects
+ Excellent understanding of inventory or asset management principles
+ Ability to create intuitive, user-friendly interfaces
+ Experience in training or creating guides for users with little to no technical background

The outcome of this project is crucial for streamlining our asset management process, ensuring that volunteers can easily check the status and location of items, reducing time spent on inventory checks, and improving the overall efficiency of setting up and managing our spaces.

I'm looking for someone who can start immediately and deliver a robust solution ASAP. Your expertise in creating custom inventory systems will play a crucial role in streamlining our asset management, improving our overall operational efficiency.

Please include in your proposal examples of similar projects you've completed, your approach to making the system user-friendly, and any suggestions you have for ensuring the system meets our needs.

Howard
Related categories: PHP Software Architecture Microsoft Access MySQL HTML