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
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 project.
Best Regards
Fouad
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 dashboard and macros for my company and as freelance.
I've also worked as Senior Auditor in a Big4 for 5 years. I'm graduated in Business Administration and Financial Accounting.
I create reports and financial dashboards on a daily basis to support management in taking business decisions.
Reading your request, I'm quite sure to complete this task in few days. Of course, unlimited revisions till the output will meet your needs.
Contact me if you're interested in my proposal and to provide me more details.
Best regards
Nicola
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
i will do this job very well...............................................................................................................................................................................................................................................................................................