Theatre Model Essay Example for Free

Theatre Model EssayTheatre Royale is a theatre in the suburbs of London. A show is performed on Fri geezerhood, Saturdays and sunshines 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 get in concert if some(prenominal) oneness has inquiries.The problem is that far in addition a good deal time is spent on calculating the income made by the theatre by pass on beca implement all the sums are laborious and take a long time to work proscribed by hand or even with a calculator so a com intruster is needed because it could bear on lots of time because tedious sums can be saved as a formula and use again and again. This sit go away be very useful to Theatre Royale because it impart enable me to bed and calculate my income ( improvement or handout) easily, quickly and effectively, as I will explain. On a computer later checking that all my formulas are correct once I can save the correct formulas so at that place will be a very small chance that any of my figures and end results will be incorrect whitheras doing it by hand I had to check if my figures were correct every time I worked bug out any sum if I wanted to break away mistakes occurring. So an advantage is that a computer cuts work through the amount of mistakes happening in a much shorter time. too on a computer my entropy will be clear, distinguished info can be highlighted and any corrections I ramp up wont be seen, whereas when I used to work out the figures on paper it was very messy with crossings out. It was unclear what I was trying to do, to anyone else who looked at the paper. So another advantage is it will be much clearer and easier to read. All these advantages similarly contribute to saving time. So before lots of time was being raddled (time is notes) which could have been used to help the theatre in other aspects and therefore produce more money by having more time. So this pretense will be cost eff ective. Also using a vex I can see if I changed a variable or input how would it tinct my overall income. For ensample What if I paid the cleaners less? or What if I raised the prices of tickets? how would these adjoin my overall income.So using a computer willSave lots of time item most mistakes occurringMake it clear and easy to read and useBe Cost effective alter me to see if I changed a variable or input how it would scratch my overall incomeThe people who will use this model would be me (the manager) and any other employee who I ask to enter some data or check a figure. This means that even though some of my employees will have cognition of computers some wont have a lot of experience in using computers so it moldiness be easy to use. I will combat this problem in the analysis.AnalysisResearch out front beginning this project I did some research. I contacted the Milfield Theatre by e-mail address asking for information on different types of tickets and the ticket prices. T hey sent me back some useful information on ticket prices, which I will use in my projectAdultsConcessions*Performanceon Friday12.0010.00Performances on Saturday and Sunday13.5011.50* Concessions include children under 16, senior citizens and NUS students.They also gave me their telephone number (020 8803 5283). I also visited their Website address (http//www.millfieldtheatre.co.uk/) Their Website was very good. It was very well presented. It was colourful and titles were big and bold. There were pictures separating text or in spaces and watermarks. Maybe I could use a picture or watermark of a theatre or two masks in my model, just to keep the users mind focused and interested but still keeps it on the same theme. Also the Website was simple and clear. It kept me interested and it wasnt hard to follow. These are all things I will need to use to make my model clear, concise and interesting to the user.UsersThe people who would use this model are the manager and any other employee w ho 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 wont have a lot of experience in using computers so it moldiness be easy to use. For example they essential know exactly where to put their data so some cellular telephonephones could be highlighted to make it easier to see. Also I will protect important formula so people wont by the bye change any of them and ruin the calculations.PrototypeMy model will start off with the different inputs, which will be the fixed be and variable costs from like paying the cleaners, the actors, refreshment and the income from tickets and different refreshments. The issue forth 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. This will be used as a template on three sheets one for Friday, one for Saturday and one for Sunday. On a fourth sheet I will have a compendium of the week with all the totals of different variables for example total number of tickets sold for the whole week. Also listed here will be the profit/loss for the whole week.The model will be reusable by using named cell addresses, which means that instead of writing the cell name e.g. B3 you can lust carry through a name. Data Validation will be used on some of the input cells to stop incorrect data being written and also the message inside the comment niche must be descriptive but concise.Functions and FormulasThese are the processes in the model and they use the inputs to produce the outputs.I will use different percentages in the formula for my model. For example I will use the SUM function to work out the total costs and to work out the total income for the separate days and the totals for the stocky Sheet (sheet 4) and the IF function will also be used to produce in designated cells either PROFIT, if the total costs are less than th e income, or LOSS, if the total costs are more than the total income. This is an example of one of the outputs. This is one reason why I will use Microsoft Excel because it has these different functions and formulas on it whereas on other pieces of software like Microsoft Word these cant be used. I will also use macros as a way of jumping from one sheet to another by having buttons at the bottom of each sheet saying for example Go to Summary sheet or Go to Friday sheet. Visual Basic Editor will be used to make the macros. This will make navigating the model very easy for people who dont have a good idea of how to get to different sheets.Objectives ground on my research above, my solution for the theatre model will have to meet the following criteriaIt must be well presented and must keep the users interest1) Must be colourful2) Titles must be big and bold3) Pictures and watermarks relating to the theme of a theatre4) Tables must be clearly outlined so it can be clearly seen which pi ece of data goes with which table.5) It should be spaced out and not squeezed together so it is clear for the userThe formulae must be protected to avoid any of them being accidentally being changed.Cells, which are important, should be highlighted to bring attention to them.The model must be reusable named cell addresses can be used to give cells a name so instead of writing the cell name you can write the name.The model must calculate the total costs for the different days.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 syndrome 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 lap up prices how would this affect my income?