I have been asked to set up an ordering system for a clothing company to hold stock records and process orders.

Authors Avatar

Design Specification

A - Requirements

I have been asked to set up an ordering system for a clothing company to hold stock records and process orders.  The system should reflect the outdoor image of the company. The company colours are blue/yellow and it has a logo, which could be used to personalise the system.

The system must be able to:

  1. Hold Information
  1. hold the details of 20 stock items including, stock code, description, price and quantity in stock
  2. hold customer details for 10 clients including full name, address and postcode, current balance and credit limit
  1. Take an Order
  1. Input name of client (check if name is on record and generate an error message if not)
  2. Input stock code for items required (check for valid code and display item and price each)
  3. Input quantity of item required (check there is sufficient stock and generate an error message if not)
  4. Repeat for up to 5 stock items
  5. Calculate the total bill for the items ordered
  6. Apply a discount of 10% for orders over £500
  7. Add VAT at 17.5% (including a way to alter this if it changes)
  8. Calculate the overall cost for the invoice (check it is within the client’s credit limit and generate an error message if not)
  9. Include a way to process or abort the order
  1. Produce an Invoice
  1. Generate an invoice from the information input in 2
  2. Print out the invoice
  3. Update the customer current balance to reflect the new order
  4. Update the stock to reflect what has been sold
  5. Clear out data from order form ready for next order
  1. Update Information
  1. Update stock quantity when new stock arrives
  2. Update customer current balance when an invoice is paid
Join now!
  1. Produce Required Output
  1. Display/print out labels for selected customers – name, address, postcode
  2. Display data about a current stock item by entering the code.
  3. Display/print out a current stock list with values
  4. Display graphs, eg Customer balances, stock quantities
  5. Display and print invoices – see 3.1

B - System functions

The main functions required are:

  1. View Stock
  2. Check Stock
  3. Print Stock
  4. Add New Stock
  5. Graph Stock Quantities
  6. View Customer
  7. Print Address Labels
  8. Take an Order
  9. Pay Invoices
  10. Graph Outstanding Balances

A button linked to a macro will be required on the menu ...

This is a preview of the whole essay