• 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. I have been given the task to design a database for a company called ...

    Evaluation of possible software solutions I have decided to recommend the use of Access to the clients as being most suitable because it seems to offer more facilities and features, which will help me in designing a program for the Postquick Parcels, clients.

  2. Smart Card System

    The Smart Card is different. By using multi directional interaction between the card and the reader true authentication of identity can be met in a more powerful way that is much more secure than the traditional magnetic stripe card. The cardholders' identity is held on the card via a secret key.

  1. Computer Aided Design Package

    that the CAM machine might not read the files it outputs perfectly. TurboCAD 10 outputs a different type of file but they state that this type of file is perfectly compatible with any CAM machine that reads .DWG files. Although they say this I think that from past experiences there

  2. Robot Prototype design principles.

    * consistency * compatibility * adaptability * economy * guidance not control * structure Interaction types * menu selection * command languages * direct manipulation Task Analysis The task analysis diagram of this Prototype would looks like this: Select If 'Yes' If 'No' The task analysis is the process of

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

    Alternative Hypothesis Words that are coloured in conflicting colours to that which the text describes (conflicting condition, Cc) will take significantly longer to process than words coloured in the same colour that the text describes (similar condition, CS). This is a one-tailed (directional)

  2. My aim is to design a spreadsheet for a teacher

    � Cells can contain a number of things such as numerical data, text data and formulas. � Spreadsheet data can also be exported and imported so if the data is stored in either a database or a data-logging device you can then import it directly into a spreadsheet without wasting time and typing it all in again.

  1. Evalutation of a Spreadsheet

    This would make it much easier to analyse the phone sales. The minimum, maximum, average are also useful features you can use within a spreadsheet to calculate the minimum sales, maximum sales, and average sales. This can be useful because it will give the manager a clear image of weak sales and maximum sales.

  2. Data Management: Past, Present, and Future

    Hollerith's business eventually became International Business Machines. This small company, IBM, prospered as it supplied unit-record equipment for business and government between 1915 and 1960. By 1955, many companies had entire floors dedicated to storing punched cards, much as the Sumerian archives had stored clay tablets.

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