Creating a Strategy for changing Prices with Excel

Completed Posted Jan 31, 2016 Paid on delivery
Completed Paid on delivery

I have 59 products, each product has 5 - 15 types of prices ( with different quantities, I also has an interval value for each product ), as each type of product's quantity increased, my selling prices will come out with a increased percentage discount . I need you to create a formula with this strategy and pull out my selling prices for those 59 products with 5 - 15 options with excel. I'll give you my cost price numbers and the interval value for each 59 products ( they are different in number ), I also need to be able to change the cost price and the interval value at any time, so the other numbers will change along with it. I also prefer the excel come with charts, things like showing my profit margins etc. I'm not sure if you really need VBA skill to do this, but talk to me in details. Best regard.

Data Entry Data Processing Excel

Project ID: #9525265

About the project

10 proposals Remote project Active Jan 31, 2016

Awarded to:

vlayausa

Hello, I am interested in this project. I am very skilled with VBA, but I don't think you will need it in this project. It can all be done with simple Excel functions. I would love to help you make your Excel sp More

$30 CAD in 1 day
(18 Reviews)
4.0

10 freelancers are bidding on average $36 for this job

dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Wai More

$100 CAD in 5 days
(143 Reviews)
6.3
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 CAD in 1 day
(64 Reviews)
5.8
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 55+ are complex VB/VBA projects, hence i can definitely deliv More

$30 CAD in 1 day
(51 Reviews)
5.3
rilhad1

Hi, I would like to offer my candidature for this job. I have all the necessary knowledge and skills to perform this job. Everything will be done accurately, efficiently and professionally. I understand that you had be More

$30 CAD in 3 days
(1 Review)
1.8
daniyal3214

I posses expertise in using excel for financial analysis, break even analysis, financial forecasting, cash flow projection, budgeting etc. I can also show you samples of my previous projects for your evaluation. I wi More

$30 CAD in 1 day
(1 Review)
1.1
vroux

I think I know what you want to do, but it would help if we could chat about the details and you provide me with an example, if you have one, of what you're looking for. At least that way I can ask some questions abou More

$30 CAD in 1 day
(1 Review)
0.9
ipianochan

Fast typer Very flexible time Work atleast 8hrs a day Have good knowledge in MS Offices (Including Formulas in Excel)

$25 CAD in 1 day
(1 Review)
0.0
michalmroz1

Your description looks pretty straightforward - I am thinking for this kind of solution a few simple lookup (either vertical or horizontal) should suffice - though this of course depends how the data in the spreadsheet More

$30 CAD in 1 day
(0 Reviews)
0.0
waiyuetc

I want to confirm what is the interval value. Is it the difference between cost price and selling price?

$25 CAD in 1 day
(0 Reviews)
0.0