To set a weekly food delivery budget, list what you spent on delivered food in each of the last eight weeks, find the median, and use it as your realistic ceiling. A lower figure from your best weeks becomes the stretch goal. Starting from your own history works better than picking a round number.
Why eight weeks?
One or two weeks can be unusual because of a festival, guests or illness. Eight weeks covers a mix of normal and odd weeks without going back so far that the habits have changed. If you cannot find that many weeks, use four and say so in your notes.
Step one: collect the weekly totals
- Open your statements or order history for the last eight weeks.
- List every food delivery payment with its date and amount, including fees and tips.
- Group by week, from Monday to Sunday.
- Write the eight totals down in a column.
A made-up series
Say the eight weekly totals are ₹1,100, ₹650, ₹900, ₹1,450, ₹800, ₹700, ₹1,250 and ₹950. They add up to ₹7,800, so the average is ₹975. Put in order, the figures are 650, 700, 800, 900, 950, 1,100, 1,250 and 1,450.
| Figure | How to find it | Result |
|---|---|---|
| Median | Middle of the sorted list: (900 + 950) / 2 | ₹925 |
| Low figure | Average of the three lowest weeks: (650 + 700 + 800) / 3 | ₹717 |
| Average | Total divided by eight | ₹975 |
| Highest week | The largest value | ₹1,450 |
In a sheet, with the eight totals in B2:B9, the formulas are =MEDIAN(B2:B9), =AVERAGE(B2:B9) and =AVERAGE(SMALL(B2:B9,{1,2,3})) for the low figure. They work in Excel and Google Sheets.
Which figure should become the ceiling?
The median is a good starting ceiling because half your weeks were already at or below it. Here that is ₹925, which you might round to ₹900 for easy tracking. The low figure, ₹717 or about ₹700, is your stretch goal for weeks when you are cooking more. The average is pulled up by the biggest weeks, so it is the least useful of the three for a ceiling.
A ₹900 weekly ceiling works out to about ₹3,900 a month (900 multiplied by 52 weeks and divided by 12 months). If that number feels wrong against your monthly food budget, adjust the weekly figure rather than the arithmetic.
Which week does an order belong to?
Count each order in the week it was placed, not the week the payment reached your statement, because card payments can post a day or two later. Include fees and tips, and add orders from every app you use. If you pay some orders in cash on arrival, note them by hand, since they will never appear on a statement.
What do you do in a week with a party or festival?
Do not let one exceptional week ruin the system. Either give that week an agreed extra amount, say ₹500, in advance, or log it as an exception and exclude it from next month's median. What matters is that the decision is made before ordering, not after.
Checking how it is going
- After four weeks, count how many were within the ceiling.
- If you stayed under in all four, try the stretch figure.
- If you went over in three, the ceiling may be too low for now. Raise it by ₹100 and watch.
- Re-run the eight-week check every quarter.
If your orders come through UPI or card, uploading statements into SpendixAI lets you see delivery payments by merchant and by month, which saves collecting the totals by hand. It also offers budgets on the Pro plan, where you can set a limit for a category. Check each imported row before saving. The weekly grouping you can still do in a sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

