Find Jobs
Hire Freelancers

Pricing Estimation tool (php & mysql)

$250-750 USD

I përfunduar
Postuar over 10 years ago

$250-750 USD

Paguhet në dorëzim
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.
ID e Projektit: 4981276

Rreth projektit

13 propozime
Projekt në distancë
Aktive 10 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
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 në 4 ditë
4,9 (293 përshtypje)
6,9
6,9
13 freelancers are bidding on average $619 USD for this job
Avatari i Përdoruesit
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 layout. It will be developed as per your requirement document. We would invite your feedback and suggestions on the selected format so as to make it exactly as per your requirements. You would designate one of your officers to directly interact with Sri Technocrat to monitor the progress of the work and supply relevant data as and when required. The timeline for development is stated along with the bid. During development period, the site would be visible on one of our test servers. At the time of transfer of complete application to your control, we will send you complete code and documentation. We will provide a copy of complete site management manual. The total cost of the development is stated along with the bid. Sri Technocrat takes services of professionals in the fields of graphic designer, site management and programming. In order to provide best performance and in time, we accept milestone payment along with contract. We transfer all source codes, security protocols and password management to the client. We carryout site development in a modular form, so that and additional feature / facility can be added without disturbing the existing site. Thanking you for considering Sri Technocrat as a partner in development. With regards, Sri Technocrat
$789 USD në 30 ditë
4,7 (77 përshtypje)
7,6
7,6
Avatari i Përdoruesit
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 service exciting my customers. Please contact in PMB to discuss details. Best Regards, Zeke
$515 USD në 10 ditë
4,5 (181 përshtypje)
7,5
7,5
Avatari i Përdoruesit
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 në 4 ditë
5,0 (42 përshtypje)
6,2
6,2
Avatari i Përdoruesit
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 në 10 ditë
5,0 (5 përshtypje)
3,1
3,1
Avatari i Përdoruesit
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 the data models with a suitable web-interface for administration in 12 hours for your feedback. The web interface is used to authenticate users, and lead to an administration page that shows features according to the authenticated user's permission group. Users and groups could be created or altered even after implementation. Excel processing can be done if the format of the files is csv (Comma seperated values) Excel can save files in that format. Dealing with XLS and XLSX files can be more done but I'll have to review a sample of the excel sheets for the daily price update. Implementation and basic training will be provided as follows: - The solution will be hosted on our staging server for your approval and could be hosted there until approved by end-customer. - Source code will be well documented for a complete technical reference. - Clear implementation guide will be provided. - A recoded screen cast video will be also be provided as a tutorial. - Implementation will be done in any suitable cloud environment or even on your or end-customer's private server if remote access is granted. Please contact me if you need any clarification.
$666 USD në 2 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 as below. Today is 1st October and you requires delivery on 3rd which is an impossible task for any developer as on war footing it is an effort of 4 to 5 days. (We do not believe in false commitments may be that is why we have 100% delivery records for all our projects). I am not scared you but being a professional i am just telling you the truth. Is the design is ready or you only have excel spread sheets. Do you have any SRS (System Requirement Specification) document. We can discuss through skype, if sounds good. Regards, Loveneesh bansal bsdinfotech
$555 USD në 3 ditë
0,0 (1 review)
0,0
0,0
Avatari i Përdoruesit
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 worker, worker can add the used materials and worked hours, administrator can add files like blueprints to the project and acording to the worked hours and materials can generate invoice) shortly is a big system. If you are interested we can talk on chat. You will see what i have made so you will be assured that i got what is nedeed to make your project.
$750 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED STATES
West Chester, United States
5,0
7
Mënyra e pagesës u verifikua
Anëtar që nga qer 6, 2012

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.