Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Assets Cash Deacon Company Balance Sheet March 31 Accounts receivable. Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity Budgeted Income Statements Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating income Budgeting Assumptions: $ 62,000 43,600 46,000 107,000 $ 258,600 $ 63,600 70,000 125,000 $ 258, 600 May April $ 120,000 $ 130,000 78,000 72,000 48,000 24,900 $ 23,100 $ 25,600 52,000 26,400 June $ 150,000 90,000 60,000 29,400 $ 30,600 a. 60% of sales are cash sales and 40% of sales are credit sales. Twenty percent of all credit sales are collected in the month of sale and the remaining 80% are collected in the month subsequent to the sale. b. Budgeted sales for July are $160,000. c. 10% of merchandise inventory purchases are paid in cash at the time of the purchase. The remaining 90% of purchases are credit purchases. All purchases on credit are paid in the month subsequent to the purchase. The accounts payable at March 31 will be paid in April. d. Each month's ending merchandise inventory should equal $10,000 plus 50% of the next month's cost of goods sold. e. Depreciation expense is $1,900 per month. All other selling and administrative expenses are paid in full in the month the expense is incurred. Required: 1. Calculate the expected cash collections for April, May, and June. 2. Calculate the budgeted merchandise purchases for April, May, and June. 3. Calculate the expected cash disbursements for merchandise purchases for April, May, and June. 4. Prepare a budgeted balance sheet at June 30th. (Hint: You need to calculate the cash paid for selling and administrative expenses during April, May, and June to determine the cash balance in your June 30th balance sheet.)
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Assets Cash Deacon Company Balance Sheet March 31 Accounts receivable. Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity Budgeted Income Statements Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating income Budgeting Assumptions: $ 62,000 43,600 46,000 107,000 $ 258,600 $ 63,600 70,000 125,000 $ 258, 600 May April $ 120,000 $ 130,000 78,000 72,000 48,000 24,900 $ 23,100 $ 25,600 52,000 26,400 June $ 150,000 90,000 60,000 29,400 $ 30,600 a. 60% of sales are cash sales and 40% of sales are credit sales. Twenty percent of all credit sales are collected in the month of sale and the remaining 80% are collected in the month subsequent to the sale. b. Budgeted sales for July are $160,000. c. 10% of merchandise inventory purchases are paid in cash at the time of the purchase. The remaining 90% of purchases are credit purchases. All purchases on credit are paid in the month subsequent to the purchase. The accounts payable at March 31 will be paid in April. d. Each month's ending merchandise inventory should equal $10,000 plus 50% of the next month's cost of goods sold. e. Depreciation expense is $1,900 per month. All other selling and administrative expenses are paid in full in the month the expense is incurred. Required: 1. Calculate the expected cash collections for April, May, and June. 2. Calculate the budgeted merchandise purchases for April, May, and June. 3. Calculate the expected cash disbursements for merchandise purchases for April, May, and June. 4. Prepare a budgeted balance sheet at June 30th. (Hint: You need to calculate the cash paid for selling and administrative expenses during April, May, and June to determine the cash balance in your June 30th balance sheet.)
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following
information is available
Assets
Cashi
Deacon Company
Balance Sheet
March 31
Accounts receivable
Inventory
Buildings and equipment, net of depreciation
Total assets
Liabilities and Stockholders' Equity
Accounts payable
Common stock
Retained earnings
Total liabilities and stockholders' equity
Budgeted Income Statements
Sales
Cost of goods sold
Gross margin
Selling and administrative expenses.
Net operating income
Budgeting Assumptions:
$ 62,000
43,600
46,000
107,000
$ 258,600
$
$ 63,600
70,000
125,000
258, 600
April
May
$ 120,000 $ 130,000
72,000
78,000
48,000
52,000
24,900
26,400
$ 23,100 $ 25,600
June
$ 150,000
90,000
60,000
29,400
$ 30,600
a. 60% of sales are cash sales and 40% of sales are credit sales. Twenty percent of all credit sales are collected in the month of sale
and the remaining 80% are collected in the month subsequent to the sale.
b. Budgeted sales for July are $160,000.
c. 10% of merchandise inventory purchases are paid in cash at the time of the purchase. The remaining 90% of purchases are credit
purchases. All purchases on credit are paid in the month subsequent to the purchase. The accounts payable at March 31 will be
paid in April.
d. Each month's ending merchandise inventory should equal $10,000 plus 50% of the next month's cost of goods sold.
e. Depreciation expense is $1,900 per month. All other selling and administrative expenses are paid in full in the month the expense is
incurred.
Required:
1. Calculate the expected cash collections for April, May, and June.
2. Calculate the budgeted merchandise purchases for April, May, and June.
3. Calculate the expected cash disbursements for merchandise purchases for April, May, and June.
4. Prepare a budgeted balance sheet at June 30th. (Hint: You need to calculate the cash paid for selling and administrative expenses
during April, May, and June to determine the cash balance in your June 30th balance sheet.)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fcee8e356-fbb7-424e-9ef3-2901ab2f7d28%2F4c35e6c9-e2c6-4cab-a239-8c720e264e8c%2Fh9yj3la_processed.png&w=3840&q=75)
Transcribed Image Text:Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following
information is available
Assets
Cashi
Deacon Company
Balance Sheet
March 31
Accounts receivable
Inventory
Buildings and equipment, net of depreciation
Total assets
Liabilities and Stockholders' Equity
Accounts payable
Common stock
Retained earnings
Total liabilities and stockholders' equity
Budgeted Income Statements
Sales
Cost of goods sold
Gross margin
Selling and administrative expenses.
Net operating income
Budgeting Assumptions:
$ 62,000
43,600
46,000
107,000
$ 258,600
$
$ 63,600
70,000
125,000
258, 600
April
May
$ 120,000 $ 130,000
72,000
78,000
48,000
52,000
24,900
26,400
$ 23,100 $ 25,600
June
$ 150,000
90,000
60,000
29,400
$ 30,600
a. 60% of sales are cash sales and 40% of sales are credit sales. Twenty percent of all credit sales are collected in the month of sale
and the remaining 80% are collected in the month subsequent to the sale.
b. Budgeted sales for July are $160,000.
c. 10% of merchandise inventory purchases are paid in cash at the time of the purchase. The remaining 90% of purchases are credit
purchases. All purchases on credit are paid in the month subsequent to the purchase. The accounts payable at March 31 will be
paid in April.
d. Each month's ending merchandise inventory should equal $10,000 plus 50% of the next month's cost of goods sold.
e. Depreciation expense is $1,900 per month. All other selling and administrative expenses are paid in full in the month the expense is
incurred.
Required:
1. Calculate the expected cash collections for April, May, and June.
2. Calculate the budgeted merchandise purchases for April, May, and June.
3. Calculate the expected cash disbursements for merchandise purchases for April, May, and June.
4. Prepare a budgeted balance sheet at June 30th. (Hint: You need to calculate the cash paid for selling and administrative expenses
during April, May, and June to determine the cash balance in your June 30th balance sheet.)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education