- #1
ojsimon
- 56
- 0
Hi
I am trying to do this manually without excel, http://office.microsoft.com/en-us/help/HA100242441033.aspx
I have come to the two equations:
u=30000*(1+((x/20)-1)*-1.1)
m=(u*(x-10))-300000
where u= optimum units sold
x= optimum price
m=margin with optimum price
I have tried simplifying these together and optimising it, but keep getting the wrong answer. Could anyone help me by providing a solution to it which matches the one on microsoft's website?
Thanks
I am trying to do this manually without excel, http://office.microsoft.com/en-us/help/HA100242441033.aspx
I have come to the two equations:
u=30000*(1+((x/20)-1)*-1.1)
m=(u*(x-10))-300000
where u= optimum units sold
x= optimum price
m=margin with optimum price
I have tried simplifying these together and optimising it, but keep getting the wrong answer. Could anyone help me by providing a solution to it which matches the one on microsoft's website?
Thanks
Last edited by a moderator: