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

Please take time to read this article if you haven't decided what ticket tier prices you want to offer.

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

Screen Shot 2022-07-15 at 2.37.05 PM

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!

Did this answer your question? If not, please feel free to contact us using that teal chat bubble on the lower right corner of your Trellis account dashboard.