Supplier Payment Schedule Calculation

**lalosan** · 02-02-2012, 10:55 PM

Hi,

I need to calculate the payments to suppliers based on the different terms each supplier offers. It is easier to visualize in the attached dummy spread sheet. Please create the formulas in the area highlighted in Green and maintain the layout of the spread sheet.

Thank you in advance for your kind help.

Regards,

Lalosan

**dilipandey** · 02-02-2012, 11:45 PM

Hi Lalosan,

Had a look into the spreadsheet, would appreciate if you can enter the results manually into the green area and then I would be happy to obtain the same through formulas. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**lalosan** · 02-03-2012, 04:12 PM

Hi,

For purposes of illustrating how the formula should work,I have done examples of what the results should be using only the purchase numbers
highlighted in Green. Please see attached spread sheet.

Regards,

Lalosan

**dilipandey** · 02-04-2012, 12:03 AM

Sorry... still not clear.

Supplier 4 has amount $11,000 on Jan-12 but that column has Container from Supplier 1 =1 (cell J8) and cost = $55,000 (cell J9).. I am not able to relate.

Regards,
DILIPandey

<click on below 'star' if this helps>