Business

Staff cost as a share of sales: a monthly check for shop owners

Work out staff cost as a share of sales each month from wages, bonus set-aside and meals, with a made-up three-month trend and how to read a rise.

Editorial illustration for Staff cost as a share of sales: a monthly check for shop owners

Add up everything you spend on staff for the month, divide it by that month's sales and multiply by 100. The result is your staff cost as a share of sales, and the useful part is the trend from month to month. A rising share means either sales fell, staff cost rose, or both, and a look at the two numbers separately tells you which.

What counts as staff cost?

  • Salaries and wages earned in the month, including daily wages.
  • Overtime or extra-hours pay.
  • The monthly set-aside for a festival bonus.
  • Staff meals, tea and any other regular amount you provide.
  • Employer contributions or insurance, if you pay any.

Advances are different. An advance is money you expect back through deductions, so it is not a cost when you give it. Count the full salary earned, and treat advances as a separate balance. If an advance is never repaid, it becomes a cost at that point.

What is the formula?

Staff cost share = total staff cost / total sales x 100. In a spreadsheet, with staff cost items in B2:B5 and sales in C2, it is =SUM(B2:B5)/C2, formatted as a percent. Use the same month on both sides and the same basis for sales, such as sales before or after GST on each month.

What does a three-month trend look like?

Month (made-up)SalesWagesBonus set-asideMealsStaff costShare of sales
August₹3,00,000₹23,400₹800₹1,800₹26,0008.7%
September₹3,10,000₹23,400₹800₹1,800₹26,0008.4%
October₹2,80,000₹27,400₹800₹1,800₹30,00010.7%

Check: 26,000 / 3,00,000 = 8.67 percent; 26,000 / 3,10,000 = 8.39 percent; 30,000 / 2,80,000 = 10.71 percent. Rounded figures are shown in the table. All the numbers are invented.

How do you read a rise?

October rose by about 2 percentage points. Two things changed: sales fell by ₹30,000 and wages rose by ₹4,000 because a part-time helper was added. Split the effect. If staff cost had stayed at ₹26,000 against October sales of ₹2,80,000, the share would have been 26,000 / 2,80,000 = 9.3 percent. So the lower sales account for about 0.9 points and the new hire for about 1.4 points more (10.7 - 9.3).

That tells you what to ask next. Was the extra helper meant for a busy period that did not come? Is October simply a slow month for your shop, as it was last year? A trend is a question, not a verdict.

What can you do about a rising share?

  • If sales are the problem, look at footfall, stock and pricing before cutting staff.
  • If cost is the problem, check overtime, extra hires and meals separately.
  • If a hire was for a short period, set an end date and review it.
  • If a share is rising while sales are rising too, check that you are not paying for more cover than you need.

What if sales are uneven within the month?

A single month can mislead if a festival fell at the start of one month and the end of another. Add the last three months together and divide the three months of staff cost by the three months of sales. Using the made-up figures above, that is (26,000 + 26,000 + 30,000) / (3,00,000 + 3,10,000 + 2,80,000) = 82,000 / 8,90,000, which is about 9.2 percent.

A five-minute monthly routine

  1. On the 1st, list last month's wages, overtime, bonus set-aside and meals.
  2. Add them and divide by last month's sales.
  3. Write the share beside the previous two months.
  4. Note one reason for any move of more than a point.
  5. Decide whether any action is needed before the next month.

Salary transfers and staff-related spending that pass through a bank statement can be categorised in SpendixAI, which makes the monthly wage total quicker to find.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports