Game Rental Shop :: Video Games Consumerism Spreadsheets Essays

Game Rental ShopSpreadsheetRent itGames rentalIdentificationTo start my project I have chosen that I would do a spreadsheet for agames rental shop. This shop would be renting out games for people toborrow over a period of 3 nights. If the games are brought back laterthan the due in date then there will be a fine of 1 every night. I debate choosing to do a games rental shop is quite a good choicebeca routine it would involve lots of calculations. I think that excelwould be very suitable software to use for this games shop as it wouldgive me all the calculations and results.I am going to have a stock sheet on excel and another(prenominal) sheet whichinvolves the sales and late charges. I will be calculating things suchas adding up sales and late charges and adding up. Excel is the bestprogram to calculate because I would be development its features tocalculate. Using formulas you can calculate the whole database in asecond.These are the sorts of calculations that we can get from excel Average sales per week Most rented game Adding up the number of rentals in a week functional out the profit Fine charges etc.I can use excel to get results such as the most rentals in the week ofa single game using a bar chart. Get results for the fine charges ofthe week again using bar charts and I can also use a pie chart to seethe best renting backup. Excel also has a function called sort. Ifthere is almost 200 games on my database and next to them it tells youhow many times this title has been rented out then all you have to dois click sort and it would tell you in order of what the best rentingtitle is.Rather than an ordinary database program people prefer spreadsheetsbecause its good for storing and retrieving. It can do calculationsvery fast and efficient. Excel also with the use of formulas is meliorate than word processor or a database program.My end user would use the spreadsheet that I will design. My end userwould be the shop owner who is using this as a super calcula tor andwould help them get good outcomes from the spreadsheet.The end user requirements should be* Fast data search* Accurate calculations* light-colored to use (user friendly)* Everything sorted out by using the Sort function* Get good results and easy to understand themTo get from one sheet to another sheet I will be using macro buttons.