Stories

Home Page

The user stories, with the tasks we thought were involved in order to implement them. In brackets are any estimates in hours that people put on them. The stories are numbered according to the priorities the customer gave them.

5) The software should be able to analyze past demands and predict amount to be reordered for any item

1. 1. Database must store historical demand data
   2. Need a module to interact with this DB and perform necessary calculations. (4 – Nitin, Vibhu)

6) When the stock falls below reorder level, calculate amount to be reordered and place the order.

1. 1. Database with a trigger. (5 – Vibhu)
   2. Identify vendor for the item by looking up DB (only one vendor for any given item).
   3. Place order, amount is calculated by module in story 5. (6 – Nitin, Vibhu)

3) Keep track of demands of various items over thelast ten weeks. This data will be used for calculating amount to be reordered.

Tasks

1. 1. Create demand database.
   2. Update it upon receipt of a requisition slip. (10 – Sukhvinder, Manish. 8 – Vibhu)

7) Shipment arrives.

• Inform any waiting departments – rejected by customer.
• Update database

1) A dept must be able to request items from the central store. There are also special orders (for emergency situations when the order is very high), but for such situations the dept does not use the software system to place his order

Need a GUI through which one can submit a requisition to the store. (done in iteration 1)

4) Vendor supplies certain items. Items come from exactly one vendor and vendors may supply items at discounted prices on bulk purchases, with at most 3 price breaks.

Tasks

• • Need to store vendor quotes at various price breaks.
  • Need to store which vendors supply which items.
  • Create a database which stores vendor quotes for different quantities purchased (3 – Vibhu)

2) Store handles the requisition slip

• • Reduce in accordance with quantity demanded the current stock of every item in the requisition form.
  • Add entire requisition slip to historical demand database

8) We need to be able to update the database for the following:

1. 1. Change which items are supplied by which vendors.
   2. Change his quoted price