Calculator Inputs
Performance Graph
The chart shows hourly sales if you provide a list. Otherwise, it compares key hourly metrics against your target.
Example Data Table
Use this sample to understand how hourly sales patterns and adjustments affect final productivity metrics.
| Hour | Gross Sales | Refunds | Discounts | Net Sales | Transactions |
|---|---|---|---|---|---|
| Hour 1 | $420.00 | $10.00 | $5.00 | $405.00 | 9 |
| Hour 2 | $510.00 | $0.00 | $12.00 | $498.00 | 11 |
| Hour 3 | $615.00 | $15.00 | $8.00 | $592.00 | 14 |
| Hour 4 | $580.00 | $0.00 | $15.00 | $565.00 | 13 |
| Hour 5 | $495.00 | $20.00 | $6.00 | $469.00 | 10 |
| Hour 6 | $710.00 | $5.00 | $18.00 | $687.00 | 16 |
Formula Used
- Net Sales = Gross Sales − Refunds − Discounts
- Productive Hours = Shift Hours − (Break Minutes + Non-Selling Minutes) ÷ 60
- Net Sales per Productive Hour = Net Sales ÷ Productive Hours
- Net Sales per Paid Hour = Net Sales ÷ Shift Hours
- Team Productive Hours = Productive Hours × Staff Count
- Sales per Employee Productive Hour = Net Sales ÷ Team Productive Hours
- Average Transaction Value = Net Sales ÷ Transactions
- Transactions per Hour = Transactions ÷ Productive Hours
- Labor Cost = Labor Rate × Shift Hours × Staff Count
- Labor Cost Percent = Labor Cost ÷ Net Sales × 100
- Gross Profit = Net Sales − Cost of Goods Sold
- Profit after Labor = Gross Profit − Labor Cost
- Target Attainment = Net Sales per Productive Hour ÷ Hourly Target × 100
- Target Gap = Net Sales − (Hourly Target × Productive Hours)
How to Use This Calculator
- Enter gross sales for the full shift or chosen review period.
- Add refunds and discounts so the calculation uses true net sales.
- Enter total shift hours, then subtract break and non-selling time.
- Provide staff count to measure team productivity and employee-hour performance.
- Fill in transactions, items sold, labor rate, and cost of goods for deeper efficiency analysis.
- Add hourly sales values to visualize trends and compare actual performance with your target.
- Click the calculate button to display the result above the form and review the graph, summary table, and target gap.
- Use the CSV or PDF buttons to save results for reports, coaching, scheduling, or historical benchmarking.
FAQs
1. What does sales per hour measure?
Sales per hour shows how much net revenue is produced during each hour of work. It helps managers compare shifts, track staffing effectiveness, and find time periods where selling performance improves or drops.
2. Why separate productive hours from paid hours?
Paid hours include the full shift, while productive hours remove breaks and non-selling tasks. Comparing both numbers reveals whether lower performance comes from weak sales activity or from too much time spent away from selling.
3. Should refunds and discounts be included?
Yes. Using net sales gives a more realistic view of hourly performance. Gross sales can overstate output when returns, markdowns, and promotions reduce the actual revenue retained by the business.
4. How does staff count change the result?
Staff count converts total hours into employee-hours. That helps you judge whether a busy shift really performed well or simply used more labor. It is useful for scheduling and team productivity reviews.
5. What target sales per hour should I use?
Use a target based on historical averages, labor budgets, store capacity, seasonality, or management goals. A practical target should be challenging but achievable for the specific team, product mix, and time period.
6. Can this calculator work for stores, teams, or individuals?
Yes. Enter one employee for individual analysis, or multiple employees for team performance. The same structure also works for retail counters, restaurants, call-based selling teams, and temporary sales events.
7. Why might the chart total differ from net sales?
The chart uses only the hourly values you enter. If the list covers part of a shift, excludes adjustments, or uses gross amounts, the chart total may not match the final net sales calculation.
8. How often should sales per hour be reviewed?
Review it daily for shift control, weekly for staffing decisions, and monthly for trend analysis. Frequent reviews help detect slow periods, improve schedules, and refine selling targets with better confidence.