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

Introduction

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.

Middle

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.

Conclusion

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. System I designed in order to produce a promotion package for her newly formed ...

    It gives their ID number, name, address, age, gender, telephone number and what way they would like to pay; either by Visa, cheque or case. Influences of Hardware and Software available The software I chose did not help as much as I expected it too much.

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

    This is not needed at this current time in the company's life cycle, because of this I will not be recommending spending vast amounts of money on this type of solution. The next type of system that could be used would be a custom made solution.

  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 charts and graphs must be fit for purpose with the correct titles and axis used, it must be consistent with the company colours and theme.. This department employs 5 staff members. 2.6 Sales/Call Centre: This department has been created recently to deal with the increase in sales they deal

  1. Firewall Protection

    will not be responded at all. This way the remote user will not be able to even know that it reached a live computer. This might discourage the remote attacker from investing further time in effort to crack into your computer.

  2. Smart Card System

    divisible by (p-1)(q-1). We define E_K(P) = P^e mod pq, D_K(C) = C^d mod pq. All quantities are readily computed from classic and modern number theoretic algorithms (Euclid's algorithm for computing the greatest common divisor yields an algorithm for

  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.

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