Sims Urd
Sims Urd
Sims Urd
This project is aimed at developing an online Sales and Inventory Management System
(SIMS) for a departmental store. This system can be used to store the details of the
inventory, update the inventory based on the sale details, produce receipts for sales,
generate sales and inventory reports periodically etc. This is one integrated system that
contains both the user component (used by salespersons, sales managers inventory
managers etc) and the admin component (used by the administrators for performing
admin level functions such as adding new items to the inventory, changing the price of an
item etc).
Following is a list of functionalities of the system. More functionality that you find
appropriate can be added to this list. And, in places where the description of functionality
is not adequate, you can make appropriate assumptions and proceed.
There are registered people in the system (sales people working in the shop, inventory
managers, admin et al). Each one of them may have some exclusive privileges (admin,
for example, could create new users to the system whereas sales people cannot).
see the status of the inventory, ie, whether a particular item is available or
not etc
search for a particular item by typing the initial letters (‘app’ for example
may bring up the item ‘apple’ in the top) or by category-wise (apple, for
example, may be looked up by going through the category ‘fruits’)
enter the items purchased by a customer and produce a bill for the same
(the bill will have a unique sale id, date, time, item/quantity/price details
etc)
cancel the produced bill, in case of error in entering the details, and
produce a new one
take back an already sold item that is not satisfactory to the customer (the
shop allows that) and produce a receipt for the same
inform the inventory manager about the items that are not available, so
that they can be stocked
inform the sales manager about any exceptions (such as an item is being
purchased, but it is not available in the system)
get help about the system on how to use the different features of the
system
see the reports from sales people about items that are not available and
need to be kept in the inventory
validate the inventory against the sales done in the previous day (whether
the items that are sold and the change in the inventory for the
corresponding items match etc)
check how many bills have been generated in the day so far
check how many bills have been cancelled so far in the day(due to wrong
entry by the sales persons)
check how many items have been returned so far in the day
check for any exception reports from the sales persons and correct it by
contacting the inventory manager
generate sales-trend graphs for each of the item (like how is apple selling in
the last one month)