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:
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 $370,000 for November, $390,000 for December, and $380,000 for January. Collections are expected to be 70% in the month of sale and 30% in the month following the sale. The cost of goods sold is 68% of sales. The company desires an ending merchandise inventory equal to 65% 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 $19,900. Monthly depreciation is $19,700. Ignore taxes. Assets Cash Balance Sheet October 31 $ 20,700 Accounts receivable Merchandise inventory Property, plant and equipment (net of $583,000 accumulated depreciation) Total assets Liabilities and Stockholders' Equity Common stock Accounts payable Retained earnings 81,700 163,540 993,000 $ 1,258,940 $ 194,700 480,000 584,240 $ 1,258,940 Total liabilities and stockholders' equity Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. c. Prepare Cash Budgets for November and December. d. Prepare Budgeted Income Statements for November and December. e. Prepare a Budgeted Balance Sheet for the end of December. Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $370,000 for November, $390,000 for December, and $380,000 for January. Collections are expected to be 70% in the month of sale and 30% in the month following the sale. The cost of goods sold is 68% of sales. The company desires an ending merchandise inventory equal to 65% 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 $19,900. Monthly depreciation is $19,700. Ignore taxes. Assets Cash Balance Sheet October 31 $ 20,700 Accounts receivable Merchandise inventory Property, plant and equipment (net of $583,000 accumulated depreciation) Total assets Liabilities and Stockholders' Equity Common stock Accounts payable Retained earnings 81,700 163,540 993,000 $ 1,258,940 $ 194,700 480,000 584,240 $ 1,258,940 Total liabilities and stockholders' equity Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. c. Prepare Cash Budgets for November and December. d. Prepare Budgeted Income Statements for November and December. e. Prepare a Budgeted Balance Sheet for the end of December.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
(10%) Problem 10: Suppose A = (-3.67 m)i + (4.57 m)j, B = (2.52 m)i + (-4.17 m)j + (2.39 m)k, and D= (-2.89 m)i + (-5.99 m)j. 50% Part (a) What is the angle, in degrees, between D and A? 0=11547...
-
Packer, Inc., a U.S. producer of computer disks, plans to establish a subsidiary in Mexico in order to penetrate the Mexican market. Packers executives believe that the Mexican pesos value is...
-
The state of Ohio has several statewide lottery options. One is the Pick 3 game in which you pick one of the 1000 three-digit numbers between 000 and 999. The lottery selects a three-digit number at...
-
For each of the following items, a through f, indicate whether the item represents (1) an advantage or (2) a disadvantage of downsizing. a. Decease in employee morale b. Incurrence of costs due to...
-
Consider the following transactions of Pearl Software: Mar 31 Recorded cash sales of $180,000, plus sales tax of 8% collected for the state of Texas. Apr 6 Sent March sales tax to the state....
-
How you behave or may behave in political situations that occur in your workplace or in your private life.
-
Vine plc. produces a single product. The following information on inventory, purchases, and sales are available for the month of January 2018. DATE TRANSACTION NUMBER OF UNITS UNIT COST...
-
During January the following purchase transactions occurred: 8-Jan Purchased $5,900 of merchandise from The Chocolate Shop. Terms 2/15, n/45, FOB shipping point. The Candy Store prepaid...
-
ds Suppose quantity s is a length and quantity t is a time. Suppose the quantities v and a are defined by v = (a) What is the dimension of v? and a= dt dv dt (Use the following as necessary: Land T.)...
-
Required ( be sure to label each part of your answers ( 1 2 a , 1 2 b , 1 2 c ) : 1 2 . a . What is the name of the file that contains a record that stores the data regarding G . H . Allen s unpaid...
-
1 - In a digital world of businesses, you as manager have two options to explore new product development potential areas. A) Copy other competitors' ideas and improve productivity to increase...
-
What is the break even point in unit cells and dollars for each type of filter at the current sales mix?
-
Describe a unit root process and show that it does not have a constant limited variance.
-
Show that the peak of the black body spectrum as a function of ? is given by eq. (22.14) kg T Wmax = 2.82
-
Calculate the dividend yield for Evans \& Sons for 2018 and 2019. Did the dividend yield improve from 2018 to 2019? Evans \& Sons, Inc., disclosed the following information in a recent annual report:...
-
Calculate the dividend payout for Evans \& Sons for 2018 and 2019. Did the dividend payout increase from 2018 to 2019 ? Evans \& Sons, Inc., disclosed the following information in a recent annual...
-
What is equity capital? Explain the advantages to the firm of raising capital this way. What are the disadvantages?
Study smarter with the SolutionInn App