Christmas Dinner Planner Excel - Free Template

1. Open Summary & Instructions first to understand the dashboard measures and the workbook workflow.
2. On Dinner Planner, replace the sample dinner date, guest count and hosting location in the hosting details area.
3. Enter each dish, ingredient or task from row 7 onwards, including the course, quantity, unit, estimated cost, dietary information and responsible person.
4. Add preparation dates and 24-hour preparation, cooking or serving times using DD/MM/YYYY dates where applicable.
5. Choose a preparation status from the available list and use Notes for collection arrangements, cooking instructions or other reminders.
6. On Shopping List & Budget, enter ingredients, quantities, suppliers and estimated unit costs, then update Purchased? and Actual Cost (£) after each shop.
7. Review the calculated budget, VAT summary, variances, completion measures and category breakdown on Summary & Instructions before the meal.

This workbook suits the person hosting Christmas dinner, a household sharing preparation between relatives, or anyone coordinating a meal where shopping and cooking happen on different days. It is designed for practical household planning rather than formal catering administration, with space for the menu, people responsible, preparation timings and costs in one file.

Planning the menu and jobs

Start with the Dinner Planner sheet when the menu is being agreed. The sample row identifies a turkey crown serving 10, with a quantity of 1 x 4.5 kg, an estimated cost of £48, Harry as the responsible person, preparation on 24/12/2026 at 09:00, and cooking or serving time at 13:30. That gives you a useful model for entering a roast, side dish or dessert.

A family could add roast potatoes for 10 people, assign them to another person and record a preparation time before the turkey. The six permitted course choices—Main, Side, Vegetable, Dessert, Starter and Other—keep the menu categories consistent while the Notes field can hold instructions such as the sample collection reminder for the London butcher.

Using it before the shopping trip

The Shopping List & Budget sheet is suited to the person making the main shop or collecting items from several suppliers. Enter the required quantity, unit, preferred supplier and estimated unit cost, then let the workbook calculate the estimated total. For example, one turkey crown at £48 produces an estimated total of £48 before the actual cost is entered.

Use Summary & Instructions for a quick household review. It brings together estimated food cost, actual food cost, cost variance, average cost per guest and the number of dinner items. With 10 guests, a hypothetical estimated food cost of £150 would produce an average estimated cost per guest of £15, subject to the entries in the workbook.

The workbook separates planning inputs from calculated outputs. You enter dishes and tasks on Dinner Planner, purchasing details on Shopping List & Budget, and then use Summary & Instructions to inspect linked results. This is preferable to typing the same total in several places because the summary updates from the underlying sheets.

Calculated preparation measures

Dinner Planner totals estimated costs in the Estimated Cost (£) column and calculates the average item cost. It also counts rows marked Complete and divides completed items by populated dish or item entries to produce the completion percentage. If 12 items are entered and 9 are Complete, the calculated completion percentage is 75%.

Each populated planning row also receives a budget flag. The formula labels an item Review cost when its estimated cost is greater than £20 and Within target when it is £20 or less. This is a workbook planning rule, not an external pricing standard; use it as a prompt to check unusually expensive items. The sample turkey crown at £48 would therefore be flagged Review cost.

Shopping calculations and reference values

Shopping List & Budget multiplies Quantity by Estimated Unit Cost (£) to calculate Estimated Total (£). After you enter Actual Cost (£), the workbook calculates Variance (£), marks the item Purchased or To buy, and calculates VAT Amount (£) from the VAT Rate lookup. The reference area includes sample planning values such as 0 for turkey crown and potatoes and 0.20 for pigs in blankets and stuffing mix. These are workbook reference values and should be checked for your own purchasing situation.

Use the permitted lists rather than inconsistent free text: shopping categories, units and Yes or No for Purchased?. Consistent entries allow the SUM, SUMIF, SUMIFS, COUNTIF, COUNTIFS, VLOOKUP, INDEX and MATCH formulas to return reliable results.

The most expensive planning errors usually come from incomplete links between the menu and the shop. For example, entering a turkey crown on Dinner Planner but leaving it out of Shopping List & Budget makes the meal plan appear complete while the budget omits a £48 estimated item. The separate sheets need to be reviewed together rather than treated as two unrelated lists.

Missing or inconsistent entries

A blank Dish / Item prevents many row formulas from producing a shopping result, while a blank Actual Cost means the actual spend remains incomplete. If five purchased ingredients are left with Purchased? set to No, the summary can continue to show outstanding estimated spend even though the items are already in the kitchen.

Units can also distort quantities. Entering 2.5 in Quantity with kg in Unit is clear; entering 2.5 without a unit makes it harder to distinguish 2.5 kg from 2.5 packs. The available unit list includes kg, g, packs, pack, portions, crown, pudding and item, so choose the closest permitted value instead of inventing variations such as kilogrammes or pk.

Timing and responsibility gaps

A dish with no Responsible Person can be overlooked when several people are sharing the work. Likewise, entering 13:30 as text rather than a time value can weaken the usefulness of the preparation schedule. The workbook instructions specify DD/MM/YYYY dates and 24-hour times, so a date such as 24/12/2026 and a time such as 09:00 should be entered consistently.

Cost errors can be visible in the summary but still need investigation. In a hypothetical example, estimated shopping of £180 and actual costs of £195 create a £15 variance. Check quantities, supplier prices and duplicated ingredients before changing the estimate, and use the highest-cost item measure to identify where that review should begin.

Use the workbook at fixed points rather than trying to complete it in one sitting. A practical routine is to confirm the guest count and menu first, update shopping prices before the main shop, and then record actual costs immediately after each purchase. This turns the file into a running plan instead of a list that becomes inaccurate after the first supermarket visit.

A simple weekly planning rhythm

• At the first menu review, enter every course and major task on Dinner Planner, even where the estimated cost is provisional.
• During the next shopping review, copy the menu items into Shopping List & Budget and add quantities, units and suppliers.
• After each purchase, set Purchased? to Yes and enter Actual Cost (£), rather than relying on receipts several days later.
• Before cooking begins, filter the Dinner Planner list using the preparation details and update each Status value as work progresses.

For example, if 16 items are planned and 12 have been marked Complete, Summary & Instructions will show the corresponding 75% completion measure. If the shopping sheet contains 10 items and 7 have Purchased? set to Yes, the shopping completion percentage will reflect that entry pattern.

When the workbook is no longer enough

This template is suitable for a single household meal with up to 100 planning and shopping rows. Consider a more specialised system when several events, many suppliers, live stock levels, shared access or detailed recipe scaling make manual updates difficult. Until then, keep one master file, avoid deleting formula rows, and review Summary & Instructions after each meaningful change.