Created by Prof. Al Bento, University of Baltimore. Version 2.1 - January 2002.
VOICE's business was originally to sell electronic components, from which it derives its name: Volume Integrated Circuits Express. Presently VOICE is focused on selling computer products by mail. Its catalog includes items like DOS and Windows software, hardware add-on, and PCs. VOICE used to sell products by mail only. But computers and software change so fast that VOICE decided to develop an automated phone order system to receive and process orders and hired you to do the job.
You had the lowest bid, because you do not have that much experience in developing systems, and consequently won the contract. What follows are the results of interviews with VOICE management and other personnel.
If the customer decides to order the product, the sales representative assigns a customer number and enters the customer name, address, phone number, credit card number, date, item(s) number, description(s), quantity, unit price, shipping&handling, and totals into a request form. The ideal system would then transcribe this information to a customer file and a sales order file, and update the list (or file) of product quantity on-hand. Repeat customers should be able to either give their names or customer number and provide only changes to their existing information with VOICE. Repeat customers are key to VOICE's competitive ability because the cost of obtaining a new customer is twice that of maintaining existing customers. Obtaining credit-card approval of the customer charge to pay for the order is to be done after the order is entered.
VOICE's management would like to receive a daily summary sales report by product and a daily exception stockout report, both listing the product number, product description, unit price, quantity and total. They mentioned that percentages should be included. The first report if for them to know how much they are selling, and the second for them to know how much they may be losing on sales.
Given your limited experience with developing systems you secured the advice of Dr. Alben (a nationally recognized expert ) to be sure that you can do the job well. Dr. Alben advised you to:
|Catalog Number||description||unit price||QTY |
|14002||Paradox Win 8||135.67||35||17||30||25|
|14003||Norton System Works||59.96||20||10||15||12|
|23001||AMD Athlon PC||980.00||30||20||20||20|
|23002||Pentium III PC||1,538.00||60||30||40||30|
|23003||Pentium IV PC||2,459.00||30||20||20||17|
|31001||128 MB SDRAM||40.00||100||40||55||40|
|31002||256 MB SDRAM||70.00||80||30||45||30|
|53001||HD 40 GB||59.00||50||20||35||25|
|53002||HD 80 GB||89.00||50||20||35||25|
|E1237789||Smith||John S.||13 Monroe St.|
Tolltale, AL 32077
|A3247209||Lewis||Belle M.||256 Jones St.|
Laerne, CA 91000
|G9912567||Faria||Peter N.||780 Peace Blvd.|
Kyaville, LA 45120
|B5674320||Curtiss||Tony G.||1 Happy Ave.|
Heaven, CA 91006
|M0052713||Britt||Anne M.||1277 !st Ave.|
Nearby, MD 21004
|Order #||Date||Cust. Number||Cat. Number||Quantity|
Note: assume that when stock-out occurs the sales representative enters another order, in the next day, for the quantity available of the product, after talking with the customer.
This page is maintained by Al Bento who can be reached at abento@UBmail.ubalt.edu This page was last updated on January 12, 2002. Although we will attempt to keep this information accurate, we can not guarantee the accuracy of the information provided.