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

Theatre Model

Extracts from this document...


Introduction Theatre Royale is a theatre in the suburbs of London. A show is performed on Fridays, Saturdays and Sundays nights and on the other days the theatre is closed although on some days I go in to check the email and the post to see if anyone has inquiries. The problem is that far too much time is spent on calculating the income made by the theatre by hand because all the sums are laborious and take a long time to work out by hand or even with a calculator so a computer is needed because it could save lots of time because tedious sums can be saved as a formula and used again and again. This model will be very useful to Theatre Royale because it will enable me to manage and calculate my income (profit or loss) easily, quickly and effectively, as I will explain. On a computer after checking that all my formulas are correct once I can save the correct formulas so there will be a very small chance that any of my figures and end results will be incorrect whereas doing it by hand I had to check if my figures were correct every time I worked out any sum if I wanted to stop mistakes occurring. ...read more.


These are all things I will need to use to make my model clear, concise and interesting to the user. Users The people who would use this model are the manager and any other employee who works in the theatre. This means that even though some of the employees will have a good knowledge of how to use computers some of them won't have a lot of experience in using computers so it must be easy to use. For example they must know exactly where to put their data so some cells could be highlighted to make it easier to see. Also I will protect important formula so people won't accidentally change any of them and ruin the calculations. Prototype My model will start off with the different inputs, which will be the fixed costs and variable costs from like paying the cleaners, the actors, refreshment and the income from tickets and different refreshments. The total costs will then be worked out and so will the total income. The total costs will then be subtracted from the total income to see if I have made a profit or if I have made a loss. ...read more.


The model must calculate the total income for the different days. The model must calculate the profit/loss for a single day by subtracting the costs form the income. The model must calculate the cumulative profit/loss for the day and the previous days. The model must either produce the word PROFIT or LOSS in designated cells using the IF function, whether a profit or a loss is made. A user must be able to navigate and go around the model with ease so macros should be used because they can link the different sheets with buttons. The model should not pose any health risks, whether it is radiation or making an employee strain his/hers eyes therefore causing headaches. Data validation will be used on input boxes such as tickets sold. Also the message inside the comment box should be clear, descriptive but concise. Different sheets should be labelled so people know what is on the different sheets. Backing up (saving) the information stored must be possible to avoid data loss if the system of hardware fails or in the event of a security breach. The model must be able to show how a change in one or more inputs will affect the overall income. For example if I raised concession ticket prices but lowered ice cream prices how would this affect my income? Ellis Savva 1/5 01/05/2007 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Financial Model to help organise the year eleven prom

    An alternative method would be to use a school computer and the Microsoft package, Excel. This program is designed to deal with working out numbers and problems as long as it has the right information and is given the correct command.


    Select main menu macro button To check if macro works correctly Should go to the front-end menu As expected 22. Select print macro button To check if macro works properly Print currently displayed chart As expected User form 1:

  1. GCSE Calculator Project

    The calculator should automatically fill the screen as soon as it's open. 5. It should have large buttons so that the people with not so good hand-eye coordination will find it easier to use, and easier to use. 6.

  2. System requirements analysis

    Having a software like the example shown above would benefit the doctors and the receptionists. This software is designed specifically for booking software and medical use. This software has data base for storing patient records, to book appointments and to also view a doctors schedule.

  1. a level ict project

    their vehicles * Specific records of customers should be able to be located with ease * Information should not need to be entered twice, if possible it should become automated if it is a routine process * Price calculations should be done automatically, or specific charges should be apparent as

  2. The end user of my program is for the people applying for the insurance ...

    store quotes so customers come back this will reduce the number of errors etc. The most important part of the end user requirement going to be to make sure that the customer can be able to actually pay for the service provided, and this can easily done By the hawks

  1. Main aims and functions of Buckingham Bingo.

    The prize money for these two games is very big so the office has to take all of the winners personal details and bank details in order to grant the customer with there winnings. Cash Office * This is another section of the main office, but this is where all the money is dealt with.

  2. Analysis of stock ordering for Henley Ice cream Parlour.

    The data is compiled in an order book. When the ice cream is delivered, the invoices are also kept. 16. What does the system cost to operate? Costs include the wages paid to the employee who counts the ice cream; the price of the phone call and the price of the paper information is recorded on.

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