Results 1 to 3 of 3

Thread: Biz plan projetcion help

  1. #1
    Mar 2010

    Biz plan projetcion help

    >>>>>>>>>>>>I REPOSTED THIS in Pre-Algebra/algebra because I think that I was not too clear and I gave more info....and maybe this is more an algebra problem Please go there to help me.


    I am lost on what to do here. I know that I knew long time ago but i just cant remember now.

    I am doing business plan projections on an excel spreadsheet.

    I have 7 years of MONTHLY sales figures.

    I want to use the same figures but do several different projections like what if I can do better than I expect and can do 7 years of these sales in 5 years. or 6 years. or whatever.

    So the data is simple. The sales have some fluctuations so they do not go in a straight line.

    month sales amount
    1 5000
    2 8000
    3 7000
    4... 8500

    and so on for 84 months or 7 years.

    Thank you for your help

    Work Done
    I currently have the variable expenses and other items set up to adjust for the new sales figure... but I do not know how to logically adjust the number of years to goal for the sales figure itself easily.
    Last edited by tstmlone; Apr 1st 2010 at 04:24 AM.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Super Member Deadstar's Avatar
    Oct 2007
    Right I'll reply in this one so that it gets bumped to the top and the other one you posted stays unanswered so other folk will look at it...

    Let's just clarify what you're asking first...

    Lets say you took the following amounts in 4 months.

    Month Amount
    -- 1 --- 1000
    -- 2 --- 2000
    -- 3 --- 1500
    -- 4 --- 1800

    Total = 6300

    And you want to know how to scale it down so that can see how much you would need to earn each month if you wanted the same final total in say, 3 months. Right?

    I can't formalize a way yet but I'll show you what I'm thinking...

    Have a look at the picture attached.

    Each box on the graph represents the monthly takings. (We'll call these old month)

    The boxes below the graph represent the new rescaled months. (Call these new months)

    What to do is look at each new month and see what each box covers, this is how much you need to earn that month...

    So, the amount you need to earn for month 1 is...

    $\displaystyle 1000 + \frac{1}{3} \times 2000$

    For month 2...

    $\displaystyle \frac{2}{3} \times 2000 + \frac{2}{3} \times 1500$

    For month 3

    $\displaystyle \frac{1}{3} \times 1500 + 1800$

    How did I do this? Draw lines up from the new months boxes up to the graph and you'll see for example, new month 1 covers all of old month 1's amount + a fraction of old month 2's amount.

    Do this with the rest of the new months and you get how much you need for each new month.

    Just as a check, if I add up the above totals I get...

    $\displaystyle 1000 + \frac{1}{3} \times 2000 + \frac{2}{3} \times 2000 + \frac{2}{3} \times 1500 + \frac{1}{3} \times 1500 + 1800 = 6300$

    I'll try and formulate a way for you to do this quickly with your large scale one...
    Attached Thumbnails Attached Thumbnails Biz plan projetcion help-asdfgdh.jpg  
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Mar 2010

    thanks so far

    Thanks for your work so far.

    I thought this was going to be simpler than what it is. I have asked 6 math people so far and got 2 different answers from 2 of them and basically "I don't knows" from 4.

    I would appreciate a formula if there is one. As I want to do various scenarios .
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Best Fencing Plan
    Posted in the Calculus Forum
    Replies: 4
    Last Post: Nov 28th 2010, 02:45 PM
  2. what is the plan?
    Posted in the Math Puzzles Forum
    Replies: 6
    Last Post: Apr 24th 2010, 09:53 AM
  3. Air Plan
    Posted in the Algebra Forum
    Replies: 3
    Last Post: Apr 23rd 2010, 11:45 PM
  4. Equation of plan
    Posted in the Calculus Forum
    Replies: 3
    Last Post: Jun 25th 2008, 01:55 PM
  5. plan of attack
    Posted in the Advanced Statistics Forum
    Replies: 2
    Last Post: Oct 31st 2007, 03:59 AM

Search Tags

/mathhelpforum @mathhelpforum