Creating a Strategy for changing Prices with Excel

完了済み 投稿 Jan 31, 2016 着払い
完了済み 着払い

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.

データ入力 情報処理 エクセル

プロジェクトID: #9525265

プロジェクトについて

10個の提案 リモートプロジェクト アクティブ Jan 31, 2016

アワード:

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 もっと

$30 CAD 1日以内
(18レビュー)
4.0

10人のフリーランサーが、平均$36 で、この仕事に入札しています。

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 もっと

$100 CAD 5日以内
(143件のレビュー)
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 1日以内
(64件のレビュー)
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 もっと

$30 CAD 1日以内
(51件のレビュー)
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 もっと

$30 CAD 3日以内
(レビュー1件)
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 もっと

$30 CAD 1日以内
(レビュー1件)
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 もっと

$30 CAD 1日以内
(レビュー1件)
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 1日以内
(レビュー1件)
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 もっと

$30 CAD 1日以内
(0件のレビュー)
0.0
waiyuetc

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

$25 CAD 1日以内
(0件のレビュー)
0.0