• 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. The Design Brief - The company is a car hire company called Citicar.

    forms etc * Data presented clearly for customers to use in a database * Simple instructions so customers can use the system easily * Over due cars can be spotted easily and sorted out quickly Is the system able to all the things required?

  2. Creating a computer system for a video rental shop

    There is no calculated attributes in the entity The third table is borrowing, it contains: Transaction number Member ID Date of borrowing. All the attributes values are atomic, therefore it is normalised to the 1NF To check for the 2 NF.

  1. ICT car insurance quotation System Coursework

    requirements: �Have a separate sheet of car details showing IG numbers �Have a separate sheet of multiplying factors �Have a quotations sheet where the quote is calculated by using formulas. (Information is taken from the cars and multipliers sheets to work out the quote)

  2. Creating a computer system.

    The invoice totals are added up at the end of each week and the profits are noted down. Mr. Bains doesn't use a computerized system to monitor stock levels. Therefore, he has to count the stock every few days, to see which stock needs reordering.

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

    This include search functions as well as * VLOOK UP * DROP DOWN LIST It must contain all vital information This means that the spreadsheet document should have all information that it needs to work E.g. * Products should be in the spread sheet * Prices and other information sources should be in the same document.

  2. System requirements analysis

    Here is a screen shot of the Patient's records. It has the patients medical no., name, address, doctor, etc. the concatenate fiction is also here. These records (including the concatenate function) are all needed in the appointments page. The name, date-of-birth, etc is, unmistakably used in the appointments page, but the concatenate function is not.

  1. Data analysis report - Factors influencing pocket expenses of college students

    our calculated value of ?2 is less than the critical value of ?2 i.e. 11.0705; we accept the null hypothesis and reject Alternate hypothesis, concluding that there is no relationship between family income and number of working members in the family.

  2. Financial Model to help organise the year eleven prom

    This certainly could make the school lose a profit. (Picture 1) (Picture 2) So after carefully thinking about it, I decided to change the catering firm formula from a normal "Vlookup formula" to a "Vlookup" within a "if" formula. This then would give a more accurate price and could increase the profit entirely.

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