Recently a small "Young Enterprise" group has set up a Sweet Stand, which sells a variety of sweets and soft drinks. The staff working at this Sweet Stand are Dave Currall (The Manager), Natalia Gelder (Assistant Manager).

Method of collecting data

 

Information collected

• Items sold
• No. in Stock of stock
• Supplier
• What the supplier suppliers/ what item(s)
• Sell-by-date
• Re-order level of items

Method Used

• Items sold - The staff count the items and write all the stock items onto a list. So when an item is sold, the staff will write down what has been sold.
• No. in Stock of stock - The staff will count how much stock of each item they have, and write it down on paper.
• Supplier - The staff would contact the supplier and retrieve the information they need to know on what the supplier supplies.
• What the supplier supplies/ what item(s) - The staff would contact the supplier and find out what stock the supplier has via telephone, letter, etc.
• Sell-by-date - each box of items shall have the same sell-by-date so the staff can write down the sell-by-date for that box and keep up to date with the items.
• Re-order level of items - levels of items need to be monitored manually to see what items run out of stock quickly, and some items which don't sell very much. This way different levels are aquired for each item.

Suggested Alternatives

Alternative solutions shall improve the Sweet Stand; these should be improving the capture of the records by inserting them into a database so that they are kept safe. It should be able to identify when an item should need to be recorded. Also, it will control the No. in Stock of each item. Also it will be able to identify which item has come from which supplier. Also, these orders will be prepared when an item needs to be reordered.

Inputs, Processing and Outputs required

 

Detail of inputs, processing and outputs

Suggested System Specification

---

Design

Data Structure

Alternative to the Basic

Justify choice of data structure

2. User interface

3. Output Formats

---

4. Software and Hardware requirements

Preferred Software and Hardware

Implementation

1.

2.

3.