Preparing the inventory purchases budget and schedule of cash payments Hoskin Company’s purchasing manager, Scott Medina, is preparing a purchases budget for the next quarter. At his request, Larry Franklin, the manager of the sales department, forwarded him the following preliminary sales budget.

L.O. 3 L.O. 4, 7 October November December January Budgeted sales $640,000 $768,000 $960,000 $800,000 For budgeting purposes, Hoskin estimates that cost of goods sold is 75 percent of sales. The company desires to maintain an ending inventory balance equal to 20 percent of the next period’s cost of goods sold. The September ending inventory is $90,000. Hoskin makes all purchases on account and pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the following month. The balance of accounts payable at the end of September is $90,000.

Required

a. Prepare an inventory purchases budget for October, November, and December.

b. Determine the amount of ending inventory Hoskin will report on the end-of-quarter pro forma balance sheet.

c. Prepare a schedule of cash payments for inventory for October, November, and December.

d. Determine the balance in accounts payable Hoskin will report on the end-of-quarter pro forma balance sheet.