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. Budget sales :

  month	october	november	december	january
  Sales in unit	30,000	25,000	40,000	30,000

• collections are expected to be 70% in the month of sale, 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 $28 per unit.
• In addition to meeting the current month's sales demand, management wants to maintain and ending inventory balance of 10% of the next month's sales.
• The ending inventory balance at September 30th is 3,000 units.
• Payment for merchandise is made as follows: 1/2 paid in the month of the purchase, 1/2 paid the month following the purchase.
• The A/P balance at September 30th will be paid in full in October.
• Other monthly expenses to be paid in cash are $300,000

Balance sheet

September 30

Assets

Cash	$16,000
Accounts receivable	250,000
Inventory	84,000
Property, plant and equipment (net of $500,000 accumulated depreciation	980,400
Total assets	$1,330,400

Liabilities and Stockhilders' Equity

Accounts Payable	$40,000
Common Stock	840,000
Retained earnings	450,400
Total liabilities and stockholders' equity	$1,330,400

Required:

1. Prepare a sales budget for October, November and December.
2. Prepare a Schedule of Expected Cash Collections for October, November and December.
3. Prepare a Merchandise Purchases budget for October, November and December.
4. Prepare a Schedule of Expected Cash Disbursements for October, November and December.
5. Prepare Cash Budgets for October, November and December.