Gibson Books buys books and magazines directly from publishers and distributes them to grocery stores. The wholesaler expects to purchase the following inventory:

April May June

Required purchases $($on account$)$ $ $106,000$ $ $126,000$ $ $138,000$

Gibson Books$$ accountant prepared the following schedule of cash payments for inventory purchases. Gibson Books$$ suppliers require that $85$ percent of purchases on account be paid in the month of purchase; the remaining $15$ percent are paid in the month following the month of purchase.

Required

Complete the schedule of cash payments for inventory purchases by filling in the missing amounts.

Determine the amount of accounts payable the company will report on its pro forma balance sheet at the end of the second quarter.Complete the schedule of cash payments for inventory purchases by filling in the missing amounts.

Schedule of Cash Payments for Inventory Purchases