The following information pertains to Bartholomew Corporation Month Sales (units). Sales (dollars) July 1,500 $45,000 August 1,700 49,300 September 1,900 53,200 October 1,680 50,400 November 1,920 48,000 December 2,400 60,000 January 2,250 60,750 February 2,000 52,000 March 1,800 45,000 April 1,600 41,600 May 1,500 30,000 June 1,400 32,200 Of sales, 20% are in cash with the remainder on account Accounts Receivable is collected from customers in the following manner: Month of sale 40% Month following sale 50% Second month following sale 10% Bartholomew Corporation desires ending inventory for finished goods to be 40% of next month's sales. Each unit requires four pounds of material, cach pound costs $1.25. Bartholomew Corporation desires ending inventory of raw materials should be 50% of next month's needs. Materials are purchased on account. Payments are 30% in the month of purchase with the remainder paid in the following month. The September ending Accounts Payable balance was $6,279 In addition, each unit requires three hours of labor, cach labor hour costs $16. Labor costs are paid for in the month incurred. REQUIRED: 1. Prepare a Revenue budget for October, including revenue, cash collections (include both cash sales and cash collected on account), and the end of month accounts receivable balance. 2. Prepare a Production Budget for October. 3. Prepare a Raw Materials Purchases Budget for October, including.cash disbursements and the end of month accounts payable balance. 4. Prepare the Direct Labor Budget for October showing the payments for the month