1. ## Excel Commitment Help

Dear Members and Moderators,
Good day to you.

I have two worksheet named Commitment and Purchase
Commitment Sheet contains the following Data
 Commitment No Quantity Price 1 5000 100.00 2 5000 101.00 3 10000 101.50
Purchase Sheet Contains Following Data
 Date Quantity Price 02/01/2012 4820 03/01/2012 4000 04/02/2012 7010
Price to be calculated from commitment sheet
for example price for 4820 kgs equal to 100.00 and price for 4000 kgs to splitted to first and second commitment that is remaining commitment of 5000 is 180 kgs @ 100.00 balance of 3820 kgs @ 101.00 so second commitment balance is 1180.00

Can any body help me to calculate the same

3. I don't understand the logic here? You have 2 - 5000 qty prices in the Commitment sheet. Why?

How do you "split" 4820 amongst the prices that way.. why not all under the 5000 kg price, since 4820 is below 5000?

The logic you present is not making sense to me.

4. Originally Posted by NBVC
I don't understand the logic here? You have 2 - 5000 qty prices in the Commitment sheet. Why?

How do you "split" 4820 amongst the prices that way.. why not all under the 5000 kg price, since 4820 is below 5000?

The logic you present is not making sense to me.

Mr. X Committed to Sell 5000 Kgs @ 100.00 and 5000 Kgs @ 101.00 and 10000 Kgs @ 101.50 and so on.
Mr. X Delivered 4820 Kgs first time. he have to send 180 kgs balance for first commitment that is 5000 @ 100.00
Second time he delivered 4000 kgs instead of 180 Kgs. So 180 Kgs @ 100.00 and Balance 3820 Kgs @ 101.00
Now his second commitment was 5000 Kgs @ 101.00 he have to deliver balance (5000-3820) 1180 Kgs @ 101.00

I hope you understood my problem.