• 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. Evalutation of a Spreadsheet

    These include possible inaccurate calculations, editing the data is difficult, filing a lot of paperwork would be difficult, and human errors are likely. Possible inaccurate calculations and human error - when using a manual system it would be time consuming when performing calculations.

  2. Unit 6 - Advanced Spreadsheet Skills

    The team employ 5 staff members. 3. Suppliers: All the produce is supplied locally from farmers and growers who have to provide evidence their there crop is grown to organic standards. For this to happen they have to be subject to regular rigorous checks every week.

  1. Firewall Protection

    There are also some programs (sometimes called antiTrojan programs) which specialize in the identification and removal of Trojan horses. For a list of those programs, and for comparison on how well different antivirus, and antiTrojan programs identify different Trojan horses, see Hackfix (http://www.hackfix.org), under "Software test results". Hackfix also has information on the more common RATS (such as the Netbus and the Subseven)

  2. Smart Card System

    Smart cards provide data portability, security and convenience. There are 2 kinds of smart cards: "intelligent" smart cards contains a central processing unit-A CPU, that actually has the ability to store and secure information and " make decision" as required by the card issuer's specific applications needs.

  1. 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.

  2. Computer Aided Design Package

    Us is above him. In total this brings the number of employees working for Engineering ? Us to twenty and two of these twenty employees will be using the system I am to justify. The company has recently won a new contract from a client and now has to construct a lot more furniture over a shorter period of time.

  1. Data Management: Past, Present, and Future

    This would have been impossible with manual techniques. Still, it was clearly time for a new technology to replace punched cards and electro-mechanical computers. 2.2. Second Generation: Programmed Unit Record Equipment 1955-1970 Stored program electronic computers had been developed in the 1940's and early 1950's for scientific and numerical calculations.

  2. Robot Prototype design principles.

    Each button on the bar invoked a pop-up window that was responsible for some aspect of the tool's high-level operation. The consistency principle: Things that are similar should look similar, and things that are different should look different [Brown 88, pp.

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