Shopping

Grocery cost per person per day: a formula for any household size

Work out grocery cost per person per day for any household using monthly spend, days and head count, with guests as part-persons. Two made-up households.

Editorial illustration for Grocery cost per person per day: a formula for any household size

Grocery cost per person per day is the month's grocery spend divided by the number of person-days eaten in that month. Person-days are the days in the month times the people who live at home, plus guest-days for visitors. With ₹9,450 spent by two people in 30 days and 3 guest-days, the figure is ₹150 per person per day.

What is the formula?

Cost per person per day equals grocery spend divided by (days times residents plus guest-days). A guest-day is one guest eating all the day's meals. A guest who comes only for dinner can count as half a day, or whatever fraction you decide, as long as you use it consistently.

In a sheet, put the spend in B2, the days in B3, residents in B4 and guest-days in B5. The result in B6 is =B2/(B3*B4+B5). The same formula works in Excel and Google Sheets.

How do I count guests and children?

  • One guest staying a full day: 1 guest-day.
  • A guest who stays for dinner only: 0.5 guest-day, or the share of the day's food they ate.
  • A child at home: count as 1, or as 0.5 if you want to reflect smaller portions. Pick one rule and keep it.
  • A resident who is away for a week: subtract those days, by reducing days times residents by 7.

None of these choices is right or wrong. The aim is a stable measure that you can compare from month to month, not a perfect one.

What do two made-up households show?

DetailHousehold of twoHousehold of five
Grocery spend for the month₹9,450₹20,000
Days in the month3030
Residents25
Guest-days310
Person-days63160
Cost per person per day₹150₹125

For the two-person household, 30 times 2 is 60, plus 3 guest-days makes 63 person-days, and 9,450 divided by 63 is exactly 150. For the five-person household, 30 times 5 is 150, plus 10 guest-days makes 160, and 20,000 divided by 160 is 125.

Do not read the two numbers as a rule about household size. They are invented. What matters is that the same formula lets two very different homes be compared, and lets one home compare itself across months.

What counts as grocery spend?

Decide once and write it at the top of the sheet. A narrow definition is staples and household supplies. A wider one adds milk, vegetables, fruit and eggs. Eating out and delivery meals are different and are best kept in a separate line, so that a month of takeaways does not make the grocery figure look like it fell.

How can I use the number?

Multiply by the days and people to sketch next month: if you expect two residents, 30 days and about 3 guest-days, the sketch is the per-person figure times 63. Compare the sketch with the budget. The figure is also a quick way to notice a month that drifts, because a jump from ₹150 to ₹180 is easier to spot than a change in a total.

If your statements are in SpendixAI, you can read the month's Groceries total from a report and drop it into B2, so the sheet only needs the head count and guest-days.

Review the figure every quarter if the monthly numbers feel noisy. Festivals, illness and travel all push a single month around. To smooth it, add three months of grocery spend and divide by the three months' person-days together, rather than averaging three per-day figures, since a month with more guests should count for more.

A quick routine

  1. Write the month's grocery total using one fixed definition.
  2. Note the number of residents and any days when someone was away.
  3. Count guest-days from your memory or a calendar note.
  4. Calculate and file the result next to last month's.
  5. Add one line of reason if the figure moved by more than you expected.
SPENDIXAI JOURNAL

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

Explore your reports