Theatre Model Essay Example for Free

Theatre Model EssayTheatre 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 chore is that far too much clip is spent on calculating the income make by the theatre by hand because all the sums are severe and take a long age to work disclose by hand or even with a calculator so a ready reckoner is needed because it could save lots of time because tedious sums can be saved as a formula and used again and again. This nonplus go forth be very useful to Theatre Royale because it go out enable me to manage and seem my income (profit or loss) easily, quickly and effectively, as I lead explain. On a computer after checking that all my formulas are correct once I can save the correct formulas so there entrust be a very small chance that any of my figures and end results will be inco rrect 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. So an advantage is that a computer cuts down the amount of mistakes happening in a much shorter time. Also on a computer my data will be clear, important data can be highlighted and any corrections I make 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 move 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 likewise contribute to saving time. So before lots of time was being wasted (time is money) which could have been used to help the theatre in other aspects and therefore produce more money by having more time. So this model will be cost effective. Also employ a model I can see if I changed a variable or input how would it affect my overall income. For example What if I paid the cleaners little? or What if I raised the prices of tickets? how would these affect my overall income.So using a computer willSave lots of timeStop most mistakes occurringMake it clear and easy to read and useBe be effectiveEnable me to see if I changed a variable or input how it would affect my overall incomeThe plenty 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 knowledge 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.AnalysisResearchBefore beginning this project I did some research. I contacted the Milfield Theatre by email address asking for information on diverse types of tickets and the ticket prices. They sent me back some useful information on ticket prices, which I will use in my projectAdultsConcessions*Performanceon Friday12.0010.0 0Performances 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 demonstrates 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 floor. 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, pithy and interesting to the user.UsersThe 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 o f them wont 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 wont accidentally change any of them and ruin the calculations.PrototypeMy model will start send 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 agree costs will and so 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 tercet piece of papers one for Friday, one for Saturday and one for Sunday. On a fourth sheet I will have a summary of the week with all the totals of different variables for example total number of tickets sold for the whole w eek. 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 kinda of writing the cell name e.g. B3 you can lust write a name. Data ecesis will be used on some of the input cells to stop incorrect data being written and also the message indoors the stimulus box 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 functions 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 ruin days and the totals for the Summary 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 the 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 outmatch be cause 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.ObjectivesBased on my research above, my solution for the theatre model will have to get wind 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 piece 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 rilievo 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 tense up his/hers eyes therefore causing headaches.Da ta 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?