• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Cindy Bells is a small wedding shop situated in Brownhills, West Midlands that makes and sells its own dresses - the current system

Extracts from this document...


Cindy Bells is a small wedding shop situated in Brownhills, West Midlands that makes and sells its own dresses. The orders are usually made in person, as a fitting is necessary. All accounts are done by hand, and copies of orders for materials (usually obtained from Los Angeles), and customer invoices, are all kept in a filing cabinet at the rear of the shop. With orders, the proprietoress, Cindy Costello, makes purchases over the phone, writing down what she has ordered on a piece of paper. The problem with this is that this system is error-prone and unreliable. Post-It notes are usually just stuck on a desk or pieces of scrap paper are left lying around the office. For this reason, some essential work is sometimes forgotten. When the order arrives, if the order has been written down to confirm the placement of the order, the piece of paper is filed, along with the order received documents. When billing customers, she hand writes a bill, photocopies it, then gives the original to the customer, and files the copy. The current system Mrs. Costello is happy with the way that she does her invoices and orders, but acknowledges that this is very time consuming. ...read more.


D: A Daily job list is needed and is not in place at the moment. E: After a stock check is made, the customer has a choice of which fabric to use. If the selected fabric is not in stock, it needs to be ordered via phone from Los Angeles (a very time consuming activity) F: A deposit is made on the dress before it is made, and after the dress has been made, an invoice is prepared (with materials, fabric and labour included). G: When the invoice has been paid in full, the dress can either be picked up from the shop, or delivered (for a small charge). No drivers are employed, as they would not be needed, so either of the workers delivers the dress, if this is preferred. Boundaries of the system Problems with putting in a new system are that certain problems will be unavoidable. These include software and hardware restriction, and the user's skill level. Performance Indicators * It should not take very long to obtain information whether about stock or a specific customer's requirements. * The program needs to be simple enough so that the primary users will soon pick up the necessary skills to use it. ...read more.


Microsoft Excel contains features that can be used in the system such as: * Ability to create a blank worksheet, which you can input data. * Ability to link 2 workbooks together. For example an order that needs to be processed and stock page can be checked together to see if any material needs to be ordered. * Ability to protect documents and workbooks from accidents such as altering formulae or deleting sections unintentionally. * Customised menus and toolbars. * Formatting to help make it clear to the user where to enter data. Worksheet Design The system will be based on two workbooks, 1 containing the stock details, and the other with the order forms. At the beginning of each workbook, there will be a chance to either open a new worksheet in which new data can be entered or to load existing data from the database. From this, the user will be able to view things such as order sheets/forms and notes on stock. The data will also be accumulated and viewed monthly and annually in order to check for things such as past orders and contact details of clients. Data Flow Diagram of proposed new system Nikki Westwood 012 1 ...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

    * DVD-ROM drive is included so CD/DVD can be played on the computer. Disadvantages * User may struggle with new software as it does not have high processing power and memory. * The windows ME operating system is for home use only, it has a lot of bugs, and may cause the computer to crash or stop working.

  2. ICT notes

    * Have regular eyesight tests. * Take regular breaks. Back/Circulation problems * Poor posture. * Sitting all day in front of a computer. * Ensure posture is correct. * Take regular breaks and walk to improve circulation. The use of ICT when Paying Staff WagesStaff at the health centre are paid using a computerised system and their wages are paid straight into their bank account.

  1. Designing a database to manage stock in a clothes shop.

    It could be to create an Access database in which I would include all of the products, the suppliers, the date of manufacture and the type of product it was. This would help the owner of the business to be more organized and can provide a better service to the

  2. System requirements analysis

    Also one of the main things that she found quickened her speed was the fact that she had an ear phone and this meant that both her hands were free to type on the computer and this really sped her up as her typing quickened and it was easier for


    All the arriving stock shall be recorded on the database. I shall also include things such as staff records and how much they're paid. Further more the students too will be included in the database and their expenses will be properly recorded.

  2. The information handling problems of MovieZone a small video rental shop in Stoke-on-Trent. The ...

    Information about each video is written down on a card that is kept inside its case. Information about each member is written down on a card. These cards are stored in a card index box in ascending order of member number.

  1. The new system is required to calculate the costs of a new car as ...

    at Mr Cruisers disposal - will prove sufficient and relatively cheap to provide for printing off templates for designing onto, e.g. a blank spreadsheet table for laying out designs onto which will be done later on in the project. * A modem and Internet connection will be required, for initial

  2. drum kit costing system

    I now have been given a list of their top selling drum kits and their prices. Also he gave me some accessories to put in as well. I will include these in my drum pricing model: Drum Kit Make Price (�)

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