Holiday Cookie Tray Calculator: 60 Cookies, 5 Trays

What the cookie tray answer means

The tray count is the number of filled trays the table needs, not the number of cookies baked: 60 cookies on trays of 12 is 5 trays, and a table needing 61 cookies is 6 trays, because the sixty-first cookie starts a new tray. The total cost follows the trays, not the cookies, so a tray that is only half full still costs a full tray price — which is why tray size matters as much as guest count when the budget is tight.

Output · formula · meaning

Three things to check before you trust the number

First, check the tray size against the cookies you actually bake: a tray that holds 12 in theory but only 10 without stacking changes the count. Second, check cookies per guest against the table: a tray table that is the dessert needs 3 cookies each, while a table full of other desserts needs closer to 1. Third, check the price per tray against the basket: $3.00 a tray should look like the flour, sugar and tray in the shop, not like a bakery bill.

Worked example

Twenty guests are coming, each taking 3 cookies, and a tray holds 12 cookies at $3.00 a tray. Cookies are 20 × 3 = 60. Trays are 60 ÷ 12 = 5, exactly, with no rounding needed. Cost is 5 × $3.00 = $15.00. If four more guests arrive, the same steps give 24 × 3 = 72 cookies, 72 ÷ 12 = 6 trays, $18.00 — and if the tray held only 10 cookies, the original 60 cookies would need 6 trays instead of 5, which is exactly the kind of check that saves a short table.

Every branch, checked

At 21 guests the answer moves to 63 cookies, 6 trays, $18.00, because the sixty-first cookie starts a new tray. At 2 cookies each the answer falls to 40 cookies, 4 trays, $12.00. At $0.00 a tray the trays stay 5 and only the total drops to $0.00, which is the pantry-stores case: the trays are still needed, only the new spending disappears.

Who uses this

• Party hosts:: set out enough trays before guests arrive, instead of refilling a single tray all evening.
• Bakers selling trays:: price a tray order from the guest count, not from a guess at the cookie count.
• Office party organisers:: turn a headcount into a tray order that survives the first ten minutes.
• Families:: split the baking between households by trays, so each household knows exactly how many to bring.

Accuracy & limitations

The calculator is exact for the figures you enter, but the figures themselves are judgements: cookies per guest varies with the table, and tray capacity varies with cookie size. A tray of large cookies holds fewer than a tray of small ones, so measure your own tray once with your own cookies and use that number. The rounding is always up, which is the safe direction for a table: an extra tray is leftovers, a missing tray is an empty table.

Cite this calculator

Bright Side Kit, “Holiday Cookie Tray Calculator: 60 Cookies, 5 Trays”, https://brightoolbox.com/holiday-cookie-tray-calculator/, accessed 4 November 2026. Students and researchers: cite the calculator name, the page URL and the date you used it, and quote the defaults (20 guests, 3 cookies each, 12 per tray, $3.00 a tray) so the result can be checked.

Frequently asked questions