If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Maths Question

Torres999 · 2021-04-15 16:49:01

I have 2 suppliers. Supplier 1 sells at €0.81 per L Supplier 2 sells at €0.77 per L We want to make 10,000,000 L and want a cost of €8,000,000 Whats the fastest way to calculate what % of each I need to get to €8,000,000 or an average of €0.80 per L . Is there a magic excel formula?

15-04-2021 5:49pm

#1

Torres999

Registered Users Posts: 186 ✭✭

Join Date: June 2013

Posts: 148

I have 2 suppliers.

Supplier 1 sells at €0.81 per L
Supplier 2 sells at €0.77 per L

We want to make 10,000,000 L and want a cost of €8,000,000

Whats the fastest way to calculate what % of each I need to get to €8,000,000 or an average of €0.80 per L . Is there a magic excel formula?

0

Comments

#2 15-04-2021 5:55pm

MugsGame

Registered Users Posts: 165 ✭✭

Join Date: April 2008

Posts: 156

https://www.wolframalpha.com/input/?i=systems+of+equations+calculator&assumption=%7B%22F%22%2C+%22SolveSystemOf2EquationsCalculator%22%2C+%22equation1%22%7D+-%3E%22A%2BB%3D10000000%22&assumption=%22FSelect%22+-%3E+%7B%7B%22SolveSystemOf2EquationsCalculator%22%7D%7D&assumption=%7B%22F%22%2C+%22SolveSystemOf2EquationsCalculator%22%2C+%22equation2%22%7D+-%3E%220.81A%2B0.77B%3D8000000%22

To get a formula for A, rearrange the second equation to state B in terms of A, and then substitute it for B in the first equation.

0