Question: Please complete requirements A, B, C, D, and E. Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry: Data regarding the stores





Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry: Data regarding the stores operations follow: - Sules are budgeted at \$350,000 for November, $370,000 for December, and $360,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 72% of salos. - The company desires an ending merchandise inventory eoual to 80% of the cost of noods 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,500 - Monthly depreciation is $21,300. - Ignore taxes. 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. Complete this question by entering your answers in the tabs below. Prepare a Schedule of Expected Cash Collections for November and December. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and Decembet. c. Prepare Cash Budgets for November and December. d. Prepare Budgeted tncome Statements for November and December: e. Prepare a Budgeted Balance Sheet for the end of Decembet: Complete this question by entering your answers in the tabs below. Prepare a Merchandise Purchases Budget for November and December. 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: Complete this question by entering your answers in the tabs below. Prepare Cash Budgets for November and December. 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 tncome Statements for November and December. e. Prepare a Budgeted Balance Sheet for the end of December. Complete this question by entering your answers in the tabs below. Prepare Budgeted Income Statements for November and December. 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. c. Prepare a Budgeted Balance Sheet for the end of December. Complete this question by entering your answers in the tabs below. Prepare a Budgeted Balance Sheet for the end of December
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
