Results 1 to 8 of 8

Thread: solve for x ?

  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    solve for x ?

    helllo all

    I was thinking that excel had a function that could do this but for the life of me I could not remember it so if it is not available I need a formula that would solve for the following.

    Jelly filled Goal = 60% of total donuts sold

    Current # donuts sold # of current donuts jelly filled current % number of new sales projected
    8 4 50 2

    % new sales need to be jelly filled to attain 60% total goal
    X

    Thanks in advance for all the help

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts

    Goal Seeking

    cvbs,

    You can use the Solver Add-in which I do not have installed so I cannot comment on it (see image to load it from options) or you can use goal seeking.

    Data tab> What If Analysis> Goal Seek...

    A simple example.
    Cell:
    B1=C1/D1
    D1=100
    Seek for C1

    GoalSeek.png


    Solver Addin
    solver.png

    Hope that is what you are looking for
    Maud

    PS Sorry CV, I thought you were looking for some built-in Excel feature for solving
    Last edited by Maudibe; 2013-08-11 at 18:43.

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi cvbs

    If I understand your requirements correctly, you can use very simple formulas to determine how many, and what percentage of new sales, need to be Jelly-filled to make an overall specified sales target%.
    see attached file.

    zeddy
    Attached Files Attached Files

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You can use the formula:
    =Max(0,((TotalSold+ProjSales)*JellyGoal-SoldJelly)/ProjSales)

    JellyGoal should be a percentage (60% = 0.6) not 60. If you want to enter 60 then use:
    =Max(0,((TotalSold+ProjSales)*JellyGoal/100-SoldJelly)/ProjSales)

    The number should be formatted to percentage (or multiplied by 100 if you don't want to format). If the percentage is larger than 100% (ie the number is greater than 1, then even if ALL the projected sales are jelly, will not get your goal.

    Steve

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    In the UK we use jam, not jelly.
    ..like Bob Marley's favourite kind of donuts.
    (Wi' jammin')

    zeddy

  6. #6
    Super Moderator BATcher's Avatar
    Join Date
    Feb 2008
    Location
    A cultural area in SW England
    Posts
    3,417
    Thanks
    33
    Thanked 195 Times in 175 Posts
    Quote Originally Posted by zeddy View Post
    In the UK we use jam, not jelly.
    Not strictly true: what the Americans call jelly, we call jam (a number of varieties of fruit preserve).
    Jell-o™ is what we British chaps know as jelly.

    (No doubt other fine Jell-o™-like products are available...)
    BATcher

    Time prevents everything happening all at once...

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In the US there are differences between a jam, a jelly, and Jell-O. Jelly refers to a clear (though generally not colorless) spread made from fruit (or vegetable) juice "firmed" with pectin (a high molecular weight water-soluble colloidal carbohydrate). Jam is a product made with whole fruit, cut into pieces or crushed. Jell-O is a desert made from gelatin, a protein made from animal skin and bones. Vegans would eat jam and jelly since are fruit/vegetable products, but would not eat Jell-O since it contains animal products.

    Steve
    PS since you also mentioned preserves: In the US a preserve is fruit cooked with sugar until the chunks of fruit are suspended in a syrup base. The texture of preserves is not smooth like jelly or jam. In the US I believe that there are Food and Drug Administration standards which define what a Jelly, a jam, and a preserve is for consumers.
    Last edited by sdckapr; 2013-08-13 at 10:16.

  8. #8
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi BATcher

    Re: what the Americans call jelly, we call jam
    ..didn't I say that?
    ..hang on, no, you are right!!, I said "use", not "call"
    ..hang on, hang on, no, when I said "use", I meant we use the word jam when Americans use the word jelly.
    ..or are you saying, as per the original post, "current donuts jelly filled..", that he should've said
    "currant donuts jell-o filled"

    zeddy
    Self-preservation: For when you've got yourself in a jam.
    Last edited by zeddy; 2013-08-13 at 11:16.

Posting Permissions

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