Hello. I have four channels (products) each with their respective revenues and cost %. I have a base year and then years 2-6. What I want to do is find the ideal growth rate in each of the channels. The "ideal" would mean the growth rates that result in the highest profitability sum for all of the years. Is there a way I can do this in excel with solver or something like that?
Bookmarks