I buy an create the games and store the stock in various warehouses around the world, which are then sent to many stores and some games go directly to my customers who have booked them in advance. We deliver all the stock ourselves with are own personal delivery team. – How do you record your finances, what is involved and how long does it take? Once the goods are sent out we keep invoices, which are then filed. At the end of each month I personally add up the bills and calculate the sales, decrease/increase in stock levels, profit/loss, monthly expenses and VAT.
This process takes up the whole day as the sums are lengthy and take up a lot of time. At the end of the year income tax is calculated referring to the profit or loss made throughout the twelve months. – How useful will this new computer-based system be to your company? The computer system has enabled my company to keep track of the latest stock levels, sales, staff expenses, etc. This meant my company can solve any problems (like if our expenses start spiraling out of control) immediately we can adjust the way in which we run our company, with a computer based system I will have better control over my company and its finances.
– What advantages and disadvantages do you think the computer system has? The computer is accurate and will save me a lot of time but I am worried about the cost of a PC and software needed to run my finances, also if anything happens to the computer all my finances will be destroyed. – What has the new system able to do? The new system is be able to explain to the user the amount of games the staff has sold and at what quantity, also their expenses should was shown so that the profit/loss can be worked out.
The information was to be displayed in an organised way so that it is user friendly and the user can access the data easily. For this the information needs to be shown in some sort of order, i. e. it needs to be shown in rows and columns. The system must be able to save the information so that progress can be tracked and any changes made. – How has the new system perform? The new system performed accurately, as it performed important calculations. If there were any mistakes then the overall profit/loss became incorrect but was changeable.
It also has to perform quickly, when any of the data is changed; automatically all relevant data should change. From this statement I can say that I have solved the initially problem because the new system I have created has benefited the owner. I have shown the owner that the previous manual method he was using was not as accurate as a computer system. Also he has saved a lot of space in his store and was bale to make the store look nicer and attractive.
This project in my opinion has been very successful one. I met the project needs, which was my original and main target, and these needs were met with a sufficient amount of detail. For the time allocated, I was satisfied with the way my spreadsheet was set up indeed I used a variety of formulas and functions that were all relative to the work. These functions allowed me to set the spreadsheet to calculate data automatically in most cases, which is one of the main things I believe a user would need.
Absolute and relative reference was both tested and they both worked for my spreadsheet. I have shown my spreadsheet to one of my friends whose name is Soyful and he said that “my spreadsheet is very well set out and all the formula’s work perfectly. ” A weakness of my spreadsheet is that it takes too long to do. I could improve this by having a special group, which type the information up. I think that I could have made my spreadsheet better by making it more detailed in certain aspects such as the length of time I set the spreadsheet over.
This could only have been achieved if I had more time to work on the project however, so it would have been too hard to include a great amount of detail in such a short space of time. I could have also included a wider range of items on sale as the amount I had were really for a smaller type store who would more often than not leave the transfer of data on to a spreadsheet due to there not being enough data to permit doing so. Doing my spreadsheet over a year rather than a month would have given the user a much better idea of how their business is doing.
Only doing a month restricts their knowledge of the store and a yearly record would enhance this view and allow them to make future decisions under better judgement. I believe that I could have improved the discount aspect of spreadsheet, as it is slightly out of sync with the rest of my work. The main detail for that particular worksheet was the names of the customers but again I could not have added such depth with the time allowed. My company will constantly keep on – going maintenance by having a special group of people who will update the information whenever new information comes in.
I will employ 5 people so when there is a lot of information to update, it can be done more quickly. If I were to do this project again, I would perhaps do a different type of store to allow me and the user to use a variety of news and different functions, as well as get a better outlook on how the productivity sales varies with different types of stores. Overall, I have found this project a very interesting and intriguing one and I am proud to say that I met the user’s needs and thus met the main target set out at the start of the work.