Stock Management System Software Requirements Specification (SRS) Project by Kunal Apurva (12ESKS!2") Avinas# Rai (12ESKS!1$) %autam Kumar (2ESKS!21) IV SEM (CS II SHIFT)
S&'*E+ *,SS. /+0 A/
Index 1. Introduction 1.1.
System objectives and overall description
1.2.
System boundaries
1.2.1. System context 1.2.2. System constraints and assumptions 2. Functional requirements 3. Non-functional quality requirements . Future requirements !. "ppendices !.1 #ontext dia$ram !.2 %ntity-&elations'ip dia$ram !.3 (ata Flo) dia$ram !. *oal dia$ram !.! Sales "nalysis dia$ram !.+ Sales "nalysis model
1. Introduction ,'ere are supermarets suppliers and )are'ouse mana$ers in t'e system. ,'e company 'as !// supermarets and a bi$ )are'ouse.
"bout /// items are stored in t'e
)are'ouse. %ac' item is provided from exactly one supplier.
1.1. System Objectives and Overall Description
1.1.1. ,'e Stoc 0ana$ement System S0S assumes control over t'e booeepin$ and accountin$ needed to operate a are'ouse for a company speciali4in$ in retail sales of food and $roceries. "ll day-to-day operations of t'e )are'ouse as )ell as conducted )eely accountin$ of t'e products stored in t'e )are'ouse and disbursed to participatin$ supermarets )ill be performed by t'e soft)are. 1.1.2. " considerable amount of accountin$ needed to operate a typical )are'ouse calls for a reliable and fast soft)are tool to 'elp t'e )are'ouse mana$ement 'andle flo)s of information re$ardin$ incomin$ and out$oin$ quantities of products and a stoc inventory. 1.1.3. ,'e problem of stora$e of t'e accountin$ documents suc' as invoices and orders )ould be solved. 1.1.. ,edious arit'metic involved in t'e correspondin$ booeepin$ )ill be automated. 1.1.!. " cost of maintenance of a specially trained accountin$ professional in t'e )are'ouse )ould be saved by replacin$ t'is position )it' a soft)are tool and a less costly data entry specialist.
1.2. System Boundary
1.2.1. System #ontext 1. ,'e S0S is located at central )are'ouse and eeps trac of t'e stoc level of eac' item in t'e )are'ouse orders from supermarets and orders from t'e )are'ouse to t'e suppliers. Items and product $roups and t'eir quantities in t'e )are'ouse are all part of t'e system.
2. ,'e S0S )ill provide supermaret mana$ers )it' t'e ability to enter orderin$ information directly into t'e system. 5ut it also accepts t'e order by p'one from t'e supermaret t'at doesn6t 'ave t'e connected computer system. In t'is case a data entry specialist )ill 'andle t'e paper formats of orders and invoices. 3. " convenient *7I $rap'ical user interface )ill provide users )it' t'e ability to quicly enter t'e information from t'e incomin$ orders from t'e supermarets and to output t'e invoices reflectin$ t'e out$oin$ flo) of $oods supplied to t'e supermarets. . ,o maintain t'e current level of t'e stoc inventory t'e system )ill be provided )it' easy-to-use )ays of enterin$ t'e product information suc' as names quantities purc'asin$8sales prices and stoc level. !.
(atabase of records reflectin$ eac' in and out transaction )ill be automatically maintained.
+.
,'e S0S is supposed to provide t'e )eely sales analysis report reflectin$ t'e )are'ouse operations durin$ t'e )ee in an automatic manner.
9.
" careful analysis and booeepin$ )ill be conducted re$ardin$ t'e delayed orders arisin$ from insufficient stoc levels 'appened durin$ t'e )ee.
1.2.2. System #onstraints and "ssumptions 1. ,'e S0S assumes t'at all deliveries from )are'ouse to supermarets are successfully completed so t'ere is no loss of item or delay on t'e )ay to t'e supermarets. ,'erefore any trucin$ system is beyond t'e S0S boundary. 2. ,'e S0S assumes all suppliers 'ave enou$' stocs t'erefore )'enever )are'ouse mana$er orders items t'ey can be delivered )it'in 2 'ours. 3. Specific booeepin$ and accountin$ re$ulations reflectin$ t'e current la)s and re$ulations )ill 'ave to be pro$rammed )'en updated. . ,'e system )ill require some occasional supervision of a trained accountant to verify its correctness upon t'e system update.
2. Functional Requirements 2.1. Accepting Orders from Supermarkets
2.1.1 Inormal !escri"tion 1. Supermaret 0ana$er initiates t'e processin$ of t'e order. ,'e mana$er provides orderin$ information suc' as t'e name of t'e supermaret t'e requested item t'e requested amount of t'e item and t'e date and time of orderin$. %it'er t'e supermaret mana$er eys t'e data into t'e S0S directly or 'e orders by p'one and t'e )are'ouse operator eys t'e entry into t'e S0S. 2.
,'e orders from different supermarets on eac' different item )ill be enqueued daily up until p.m. after )'ic' t'e queue )ill be processed and t'e supply of eac' item )ill be determined batc' processin$. "fter t'e p.m. t'res'old t'e queue is emptied and t'e accumulation of orders for t'e next business day commences.
2.1.2. #recondition : Supermaret mana$er is at t'e terminal and t'e )are'ouse system is in a consistent state. ,'e stoc level of t'e supermaret $oes do)n to a certain level. 2.1.3. #ostcondition: ,'e mana$er $ets t'e unique order id number in return.
2.2. Responding to Orders from Supermarkets
2.2.1. Inormal !escri"tion 1. "fter t'e batc' processin$ 'as been completed soon after p.m. on eac' business day t'e S0S s'all first process t'e delayed i.e. carried over from t'e previous days orders for eac' of t'e items orders. ,'e recent orders i.e. ones from current day )ill be serviced next. 2. No) t'at t'e order 'as been received t'e system responds to it and decides 'o) muc' stuff t'e supermaret )ill $et. For eac' item for )'ic' any quantity 'as been ordered by any supermaret t'e S0S c'ecs t'e amount of available items versus t'e sum of t'e amounts in t'e orders.
3. If t'ere is enou$' in t'e )are'ouse to complete all orders t'en t'ey )ill all be filled t'e $oods sent t'e supermarets billed and t'e amount in stoc )ill be reduced by t'e amount sent. . If t'ere is not enou$' stoc t'en t'e delayed orders are filled proportionately to t'e amounts desired. ,'e remainders for eac' order s'all t'ereby become delayed for some or all of t'e items. !. ,'e stoc inventory is updated for eac' item to reflect t'e ne) quantities t'at remain. " record is ept of t'e state of eac' order for eac' item. +. "n invoice s'all be $enerated to reflect t'e Item "mount (estination and (ate of s'ippin$ for eac' order. 2.2.2. #recondition : ,'e batc' job starts at :// ;.0. and t'e item order id amounts and order date and time are correct. 2.2.3. #ostcondition : ,'e $oods are t'en sent t'e supermarets billed and t'e amount in stoc and requested by t'e supermaret is reduced by t'e amount sent.
2.. !etting Supermarkets Billed
2.3.1. Inormal !escri"tion : 1. ,'e supermaret is billed for $oods rendered. 2.3.2. #recondition : " supermaret
2.". Sending !oods to Supermarket #outside System$
2..1. Inormal !escri"tion 1. ;ut t'e items in t'e mail or on t'e truc to be s'ipped to t'e maret. 2..2. #recondition$ ,'ere are enou$' of t'e appropriate $oods in t'e )are'ouse.
2..3. #ostcondition : ,'e $oods are no lon$er in t'e )are'ouse but are on t'eir )ay to t'e supermaret. ,'ey are assumed to eventually arrive.
2.%. Ordering from Suppliers
2.!.1. Inormal !escri"tion 1. 7pon processin$ all orders t'e system c'ecs t'e stoc inventory. For eac' item if t'e remainin$ quantity is less t'an 1// items i.e. may be from / to 1// an order is sent to t'e correspondin$ supplier for 1/// units of t'e item. 2. If t'ere is none of an item and t'e supermarets 'ave requested some additionally request t'e number for )'ic' t'e supermarets 'ave ased. 2.!.2. #recondition : It is just after !:// ;.0. after completin$ all on a )eeday and t'e item bein$ ordered is already in t'e system. 2.!.3. #ostcondition: &estoc t'e supermaret s'elves )it' t'e appropriate items.
2.&. Receiving 'ayment
2.+.1. Inormal !escri"tion 1. *et a payment from t'e supermaret mana$er on duty. 2.+.2. #recondition$ ,'e supermaret o)es at least as muc' money as t'e payment amount. 2.+.3. #ostcondition$ ,'e amount t'e supermaret o)es 'as been decreased by t'e amount of payment.
2.(. 'aying Suppliers
2.9.1. Inormal !escri"tion 1. *ive a timely payment to t'e suppliers )'o )ould be really 'appy to 'ave t'e money. 2.9.2 #recondition$ ,'e )are'ouse o)es t'e supplier money.
2.9.3. #ostcondition$ ,'e supplier 'as accepted t'e payment. ,'e )are'ouse no) o)es t'e supplier t'e amount less money.
2.). 'rocessing Deliveries from Suppliers
2.=.1. Informal (escription 1. Items from t'e supplier on a truc 'ave arrived at t'e )are'ouse.
Some
booeepin$ needs to be done. 2.
,'e supplier is responsible for providin$ t'e information suc' as name of supplier delivered item amount date and time of s'ippin$ from t'e delivery slip into t'e S0S system.
3. ,'e delivery slips are put into a )aitin$ queue in order to be processed at p.m. on eac' business day. "fter t'e pm t'res'old t'e queue is emptied and t'e accumulation of orders for t'e next business day commences. . ,'e stoc inventory is updated to reflect t'e incomin$ amounts of all t'e items. 2.=.2. #recondition$ ,'e delivery slip 'as arrived. ,'e supplier and t'e item 'ave been entered into t'e system. 2.=.3. #ostcondition$ ,'e stoc of t'e item 'as been increased by t'e appropriate amount.
,'e amount in question 'as been added to )'at t'e )are'ouse o)es t'e
supplier.
2.*. +onducting a Daily Sales Analysis
2.>.1 Inormal !escri"tion 1. ,'e system starts )it' t'e number delayed yesterday and subtracts t'e number of delayed orders t'at 'ave been processed. ,'en it adds t'e number of ne) orders t'is day and subtracts off t'e number of non-delayed orders processed. ,'is $ives t'e ne) daily number of orders processed.
2. ,'e system $ives t'e output in ro)s and columns accordin$ to accountin$ re$ulations. For eac' supplier it outputs t'e amount due to t'at supplier. For eac' supermaret t'e amount it o)es is $iven too. 2.>.2. #recondition$ It is t'e end of t'e )orin$ day at !:// ;.0. 2.>.3. #ostcondition : ,'e )are'ouse mana$er can see t'e sales analysis report of t'e previous business day in t'e mornin$.
2.1,. +onducting a -eekly Sales Analysis
2.1/.1. Inormal !escri"tion 1. ,'e S0S s'all $enerate a )eely sales analysis report t'at s'all contain t'e follo)in$ information: •
,otal amount of delayed orders from previous sales analysis
•
,otal amount of orders received durin$ t'is )ee from supermarets
•
,otal amount of delayed orders processed t'is )ee
•
,otal amount of non-delayed orders processed t'is )ee
•
,otal amount of orders currently delayed.
2. Sets t'e number delayed for t'e )ee equal to t'e number delayed at t'e end of t'e last )ee minus t'e sum of t'e numbers of delayed orders processed plus t'e ne) orders t'is day minus t'e sum of t'e number of orders processed daily. 3. ?utputs all of t'ese numbers for t'e day and for t'e )ee neatly in ro)s and columns accordin$ to day and $ives t'e sums in t'e ri$'t places. 2.1/.2. #recondition$ It is Friday ni$'t after completin$ t'e daily sales analysis for Friday. ,'ere 'ave been no problems )it' t'e daily sales reports for t'e last )ee. 2.1/.3. #ostcondition$ *ives t'e )eely sales analysis for eac' of t'e five business days from 0onday until Friday.
3. Non-functional @uality &equirements .1. sability
1. are'ouse mana$ers s'ould be able to order and vie) t'e levels of any stoc in t'e system at any time t'rou$' a *rap'ical 7ser Interface. ,'e *rap'ical 7ser Interface s'all conform to company standards outlined later. 2.
,'ere )ill be a separate *7I for t'e supermaret mana$ers to use. It )ill conform to t'e #ompany *rap'ical 7ser Interface Standard.
3.
,'e )are'ouse mana$ers and executive mana$ement as )ell as maretin$ personnel )ill be able to read t'e sales and reports of 'o) muc' money t'e various supermarets o)e as )ell as 'o) muc' money is o)ed to suppliers.
.
,'e #ompany *rap'ical 7ser Interface Standard states t'at t'e interface be clear uncluttered consistent and efficient. " eyboard and mouse )ill be used as numbers need to be entered into t'e system.
!.
,'ere s'ould be fe) errors and all numerical input s'ould be double-c'eced )it' t'e user. ,'e interface learnin$ curve s'ould be s'allo) and occasional users s'ould enjoy learnin$ t'e system.
.2. System 'erformance and Reliability
3.2.1. ,'e central )are'ouse system s'ould be$in its processin$ of orders at :// p.m. and finis' by !:// p.m. at least >!A of t'e time looin$ at intervals of at least t)o mont's. 3.2.2. ?rders from t'e supermaret to t'e central )are'ouse )ill arrive )it'in one 'our >=A of t'e time looin$ at any interval of at least one mont'. 3.2.3 ,'e supermaret systems s'ould run )it' 182/ second response times on systems )it' state-of-t'e-art as of 1 year a$o B1!// destops. 3.2.. ,'e central system s'ould meet all its requirements on a server costin$ less t'an B2//// dollars 1 year a$o.
3.2.!. ,'e system s'ould not use more t'an double an absolute lo)er bound on its band)idt' consumption. 3.2.+. ,'e mean time bet)een failures of t'e system s'all be no more t'an once every 1//// 'ours. Failure of t'is means a system cras' or more t'an 'alf of t'e data is corrupted. 3.2.9. ,'e mean time bet)een failures of t'e individual supermaret systems s'all be no more t'an once every 1/// 'ours. Failure of t'is means a blan screen ernel panic free4in$ up but not )eb bro)ser cras'es.
.. System Scalability and /odifiability
3.3.1. ,'e company s'ould be able to double t'e si4e of its operations )it'out seriously affectin$ t'e response time of t'e system. 3.3.2. ,'e system s'all be very extensible: t'at is it s'ould be able to become real-time and it s'ould be implemented in a type-safe lan$ua$e )it' modern pro$rammin$ principles and practices and s'ould be as extensible and modifiable as possible.
.". 'ortability
,'e system )ill be portable to t'e various 'ard)are platforms it needs to run on includin$ Cinux indo)s N, and 0ac?S. ,'e system s'ould be easily portable to ;alm?S.
. Future &equirements .1. ,'e S0S )ill need to support t'e estimation of economic orderin$ quantity and time from suppliers. ,'erefore it )ill 'elp to minimi4e t'e cost of 'oldin$ items in t'e )are'ouse. .2. ,'e S0S )ill need to support real time stoc eepin$. .3. ,'e S0S )ill need to support ur$ent delivery requests from supermarets.
!. "ppendices %.1. System +onte0t diagram
Managers
Sales Analyses
Order Supermarkets Invoice
SMS 0
Order Suppliers Delivery Slip
%.2. ntity Relationsip Diagram !ame
Product group Order Date
Delivery Date
Processing Status
Order Date
Amount
supply Date
Amount
Belong to Processing Status Item
Ordered by
Supermarket
!ame
Address
Entity
Attribute
Relation
Sales Price
Pone#
Supplied by
Stock level Item !ame
Supplier
Purcasing Price
"uantity
!ame
Address
Pone#
%.. Data 3lo4 Diagram
Supermarket Manager
Supplier
Order$ market% item% amount% date% time% order id
payment$ item% order id% amo unt
delivery sli p$ item% &uantity% due% date% time% id
'pdated Stock Inventories
Initial Stock Inventories
Ordering System
Delayed Order Processing
Amoun t O)ed to Eac Supplier
Orders Delayed
Amoun t O)ed by Eac Supermarket
Orders Received
!ormal Order Processing
Delayed Orders Processed
!on(delayed Orders Processed
Daily Sales Report
*eekly Sales Report
Invoice to Super market$ item% &uantity% amount% supplier% s ipping
Supermarket
%.%. !oal Diagram ?rder Supplies
;rocess *ranted
Store (elayed
;rocess 5atc'
#alculate (elayed #alculate *ranted
#alculate ?rders
;rocess (elayed ?rders
Store (elayed &etrieve (aily
#alculate (eliveries
"naly4e (elivery Slips
;rocess Ne) ?rders
#alculate Stoc-
&etrieve ;revious
7pdate (eliveries
;rocess Sales "nalysis
#alculate (aily Sum
#alculate Ne) 3ee-ly
&etrieve ;revious 3ee-ly
Store Ne) 3ee-ly
%.&. Sales Analysis /odel
!.+.1. ,'e S0S is supposed to provide t'e )eely sales analysis report for )are'ouse mana$ers every Friday after closin$ daily data $at'erin$. !.+.2. ,'e business 'ours of t'e )are'ouse are from >am to !pm but all supermarets are open 2 'ours a day 3+! days a year. !.+.3. (efinition of sales analysis items !.+.3.1. ,otal available amount of eac' item ,'e S0S $enerates t'e total available amount of an item by addin$ t'e total remainin$ amount of t'e item at previous business day plus t'e total amount delivered by suppliers for eac' item every day at p.m. ,otal amount delivered by suppliers for eac' day is defined as amount of an item for )'ic' )are'ouse 'as received t'e delivery slip from t'e supplier t'is day before p.m. For example t'e amount delivered on Dune 1st is equal to total amount on t'e delivery slips S0S received from 0ay 31 ://:/1 p.m. to Dune 1 ://:// p.m. !.+.3.2. ,'e amount of orders received today Supermaret mana$ers can order items at any time t'ey )ant but only orders placed before pm everyday )ill be treated an order occurrin$ on eac' specific day. In ot'er )ords t'e amount of orders from supermarets on Dune 1st is actually t'e orders placed from 0ay 31 ://:/1pm to Dune 1 ://://pm. !.+.3.3. ,'e amount of delayed orders at t'e sales analysis on t'e previous business day ,'e S0S assi$ns t'e amount of items to t'e correspondin$ orders every pm from 0onday to Friday. "t t'is point if t'e stoc level of t'e requested item is not sufficient to serve all of t'e orders t'e remainin$ quantity is parcelled out bet)een t'e orders proportionally to t'e quantities desired. If t'e total amount of orders minus t'e total assi$ned amount is $reater t'an 4ero t'is amount is defined as t'e total delayed amount of orders for t'e next business day.
-e amount o+ delayed orders at te sales analysis on te previous business day
-e amount o+ orders received today
-e amount o+ delayed
-e amount o+ delayed
orders processed today
orders not processed today
-e amount o+ non(delayed orders processed today
-e amount o+ non(delayed orders not processed today
At te beginning o+ te ne,t business day -otal amount o+ orders currently delayed
!.+.3.. ,'e amount of delayed orders processed today ,'e amount of items )'ic' assi$ned to process !.3.3.3 today !.+.3.!. ,'e amount of non-delayed orders processed today ,'e amount of items )'ic' assi$ned to process !.3.3.2 today ?nly )'en !.+.3.3 equals !.+.3. !.+.3.! can be $reater t'an 4ero. In ot'er )ords delayed orders must be processed before ne) ones. !.+.3.+. ,'e amount of delayed orders not processed today (efined by !.+.3.3 less !.+.3. !.+.3.9. ,'e amount of non-delayed orders not processed today (efined by !.+.3.2 less !.+.3. !.+.3.=. ,otal amount of currently delayed (efined by !.+.3.+ plus !.+.3.9
!.+.. %vent-&esponse 0odel "$ent
%vent
&esponse
Supermarets
;lace orders
,otal amounts of orders received today 8 Increase
are'ouse
(eliver orders
,otal amounts of delayed orders processed today 8 Increase
are'ouse
(eliver orders
,otal amounts of non-delayed orders processed today 8 Increase
Suppliers
(eliver orders
,otal available amounts of items 8 Increase
!.+.!. ,'e )eely sales analysis report )ill include t'e follo)in$ information !.+.!.1. ,otal amount of delayed orders at previous sale analysis ,otal amount of orders )'ic' could not be served at pm on t'e last Friday. !.+.!.2. ,otal amount of orders received t'is )ee from supermarets ,'e sum of amount of orders received durin$ eac' day from 0onday to Friday of t'is )ee. !.+.!.3.
,otal amount of delayed orders processed t'is )ee
,'e sum of amount of delayed orders processed durin$ eac' day from 0onday to Friday of t'is )ee. !.+.!..
,otal amount of non-delayed orders processed t'is )ee
,'e sum of amount of non-delayed orders processed durin$ eac' day from 0onday to Friday of t'is )ee. !.+.!.!.
,otal amount of orders currently delayed
E ,otal amount of orders received t'is )ee from supermarets - ,otal amount of delayed orders processed t'is )ee ,otal amount of non-delayed orders processed t'is )ee
!.+.+. Sample Sales "nalysis &eport for an item 6@6
(aily Sales "nalysis units Mon
Tue
%ed
T&r
eely Fri
Sales "nalysis
,otal available amount of
2''
1'
1''
1''
1'
1''
1''
'
2''
''
1''
2''
1''
2'
2''
2''
*'
1''
1''
'
1''
1'
''
1''
'
'
'
'
2''
1''
'
2''
''
'
'
item @
,otal amount of delayed order at t'e sales analysis on t'e previous business day ,otal amount of ?rders received today ,otal amount of delayed orders processed today ,otal amount of non-delayed orders processed today Total amount o orders currentl+ dela+ed
