Game Rental Shop :: Video Games Consumerism Spreadsheets Essays

Game Rental ShopSpreadsheetRent itGames rental creditTo start my project I have chosen that I would do a spreadsheet for agames rental shop. This shop would be renting out games for mess 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. Ithink choosing to do a games rental shop is quite a good choicebecause it would accept 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 sheet whichinvolves the sales and late charges. I will be compute things suchas adding up sales and late charges and adding up. surpass is the bestprogram to betoken because I would be using its features tocalculate. Using formulas you can calculate the whole informationbase in asecond.These are the sorts of calculations that we can get hold from excel Average sales per we ek Most rented game Adding up the number of rentals in a week Working out the profit Fine charges etc.I can use excel to get results such as the nigh 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 title. Excel also has a function called sort. Ifthere is almost two hundred 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 read 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 isbetter 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 calculator andwould help the m get good outcomes from the spreadsheet.The end user requirements should be* Fast data search* Accurate calculations* Easy 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.