Hamper and Gift Box Costing Sheet

Who this is for

What one hamper really costs. List the contents with the quantity in each hamper and your unit cost, add the container, filler, ribbon, card and postage, and see the cost of one hamper and of the whole batch.

People making hampers or gift boxes for family, clients, staff or a fundraiser raffle, and anyone deciding what to charge for hampers they sell.

What this helps you track

• The cost of the contents going into each hamper
• The cost of the container, filler, ribbon, card and postage
• The cost of one finished hamper
• The total for the number you are making
• The difference between your cost and your selling or target price

How to use it

1. Write the hamper name, who it is for, how many you are making and the date they are needed.
2. List each item going in with its supplier, the quantity per hamper and the unit cost you pay.
3. Fill in the packaging and delivery lines the same way, adding any others you use.
4. Enter your own selling or target price per hamper.
5. The line costs, cost per hamper, batch total and difference are worked out in the browser and the workbook; on paper, multiply quantity by unit cost and add the lines.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

Where do the unit costs come from?

From your own receipts or supplier prices. If you buy a multipack, divide the pack price by the number in it. No prices are supplied, because they depend on where you buy and how many.

What should I charge for a hamper?

The sheet does not suggest a price or a markup. Enter the figure you have in mind and it shows the difference from your cost, which you can then judge against your own aims, whether profit or a fundraising total.

Does it include my time?

Not unless you add a line for it with your own hourly figure. For hampers sold as a business, the craft business costing sheets cover labour and overheads in more detail.

Can I cost different hamper sizes?

Use one sheet per size or type, with its own name in the header, so each has its own cost per hamper and price.