Results 1 to 4 of 4

Thread: Excel Commitment Help

  1. #1
    Neophyte cherambane's Avatar
    Join Date
    May 2012
    Location
    Karnataka, India
    Posts
    4
    Articles
    0

    Excel Commitment Help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 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

  2. #2
    Neophyte cherambane's Avatar
    Join Date
    May 2012
    Location
    Karnataka, India
    Posts
    4
    Articles
    0
    Help me please

  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,468
    Articles
    0
    Excel Version
    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.


  4. #4
    Neophyte cherambane's Avatar
    Join Date
    May 2012
    Location
    Karnataka, India
    Posts
    4
    Articles
    0
    Quote Originally Posted by NBVC View Post
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •