Equation involving % yield

Printable View

February 13th 2011, 08:34 AM
ashmack

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
February 13th 2011, 08:55 AM
skeeter

Quote:

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}$
February 13th 2011, 09:28 AM
ashmack

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