Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $310,000 for November, $330,000 for December, and $320,000 for January. Collections are expected to be 80% in the month of sale and 20% in the month following the sale. The cost of goods sold is 77% of sales. The company desires an ending merchandise inventory equal to 85% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. Other monthly expenses to be paid in cash are $20,500. Monthly depreciation is $20,300. Ignore income tax. Weller Industrial Gas Corporation Balance Sheet October 31 Assets Cash $ 21,300 Accounts receivable 82,300 Merchandise inventory 202,895 Property, plant and equipment (net of $589,000 accumulated depreciation) 999,000 Total assets $ 1,305,495 Liabilities and shareholder' Equity Accounts payable $ 195,300 Common shares 540,000 Retained earnings 570,195 Total liabilities and shareholder' equity $ 1,305,495 BUSI 3320 Winter 2024 Required: Use Excel to a) Prepare a Schedule of Expected Cash Collections for November and December. b) Prepare a Merchandise Purchases Budget for November and December. c) Prepare a Schedule of Expected Cash Disbursements for November and December. d) Prepare a Cash Budget for November and December. e) Prepare a Budgeted Income Statements for November and December.