The beginning accounts payable (associated with PlasticPR purchases only) will consist of $101,278 arising from the following estimated material purchases for November and December of 2020:

Material purchases in November 2020: $213,850

Material purchases in December 2020: $138,400

Wood Parts-Musical Instruments pays for 50% of a months purchases in the month of purchase, 35% in the following month and the remaining 15% two months after the month of purchase. There is no early payment discount.

I need a schedule of cash disbursement for materials, in a spreadsheet