1 Attachment(s)
how much would you do this project for?
Can anyone give a ballpark figure as to how much this project is worth?
It's an order entry program for a mail-order apparel company that the in-house customer service reps (CSR's) will be using over the phone to take orders with. It will be written in VB with a MS Access backend. The db will be stored on a central server with 5 clients each running their own executable that accesses this db.
It should take care of all ordering details for the company including the ability for the CSR's to collect customer data and add/edit/delete items to/from invoices.
The invoice itself should be an OLE object that links to a Word document which, in turn, links to an Excel worksheet that does all the mathematical computations. (This should all be automated behind-the-scenes so the CSR doesn't have to see this.) The invoices should be saved for later retrieval/editing.
Each customer can have several contacts, and their information (shipping and billing addresses), if they're already in the database, should be autocompleted when the CSR goes to enter an order. At the conclusion of the order, the invoices are to be printed so that they can be faxed to the customer.
There are special Packs that must be dealt with. They allow to customer to buy a specific group of items at a discount.
Below is a more thorough RFP, and attached is a sample invoice.jpg if you want to look at it. The items will have to fit the layout of this invoice. We estimate this program will probably require around 10,000 lines of code. You will have 5-7 weeks to code and then an additional 1-2 weeks for debugging and testing.
Thanks, and if you have any questions, don't hesitate to email me.
Greg
[email protected]
Order Entry Program
Needs
This interface will need to collect, store, and retrieve customer data. An invoice numbering system, will need to be used (each customer order must be assigned an invoice number that our accounting system, Quickbooks, will use as well). After an order is completed in the interface, the order must be printed out and the data must be saved in the database (all information from the order).
When the interface is run, the program should start by allowing the user to:
· Place an Order
· View Recent Orders
· Edit an Existing Order
· Add/Edit/Remove Items from the Order Entry Interface
When a customer service representative (CSR) is ready to enter an order, the interface should prompt the CSR for information about the customer placing the order. The program should be designed for a CSR to enter an order with a customer on the phone.
The interface must prompt for:
Organization
Contact Name
Note: For future orders from the same organization, once the organization name has been entered, a contact name drop down list should be available. Once the name and organization is filled in, the information/data should auto-fill in from the their last order.
Billing Address (including street address, city, state, and zip in different fields)
Shipping Address (including street address, city, state, and zip in different fields)
- Shipping address must be a physical address- no PO boxes b/c we ship UPS
Day Time Phone (prompt with three separate fields- area code w/ 3 numeric characters, prefix w/ 3 numeric character, and last 4 numeric characters)
Evening Phone (prompt with three separate fields- area code w/ 3 numeric characters, prefix w/ 3 numeric character, and last 4 numeric characters)
Organization Phone Number (prompt with three separate fields- area code w/ 3 numeric characters, prefix w/ 3 numeric character, and last 4 numeric characters)
Fax Number (prompt with three separate fields- area code w/ 3 numeric characters, prefix w/ 3 numeric character, and last 4 numeric characters)
Email Address (make sure that it follows *(a7*.com (or .cc or .tv) for proper syntax
Payment Method
- Purchase Order (must then prompt for the PO # and name of person directly responsible for paying the bill on the account- i.e. bookkeeper's name and phone number)
- Prepay w/ Credit Card (must then prompt for card #, exp date, name on card and billing address of card holder)
- Prepay w/ Check, Money Order, or Cashier's Check
Sales Tax Exempt Number (if applicable) when resident living in Florida
- Must test against field already entered above in "state" field in the address CSR's initials (3 alpha character in capital letters)
How order is being taken (phone, off a fax, mailed in order, emailed order, shopping cart order- make a drop down list)
Need date on order - specific date format (month/day/year)
Shipping method - Options for shipping:
UPS Ground (regular shipping- noted in catalog) UPS 2 day (regular shipping price + $20)
UPS Next day (regular shipping price + $25)
Once all the pertinent information has been gathered about the customer, the interface should move to entering the products that the customer desires to purchase. This part of the program will deal with the products listed in our 2001 catalog. The interface must allow the user to choose all the attributes of the selected products. These attributes include, but are not limited to, quantity, size, color (may have multiple color selections for 1 product), etc. The products that are available in different sizes must be entered (and displayed on the invoice) in a horizontal table format where quantities for each size are listed across the invoice instead in a vertical format. All of the attributes for a product must be displayed on the invoice for future reference in an easy to read format.
When entering products to be purchased, the CSR must be prompted in an "illegal" quantity is ordered- as stated in the catalog, there are minimum quantities for many products. The user must be notified of the error and given a chance to reenter a "legal" amount to be ordered. An override option should be available.
The prices, as stated in the catalog, must be stored with the data for the products. The prices need to be printed on the invoice. At times, prices need to be adjusted for the products. The CSR needs to be given the ability to adjust the price of the product after the product has been entered.
As the order is input, product by product, the CSR must be able to see the order in progress to be able to refer back to what has been ordered so far.
As the order is entered, the shipping and handling needs to be update after each item/product is entered (determined via our table in the catalog). If the method of shipping is "Overnight" or "2-day", please add $25 and $20 respectively to the normal shipping price noted in the catalog. Also, product subtotal (b/f shipping, taxes, etc.), the sales tax (Florida customers are not-taxable only if customer has a valid sales tax id number and is paying with a school check- paying with a booster club check makes them taxable) and the Grand Total must be updated after each product is entered.
Special entry dilemma: In the catalog, we offer special Packs which allow the customer to order a group of products at a discount. The order entry process for these Pack's must prompt the CSR to enter all the products within a given Pack.
Ex. A customer wants to order 3 shirts and 3 shorts. For this Pack, the CSR needs to enter all 3 shirts and all 3 shorts before they can move onto the next product. The number of shirts and shorts will be the same for the 3 sets of clothes. This needs to be checked when the CSR enters the quantities in each size.
how much would YOU charge
If YOU were to bid on this, how much would you charge? I'm just trying to get a ballpark figure.
Thanks