• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21

Spreadsheet project

Extracts from this document...


IDENTIFY THE PROBLEM Description of organization & problems: - The user of my spreadsheet is a games company owner who needs to collect and distribute data to predict capital expense of wages for the future. They need to be able to see the expenses of their company and how, if the input into the spreadsheet is altered, the output is changed also. My spreadsheet is a model that simulates the real thing. As a company owner, the user should be able to record the various categories of income and expense and decide their course of action depending on how the store is doing on the spreadsheet. It should allow the user to make comparisons of profit/loss for that particular week, month or year. However, I will be going through this product as though I were the user and make references to the actual user of real life at appropriate times. I will be presenting the worksheets over a time span of a month so as not to make it too complex to understand. The product is aimed at the soul user of the system, which will be the storeowner. The name of my company is called Nintendo Universe. My company designs computer games for a number of consoles that we build. We sell accessories along with toys and magazines. We are basically a wholesaler selling our components to other big businesses. Our main headquarters is in California, America. We have a second headquarter in Tokyo, Japan. We have various factories and warehouses that produce and store these products and export them to big businesses on request. I have a total of 480 employees, out of which 100 are employed for the headquarters. Two hundred staff members are in the two production factories. The rest of my staff works in the various warehouses. I am the sole owner of the company. As this is a large trading enterprise, I have chosen to have a board of directors who are assigned various shared responsibilities and they own percentages of share in the company. ...read more.


makes sure the numbers are between the specified range Spell check: Makes sure that words have been written accurately For Validation you can also use IF statements, which will prompt you if there is the data entered, goes beyond what you have specified. You can for example say that the data should not exceed stock level and if it exceeds stock level to write error so that you are aware. For this you can do many checks, which will minimise the chance of any mistakes. One that you can use is the range check which is =IF (G2>STOCK!C3<,"OK","ERROR") In this the computer looks at G2 and looks if it is more than the stock in STOCK!C3, if it is then "ok" will be displayed and if not then "error" will be displayed. Spreadsheets I am going to do: - The spreadsheets that I will be creating will be of the payroll and one of personal information of my employees. It will include all necessary information such as 'hours worked' and 'overtime' and will also contain confidential information such as Telephone, Address and National Insurance Number. They then can help me to work out who gets paid what and whether the rotation system is working so that everybody gets roughly the same hours worked therefore the same pay at the end of each month. This spreadsheet will be very useful because it will show me the amount of money which is needed to keep the store open and then I will cross reference it with the profit I make in a month. If I manage to find a major decrease in money it will help me to make adjustments or if need be shut down that firm. The following is how my spreadsheet should roughly look like and is an example of how it should be set out. Name Age Address Telephone Hours Worked Tax Gross Pay 1 Bob John 34 8 Blenheim crescent 5432 7832 36 25% 2 John Ken 21 23 Elgin crescent ...read more.


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. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level ICT in Business essays


    This gives convenient to those particular group or people. By the use of Internet, Tesco advertises its products and sells at the same time. * Introduction of improvement in mechanism- TESCO introduced a self-service check in point in the shop floor where by the customer who does not want to


    M&S said the return is conditional upon the approval of shareholders and the High Court. Commenting on the announcement chairman and chief executive Luc Vandevelde said the return of capital "will enable us to improve the potential for a faster rate of earnings growth and create a more efficient balance

  1. Business report on Marks and Spencer.

    TQM is best described as an ethos / philosophy adopted by companies that place the pursuance of quality at the heart of the organisation and everything it does. To emphasise what a shift change this represented from the traditional approach of quality assurance.

  2. The business I am going to set up is a snooker club,

    Both small and large businesses can face national competitors. Professionals such as accountants, Banks and Manufacturing firms can face national competition. How competitors influence businesses? The business might have to lower prices because of competition this will degenerate profit levels, if the business doesn't lower the prices they will lose existing customers.

  1. ICT Coursework Two - Database Project

    an invoice with their details they have inputted and attached is another form to fill in the correct information and then collect it and update the database. For the videos the staff will do daily checks on the database to see any obscure looking information in the database and will

  2. Identify four different types of popular software application packages used in HRM and describe ...

    Features: Allows files, presentations, graphics, sounds or just plain text to be sent to any other email address in the world. All for the cost of a local phone call. Calendar feature enables easy organisation of daily/weekly/one off tasks. Reminders can be set for any task both regular and one off.

  1. The purpose of this document is to define the Context of Cain Motors Information ...

    Change Benefits: Benefits include increased revenue. Workflow efficiency removing double bookings. Improve staff communication; be able to access information, which is presented clearly and legibly. Change Costs: Virtual web hosting will incur a continued leasing cost Housing a web site has many long term running costs to be considered such

  2. Evaluate Data Collection Methods:

    This will tell us how long they worked, and if they were in work. Staff Pay scale The invoice will not store staff pay scale details The log book will contain all the information that I will need , it will be reliable because it will tell me what number

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work