Fermé

Inventory & Proposal

We wish to develop inventory + proposal software to pick, reserve, or replenish inventory from 4 warehouses, including part number, part name, weight and dimensions, and generate parts quotes for clients (from a client list) on a letterhead template, integrating logistics API's if possible to add freight to quotes. The client's previous orders should be accessible from search to check the last price sold.

RFP 92215 INVENTORY AND PROPOSAL MANAGEMENT SYSTEM

Summary:
We have an international business based in the US which is manufacturing and distributing equipment to the wastewater treatment market. We maintain stock in NL, UAE, KR, India and USA, and we have clients worldwide. Presently we employ 4 people in inside sales based in the US, plus people who do inside sales work at remote locations. We currently keep track of inventory manually on an Excel spreadsheet, and we categorize stock by part number, warehouse location, and in-stock (+), en route, and deficit (-). We currently write proposals from an email client, from a previous proposal in MS Word or from a blank sheet of e-letterhead in MS Word, and we manually enter the quantities, prices and tally the totals, then manually calculate weights and dimensions. Based on those values and the client location, we determine whether to ship via UPS, truck, air freight or ocean freight, and then we price accordingly, and manually add that to the proposal. Then we prepare an email, and attach the proposal together with supporting documents like product data sheets. All of this is done internally. European clients have limited access to inventory reports in Europe but not to other warehouses and other clients located elsewhere in the world do not.

Note: A non-disclosure agreement is required to accept this work.

Scope of Work:

Develop a web-based proposal and inventory tool with strong page-by-page security containing the following:

Prepare a database with the ability to enter the following fields:
Item #
Part #
Quantity in stock
Quantity in transit
Arrival date of quantity in transit
Quantity reserved from stock and in-transit
Product Description
Unit List Price




Prepare a GUI with the following pages:
User login with password
Administrative login with password
Administrative settings page with the following links:
Users (Administrator, Rep or Agent), Roles (discount codes from list price which may be a fixed discount, or a discount against a curve, just for one possible example 20% off a $500 order, 50% off a $100,000 order and a curve in between, location of customer, payment terms)
Counters (closure rate, usage tracking and pricing/total sales reports through this system)
Clients (End User – A User can sell to a Client, for example)
Input Container (incoming shipments entry, with targeted arrival date, model numbers, quantities and warehouse location)
Input New Items with auto-assigned item #, enter part #, description, unit list price, and initial in-stock, en-route and reserved inventory levels, weights and box dimensions, ideal stock quantity, alarm%)
Input part number or description, quantity, and client name and address (for all users). Multiple items can be priced or ordered at once. Offer warehouse choices from which to draw stock, possibly more than one, with check boxes. Pricing should be auto-generated for regular users, but for administrative users, offer the ability to modify the price.
Offer a button for a regular user to “Place order”


Algorithms and Functions:
Determine appropriate shipping method by weight and shipping volume.
Call API for appropriate freight estimate, where appropriate, in which case return price FOB Jobsite. Where a freight estimate is not possible, i.e. for big shipments or international shipments, quote FOB Factory.
Match required quantity of each part number by user to the available inventory. If there is enough inventory return ex-stock. If there is sufficient inventory for a partial shipment, return that quantity with a leadtime for the balance. If the balance is en-route, refer to the input arrival date and return that value for the balance. If the balance is not yet en-route, return 8-10 weeks, typically. Typically stock is requested within a geographical region, for example NL serves Europe, UAE serves MENA, India serves India only, USA serves N. and S. America, and Korea serves Asia (Korea also has a quicker build than 8-10 weeks for Asian shipments). It would be appropriate to offer stock from another location sometimes, for example if NL has stock but UAE does not, some clients in MENA will take from NL. Likewise if USA has stock but NL does not, some European clients will take from USA. But this should be optional.

API’s:
Ups.com (box shipments, worldwide)
Freightquote.com (trucking – USA and Canada)
www.searates.com for pallet stuffing?

