+ Reply to Thread
Results 1 to 3 of 3

optimizing sales growth

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    optimizing sales growth

    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?

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: optimizing sales growth

    Yes you can but you will have to define the assumptions and constraints.

    You are basically defining a formula then having excel determine the ideal point for the variable(s) in the formula.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Re: optimizing sales growth

    Ok, do you know of any links or resources where I could see an example of this in multiple years? I see some stuff for product mix but that's all in one year.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 02-02-2020, 01:39 AM
  2. Interpolate monthly growth from known Annual Growth
    By nopointing in forum Excel General
    Replies: 3
    Last Post: 06-15-2014, 03:36 AM
  3. Replies: 6
    Last Post: 05-05-2013, 07:17 PM
  4. Predict Sales increase Trend or Growth.
    By elcasey125 in forum Excel General
    Replies: 1
    Last Post: 06-11-2009, 04:38 PM
  5. growth formula to predict sales for this year
    By ipodman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-25-2007, 03:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1