Exercise $7-8$A $($Static$)$ Preparing a schedule of cash payments for inventory purchases LO $7-3$

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

$\backslash$table$[[,$April,May,June$],[$Required purchases $($on account$),$$ $70,000,$$ $80,000,$$ $95,000]]$

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

Required

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

b$.$ Determine the amount of accounts payable the company will report on its pro forma balance sheet at the end of the second quarter.

Complete this question by entering your answers in the tabs below.

Required $A$

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

$\backslash$table$[[$Schedule of Cash Payments for Inventory Purchases$],[$Payment for current accounts payable,April,May,June$],[$Payment for previous accounts payable,$$63,000,,],[$Total budgeted payments for inventory,$4,000,,]]$