• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  • Level: GCSE
  • Subject: ICT
  • Word count: 1229

A Program for a Cinema Manager

Extracts from this document...

Introduction

The cinema manager doesn't know how much to charge for each ticket so he can break even. So he is not sure how much to charge for each ticket. I will have to find out how much he makes and spends each year to help calculate the suitable price to sell tickets for to break even, anything he adds on is profit. The program I will be using is Microsoft Excel, a very useful spreadsheet program which is designed to display and process numbers. If this was done by hand, even with a calculator, it is very tedious and the manager wants an easy and most important of all quick. The program contains mathematical, statistical and financial calculations that can be applied to numbers, and it can even display values in the form of graphs and pie charts. The reason I want to use this program is because it is a very powerful, if the manager wants to see what would happen if he raised or lowered a price he could see exactly what happens to the rest of his calculations, if he changes an employee's wages, everything is automatically updated. ...read more.

Middle

* He then can compare that to his expenditure to break even * It will also need a title navigation screen to take you around the spreadsheet. Input: I will collect data and information about the business, these things include: * Employee costs * Cost for showings * Cleaning * Rent * Equipment * Furnishings * Estimated numbers of customers All of these things will be taken into account when building the spreadsheet. Process The computer will then be able to: * Use formulas to calculate sums and numbers regarding the businesses expenses and incomes * Show what happens if you change anything * Make mathematical findings * Calculate staffing expenses Output Then the manager can: * Print out account details for meetings * Can show partners or anyone else easily the accounts in a quick and easy way. * Can see how much to charge for tickets * Calculate profit via "what if" Easy Access To make my spreadsheet more easy to use and accessible I will put easy to use buttons on the sheet that takes you around the spreadsheet, for each individual worksheet. there will be a button that will take you back to the main menu. ...read more.

Conclusion

Outcome: successful Test Number What the test will do Expected results Result 1 Test the buttons take you to the selected page It should work Each f the buttons take you to the selected page 2 Drinks and sweets test and that the formulae work It should come to: �108.000 �108.000 See signed screenshot 3 Test that ticket sales It should come to: �9,504.00 �9,504.00 See signed screenshot 4 Ticket price and income "what if function" When the ticket price is �1.61 It should be �117.501 �117.501 see signed screenshot I feel that the project went well; I managed to make a well-rounded spreadsheet using the formulae I have learnt from my lessons. I think that the spreadsheet served its purpose well. I felt that it was easy to use and "user friendly". It is very easy to use on a busy day so they manager can make quick decisions and utilize the time he has to improve his business. I am sure the spreadsheet will make a good impression on his business. William Morgan Northbrook C of E School Last printed 11/01/2002 16:10 - 1 - ...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 Software 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 Software essays

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    The only alteration I needed to make was changing the cell references inside the functions as they were now different. Step 12 Once I had completed that, I then pasted the 2 tables again but this time next to the "writing" table; these tables were for the "Overall English Grade."

  2. Powerpoint review project

    Above shows the second part of the transitions menu. As you can see it is named 'Modify Transition and 'Advance Slide' these are two options that allow you to edit the transitions. The modify section allows you to choose the speed and sound of the transition whilst the advanced slide area allows you to choose whether the slide advances by a mouse click or automatically after a set time.

  1. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    Here are some of the backup devices that can be used: 1. Floppy discs: since floppy discs are small and portable, data can be easily transferred from one computer to another, this is an advantage but as they do not have a very high storage capacity, they are seldom used for backup.

  2. Payments Spreadsheet task. - formulas and fomatting

    I calculated the average per month by using the function average and using a range between the payment made by the first pupil to the payment made by the tenth pupil and then it gave me an average amount per month, which I then replicated the formula across the row.

  1. I will choose all my software considering what will work best for my website. ...

    webpage would look like and it is able to do everything and make very realistic like a real website. Microsoft Front Page This is a program which allows you to create a website. It has templates from which help you to come with your design it has an image editor and a HTML editor.

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    Later after every few months one of the employees has the enjoyment of typing out all our sales and purchases, in great detail, this makes it very time consuming and I hope to improve on that substantially. In order to obtain good results I have set up questionnaires and sent

  1. ICT PROJECT PRESENTATION

    Backup / Security Strategy The Computer file containing the database must be backed up on a memory stick. This copy should be kept at a different location from the computer in case of fire, theft or flood at the surgery.

  2. The growth of the computer industry in business

    You can edit your work as you create it. Formatting refers to adjusting the appearance of the document to make it look appropriate and attractive. For example, you might want to centre a heading, make wider margins, or use double spacing. Storing a document means saving the document on a floppy disk or hard disk.

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