please help, stuck on this problem and other answers I found on chegg are too small to read.

2. (12 points) Weldon Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: The company sells each unit for $45. Budgeted Sales: Month October November December January Sales in Units 30,000 25,000 40,00030,000 Collections are expected to be 70% in the month ofsale, 30% in the month following the sale. .The A/R balance at September 30th will be collected in full in October The cost of the merchandise is $38 per unit. In addition to meeting the current month's sales demand, management The ending inventory balance at September 30th is 3,000 units. The A/P balance at September 30th will be paid in full in October wants to maintain and ending inventory balance of 10% of the next month's sales. Payment for merchandise is made as follows: the purchase, % paid the month following the purchase. % paid in the month of * A dividend was paid in October for $500,000. Minimum cash balance is $100,000. The company has a line of credit for $500,000 at an annual interest rate of 12%. Loans are taken out on first day of month borrowed and repaid at the end of the quarter with interest . * Balance Sheet September 30 Assets Cash Accounts receivable250,000 Inventory.. S 100,000 114,000 Property, plant and equipment (net of $200,000 accumulated depreciation) Total assets 866.400 Liabilities and Stockholders Equity Accounts payabile. Common stock Retained earnings... Total liabilities and stockholders' equity S 300,000 582,000 $1,.330400 Required a. Prepare a Sales Budget for October, November, December, and Quarter b. Prepare a Schedule of Expected Cash Collections for October, November c. Prepare a Merchandise Purchases Budget for October, November, December, December, and Quarter Prepare a Schedule of Expected Cash Disbursements for October, November, December, and Quarter Prepare Cash Budgets for October, November, December, and Quarter. d. e. Sales Budget Units Sold Sales Price per unit Total Sales October NovemberDecember Quarter Schedule of Expected Cash Collections Beginning A/R October Sales November Sales December Sales Total October November Quarter Purchases Budget Budgeted Sales +Desired ending October November December Quarter inv. total needs Beginning inv. -Total Purchases X cost per unit -Total purchase cost Schedule of Expected Cash Disbursements October November Quarter Beginning A/P October Purchases December Purchases Total Cash Budget October November December Quarter Beginning Cash bal. +Cash collections -Cash Available Less: Cash Disburse. For Purchases Dividend -Total cash disburse Excess/(Deficiency) Borrowing Repayment Interest Ending Cash bal