Rachel Is a Staff Accountant at Bowl More, Inc

Rachel is a staff accountant at Bowl More, Inc. She has been assigned the task of preparing the company's purchases budget and schedule of cash disbursements for the quarter ended June 30. During her review of the company's purchasing and payment policies, she determines the following information:
-The company's budgeted purchases of bowling balls for the next quarter are as follows:
o April: 800 bowling balls
o May: 950 bowling balls
o June: 860 bowling balls
-The company purchases bowling balls from its vendor for $100 each.
-Freight charges of $6 per bowling ball are invoiced to Bowl More by the vendor. These are shown on the same invoice as the bowling balls and are charged to accounts payable.
-The company's payment schedule for accounts payable is as follows:
o 10% of payables are paid during the month of purchase
o 55% of payables are paid the month following purchase
o 35% of payables are paid two months following purchase
-The accounts payable (A/P) balance as of March 31 is $16,200. Of this amount, 60% is for purchases made in February and 40% is for purchases made in March.
a. Determine the total cost of purchasing bowling balls for each month and the total for the quarter.
b. Prepare a schedule of cash disbursements for the quarter ended June 30.
c. Determine Bowl More's accounts payable balance as of June 30.
d. Explain how Rachel's work on these items will impact the company's budgeted balance sheet for the quarter ended June 30.