• 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. The business I am going to set up is a snooker club,

    * Deposit on property - I will pay �1000 on deposit for the property in the first month. This is an indirect cost because I will have to pay in order to do business in the property.

  2. In this assignment I am going to produce a detailed business report on a ...

    As Tesco is increasing, ICT becomes increasingly a bigger part of Tesco. It is used in all areas of the organisation, from the till to the manager who uses ICT for report, memos and a variety of other aspect of the running of the business.

  1. Business report on Marks and Spencer.

    18.5 The transmitter then chooses the communication channel that he wishes to use in order to send it to the receiver (the target for the message). 18.6 On receipt of the message, the receiver will decode it (i.e. interpret what the message is conveying) and act upon it as necessary.

  2. In this coursework I need to produce a detailed business report on one medium-sized ...

    HR professionals HR professionals operate out of the Line, working as part of the senior management team in order to influence and implement HR strategy. They work closely with the central HR departments and line managers to deliver key aspects of company's business plan: * Develop the best * Recruit

  1. Buisness at work

    there goods and services from there are satisfied with them and shop from there repeatedly. (Repeat business) Asda provides a un - rivalled value to its customers in the quality of the goods they sell, in the commitment of their prices and in the range of choice they offer.

  2. Business Venture - Dance Club

    > The Ivory Room - self contained and holding up to 275 guests, is on the top floor bar and restaurant space has spectacular view of the London Skyline. * Storm (based on Leicester Sq.) * Metra club & bar (based on Leicester Sq.)

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