Help me to understand formulae

A

anna

Hi,
Searching for the solver examples on the net I came across the example where
I find a formulae that I don’t understand and I just wonder if any one could
explain in very simple words the formulae is

=B14*MAX (B10, 0) ^$H$4

where b14 =Unit Profit
b10 =Units Produced
$H$4= Diminishing Profit Factor (0.9)

I can see that when I remove the Diminishing Profit Factor the result is
much higher but I don’t understand why it has been included on the first place
Thanks in advance
Anna
 
G

Gary''s Student

Hi anna:

It is just a way to model reduced profit. For example, if H4 were set to .5
and B10 was 16, the effect is the same as having B10 set to 4 with no factor
 
A

anna

Thanks Gary

Gary''s Student said:
Hi anna:

It is just a way to model reduced profit. For example, if H4 were set to .5
and B10 was 16, the effect is the same as having B10 set to 4 with no factor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top