MIS - Assignment 1 - Zoho Application

CrestRider Computers:

CrestRider Computers is a dedicated retailer of AMZ laptops and has offices in Kolkata, Chennai and Bangalore. We now intend to serve our customers online via an online “Order to Cash” system. The purpose of this system is to facilitate our customers to order our products online without having to physically visit the store.

The scope of this project will include:

1.      Developing the Online Order to Cash portal with 6 tabs:

a.      A “New Customer Registration” tab for new customers

b.      A “View configurations” tab

c.       A “Place Order” tab so that customers can order the laptops they desire.

d.      A “Payment” tab.

e.      An “Order History” tab so that customers can view the orders they have already placed.

f.        An Inventory Manager tab

2.      The details of the individual tabs are as follows:

a.      “New Customer Registration” tab:

A customer should be able to register himself on this online application by entering the following details on the registration page:

i.                    First Name(mandatory)        -> Text field

ii.                  Middle Name                         -> Text field                                   

iii.                Last Name(mandatory)        -> Text field

iv.                 Gender                                    -> Radio Buttons

v.                   Date of Birth                           -> Calendar control popup

vi.                 Address                                    -> Multi line text box   

vii.               Mobile phone number          -> Number field (limit to 10 digits)  

viii.             Email address                          -> Email field

ix.                 Zoho id                                     -> Email field

                    The “New Customer Registration” tab should have a “Register” button which completes the registration process and a “Reset” button which resets the form.

               For each new customer registration a unique customer id has to be created. Since the application will be hosted on “Zoho” , it is assumed that each user will have a pre-existing user id. This piece of information must be highlighted on the registration form.

Once the customer clicks on the “Register button”, an email will be sent to the customer notifying him of his registration details as well as his/her unique customer id.

b.      “View configurations” tab:

This tab should contain the details of the 3 standard AMZ laptop configurations that we offer the customer.

The details are:

i.                    AMZ 101 -> 4GB RAM, 500 GB HD, Preloaded Windows 7 Home Basic OS   -> Price = Rs. 30000

ii.                  AMZ 201 -> 4GB RAM, 750 GB HD, Preloaded Windows 7 Home Basic OS, Microsoft Office 2010 Basic -> Price = Rs. 35000

iii.                AMZ 301 -> 6GB RAM, 1 TB HD, Preloaded Windows 7 Office OS, Microsoft Office 2010  -> Price = Rs. 45000

c.       “Place Order” tab:

This tab should allow the customer to select the desired laptop model(s) and the quantity of each of model. The price of each model should be displayed when the customer selects the particular model.

The total cost of the “Purchase Order” should also be displayed.

The “Place Order” tab must contain the following fields:

i.                    Laptop Order 1 Label for a dropdown listing the 3 models of laptops available.

ii.                  A “Price per unit” field below the “Laptop Order 1” dropdown list which states the unit cost of the selected model.

iii.                A “Quantity” field below the “”Price per unit” field

iv.                 A “Total cost of Laptop Order 1” field below the “Quantity field” which displays the total cost of the first order

v.                   Repeat steps i. To iv. For “Laptop Order 2” and “Laptop Order 3”

vi.                 Below the “Total cost of Laptop Order 3” field, there should a “Consolidated Cost” field which displays the grand total of the customer order.
vii.       The inventory count should be automatically tracked and updated,

viii.               Below the “Consolidated Cost” field, there should be a “customer id” field. The customer should enter his unique customer code in this field.

ix.             The customer should be able to place his order only if the customer id he enters matches the unique id assigned to him.

x.                 Once the order is placed, the customer should be directed to the payment screen.

d.      “Payment” tab:

i.                    The customer should have the option to pay by Cheque, Demand Draft or credit card. Use a dropdown/radio button as deemed appropriate.

ii.                  The customer has to key in the “Bank Name”, “Bank Account Number” and the “Cheque number” if he is paying by cheque.(all mandatory)

iii.                The customer has to key in the “Issuing Bank Branch Name”, “Target Bank Branch Name” and “Demand Draft Number” if he is paying by Demand Draft. (all mandatory)

iv.                 The customer needs to select the “Bank Name” a dropdown list -> HDFC or ICICI and enter his credit card number and the 3 digit number behind the credit card if he chooses to pay by credit card. (all mandatory)

v.                   Selecting at least one of the 3 modes of payment should be made mandatory.

vi.                 After the payment has been made, an invoice should be sent to the customer’s email id and the details of the “Purchase Order” should be visible in the Order History tab.

e.      “Order History” tab:

The customer should be able to view a summary of the list of orders placed by him and the current status -> whether the product is yet to be delivered or has been delivered successfully.

f.        “Inventory Manager” tab:

i.                    This tab should be visible only to the system administrator.

ii.                  The system administrator should have the option of adding new laptop model configurations in future, add or remove existing laptop models.

iii.                The system should be scalable i.e. in future, if we add more than 3 models to our inventory, the relevant details should reflect in all the related tabs.

iv.                 The system administrator should be able to alter the prices of the laptop models as well as update the laptop inventory count for each model.

3.      Documentation:

Kindly furnish all the necessary documentation along with the project.

4.      Timeline:

15^th September 2012.