Photo Booth: Print Media Packs To Load

Excel Formulas › Photo Booth Rental

All versions

Running out of paper at 10pm is the one photo-booth failure guests remember. Media comes in sealed packs of a fixed print count, so the only safe way to pack the car is to multiply sessions by prints per session and round the packs up.

Quick formula: Sessions times prints each, divided by the prints in a pack, always rounded up:

=ROUNDUP(B2*C2/D2,0)

240 sessions printing a double strip is 480 prints — two 350-print packs, because 1.37 packs does not exist.

Functions used (tap for the full reference guide):

ROUNDUP PRODUCT

The example

Three booked events, each with an expected session count, how many prints each session takes, and the pack size the printer uses.

	A	B	C	D	E
1	Event	Sessions	Prints each	Prints/pack	Packs
2	Wedding	165	2	350	1
3	Gala	240	2	350	2
4	Grad party	400	2	350	3

The formula

Total prints first, then packs — and packs never round down:

=ROUNDUP(B2*C2/D2,0) // sessions x prints each = total prints, / pack size, rounded up

How it works

Three pieces, in order:

B2*C2 is total prints. A session is one press of the button; prints each is how many copies walk away (one per guest in the frame, or a doubled strip).
/D2 converts prints into packs. Pack size is a printer spec, not a choice — look it up once and lock the cell.
ROUNDUP(...,0) forces the next whole pack. A partial pack is a full pack you have to carry.
Copy the formula down the booking sheet and the column becomes a packing list for the week.

Add one spare pack per overnight event as a policy, not as a calculation — the formula sizes the job, the spare covers the surprise.

Try it: interactive demo

Interactive

Enter the expected sessions, prints per session, and your pack size.

Sessions

Prints per session

Prints per pack

Variations

Add a spare pack

Bake the spare into the formula so the packing list is the truth.

=ROUNDUP(B2*C2/D2,0)+1

Media cost for the job

Multiply packs by what a pack costs to get a consumable cost per event.

=ROUNDUP(B2*C2/D2,0)*89

Pitfalls & errors

Prints per session is not always 1. A 2x6 double strip cuts from one 4x6 print, but handing every person in a group photo their own copy multiplies the count fast. Set the column from your actual template.

Sessions per hour is roughly 25–35 for a well-run booth with an attendant. Estimating sessions as hours times 30 gets you close before the RSVP list is final.

Never let this round down. =ROUND(...) on 1.4 packs gives 1 and sends you out the door 140 prints short.

Practice workbook

📊

Download the free Photo Booth: Print Media Packs To Load practice workbook

Edit the yellow sessions, prints-each, and pack-size cells; the pack count recalculates.

Frequently asked questions

How do I estimate sessions before the event?

Multiply the booth hours by 30 sessions per hour for an attended booth with a short prop table. A booth tucked in a hallway with no attendant runs closer to 15 an hour, and an open-air booth at a reception peak can exceed 40 for a while.

Should I count reprints?

Yes, if you offer them. Add a reprint allowance to the prints-each column rather than a separate row, so the pack math stays a single multiplication.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: ROUNDUP PRODUCT