Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648703be31d8_3556648703b6ecd1.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648703cac8dc_3566648703c4f657.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648703d4e6ca_3566648703cdf981.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648703de3642_3576648703d8a7c6.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648703e811b6_3586648703e238a4.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648703f22da8_3586648703ebc55e.jpg)
Transcribed Image Text:
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, $350,000 for December, and $340,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 70% of sales. The company desires an ending merchandise inventory equal to 70% 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 $21,300. Monthly depreciation is $21,100. Ignore taxes. Assets Balance Sheet October 31 Cash Accounts receivable Merchandise inventory Property, plant and equipment (net of $595,000 accumulated depreciation) Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity Required: $ 22,100 83,100 161,700 1,005,000 $ 1,271,900 $ 196,100 630,000 445,800 $ 1,271,900 Required A Required B Required C Required D Required E Prepare a Schedule of Expected Cash Collections for November and December. Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total cash collections November December $ 0 $ 0 Required A Required B > Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Prepare a Merchandise Purchases Budget for November and December. Budgeted cost of goods sold Total needs Required purchases November December 0 0 $ 0 $ < Required A Required C > Required A Required B Required C Required D Required E Prepare Cash Budgets for November and December. Cash disbursements for merchandise Other monthly cash expenses Total cash disbursements Beginning cash balance Add cash receipts Total cash available Less cash disbursements Excess (deficiency) of cash available over disbursements Financing Ending cash balance < Required B November December $ 0 $ 0 0 0 0 $ 0 $ 0 Required D > Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Prepare Budgeted Income Statements for November and December. Sales Cost of goods sold Other monthly expenses Depreciation November December 0 0 $ 0 $ 0 < Required C Required E > Required A Required B Required C Required D Required E Prepare a Budgeted Balance Sheet for the end of December. Assets Cash Accounts receivable Balance Sheet December 31 Inventory Property, plant and equipment (net of accumulated depreciation) Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity < Required D $ 0 $ Required E > 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, $350,000 for December, and $340,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 70% of sales. The company desires an ending merchandise inventory equal to 70% 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 $21,300. Monthly depreciation is $21,100. Ignore taxes. Assets Balance Sheet October 31 Cash Accounts receivable Merchandise inventory Property, plant and equipment (net of $595,000 accumulated depreciation) Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity Required: $ 22,100 83,100 161,700 1,005,000 $ 1,271,900 $ 196,100 630,000 445,800 $ 1,271,900 Required A Required B Required C Required D Required E Prepare a Schedule of Expected Cash Collections for November and December. Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total cash collections November December $ 0 $ 0 Required A Required B > Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Prepare a Merchandise Purchases Budget for November and December. Budgeted cost of goods sold Total needs Required purchases November December 0 0 $ 0 $ < Required A Required C > Required A Required B Required C Required D Required E Prepare Cash Budgets for November and December. Cash disbursements for merchandise Other monthly cash expenses Total cash disbursements Beginning cash balance Add cash receipts Total cash available Less cash disbursements Excess (deficiency) of cash available over disbursements Financing Ending cash balance < Required B November December $ 0 $ 0 0 0 0 $ 0 $ 0 Required D > Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Prepare Budgeted Income Statements for November and December. Sales Cost of goods sold Other monthly expenses Depreciation November December 0 0 $ 0 $ 0 < Required C Required E > Required A Required B Required C Required D Required E Prepare a Budgeted Balance Sheet for the end of December. Assets Cash Accounts receivable Balance Sheet December 31 Inventory Property, plant and equipment (net of accumulated depreciation) Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity < Required D $ 0 $ Required E >
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Consider a lottery L1 = [0.5, A; 0.5, L2], where U(A) = 4, and L2 = [0.5, X; 0.5, Y] is a lottery, and U(X) = 4, U(Y) = 8. What is the utility of the the first lottery, U(L1)?
-
Why should human resource departments measure their effectiveness? What are some ways they can go about measuring effectiveness?
-
When would the sum of the break-even quantities for each of a companys products not be the break-even point for the company as a whole?
-
Presented below are the beginning-of-year common share price (P t-1 ), the end-of-year common share price (P t ), and the annual dividend (D t ) for three competitorsGeneral Electric, Philipps...
-
The Paymore Rental Car Agency rents cars in a small town. It wants to determine how many rental cars it should maintain. Based on market projections and historical data, the manager has determined...
-
10 0 0.9 0.5 The correlation coefficient between a stock and the market portfolio is 0.6. The standard deviation of return of the stock is 20 percent and that of the market portfolio is 15 percent...
-
Solve the problem using 6.2%, up to $128,400 for Social Security tax and using 1.45%, no wage limit, for Medicare tax.Calculate the monthly Social Security and Medicare withholdings (in $) for the...
-
An engineering student in charge of the Engineering Technology Innovation Club (ETIC), that takes on projects to develop new and often inventive technology, comes into the business law clinic at your...
-
Xstar Corporation's cost of capital is 5.65%. Income statements of the Xstar for 2019 and 2020 are given below: 2019 2020 NET SALES 6,026...
-
Your submissions must have a clear, well formulated idea; and sentence structure, grammar, punctuation, spelling count. Your submissions should be insightful, thoughtful, and analytical and must...
-
Suppose an open-ended mutual fund contains 100 shares of Walmart currently trading at $120, 1,000 shares of Target currently trading at $110, and 500 shares of Costco currently trading at $300. The...
-
Assume that the differences are normally distributed. Complete parts (a) through (d) below. 7 41.5 46.3 Observation 1 2 3 42.3 48.4 49.9 45.9 48.8 53.8 47.2 X Y (a) Determine d; = X - Y for each pair...
-
The population of the ages of all Two-Year community college students has a mean of 27.4 years and a standard deviation of 5.8 years. What is the probability that a random sample of 49 students...
-
How much more interest will be earned if $5000 is invested for 6 years at 7% compounded continuously, instead of at 7% compounded quarterly?
-
Which of the following statements is false? a. A flowchart is an analytical technique used to describe some aspect of an information system in a clear, concise, and logical manner. b. Flowcharts use...
-
A DFD consists of the following four basic elements: data sources and destinations, data flows, transformation processes, and data stores. Each is represented on a DFD by a different symbol. a. True...
-
Which of the following flowcharts illustrates the flow of information among areas of responsibility in an organization? a. program flowchart c. system flowchart b. computer configuration chart d....
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App