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

Introduction

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.

Middle

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.

Conclusion

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

    * Poor lighting, glare from the screen, flickering screen. * Use a screen filter to reduce glare and keep your eyes at least 18 inches away from the screen. * Ensure appropriate lighting. * Have regular eyesight tests. * Take regular breaks.

  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

    and also this saves the doctor time so that they can see as many patients as they can in a day. The receptionist sends this information to the doctor via an e-mail system in which the doctor has access to very easily.

  1. COMPUTERISING HIGHLANDERS BAKERY 1.1 DESCRIPTION OF THE PROBLEM Highlander's bakery is ...

    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 ...

    Thank you for taking the time to complete it. Please hand it in to receive your free rental voucher (one per customer only). Interview questions Sample documents Problem Description This project will aim to solve the information handling problems of MovieZone Video a video rental service based in Kidsgrove, Stoke-on-Trent.

  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