Botanical 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 $10 per case. At the end of each month, it is desired to have an inventory equal in units to 60% of the following month's sales in units. (Click the loon to view the sales date.) Exclusive of bad debts, total budgeted selling and general administrative expenses for the fiscal year are estimated at $76,000, of which $20,000 is fixed expense (which includes a $6,800 annual depreciation charge). The Botanical 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 Botanical Company. Requirement 1. Prepare a statement of estimated cash receipts and disbursements for October 20X7 for the Botanical 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 Desired ending inventory September October Plus: Cast 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 Payments for October purchases Payments for September purchases Disbursements for purchases October