Xander Manufacturing is preparing a cash budget for the months of September and October They have determined that a minimum cash balance of $75,000 is required. Any required borrowings take place in increments of $1,000 with annual interest of 8%. Repayment of borrowed funds is also made in increments of $1,000. Assume that borrowings are made on the first day of the month in which the cash is required, and the repayments are made on the last day of a month in which cash is available. On September 1, the cash balance will be $160,000 Sales data are as follows: July $600,000 August 650,000 September 700,000 October 625,000 November 720,000 December 800,000 Twenty percent (20%) of sales are cash sales and 80% are credit sales. Experience has shown that 30% of accounts receivable are collected in the month of the sale, 40% the month following the sale, and 25% are collected in the second month following the sale. The remaining receivables are deemed uncollectable. Budgeted inventory purchases are as follows: July $240,000 August 260,000 September 280,000 October 250,000 Cummings Inc. pays 50% of their inventory purchases the month of the purchase and 50% the following month. Budgeted expenses for September and October are as follows: September October Advertising $36,000 $30,000 Salaries 324,000 259,200 Depreciation 55,000 55,000 Insurance 60,000 Property taxes 40,000 A new machine was purchased to replace their old machine. The new machine cost $20,000 was received in September and paid for in cash. They were successful in finding a buyer for their old machine in October and received $7,500 cash. REQUIRED: Prepare a cash budget for Xander Manufacturing for the months of September and October. Include the calculations that you used to arrive at your entry