Thanksgiving & Christmas Dinner Budget Spreadsheet: Cost-Per-Guest Calculator

A spreadsheet to plan what a big holiday meal will cost, for Thanksgiving, Christmas, Friendsgiving or New Year. List what you need to buy, mark what guests are bringing, and see the projected total, what's left in your budget and the cost per guest as you shop.

★ WHAT YOU GET

• 1 spreadsheet (.xlsx) with 5 tabs: Start here, Setup, Shopping list, Portions, Summary

• Setup: meal name, date, budget, adults, children and a child-portion factor · 10 renamable categories

• Shopping list (150 rows): category, item, quantity, unit, price per unit, who provides (host, guest, already have), bought?, actual paid, store, notes · estimated and projected cost calculated per row

• Summary: budget, estimated total, spent so far, projected total, left in budget (with over/within budget flag), cost per guest and per adult portion, totals per category, and a list of items still to buy (first 25)

• Portions (optional): type your own amount per adult and pack size; it scales to your guest count and rounds up to whole packs

★ COMPATIBILITY

Made for Google Sheets (free Google account; upload the .xlsx to Google Drive, then open it with Google Sheets), Microsoft Excel 2010 or later, and LibreOffice Calc. Spreadsheet formulas checked for Google Sheets and Excel compatibility and tested in LibreOffice Calc (standard functions only, no macros, no add-ins). Unzip the download first (double-click on most computers). Best used on a computer or tablet.

★ GOOD TO KNOW

• Works in any currency (no currency symbol in the cells).

• Example items, prices and portion amounts are placeholders to show how it works, not recommendations. Replace them with your own.

• There is no printable PDF in this item.

★ Personal use only: for you and your household. Please don't share, resell or redistribute the files.

★ Digital download: nothing physical is shipped. You get one .zip file; unzip it to get the files.

★ 14-day promise: if a file is faulty or not as described, contact me within 14 days and I'll fix it or refund you.

Made with the help of AI tools (drafting text, layouts and formulas); I chose the content and reviewed and edited every file.