Output
Preview the critical parts of the proposal on – screen.
Offer the administrative user an over-ride of the auto-generated quoted price and leadtime. Let them fill in their own prices in that case.
Offer over-ride of freight option where available (yes or no) to all users, and if no, quote FOB Factory. Maybe a check box? Offer a manual input for freight in case freight was not able to be auto-generated, and if there is an input, offer FOB Jobsite. As another option, offer freight “at acutals” at time of shipment which means to you, FOB Jobiste, and on the line item which says Freight on the quote, instead of a number, list AT ACTUALS , and we will update our accounting software later.
Show estimated weights and dimensions in the proposal. Assume full box quantity for dimensions (weight will be by units). Pallets vs boxes gets more complicated. Let’s talk about this. Is there an API for this? https://www.searates.com/reference/stuffing/ Have a look here.
Offer choice of Print or Email proposal. Auto-fill quotation, freight & leadtime info into quotation template. Auto-attach the corresponding product and system data sheets & terms and conditions of sale and warranty page to proposal for email offers. Quote validity should be 30 days but adjustable by administrative users.
If the user clicked “Place order” generate an email to company and pop that quantity from stock from the desired warehouse.
If the order <=$350 not incl shipping for US customers, add $75 handling fee. For $350-750 add $50 handling fee, for US & European customers. Administrative override is available. This can be an adder on a new line item. For MENA customers, we add for 0-$500 a $150 fee , 500-$1000 a $115 fee and for 1000-$1500 a $85 fee.
If the order is by cr.card, there is a 5% cr.card processing fee. This can be included as an adder on a new line item
If the value of the proposal is more than $100,000 only an administrator can issue the proposal. Authorized users should be given a screen saying, contact factory.
An alarm function should trigger a daily or weekly email (not each incidence) to the administrator when the stock level of an item(s) drops to alarm% of ideal stock quantity for each item kept in stock with report.

Other:
A demonstration of a similar PHP application which was developed for our system quotations is available. This program has very similar administrative settings and outputs to the software package we wish to develop now.
Sample parts quote templates from past offers are also available to give you an idea what we want to auto-populate.
The current XLS inventory sheet is also available to review.

Compétences : Django, MySQL, PHP, Python, Architecture Logicielle

Voir plus : aspnet inventory tracking web site template, best api template, sample project proposal inventory system, web site api template, integrating bullhorn api, proposal inventory database, sample proposal inventory system, api template monster php, integrating godaddy api, integrating wordpress website template

Concernant l'employeur :
( 0 commentaires ) Poughkeepsie, United States

N° du projet : #8525292

44 freelance ont fait une offre moyenne de 2766 $ pour ce travail

esolzsales

Hope you are well. We have some questions? Can we discuss in details before we start? Agile model of development to have the best deliverables for your [url removed, login to view] me know if we can connect on Freelancer chat to dis Plus

3092 $ USD en 55 jours
(288 Commentaires)
9.7
kchg

Hello. I am interested in your project. I am full-stack developer and my ranking is 6th in freelancer. When i work for this project, I can make good result more than you could guess :) I hope to work with you. Bes Plus

2886 $ USD en 30 jours
(292 Commentaires)
9.0
technologyaddict

Hi, We have read the project requirements in complete detail. We have noticed that you are seeking highly skilled and expert professional personnel to develop an inventory and proposal management system. We are a Plus

2577 $ USD en 45 jours
(179 Commentaires)
8.7
meet2amitvw

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself developer so you will directly work with me. No mediators. No managers. No subcontractors. see my recent Plus

2319 $ USD en 30 jours
(124 Commentaires)
8.7
leadconcept

Hi there, I have read your project description & understand the initial high level details but wondering if you have complete requirements? Once I have complete requirements or high level list of features, then I can e Plus

3092 $ USD en 40 jours
(75 Commentaires)
8.8
hi2viv

