Need help please!
Weldon Industrial Gas Corporation supplies acetylene and othercompressed gases to industry. Data regarding the store's operationsfollow:
⢠Sales are budgeted at $340,000 for November, $360,000 forDecember, and $350,000 for January.
⢠Collections are expected to be 75% in the month of sale, 22% inthe month following the sale, and 3% uncollectible.
⢠The cost of goods sold is 68% ofsales. ⢠The company desires an ending merchandise inventory equal to 80%of the cost of goods sold in the following month. Payment formerchandise is made in the month following the purchase.
⢠Other monthly expenses to bepaid in cash are $22,000. ⢠Monthly depreciation is$17,000. ⢠Ignore taxes.
Balance Sheet
October 31 Assets Cash $ 23,000 Accounts receivable(net of allowance for uncollectible accounts) 83,000 MerchandiseInventory 184,960 Property, plant andequipment (net of $668,000 accumulated depreciation) 1,170,000 Total assets $ 1,460,960 Liabilities and Stockholdersâ Equity Accountspayable $ 200,000 Common stock 940,000 Retainedearnings 320,960 Total liabilitiesand stockholdersâ equity $ 1,460,960
Required:
a. Prepare a Schedule of Expected Cash Collections for November andDecember.
WELDON INDUSTRIAL GAS CORPORATION Schedule of Expected Cash Collections November December Sales Scheduleof Expected Cash Collections Accountsreceivable Novembersales Decembersales Totalcash collections
b. Prepare a Merchandise Purchases Budget for November andDecember. (Input all amounts as positive values. Do notround intermediate calculations.)
WELDON INDUSTRIAL GAS CORPORATION Merchandise Purchases Budget November December Budgetedcost of goods sold Totalneeds Requiredpurchase
c. Prepare Cash Budgets for November and December. (Inputall amounts as positive values.)
WELDON INDUSTRIAL GAS CORPORATION Cash Budget November December Cashdisbursements for merchandise Othermonthly cash expenses Totalcash disbursements Cashbalance, beginning Add cashreceipts Totalcash available Less cashdisbursement Excess(deficiency) of cash available over disbursements Financing Cashbalance, ending
d. Prepare Budgeted Income Statements for November andDecember.
WELDON INDUSTRIAL GAS CORPORATION Budgeted Income Statement November December
e. Prepare a Budgeted Balance Sheet for the end of December
WELDON INDUSTRIAL GAS CORPORATION Budgeted Balance Sheet December 31 Assets Total assets Liabilities and Stockholdersâ Equity Total liabilities and stockholdersâ equity
Need help please!
Weldon Industrial Gas Corporation supplies acetylene and othercompressed gases to industry. Data regarding the store's operationsfollow: |
⢠| Sales are budgeted at $340,000 for November, $360,000 forDecember, and $350,000 for January. |
⢠| Collections are expected to be 75% in the month of sale, 22% inthe month following the sale, and 3% uncollectible. |
⢠| The cost of goods sold is 68% ofsales. |
⢠| The company desires an ending merchandise inventory equal to 80%of the cost of goods sold in the following month. Payment formerchandise is made in the month following the purchase. |
⢠| Other monthly expenses to bepaid in cash are $22,000. |
⢠| Monthly depreciation is$17,000. |
⢠| Ignore taxes. |
Balance Sheet October 31 | ||
Assets | ||
Cash | $ | 23,000 |
Accounts receivable(net of allowance for uncollectible accounts) | 83,000 | |
MerchandiseInventory | 184,960 | |
Property, plant andequipment (net of $668,000 accumulated depreciation) | 1,170,000 | |
Total assets | $ | 1,460,960 |
Liabilities and Stockholdersâ Equity | ||
Accountspayable | $ | 200,000 |
Common stock | 940,000 | |
Retainedearnings | 320,960 | |
Total liabilitiesand stockholdersâ equity | $ | 1,460,960 |
Required: |
a. | Prepare a Schedule of Expected Cash Collections for November andDecember. |
|