Boutique Labor Planner

LorenBrooke | Business Tools & Planning

Plan labor with a clearer view of your sales goals and costs. This LorenBrooke Excel tool helps independent boutique owners turn sales targets into labor plans and compare those plans with actual sales and hours.

Make your next staffing plan with a clearer view of sales, hours, and labor costs.

The Boutique Labor Planner is a downloadable Excel workbook for independent boutique owners. Simple, clearly marked inputs help you plan selling hours from sales targets and compare your forecast with actual sales and hours.

What you can do

• Calculate planned selling hours from your sales target and SPH goal.

• Enter selling and non-selling hours separately on the weekly planning page.

• Keep an employee wage list and automatically calculate your team's average hourly rate (AHR).

• Estimate labor cost and labor cost as a percentage of sales.

• Compare forecast and actual sales and hours, plus estimated cost differences.

What's included

One Excel (.xlsx) workbook with Weekly Planner, Team Hours & Pay, and Quick Guide tabs. Includes a worked example and instructions. Enter your employees and wages once, then update the list as your team changes. Save a dated copy each week to preserve your history.

Before you buy

Microsoft Excel is required and is not included. This is a digital download; no physical product will be shipped. The AHR is a simple, unweighted average of employee wages. Labor costs are estimates based on total hours, AHR, and your optional employer-cost percentage, rather than exact payroll calculations. Overtime premiums, salaries, and commissions are not calculated separately.

SPH means sales per selling labor hour. Hourly scheduling guidance and hiring-gap indicators are not included in this version.