Botanica Company sells one product, herbal soap, by the case. On October 1, 20X7, part of the trial balance showed the following: Click the icon to view the partial trial balance.) The company pays for its purchases within 10 days of purchase, so assume that one-third of the purchases of any month are due and paid for in the following month. The cost of the merchandise purchased is $12 per case. At the end of each month, it is desired to have an inventory equal in units to 75% of the following month's sales in units. (Click the icon to view the sales data.) Exclusive of bad debts, total budgeted selling and general administrative expenses for the fiscal year are estimated at $74,200, of which $28,000 is fixed expense (which includes a $12,400 annual depreciation charge). The Botanica Company incurs these fixed expenses uniformly throughout the year. The balance of the selling and general administrative expenses varies with sales. Expenses are paid as incurred. Requirement 1. Prepare a statement of estimated cash receipts and disbursements for October 20X7 for the Botanica Company. Requirement 1. Prepare a statement of estimated cash receipts and disbursements for October 20X7 for the Botanica Company. Before we prepare the statement of estimated cash receipts and disbursements, let's prepare a schedule of collections of accounts receivable, a purchases budget and a schedule of payments for merchandise. Begin by preparing the schedule of collections of accounts receivable. Schedule 1, Collections of accounts receivable August sales September sales October sales Total October collections. Now prepare the purchases budget for September and October. Schedule 2, Purchases budget September October Desired ending inventory Plus: Cost of goods sold Total merchandise needed Less: Beginning inventory Required purchases Next prepare the schedule of payments for merchandise. (Round your answers to the nearest whole dollar.) Schedule 3, Payments for merchandise October Payments for October purchases Payments for September purchases Disbursements for purchases Prepare a statement of estimated cash receipts and disbursements for October 20X7 for the Botanica Company. Botanica Company Statement of Estimated Cash Receipts and Disbursements For the Month Ended October 31, 20X7 Beginning Cash, September 30, 20X7 Cash Reciepts: Collections from receivables Total cash available during October Cash Disbursements: Merchandise purchases Variable expenses Fixed expenses Ending Cash, October 31, 20X7