Salon Inventory Audit & Forecasting -- 2
Budget: ₹1,500 – ₹12,500 INR
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.
Last but not the least, its a offline project and the same has to be done on site at Varthur, Whitefield, Bangalore, India
Once the file passes these checks, the project is complete.
• 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.
Last but not the least, its a offline project and the same has to be done on site at Varthur, Whitefield, Bangalore, India
Once the file passes these checks, the project is complete.