Christmas Dinner Shopping Calculator Spreadsheet – Quantities, Packs to Buy & Cost by Number of Guests (Excel + Google Sheets)
Buy the right amount, no more, no less.
What's inside:
Shopping: up to 40 items with amount per adult, unit, pack size, price per pack, and automatic amount needed, packs to buy and cost
Dashboard: adults, children, child portion size, buffer %, portions to cater for, total packs, total cost and cost per person
What you get:
Christmas-Dinner-Shopping-Calculator-Spreadsheet.xlsx – the blank calculator
Christmas-Dinner-Shopping-Calculator-Spreadsheet-EXAMPLE.xlsx – filled with a sample menu for 6 adults and 2 children
The calculations were checked against an independent model.
Sample amounts are examples only. Check cooking times and food safety with the Food Standards Agency (food.gov.uk).
Instructions are on the Start Here tab.
Works in Microsoft Excel 2016 or newer (Windows and Mac), Excel for the web, and Google Sheets (upload the .xlsx to Google Drive and open it with Google Sheets). No macros.
This is a digital download. No physical item will be shipped. For personal use only.