Free shipping calculation

Hello

i need to calculate, in excel, many conditions and keep the profit margin at least 20%. The varibable are

. Shipping cost

. Product cost

. Free shipping rate

The product more cheap cost 1€/kg

The markup is 50%

The fix costs are 3€

The shipping cost depend from weight

The free shipping is when order total is > 39€

The module is already done (look [login to view URL]), the goal is make a macro that test

From Total products > 1€ to <= 500€

And Weight > 0 to <=100Kg

And print all conditions when the profit margin is = 20% (i need to know how much is requied for fix the loss for each condition, so i will set a different supplement to ask to customers for each condition).

This is very simple for who know Vba, the file is done at 98%

You will pass me the file with all conditions printed (in the range indicated above) and the macro also (because i have to make some tests after with little change in conditions)

I already tested a macro, and i think you simple improve it

Sub Macro1()

'

' Macro1 Macro

'

Do

Range("m2").GoalSeek Goal:=10, ChangingCell:=Range("b2")

Range("m3").GoalSeek Goal:=10, ChangingCell:=Range("b3")

Range("m4").GoalSeek Goal:=10, ChangingCell:=Range("b4")

Loop Until Abs(Range("m2")) + Abs(Range("m3")) + Abs(Range("m4")) <= Range("m5")

MsgBox "Work done", vbInformation

End Sub

Tietoa työnantajasta:
( 153 arvostelua ) Villanova Mondovì, Italy

Projektin tunnus: #17797919

Myönnetty käyttäjälle:

WeiSongJi

Hi I have read your project description and exciting. I think your project is very simple for me. I can finish your project immediately, and I can do perfectly. If you go with me in this project I can help you anyt Lisää

€24 EUR 1 päivässä
(0 Arvostelua)
0.9

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

sysdesigner13

Hi, bro. I have read your description CAREFULLY so I am very confidence for your project I am very experienced and skillful with calculation in Excel. You can visit my profile to confirm that. A few days ago, I Lisää

€23 EUR 1 päivässä
(54 arvostelua)
5.5
aubrey03

I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

€24 EUR 1 päivässä
(52 arvostelua)
5.1
sevillajk01

hello! let me help you with your project. Just award the project to me and I will take care of the rest. Hope you will consider me. thanks

€19 EUR 1 päivässä
(11 arvostelua)
3.6
Proolancer

Hello, I'm a web and desktop developer with 8 years of experience in this field, I read your project description and attached files I can dp what you want just get in touch with me and we can discuss more about your Lisää

€14 EUR 3 päivässä
(3 arvostelua)
3.0
nikopolidis

My name is Nicola, an experienced accountant and financial controller, currently Group Controller in a multinational automotive group. I use Excel daily and I'm a wizard with this software! I have created many dashb Lisää

€30 EUR 1 päivässä
(2 arvostelua)
2.7
benith1

i can do any of excel work as perfect if you want to do this please contact me soon with your information thank you very much

€23 EUR 1 päivässä
(0 arvostelua)
0.0
box1508

hi,i may be new here but i have a more than 10 years experience in Microsoft softwares like Excel,word ,and power point . I Can do this project LET'S START....PICK ME NOW

€27 EUR 1 päivässä
(0 arvostelua)
0.0
zra12

Morning sir/madam, I am skillful in calculating, well versed in excel. If you give me the opportunity I will do my best and thanks.

€24 EUR 1 päivässä
(0 arvostelua)
0.0
Mortasim

Dear Sir, thanks to you, i would to like to do your work. i have an experience on this filed last two your. thanks & best regds

€23 EUR 1 päivässä
(0 arvostelua)
0.0
manasaatir

hello I belong to the profession of chartered accountancy i think i can help you in the best possible way as i have related experience as well

€23 EUR 1 päivässä
(0 arvostelua)
0.0
€24 EUR 1 päivässä
(0 arvostelua)
0.0
RAJSINGHBANGAR

i will do this job very well.............................................................................................................................................................................................. Lisää

€19 EUR 3 päivässä
(0 arvostelua)
0.0
€21 EUR 3 päivässä
(0 arvostelua)
0.0