Salon Inventory Audit & Forecasting

I run a busy salon in Bangalore and need a single, well-structured Excel workbook that lets me: • capture opening stock, purchases, daily usage, and wastage for every SKU I sell or consume, • audit physical counts against system quantities to highlight variances instantly, and • generate a simple demand-forecast so I can place timely orders and avoid over-stocking. You will start from a clean list of products that I will share (haircare, skincare, tools, disposables, etc.). From there, I want automated formulas, drop-down selectors, and conditional formatting that: – update running balances whenever I record a purchase or a service uses up product, – flag low-stock lines in red, and – feed a forecasting sheet (moving average or similar) that shows recommended reorder quantities. Pivot-table summaries and a one-page dashboard with charts are essential for quick decision-making. If a lightweight VBA macro helps speed up data entry or reporting, feel free to include it; the file must stay compatible with Microsoft 365. Deliverables 1. Fully functioning Excel file ready to populate with my data. 2. Short walk-through document (or screen-recording) explaining where to enter figures, how the audits reconcile, and how the forecast refreshes. Acceptance criteria • All formulas calculate correctly when I test with sample numbers. • Low-stock and variance alerts trigger at the thresholds I set. • Forecast sheet populates automatically from the latest three months of usage data I paste in. • Workbook remains under 10 MB and opens without security warnings. Once the file passes these checks, the project is complete.

Project ID: 40243123