Advanced Excel Inventory Management Workbook

About Role

Create a structured Excel workbook for tracking inventory purchases, sales, stock levels, reorder points, and supplier information. The workbook should reduce manual errors, make current stock easy to understand, and provide useful summaries for routine decision-making. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.

Requirements

• Design separate input, calculation, and summary sheets.
• Create product and supplier master lists with validation.
• Track stock movement and calculate current balance reliably.
• Add low-stock alerts, filters, and summary dashboards.
• Protect formula cells while keeping input areas simple.
• Test the workbook with sample transactions and provide instructions.