Creating a Strategy for changing Prices with Excel
$10-30 CAD
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.
Project ID: #9525265
About the project
10 freelancers are bidding on average $36 for this job
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.
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
Fast typer Very flexible time Work atleast 8hrs a day Have good knowledge in MS Offices (Including Formulas in Excel)
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
I want to confirm what is the interval value. Is it the difference between cost price and selling price?