D Dokat Member Mar 10, 2021 #1 Hi, I have below retail, cost, elasticity, and unit sales data. We are looking to lower the retails. Is there an excel formula that gives the best lower optimum retail that maximizes revenue? Retail$5Cost$1.5Elasticity 1.23Units Sold178,321
Hi, I have below retail, cost, elasticity, and unit sales data. We are looking to lower the retails. Is there an excel formula that gives the best lower optimum retail that maximizes revenue? Retail$5Cost$1.5Elasticity 1.23Units Sold178,321
P Peter Bartholomew Well-Known Member Mar 13, 2021 #2 Did you sort your problem. I calculated that the retail could be raised slightly to maximise revenue.
Did you sort your problem. I calculated that the retail could be raised slightly to maximise revenue.