1. 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. 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.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

3. 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

4. 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. In the UK we use jam, not jelly.
..like Bob Marley's favourite kind of donuts.
(Wi' jammin')

zeddy

6. Originally Posted by zeddy
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...)

7. 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.

8. 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.

Posting Permissions

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