A Program for a Cinema Manager

I'm going to answer the task in a spreadsheet because I found that it is the easiest and clearest way to do so. I will be using numbers and text in the spreadsheet. The spreadsheet will need to calculate prices, incomes and expenditures. It will need to be quick and easily accessed. The formulae and functions.

Examples of these formulae are:

* Sum function (=sum)

Example. =Sum (C3:G3)-Adds up the content of cells C3 to E3.

* The "what if" function.

With a series of formulae, it is possible to make changes to figures and see what happens to expenditure and income. The spreadsheet program automatically updating figures does this.

I will be using will make using and updating the figure easy and fast. I will lay out the income, expenditure and other aspects in different clear worksheets.

I will receive the data from the cinema owner, when I have finished I hope to have made a fully working spreadsheet which displays business figures and expenses, and is easy the change and update.

For my spreadsheet to work, I will need:

* Separate worksheets to work out prices and calculations

* Those will be Income, Expenditure, number of people and a page containing ticket prices.

* The tickets worksheet will have a space where the boss can enter a price in a "what if" space.

* In this what if space, the boss enters the price that he desires, and can see what happens to his income.

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

Also, if the manager had eye problems, the text will be large, bright and easy to see. Also there will be little footnote to help the manager to use it properly, and there will also be an in depth manual.

The initial menu is going to be in the web page form to make it even easier.

Once I have implemented the spreadsheet, I am sure it will be very useful to the manager and will have a positive affect on the business and will help to run it more smoothly.

General Design

In the initial design I was considering putting everything on one worksheet, but it wasn't at all efficient, so I decided to split the figures and data and found it to be much more organised.

The worksheet is organised in the following categories:

* Expenditure

* Main menu

* Income

* Ticket price changer

Expenditure will have things like staff's pay and the price of essentials like film cost etc.

The main menu will be a "user-friendly" interface that is the first page that the cinema manager will be able to use easily.

I will use buttons and hyperlinks to link the worksheets together; the main menu is the heart of worksheet.

Income

On the income worksheet it will include things like:

* Ticket sales

* Money from drinks and sweets

* Number of people

* Total showings

* Total expenditure

User- Friendly test:

I decided to test my spreadsheet on a friend who hadn't had that much experience with computers, that person will test and use the spreadsheet and comment on:

* Presentation

* Content

* Ease of use

* And did it serve it purpose

It will be marked out of ten.

Tester:

Shane Daley

Presentation

7

Content

8

Ease of use

9

Served purpose?

Yes

I immediately corrected the problem and put buttons on each page.

Spreadsheet Test

Button test:

To check that all the buttons on the menu work

Outcome: Successful

Formula Test

To check the formulae are correct by giving sample figures that have already been worked out and see if the spread was correct.

Outcome: successful

Test Number

What the test will do

Expected results

Result

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 -