Monday, September 7, 2009

Atmakur Industries Private Limited.

Our company is a Hyderabad based company which manufactures the following FMCG goods.

a)Tooth Paste
b)Tooth brush
c)Shampoo.

The order management is not up to the mark as the business in the recent years has expanded largely.The company is not able to track the orders placed by the sales representatives.The Higher Management has decided to integrate the sales force across the regions.The following are the requirements of the application.
1)There will be broadly two users, i.e Inventory Manager(Admin) and Sales Representative.
2)Authentication is required for an end user to use the application.
3)Each user(sales representative) should be assigned a Unique ID,which can't be modified by the user , where as the rest of the details like contact number, email , address , can be modified.
4)Order Request form , accessible by the sales representatives for placing orders, which possess entries like Product,Quantity,Delivery date, Sales Representative ID,Unit Price,Total Price etc.
5)Once an order is placed successfully,it should be notified to the admin via an email.
6)The inventory status form which is non editable by the sales representatives and which is editable by the Inventory manager has details of the stock like , product,available stock,unit price,etc.
7)Provide report generations, like weekly,monthly and yearly for each product.
8)An alert should come , if the required quantity exceeds the available stock, and also an auto generated email should be send to the inventory manager.
9)Inventory manger can update the inventory stock as an when it is required.
10)An email should be send to the admin ,if the stock reaches a certain value.
11)Provide appropriate validations , like number validation,name validations, email , size limit of fields, etc.

Saturday, September 5, 2009

Big Bazaar Project

http://creator.zoho.com/sriram13888/big-bazaar-questionaire/#Form:MM_project_1_phase_2_questionaire