Quetions is that : Bernard wants to see how the company is doing prior to starting the month of December. Prepare a cash budget for the months of September, October, and November and for the three-month period in total (the period begins on September 1). Providing a supporting schedule of cash collections.

Thing is that I knew the answer, please check the following table, but I don't know how to get the answer. Can you please tell me how to calculate those data? thank you so much!

^bFor Accounts Payable taken from the balance sheet developed in Requirement 1.

^c$5,000 0.09 (2/12) (beginning of September to end of October).

^dIncludes minimum cash balance of $10,000.

I have no idea how they were calculated, please advise, thanks u!

OBJECTIVE3 Problem 8.37 Cash Budget, Pro Forma Balance Sheet Bernard Creighton is the controller for Creighton Hardware Store. In putting together the cash budget for the fourth quarter of the year, he has assembled the following data a. Sales July (actual) August (actual) September (estimated) October (estimated) November (estimated) December (estimated) $100,000 120,000 90,000 100,000 135,000 150,000 b. Each month, 20 percent of sales are for cash, and 80 percent are on credit. The collection pattern for credit sales is 20 percent in the month of sale, 50 percent in the following month, and 30 percent in the second month following the sale. c. Each month, the ending inventory exactly equals 40 percent of the cost of next month's sales. The markup on goods is 33.33 percent of cost. Inventory purchases are paid for in the month following purchase Recurring monthly expenses are as follows d. Salaries and wages Depreciation on plant and equipment Utilities Other $10,000 4,000 1,000 1,700 (continued)