1. Wayne Wrench Works (www), a manufacturer of precision wrenches and tools has developed the following sales and sales forecast figures: September (actual) October November December January 20,000 units 15,000 10,000 15,000 20,000 Selling price is $30 per unit. Based on prior experience, it is expected that 60% of sales will be collected in the month of sale with the remaining 40% collected in the month following. Production each month is 100% of that month's forecast sales. Projected unit production costs are forecast at $10 for raw materials (an decrease from the $11 paid up through September), $6 for direct labor, and $4 for variable overhead. Raw materials sufficient for that month's production are purchased each month and paid for the following month. Direct labor and overhead costs are paid for in the month incurred. Selling and administrative expense is budgeted at 12% of sales and is paid in the month incurred. Depreciation expense is $25,000 each month. Cash on the 9/30 Balance Sheet is $50,000 which is the minimum cash balance used for planning. WWW holds no marketable securities at 9/30. WWW is planning to buy $100,000 of new equipment to be delivered and paid for in October. Tax payments of $50,000 will be made in October and January a) Calculate cash collections for October. b) Calculate total cash disbursements for November c) For November, determine the amount of excess cash or borrowing that WWW will have. d) What will Accounts Payable be on a 12/31 pro-forma balance sheet? e) What will Accounts Receivable be on a 12/31 pro-forma balance sheet