Concessions worksheet
Snack Shack Menu Price Calculator
Enter the package cost and servings, then choose a margin. The calculator rounds each price up to the selected quarter, half dollar, or dollar so it doesn't undercut that margin.
More event sheets
You may need one of these too.
Example packet
Friday snack shack menu example
A concession chair prices pizza slices, water bottles, and chip bags with package costs, target margins, expected sales, and quarter-friendly rounding.
- $555.00 expected revenue.
- $305.00 expected profit.
- Three menu items priced with no current-price changes in the example.
Assumptions
What the numbers assume
- Use item-level costs and expected sales, not buyer names, student private information, banking details, or vendor credentials.
- Package cost plus package units can estimate cost per sold item when a unit cost is not known.
- Blank numeric fields count as zero. Negative values are treated as zero and flagged for review.
- Target margin is capped below 100% because a 100% margin cannot produce a finite price.
- Food-safety, nutrition, allergy, tax, permit, school, district, and vendor rules stay outside this worksheet.
Formula notes
How the totals are calculated
- If package cost and package units are entered, effective unit cost is package cost divided by package units. Otherwise the entered unit cost is used.
- Raw target price is effective unit cost divided by one minus target margin percent divided by 100.
- Recommended price rounds the raw target price up to the item rounding increment or the default rounding increment.
- Profit per item is recommended price minus effective unit cost. Item margin is profit per item divided by recommended price.
- Expected revenue and expected profit multiply recommended price and profit per item by expected sold units.
- Current price is optional and only used to show price-change notes.
Check local rules
Sources for this worksheet
Use your group's current forms and procedures for deposits, approvals, and recordkeeping.
- Local school, PTA/PTO, booster, district, bank, and food-safety procedures : Local rules and treasurer procedures are the source of truth.
- PTO Today free printables and templates
- Local school and food-handling requirements : Food safety and permits are local decisions, not calculator outputs.
FAQ
Questions that come up
Enter the package or unit cost, target margin, and a rounding increment such as $0.25, $0.50, or $1.00. Review the suggested price, then print the menu or export the rows.
No. It is only a pricing worksheet. Follow your school, district, local food-safety, permit, tax, treasurer, and vendor procedures outside this tool.
Do not enter student private information, buyer names, card details, banking details, vendor credentials, tax IDs, donor private contacts, or official login details.
Related workflow
Other sheets for this event
Cash Box Count and Closeout
Count each till, compare actual cash with expected sales, and print the deposit amount with two signature lines.
PTO Fundraiser Profit Calculator
Subtract vendor costs, supplies, and payment fees from sales. Compare the profit with the goal before deciding whether to repeat the fundraiser.
Volunteer Shift Planner
List each job, shift time, and available helper. Print the open spots for the coordinator or check-in table.