Comp ticket inventory?

sorry for cross posting this over several lists  & Forums...


Is there any good way to track (comp) ticket eligibility as a benefit for a donor? 


Here are two scenarios:

1)
Company X gives BAM a donation; the benefit package for this donation includes 50 tickets for the season.
How and where could I track those 50 tickets? They might use them for one show, or for several shows throughout the season, or not used at all.
We are currently tracking this in …. Excel …., a cumbersome activity.



2)
Donor Y gives BAM a donation, which is restricted to a production. The benefits for this donation include a pair of tickets for the engagement that they are supporting.
How would the ticket rep know that they are eligible for comps for this engagement, where would they look to see if they already have tickets?



Any advice is greatly appreciated

Monika


Monika Jouvert
Brooklyn Academy of Music
Development Business Process Director
718.623.7810 x6 / internally x4253
mjouvert@bam.org
http://www.bam.org <http://www.bam.org/>

Parents Reply Children