Question
Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $330,000 for November,
Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:
- Sales are budgeted at $330,000 for November, $300,000 for December, and $320,000 for January.
- Collections are expected to be 85% in the month of sale, 14% in the month following the sale, and 1% uncollectible.
- The cost of goods sold is 60% of sales.
- The company purchases 80% of its merchandise in the month prior to the month of sale and 20% in the month of sale. Payment for merchandise is made in the month following the purchase.
- Other monthly expenses to be paid in cash are $21,200.
- Monthly depreciation is $21,000.
- Ignore taxes.
| Statement of Financial Position |
|
| October 31 |
|
| Assets: |
|
| Cash | $ 22,000 |
| Accounts receivable (net of allowance for uncollectible accounts) | 83,000 |
| Inventory | 158,400 |
| Property, plant and equipment (net of $594,000 accumulated depreciation) | 1,004,000 |
| Total assets | $1,267,400 |
|
|
|
| Liabilities and Stockholders Equity: |
|
| Accounts payable | $ 196,000 |
| Common stock | 620,000 |
| Retained earnings | 451,400 |
| Total liabilities and stockholders equity | $1,267,400 |
Required:
- How much is the expected cash collection for the month of November?
- How much is the expected cash collection for the month of December?
- How much is the expected disbursement for merchandise for November?
- How much is the expected disbursement for merchandise for December?
- How much is the excess (deficiency) of cash available over disbursement for November?
- How much is the excess (deficiency) of cash available over disbursement for December?
- How much is the net operating income for November?
- How much is the net operating income for December?
- How much is the total assets as of December 31?
- How much is the total liability as of December 31?
- How much is the total retained earnings as of December 31?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started