• 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. ICT notes

    Keeping a record of all serial numbers on each piece of equipment and mark the health centres name and postcode on all equipment so the police can identify stolen property easily. 2. The health centre could have a security alarm system and surveillance system on the building as well as

  2. Video Rental Shop I.T. System

    Below is the spec Barry should be looking for: * A fast 1.5 to 1.7GHz Pentium 4 processor, so the computer opens etc very quickly. * 256-512 MB of RAM to make sure that programs run smoothly and so many programs can be run at ant one time.

  1. Spreadsheet Project - computer system for a video hire shop.

    Use and Implementation Relevance to design The final sheets that I have made follow the design. The following three screenshots show the three different worksheets and the original design that I created. Monthly Income Worksheet Design Date Membership No Transaction Type Video Number Cost The column 'Transaction Type' was added to the design after further discussion with end user.

  2. Creating a computer system for a video rental shop

    Advantages * Good price * 12 month warranty * Have all the essential facilitates required by the leisure centre * Ethernet card included which allows networking later on and fast transfer of data. * Intel Pentium 3 1GHz processor, this is fast possessor that can handle most applications.

  1. Creating a computer system.

    The user should be able to exit the system quickly at the click of button 10. It should be quick and easy to search for particular customer through the system In conclusion the analysis shows that a computerized system would be the best solution, so I must now look at resource requirements and what is available to me.

  2. System requirements analysis

    The monitor has a coating that is anti-static/anti-reflective and produces flicker-free images and easy viewing. The E773 monitor is designed for a wide range of users and can be used at home as well as at work. This monitor is also quite cheap, being only �79.00.

  1. Creating a computer system for a mobile phone shop.

    This would be perfect for my needs, as I need to store the customers' data, and access it quickly. I could use the software to create forms to enter the data, and then quickly create reports showing the specific information I need.

  2. Chessington Motor Centre (CMC) Information Technology System

    On the next page is an example of and invoice that would be completed by a mechanic after completing a job. Invoice Number Date Customer Name _________________________ Vehicle____________________ Part Number Description Quantity Price +VAT INVOICE TOTAL PAYMENT METHOD _________________________ SIGNED__________________________________ Invoice Number Customer Details Customer Name__________________________________ Vehicle Registration Number_______________________ Model_____________________________ Job Details Date of job (dd/mm/yy)

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