How to calculate the number of available bundles for your ticket tiers

If you have not run any raffles before you are probably wondering how many packages should you make available for your chosen raffle ticket package prices.

With Trellis we will provide you a recommended percentage on how many you should make available for each price tier depending on how many ticket packs you decide. See below image

To make it easy, please download the Trellis Ticket Package Calculator by clicking below.

Download a copy of the ticket package calculator by clicking file(top left) --> download --> download as Microsoft Excel (.xlsx). Once you have downloaded a copy, open the file and you will see that there's a sample ticket package calculation for your reference.

You are not allowed to directly edit our online template to avoid changes in our file. Again, download a copy to your computer then use that file to calculate.

Then follow these steps:

1. Enter your raffle sales goal in cell C27

2. Enter your desired ticket packages as shown below. These ticket packages are 1 for $10.00, 3 for 20.00, and 100 for $50.00

3. Now for the fun part! On the # of packs available column enter a number that the sum of total value would match your sales goal and make the percentage(%) close to the recommended percentage of packages.

If you can't make the % match the recommendation that's okay! Your aim is to be as close as possible to it but still hit your sales goal!

And that's how you calculate your ticket packages, again this is a general recommendation and this varies depending on the province's regulation and how well you know your community!