Find Jobs
Hire Freelancers

SQL Developer and Mathematician to Write Algorithm to Turn Losses to Profit

£20-250 GBP

In Progress
Posted almost 8 years ago

£20-250 GBP

Paid on delivery
Maths has never been my strong point, how I have go this far in life is beyond me! My Problem is with product pricing. The products I sell need to be sold at Retail Price [MSRP], however sometimes that just is not possible, due to online fees, delivery charges etc. I have got as far as working out my Gross Profit Margin (which might not sound like a big deal, but for a guy that is learning to code this in SQL and Failed secondary school maths with an F is a big deal!). So I need someone to write me an algorithm to turn these negative figures around to positive figures but without just writing a linear 10% increase approach. Apart from anything, that simply wouldn't work especially since some figures are -40%! I'm working with Microsoft SQL, and do have some limitations in what commands can be executed since this is a hosted system that manages my products. For example INSERT INTO cannot be used. All said, whilst I am working with SQL, I don't necessarily require a developer. If you reckon you have the Mathematical skill to coach me through, I could work with you to develop the solution. *** PHP Developer. If you are an SQL/PHP developer, there is also scope here to make this a larger project, the cloud solution I am working with has an API, so writing some kind of portal with firewall style pricing rules may also be an approach that I am open to work with. *** I have attached some examples of figures that I am working with, and can supply the MSQL I have written so far to obtain these figures... I trust you will ask more questions, frankly I am unsure what other questions to write to gain the answers! :-/ Look forward to hearing from you..
Project ID: 10692994

About the project

10 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average £149 GBP for this job
User Avatar
Hello I am checking your csv file. Hopefully I can provide you solution on database. I had done several big database oriented projects. Let discuss in details. Regards Neha M.
£277 GBP in 7 days
4.9 (46 reviews)
7.2
7.2
User Avatar
Hi I am an Electronic and telecommunication engineer with exceptional skills in mathematics. I can help you for this. Please msg to discuss further on this Thanks Note-please check my profile for past projects and reviews. (note-if you are available now we can discuss further on this and decide a feasible algo suits your requirement )
£38 GBP in 7 days
5.0 (128 reviews)
6.1
6.1
User Avatar
Hello, I am interested in your project. I have professional experience with SQL. I have analyzed your data, and I want to confirm that I understand everything. The MSRP is the price you sell your products; The Cost is the amount that you pay by the product. If MSRP>Cost then you will have profit, is not you will lose money. Your objective is to calculate a new MSRP in order to have always profit. Are the online fees and delivery charges specific for each product, or for each Source (Amazon or Ebay, etc.)? Do you have the data of each extra cost? Or do you have an estimation of how much it will be based on some parameters? I can provide you the mathematical formula, using SQL if you want, based on the parameters I have indicated. We can also define an minimal profit margin, to calculate the new MSRP. Thank you, Best regards, David
£30 GBP in 2 days
5.0 (19 reviews)
4.0
4.0
User Avatar
Hello More 20 years mathematics and programming experience. I need more details to set real price and time. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
£250 GBP in 5 days
4.9 (12 reviews)
4.2
4.2
User Avatar
Dear Client, Thank you for looking at my candidature. I can fulfill your skills requirement and would like to discuss further on this. I would like to discuss further regarding feature development part. I am good in designing and have good understanding of HTML5/CSS3 and Bootstrap designing . I will give my 100% efforts to develop good relationship and get future projects. I am a Php as well as ASP.net expert having extensive experience 5+ years. I have developed 50+ websites . I have strong command over customizing Themes as well as plugins as per client requirements. I also worked on Android and IOS APPs and has 2+ years of experience. 5 Reasons why you should hire me for your custom website and Application Development. 1. Available 24/7 upon your request 2. Delivery on-time with 100% satisfaction 3. Always think beyond boundaries and provide user friendly solution 4. Provide excellence with commitment 5. Most important, Free technical support for lifetime. I am accessible on Skype/Hangout/Email for the detail discussion on the project.
£150 GBP in 5 days
4.8 (5 reviews)
1.8
1.8
User Avatar
Hello! It sounds like you are looking for someone who can automate or help you automate pricing so that sale prices are set high enough for you to profit. I believe I can help both with the math and with the sql. For the price given, I'm offering two hours of consultation or coding, whatever you'd rather have. Thank you for viewing my bid. Happy to discuss further. Have a great day, ZehnX
£55 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£111 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 3+ experience in MSBI suite (SQL Server: 2008, 2012 and 2014, SSIS, Microsoft SQL Azure, SSAS and SSRS) with strong analytical, troubleshooting and problem-solving skills. I am available on Skype: "rgrs2007" to discuss further.
£155 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am working as a database developer for a telecom and I create complex statistical real-time reports on a daily basis. I can help you in creating the SQL code you are working on. Regards, Peter
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Horsforth, United Kingdom
4.9
13
Payment method verified
Member since Feb 13, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.