Problem $14-18$A $($Algo$)$ Preparing an inventory purchases budget and schedule of cash payments LO $143$

Rundle, Incorporated sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June, and July:

$\backslash$table$[[$Budgeted cost of goods sold,April,May,June,July$]]$

Rundle had a beginning inventory balance of $$4,200$ on April $1$ and a beginning balance in accounts payable of $$13,900.$ The company desires to maintain an ending inventory balance equal to $20$ percent of the next period's cost of goods sold. Rundle makes all purchases on account. The company pays $65$ percent of accounts payable in the month of purchase and the remaining $35$ percent in the month following purchase.

Required

a$.$ Prepare an inventory purchases budget for April, May, and June.

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

c$.$ Prepare a schedule of cash payments for inventory for April, May, and June.

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

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

Required B

Required C

Required D

Prepare an inventory purchases budget for April, May, and June.

$\backslash$table$[[$Inventory Purchases Budget,April,May,June$],[$Budgeted cost of goods sold,$$,70,000,$$$,80,000,$$$,90,000],[,,,,,,11],[$Inventory needed,,$70,000,,80,000,,90,000],[,,,,,,],[$Required purchases $($on account$),$$$,70,000,$$$,80,000,$$$,90,000]]$