Question
Welnor 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,
Welnor 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, $350,000 for December, and $340,000 for January. | |
Collections are expected to be 70% in the month of sale, 26% in the month following the sale, and 4% uncollectible. | |
The cost of goods sold is 67% of sales. | |
The company desires ending merchandise inventory to equal 85% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase. | |
Other monthly expenses to be paid in cash are $21,900. | |
Monthly depreciation is $16,900. | |
Ignore taxes. |
Balance Sheet October 31 | ||
Assets | ||
Cash | $ | 22,900 |
Accounts receivable (net of allowance for uncollectible accounts) | 82,900 | |
Merchandise Inventory | 187,935 | |
Property, plant and equipment (net of $667,000 accumulated depreciation) | 1,170,000 | |
Total assets | $ | 1,463,735 |
Liabilities and Stockholders Equity | ||
Accounts payable | $ | 199,900 |
Common stock | 930,000 | |
Retained earnings | 333,835 | |
Total liabilities and stockholders equity | $ | 1,463,735 |
Required: |
a. | Prepare a Schedule of Expected Cash Collections for November and December. (Omit the "$" sign in your response.) |
Welnor Industrial Gas Corporation Schedule of Expected Cash Collections | |||
November | December | ||
Sales | $ | $ | |
Schedule of Expected Cash Collections | |||
Accounts receivable | $ | ||
November sales | $ | ||
December sales | |||
Total cash collections | $ | $ | |
b. | Prepare a Merchandise Purchases Budget for November and December. (Input all amounts as positive values. Do not round intermediate calculations. Omit the "$" sign in your response.) |
Welnor Industrial Gas Corporation Merchandise Purchases Budget | |||
November | December | ||
Budgeted cost of goods sold | $ | $ | |
(Click to select)DeductAdd: (Click to select)Desired ending merchandising inventoryBeginning merchandise inventory | |||
Total needs | |||
(Click to select)AddDeduct: (Click to select)Desired ending merchandising inventoryBeginning merchandise inventory | |||
Required purchase | $ | $ | |
c. | Prepare Cash Budgets for November and December. (Leave no cells blank - be certain to enter "0" wherever required. Input all amounts as positive values. Omit the "$" sign in your response.) |
Welnor Industrial Gas Corporation Cash Budget | |||
November | December | ||
Cash disbursements for merchandise | $ | $ | |
Other monthly cash expenses | |||
Total cash disbursements | $ | $ | |
Cash balance, beginning | $ | $ | |
Add cash receipts | |||
Total cash available | |||
Less cash disbursement | |||
Excess (deficiency) of cash available over disbursements | |||
Financing | |||
Cash balance, ending | $ | $ | |
d. | Prepare Budgeted Income Statements for November and December. (Input all amounts as positive values. Omit the "$" sign in your response.) |
Welnor Industrial Gas Corporation Budgeted Income Statement | ||
November | December | |
(Click to select)Gross marginDepreciationSalesBad debt expenseNet operating incomeCost of goods soldOther monthly expenses | $ | $ |
(Click to select)Gross marginCost of goods soldDepreciationNet operating incomeOther monthly expensesAccounts payableSales | ||
(Click to select)Net operating incomeSalesOther monthly expensesDepreciationAccounts payableGross marginCost of goods sold | ||
(Click to select)DepreciationSalesOther monthly expensesNet operating incomeCost of goods soldBad debt expenseGross margin | ||
(Click to select)Bad debt expenseSalesOther monthly expensesNet operating incomeCost of goods soldInventoryGross margin | ||
(Click to select)Gross marginSalesCost of goods soldDepreciationNet operating incomeInventoryBad debt expense | ||
(Click to select)DepreciationOther monthly expensesSalesNet operating incomeCost of goods soldBad debt expenseGross margin | $ | $ |
Please show how answers were calculated. Please only answer if you can help with all not just part of the questions. This is the second time I Have poseted this and I got wrong or imcomplete answers. Thank you so much in advance if you are able to help. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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