• 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

    For example 'Doctors ID' witch will be common in both tables in my database. Then on one of the two tables I will have to click on the 'Doctor's ID' and drag it to the other table where it says Doctor's ID and, then I can find any other relationship if so between the two tables.

  2. ICT Coursework (MarcoS)

    Using an account system with a computer is more efficient, because you certainly spend less time, you can make copies of your work, so if the system is down, you have all your files on a cd. The security of the data stored is another big problem, because now all

  1. Database design.

    * To design an organised database. * To make user names and passwords for them. * I want to keep it secure so I won't let them have access to any options to be able to edit or delete the whole database. * I will try to keep a paperless shop.

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

    Finally I will create my switchboard. The switchboard was created successfully. The only change should be that it would be easier if there was screenshots or images and besides that it doesn't need any changes. Saving First I am going to click on File then I will select save as.

  1. Ict Powerpoint Coursework

    the presentation should be easy to read for all users - The presentation should be child friendly and be viewable for all ages ANALYSIS Hardware Image of hardware , Brand , Small amount of info Description of hardware Analyze of hardware (Advantages & Disadvantages)

  2. Database coursework

    searches automatic Produce Forms This means that it must be able to produce forms Be printable This is means it must be printable to A4 or A3. This is a problem with many databases so the designer must consider this objective Consideration of Solutions Application Advantages Disadvantages Paper /Fillet cabinet

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