Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: • Sales are budgeted at $360,000 for November, $380,000 for December, and $370,000 for January. • Collections are expected to be 75% in the month of sale and 25% in the month following the sale. • The cost of goods sold is 70% of sales. • The company desires an ending merchandise inventory equal to 85% 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 $20,000. • Monthly depreciation is $19,800. • Ignore taxes. Balance Sheet October 31 Assets Cash 2$ 20,800 81,800 214,200 994,000 Accounts receivable Merchandise inventory Property, plant and equipment (net of $584,000 accumulated depreciation) Total assets $1,310,800 Liabilities and Stockholders' Equity Accounts payable $ 194,800 490,000 626,000 Common stock Retained earnings Total liabilities and stockholders' equity $1,310,800 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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
100%
Accounts payable
490,000
626,000
Common stock
Retained earnings
Total liabilities and stockholders' equity
$1,310,800
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.
Required A
Required B
Required C
Required D
Required E
Prepare a Schedule of Expected Cash Collections for November and December.
November
December
Sales
Schedule of Expected Cash Collections
Accounts receivable
November sales
December sales
Total cash collections
< Required A
Required B >
Transcribed Image Text:Accounts payable 490,000 626,000 Common stock Retained earnings Total liabilities and stockholders' equity $1,310,800 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. Required A Required B Required C Required D Required E Prepare a Schedule of Expected Cash Collections for November and December. November December Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total cash collections < Required A Required B >
Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations
follow:
Sales are budgeted at $360,000 for November, $380,000 for December, and $370,000 for January.
• Collections are expected to be 75% in the month of sale and 25% in the month following the sale.
• The cost of goods sold is 70% of sales.
• The company desires an ending merchandise inventory equal to 85% 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 $20,000.
Monthly depreciation is $19,800.
Ignore taxes.
Balance Sheet
October 31
Assets
Cash
$
20,800
81,800
214, 200
Accounts receivable
Merchandise inventory
Property, plant and equipment (net of $584,000 accumulated depreciation)
994,000
Total assets
$1,310,800
Liabilities and Stockholders' Equity
Accounts payable
$ 194,800
490,000
Common stock
Retained earnings
626,000
Total liabilities and stockholders' equity
$1,310,800
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.
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 $360,000 for November, $380,000 for December, and $370,000 for January. • Collections are expected to be 75% in the month of sale and 25% in the month following the sale. • The cost of goods sold is 70% of sales. • The company desires an ending merchandise inventory equal to 85% 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 $20,000. Monthly depreciation is $19,800. Ignore taxes. Balance Sheet October 31 Assets Cash $ 20,800 81,800 214, 200 Accounts receivable Merchandise inventory Property, plant and equipment (net of $584,000 accumulated depreciation) 994,000 Total assets $1,310,800 Liabilities and Stockholders' Equity Accounts payable $ 194,800 490,000 Common stock Retained earnings 626,000 Total liabilities and stockholders' equity $1,310,800 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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 6 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education