Site hosted by Angelfire.com: Build your free website today!

Tickets

 

Home

In this module we had to make a school pantomime show how it could be profitable! The problem was the school had no idea what to charge for tickets or drinks.  They did not know if they could hire costumes or buy stage make up!

We used Microsoft excel to make a model.  It calculated how much we had to charge for tickets.

               
      Tickets sold 150      
      ticket price  £        1.35      
COSTS         INCOME    
Lighting  £     50.00       Ticket sales  £   202.50  
Props  £     65.00       Refreshments  £     50.00  
Tickets  £     30.00            
Costumes  £     50.00            
Refreshments            
Total  £   195.00       total  £   252.50  
               
               
               
        Profit  £   57.50      
               

 

The formula I used to make the model work look like this.

             
      Tickets sold 150    
      ticket price 1.35    
COSTS         INCOME  
Lighting 50       Ticket sales =F2*F3
Props 65       Refreshments 50
Tickets =0.2*F2          
Costumes 50          
Refreshments            
Total =SUM(C5:C9)       total =SUM(H5:H9)
             
             
             
        Profit =H10-C10    

 

Send mail to crazy4/dshaw with questions or comments about this web site.
Last modified: 06/09/05