Excel Commitment Help

cherambane

New member
Joined
May 9, 2012
Messages
4
Reaction score
0
Points
0
Location
Karnataka, India
Dear Members and Moderators,
Good day to you.

Please help me on this
I have two worksheet named Commitment and Purchase
Commitment Sheet contains the following Data
Commitment NoQuantityPrice
15000100.00
25000101.00
310000101.50
Purchase Sheet Contains Following Data
DateQuantityPrice
02/01/20124820
03/01/20124000
04/02/20127010
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
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
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.
 

cherambane

New member
Joined
May 9, 2012
Messages
4
Reaction score
0
Points
0
Location
Karnataka, India
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.

Thanks for your reply.

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.

Thanks in advance
 
Top