• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

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

Extracts from this document...


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: Adult Senior Citizen Student Child Front Stalls �12.00 �8.00 �9.00 �6.00 Back stalls �15.00 �10.00 �11.25 �7.50 Circle �18.00 �12.00 �13.75 �9.00 Gallery �20.00 �13.50 �15.00 �10.00 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. ...read more.


The Grand Theatre has produced an expected income for both productions. They are as follows: Front Stalls �1200.00 Back stalls �1500.00 Circle �1300.00 Gallery �1300.00 The Grand Theatre has also drawn up a list of expenses for both productions. They are as follows: Salaries �1790.00 Costumes �480.00 Overheads �145.00 Staging �980.00 Lighting �250.00 Sound �475.00 The Grand Theatre will be looking for a spreadsheet that will be simple to use and one that makes processing easy to do. Processing that will be carried out will include: Calculating the number of tickets sold Output that will be required will be included in the management report. This will be in the form of reports and graphs. Calculations I will be using the following formulas and lookups to aid in designing the spreadsheet: * IF Statement * VLookups * =SUM Complex Features During the process of the spreadsheet I will be using a number of complex features. They include: * Macros - these will help navigate through the spreadsheet with buttons. * Drop down lists - these lists display all of the available choices to the user so that they can click on their preference. ...read more.


Menu page 2. Marriage of Roberto 3. Pirates of Portstewart 4. Totals/Reports for both productions 5. Data/Lookups for named cells/ranges The Menu page will have buttons linking to each sheet using Macros. When a user clicks on one of these buttons they should be taken to the correct page. The two productions will have information such as number of tickets for adults, children, students and senior citizens. The seating area will be chosen with the use of a drop down list. The payment method will also be used as a drop down list. The forth page will be the Totals/Reports. In this page will be my overall income and profit as well as the Best Production sales and whether or not they exceeded the expected income or not. The fifth page will be the Data/Lookups where I will have the Appendix B - Ticket Prices as well as Expected Income and Expenses. These can be used to name cells and ranges for use with Lookups and Drop down Lists. As well as all this I will have to do a number of Graphs which will consist of bar charts and pie charts. They will give a better view of which production made the most income. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Smart Card System

    There is no way to get the password from the crypted value. In MD5, we need the information that is stored, so we can't use a one way hashing function to store it. This means that MD5 requires more rigorous security on the server machine.

  2. System I designed in order to produce a promotion package for her newly formed ...

    Here are some of the things I need to do/change to the database: * Create a data structure that holds record information * Create a database structure that holds customer information * Add a few extra fields * Change the layout of the page slightly * Update the information to the modern day.

  1. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    As this system will not be ready much before Easter for implementation Mr Hull would like it to include aspects which aren't needed at this point in time, but which will be needed come Easter. Mr Hull would like to have a stockroom in a couple of weeks within which

  2. This report aimed to replicate Stroop's (1935) experiment. Using the repeated measures design and ...

    Null Hypothesis The colour interference does not affect the participants so therefore the process times for both conditions will be similar; any differences are due to chance. METHOD Design and Controls This report has been based on the repeated measures design.

  1. Evalutation of a Spreadsheet

    How has the system improved from the manual system they used previously? By using Excel to process the data instead of the previous manual system there would be many benefits. By using a manual system there would be many limitations.

  2. Unit 6 - Advanced Spreadsheet Skills

    changed to just computer based systems this is the reason behind the new system. It will perform the entire task required like producing charts and graphs to provide evidence to the banks and larger business that the company is a solid worth while investment.

  1. Firewall Protection

    It is thus that the NBT (which sometimes loosely called "NetBIOS") is acting as a server. So the next question should be "what remote NBT commands the NBT server will do on the local computer". The answer to this question depends on the specific setting on your computer.

  2. I am going to investigate the purpose for which an organisation uses ICT. The ...

    This would allow the company to keep their accounts on computer and allow them to send mail merge letters, for example. Output devices the company would need are obviously a printer. I would expect them to choose a colour laser printer, as this provides the best quality printouts, quickly and quietly.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work