Pricing Estimation tool (php & mysql)

In Progress

THIS IS A RUSH PROJECT. WE WILL NEED A FULLY FUNCTIONAL, WORKING SCRIPT BY THIS THURSDAY, OCTOBER 3RD AT 5PM EASTERN STANDARD TIME (USA).\\r\\n\\r\\nSUMMARY: \\r\\nOne of our clients needs a pricing tool so that they can provide their customers with an accurate price instantly for two separate services they currently sell (gas service and electric service). Currently they use an Excel spreadsheet with formulas to figure out the pricing when talking to a potential customer. They would like to convert this spreadsheet into an online tool that automates the price estimation process. Basically, every day they receieve updated pricing sent to them via email - the pricing is in an Excel Spreadsheet. To get pricing, the sales employees enter in customer name, address and contact info along with 6 pieces of information they get from a customer\\\'s electric bill (current rate, current invoice amount, etc). They then copy the daily pricing into the spreadsheet. The spreadsheet does some math and delivers a 1, 2 & 3 year price along with a cost savings. The spread sheet automatically updates an agreement form they have with the pricing and customer contact info. The sales employees email the contract to the customer. The customer signs and emails back. We need to automate this process for them. The gas service and electric service use different formulas, but have the same basic structure. \\r\\n\\r\\nPROJECT REQUIREMENTS:\\r\\n1) Build an online tool in PHP that will automate the pricing estimation process for this client using an existing excel spreadsheet as a template for the formula\\\'s\\r\\n\\r\\n2) The tool will need a management portal with 3 user types: sales staff and admin. Sales Staff will need the ability to login, enter in customer information and have a customer contract/agreement created automatically from the data the tool figures out. ADMINS WILL NEED THE ABILITY TO UPLOAD AN EXCEL SPREADSHEET EVERY MORNING THAT THE TOOL WILL USE AS A BASE FOR THE PRICING FORMULAS.\\r\\n\\r\\n3) The pricing tool will allow employees to login, enter in information and then show all of the following data below:\\r\\n- 1, 2 & 3 year price cost\\r\\n- Monthly profit on 1, 2 & 3 year plans\\r\\n- 1, 2 & 3 year cost savings the customer will get by switching to their service\\r\\n\\r\\n4) The tool will allow an admin user to upload new pricing to the database every morning. The script will use this pricing information as a base for figuring out the end pricing as mentioned above. IT MUST BE VERY SIMPLE AND EASY FOR THE ADMIN TO UPLOAD THE SPREADSHEET TO THE DATABASE. Every day they receive updated pricing in one excel spreadsheet that has the rates of 4 electric companies. Once the spreadsheet is uploaded, the pricing for all 4 of these electric companies should be updated. \\r\\n\\r\\n5) The tool will allow the sales staff to put in data that they get from the customer, select one of the 4 electric companies that they receive pricing from (see #4) and instantly get the pricing options described in #3. Each electric company has unique pricing. \\r\\n\\r\\n5) The tool will automatically configure a customer contract/agreement in PDF format with the customer information the sales employee entered in along with the pricing that the tool compiled. Sales staff must have the ability to click a button and send the contract/agreement to the customer via email in PDF format. \\r\\n\\r\\nWe will supply the existing excel spreadsheets used to calculate the pricing. The spreadsheet shows the formula they use to arrive at the final price. We will pay 25% to start and will not pay the remaining amount due until the online price tool has been approved by our customer. NO EXCEPTIONS.

Skills: PHP, Software Architecture

See more: tool back, the gas company, template tool price, template of service contract, template for service agreement, template for a contract for service, standard services contract template, standard services agreement template, standard service contract template, standard service agreement template, standard service agreement form, standard service agreement contract, simple contract for service, service user agreement template, services contract template simple, services contract template, service contract template pdf, service contract agreement template, service contract agreement format, service contract agreement form, service contract admin, service bill format in excel, service agreement form template, sell excel spreadsheets, sell excel services

About the Employer:
( 7 reviews ) United States

Project ID: #4981276

Awarded to:


Contact me and send details for an efficient, perfect, well documented development of your project according to 100% accuracy and requirements, with dedicated support. Thanks

$670 USD in 4 days
(53 Reviews)

14 freelancers are bidding on average $626 for this job


Hello Sri Technocrat will provide fully interactive application/website for your project. As per the detail, Sri Technocrat will provide three template functional schemes and sample pages to make your choice for lay More

$789 USD in 30 days
(49 Reviews)

Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional s More

$515 USD in 10 days
(154 Reviews)

Hi, We’ve had a good look at your project description and we’re very interested in providing a solution . We have finished website functioning almost same concept recently, here we are fetching More

$555 USD in 10 days
(25 Reviews)

Hello Sir, I am from Confianza Technologies. I have gone through your requirements. We have developers who have vast experience in required technologies. We are interested in your project, but before finalizing budget More

$775 USD in 18 days
(37 Reviews)

Hello Sir, I am very good and PHP and MySQL. An I'm free now. So I can work only on your project to deliver on 3rd October. Please check my feedback to get an idea about my work. Thanks.

$526 USD in 4 days
(21 Reviews)

Hi, I can start immediately and create all the client-side & server-side needed to acomplish the mentioned requirements. I will implement a very easy way to upload Spreadsheets, including to use drag'ndrop-based u More

$722 USD in 3 days
(24 Reviews)

Hello, "Welcome to our Bid" Brilliant job description. Thanks. We agree with your terms & conditions. We will suggest you to build your website in custom PHP & MySQL It will help you in the long run in terms o More

$580 USD in 30 days
(5 Reviews)

Ready to start now and assure you best quality work.Having 9+ yrs of experience in web development.Regards

$499 USD in 3 days
(20 Reviews)

hello, i am senior php developer for 9 years. I can do your job without problem. If you choose me , you will not be sorry!

$500 USD in 10 days
(4 Reviews)

Hi, Sir, We are a team of professional developers in Asp.Net,VB.Net,C#.Net, HTML5, CSS3,JQuery PHP,MySQL,SQL Server,Oracle,SharePoint, WordPress and Joomla and having many years of relevant experience in web/windows/ More

$666 USD in 3 days
(1 Review)

Dear Sir, I am loveneesh bansal from India. We have written similar applications in past for our domestic clients where we automate the whole process. Going through your description raises few queries which are More

$555 USD in 3 days
(1 Review)

If you need it developed in a stable manner in a very short period of time I think you should consider python/django. That can work on any apache server using an extension to apache called mod-wsgi. I can finalize t More

$666 USD in 2 days
(0 Reviews)

We have readily available web based products for your requirements. It covers following features. quotations, purchase orders, sales orders, invoices, stock, billing, manage products, clients, vendor More

$833 USD in 3 days
(0 Reviews)

Hello. I have 4 years php+mysql experience. I am right now almoust done with a project management system for an electrical company (have administrator and workers- project area where admin asign worker and responsible More

$750 USD in 3 days
(0 Reviews)