# Thread: Equation involving % yield

1. ## Equation involving % yield

Please can somebody help with the following question?

I know the % yield involved with a process, but need a formula which will calculate the total input required to get to a set output.

The formula needs to be dynamic so it can recalculate based on any combination of output and yield.

As an example.

Wholehead broccoli is converted to floretted broccoli.

If the floretting process has a 70% yield, what is the total amount of wholehead broccoli needed, to get to 1tonne of floretted broccoli?

I'm going to write this formula in excel but would like to understand the maths behind it first.

Thanks for any help.

Phil

2. Originally Posted by ashmack
Please can somebody help with the following question?

I know the % yield involved with a process, but need a formula which will calculate the total input required to get to a set output.

The formula needs to be dynamic so it can recalculate based on any combination of output and yield.

As an example.

Wholehead broccoli is converted to floretted broccoli.

If the floretting process has a 70% yield, what is the total amount of wholehead broccoli needed, to get to 1tonne of floretted broccoli?

I'm going to write this formula in excel but would like to understand the maths behind it first.

Thanks for any help.

Phil
$W$ = amount of wholehead broccoli

$F$ = amount of floretted broccoli

$F = \dfrac{7W}{10}$

so ...

$W = \dfrac{10F}{7}$

3. Thanks for your help - really appreciate that

Havent done maths since GCSE over 10 years ago...need to dust off those text books I think!

Phil