Game Rental Shop :: Video Games Consumerism Spreadsheets Essays

Game Rental Shop Spreadsheet Rent it!!!!!! Games rental Identification To start my project I have chosen that I would do a spreadsheet for a games rental shop. This shop would be renting out games for people to borrow over a period of 3 nights. If the games are brought back later than the due in date then there will be a fine of  £1 every night. I think choosing to do a games rental shop is quite a good choice because it would involve lots of calculations. I think that excel would be very suitable software to use for this games shop as it would give me all the calculations and results. I am going to have a stock sheet on excel and another sheet which involves the sales and late charges. I will be calculating things such as adding up sales and late charges and adding up. Excel is the best program to calculate because I would be using its features to calculate. Using formulas you can calculate the whole database in a second. 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  · Working out the profit  · Fine charges etc. I can use excel to get results such as the most rentals in the week of a single game using a bar chart. Get results for the fine charges of the week again using bar charts and I can also use a pie chart to see the best renting title. Excel also has a function called sort. If there is almost 200 games on my database and next to them it tells you how many times this title has been rented out then all you have to do is click sort and it would tell you in order of what the best renting title is. Rather than an ordinary database program people prefer spreadsheets because it’s good for storing and retrieving. It can do calculations very fast and efficient. Excel also with the use of formulas is better than word processor or a database program. My end user would use the spreadsheet that I will design. My end user would be the shop owner who is using this as a super calculator and would help them 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 them To get from one sheet to another sheet I will be using macro buttons.