Dear Client, As per the project requirement you are looking for a web developer to build an inventory management application. We would like to discuss further on this as we have prior experience in working on an inv Plus

3000 $ USD en 30 jours
(69 Commentaires)
8.7
A2Design

Hello, We can build you the software that you’re looking for. We've built a backend automation system for this company. [url removed, login to view] It’s a business automation system that was created to help an ente Plus

3000 $ USD en 30 jours
(58 Commentaires)
8.3
madhavdutta

Hello Dear, Hope you are doing well!! We are in the top 10 freelancer here. I have gone through your project description and I come to know that you have required inventory + proposal software to pick, reserve, Plus

4123 $ USD en 45 jours
(149 Commentaires)
8.6
buraqtech

1. Invoicing App We already designed and developed a complete online invoicing application in which currently we are handling these modules 1. Place New Order (phone order page from sample) 2. Pending Orders 3. Shi Plus

2826 $ USD en 45 jours
(97 Commentaires)
8.0
seekdeveloper

Hi, I have read your post and understood your requirement. I have great experience in handling /PHP/MySQL/Python/Django/HTML5/jQuery/Wordpress/Magento/Joomla/Drupal/AngularJS/[url removed, login to view] Plus

3092 $ USD en 30 jours
(86 Commentaires)
8.3
arhamsoftltd

Greetings, Kindly share some more details about your project , i also need to discuss the project in detail kindly inbox me so we may proceed further. I have 10 years of experience in web development and i am expert Plus

3000 $ USD en 30 jours
(86 Commentaires)
7.8
shibin123sl

Hello We went through project description very well .We are professional website design and development company operating in UK and India. We have 8 years of experience in web/mobile design and [url removed, login to view] provide Plus

2631 $ USD en 40 jours
(131 Commentaires)
7.8
JoomlaVogue

Hello Sir, First of all, we would like to tell you how we will initialize the project with you. According to your project description, our team would like to discuss with you, to get more understanding of the Plus

1649 $ USD en 17 jours
(84 Commentaires)
7.3
faizan101010

Hello, My name is Faizan and I am a PHP developer. I have seen your project requirements and I am sure I can do it. Can we discuss in detail A little bit about me: I belong to a team of 3 developers and 2 designe Plus

2368 $ USD en 30 jours
(60 Commentaires)
7.1
workspaceit

Hello, I m Tahsinul Alam, completed Masters in Software Engineering now working as one of the project manager of Workspace Infotech, software/Outsourcing firm located in Dhaka, Bangladesh. We have 13 different team Plus

2319 $ USD en 30 jours
(45 Commentaires)
7.3
pytho

Hi, I am managing a professional web agency for more than 8 years. You can check my Themeforest profile with ratings here: [url removed, login to view], as well as the marketplace I build recently for prom Plus

3064 $ USD en 33 jours
(37 Commentaires)
6.9
iDCreativeUK

Hi, Mark here, I would be interested in discussing this project with you. Thanks for the consideration, I hope to hear from you soon Thanks, Mark

2577 $ USD en 30 jours
(21 Commentaires)
6.7
iqbalsingh

Hi, Yes,i can help you to develop inventory + proposal software to be more modern as you [url removed, login to view] would be great if you can give me some time to discuss this project. We offer custom web solutions based on PHP/co Plus

2736 $ USD en 55 jours
(48 Commentaires)
6.9
eclipsetechno

Hi, since I have experience in much big projects in ERP domain thus, Inventory business logic, I can describe in my own words as follows: 1. The warehouse management system ( WMS) have a production department, w Plus

2631 $ USD en 30 jours
(22 Commentaires)
6.7
Hariomtechnology

Hello, We are one of the best programming team on freelancer. We have more than 104+ Client Reviews (Feedbacks). Please check our profile here: [url removed, login to view] Please see som Plus

1611 $ USD en 20 jours
(71 Commentaires)
6.9