I need to solve the following pricing question within Excel:

Hi. Here's just one more method within Excel...

Aprice/Oprice = 2

First, make this linear by rewriting as a = 2*O
Then as
a - 2*O = 0
Your second equation is:
184*a + 736*O = 16,105,626

Select two vertical cells, and Array enter the following equation:

=MINVERSE({184, 736; 1, -2})*({16105626, 0})

Or perhaps the more common method of:

=MMULT(MINVERSE({184,736;1,-2}),{16105626;0})

Returning:
29176.86
14588.43


= = = = = = =
HTH :)
Dana DeLouis



Mark M wrote:
Sorry if this is trivial:

I need to solve the following pricing question within Excel:

We plan to sell:

184 Apples and 736 Oranges for total of quantity 920

The price of an apple should be 2x of an orange.
The total revenue should be $16,105,626 (expensive fruit :) )

What should the price be per Apple and Orange?

In other words:
184 * Aprice + 736 * Oprice = $16,105,626
Aprice/Oprice = 2

Any help appreciated,
Mark