• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 3439

The aim of this coursework is to design a new system for a company called Taki casuals importers and exporters. This company imports a variety of textiles from England and the UK and sell them wholesale in Europe, mainly in Italyand France.

Extracts from this document...


Introduction and overview of problem. The aim of this coursework is to design a new system for a company called Taki casuals importers and exporters. This company imports a variety of textiles from England and the UK and sell them wholesale in Europe, mainly in Italy and France. Currently the company uses a manual based system to manage their finances, this involves using a lot of filling cabinets to store the data and invoices and then calculating the company's profit or loss. This method isn't very accurate and it takes along time to make any calculations. The new system I will design will model the company's finances and will be user friendly so that the user can be efficient. My new system will model all the information needed to work out if the company is making a profit/loss. Examples of calculations are trade price, duties and tax, freight, selling price, quantity sold, wages, rates, electricity, gas, water, advertising, motoring, telephone etc. the system will include cell-referenced formulas so that if any numerical data changes, subsequent relevant data will adjust automatically. Using my new system the company will be able to use model situations to find out what amount they need to sell to break-even or how much profit will they make if they sell a certain amount of their product. They will also be able to fin out what effect a price reduction will have on their profit. This can all be done by changing a few quantities or a few prices and the formulas will automatically adjust the profit/loss. With the current system the company is unable to do this because it is impractical and will take a lot of time just to find out the results for one small criteria but with the new system answers to many criteria changes can be found instantly. The company's current situation will have to be taken into account, this will be achieved through an interview with the people concerned after which the advantages and disadvantages must be studied. ...read more.


If any mistakes are made then overall profit/loss can become incorrect. It also has to perform quickly, when any of the data is changed, automatically all relevant data should change. - The information can be put under the following suitable headings: Type of clothes Size Import price Retail price (excluding VAT) Amount of VAT Retail price (including VAT) Quantity sold Total price (excluding VAT) Total price (including VAT) Profit/Loss Expenses Input, Process and Output Requirements Identified inputs and data store requirements: - The data that will be inputted will be figures of prices on clothes. This will be up to the system user where he/she gets it from. - The owner inputs sales data - Also things like dates, customer details, addresses phone numbers, VAT figures will also need to be inputted into the system. Again this will be from the system user where he/she obtains these. - The worksheets will store much data. It will store things like prices, customer details and calculation formulas. Identified output requirements: The outputs my system has to provide are - A printed out document of which should be an invoice specifying details of the customer, price of clothing and expenditure. - A clear means of calculating the data figures, putting them into perspective according to the system. Processing requirements: - I will use need to show the VAT before and after purchase so I will have to multiply VAT (17.5%) to all the prices. - I will use formulas, mainly vlookup functions to calculate the data. - I will multiply the quantity with price of the goods. - I will total prices and sum up other expenses as well. Evaluation criteria- performance indicators To test if the new system will work a number of tests will need to be carried out. 1. Easy to use 2. Easy for the user to locate a certain sheet by the use of macro buttons 3. ...read more.


My system consists of letters and numbers and not marks therefore there aren't going to be any marks to convert. After looking at all the method I can clearly see that information will have to be typed onto the computer. A lot of data is not going to be repeatedly typed and there isn't going to any training needed to use this method. This method is easy, cheap and practical and as my company does not need to enter much information onto their system they will not need to use something like a barcode reader which is used for processing large amounts of data at a fast speed. Data Collection The company I am designing a model for does not deal with an enormous amount of customers and orders, they already make an invoice every time an order is placed. I have decided to design an invoice on which they can enter all information and a record will be kept, the information from the invoice can then be inserted onto the main spreadsheet easily. All the calculations will be made automatically as formulas will be used, only the ref no. and quantity will have to be entered and the rest will be done automatically. After the invoice has been written, the user will print it and give it to the customer and keep one 4 himself Data Verification Data Verification is checking that what is on the invoice is the same as what has been entered onto the system. Re-checking that the correct data has been entered can do this. You can also get someone else to re-type the information and the computer will check the two against each other. If the data is identical then it will be processed for further calculations and if not then you are told to check it. This can be expensive as two people have to type the information and it takes much longer. This method will be both time consuming and money consuming but proof reading will be useful if done by the same person. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Creating a computer system for a video rental shop

    The presentation of the results would better in a form this is because of a number of reasons, which include: * It is easier to read from forms than tables. * Forms display one record at a time, rather than all of them at once, like on a list, which make it harder to isolate one particular record.

  2. Introduction to information skills and system. An information system is a system that accepts ...

    Charts and graphs are the most popular ways of analyzing data. They show relationships, trends and comparisons at a glance. The impact (use of colours and symbols to draw attention to important data), speed (obvious) and simplicity (easily understood) made it popular.

  1. Database Design Guideline

    It is useful because it will tell the information about the Doctor and Patient and updates the patients and doctors information about them witch will narrow my search when I am finding out information about the staff and the patients in Whipps cross hospital.

  2. Database design.

    Information about an entity is captured in the form of attributes and/or relationships. If something is a candidate for being an entity and it has no attributes or relationships, it isn't an entity. Attributes An attribute describes information about an entity that must be captured.

  1. Benefits of using my IT system in the Travel Agents.

    After that I will choose the location where I want the file to be saved in and if I want to I will rename the file by clicking on file name. Finally I will click on save. The work was saved successfully.

  2. Ict Powerpoint Coursework

    hard drive for people to back up there work on and save there work on, it is also quite small, lightweight and portable. This will be used as a form of backup for all the S.A. Food franchisees. It will be connected to the main computer which would be used by Mr.

  1. Database coursework

    The company would need to store the data online and update the data via the Internet. The data would be entered in a web-browser. This alternative is good and easy to update. Although this alternative doesn't cover all the user requirements, but most of them.

  2. Producing documents for a company. Spreadsheet, Invoice and Website.

    * Should use drop down list * It should use VLOOK UP7 * It should do calculation automatic This would make the document more user friendly. Products and services must be find easily This means that the tables and menus should be clear and easy to use.

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