I am going to design the spreadsheet for a company called 'The Grand Theatre'

Authors Avatar

I have been asked to produce a working spreadsheet of a electronic Ticket Recording System I am going to design the spreadsheet for a company called ‘The Grand Theatre’.   The Grand Theatre is a musical theatre based in Montgomery Park, Belfast.  The company shows two productions every month, each of them lasting two weeks.  The two productions are ‘The Pirates of Portstewart’ and ‘The Marriage of Roberto’.

Due to the theatre market changing rapidly I am going to implement a computerised ticketing system for all the monthly production sales.  This will prove to be a much faster and easier method of management information.

There are a range of tickets available which vary in price depending where your seat is:

        

There is a discount offered by the theatre of 10% for parties of 10 or more people and also for productions for Monday or Tuesday.  There is also a surcharge of 3% for bookings made using a credit card.

Join now!

I am to produce a ‘template’ of a working system that can be used for any month, and that will record ticket sales for both monthly productions.

In order to be able to react to the rapidly changing theatre market I plan to computerise the ticketing system for all monthly production sales.  By implementing this method management reports will be produced and will provide quick, accurate and flexible management information.

The details of the ticket sales for the two productions are:

...

This is a preview of the whole essay