You are required to accurately enter, organize, and maintain hardware goods inventory records using information provided by the client. The task involves transferring product and stock information from the provided source documents into an Excel spreadsheet. Each record should be carefully reviewed to ensure that product names, codes, quantities, prices, suppliers, and storage details are correctly captured and organized for easy inventory tracking and management.
Required Fields
- Product ID
- Product Name
- Product Category
- Product Code
- Brand
- Supplier Name
- Quantity in Stock
- Unit Price
- Total Value
- Storage Location
- Date Received
- Stock Status
- Remarks
Data Source
All hardware inventory records and source documents will be provided by the client upon hire. No independent research is required.
Deliverables
- Complete Updated Excel Spreadsheet
- Word Report Document summarizing the completed data entry work and any missing or unclear information identified.
Quality Requirements
Ensure all inventory records are entered accurately, quantities and prices are correctly recorded, and the spreadsheet is properly organized and formatted.
