Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Fantastic news! We've Found the answer you've been seeking!
Question:
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 Deacon Company Balance Sheet March 31 Cash 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 $ 62,000 43,600 46,000 107,000 $ 258,600 $ 63,600 70,000 125,000 $ 258,600 Budgeted Income Statements April Sales $ 120,000 May $130,000 June $150,000 Cost of goods sold 72,000 78,000 90,000 Gross margin 48,000 52,000 60,000 Selling and administrative expenses 24,900 26,400 29,400 Net operating income $ 23,100 $ 25,600 $ 30,600 Budgeting Assumptions: 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 Deacon Company Balance Sheet March 31 Cash 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 $ 62,000 43,600 46,000 107,000 $ 258,600 $ 63,600 70,000 125,000 $ 258,600 Budgeted Income Statements April Sales $ 120,000 May $130,000 June $150,000 Cost of goods sold 72,000 78,000 90,000 Gross margin 48,000 52,000 60,000 Selling and administrative expenses 24,900 26,400 29,400 Net operating income $ 23,100 $ 25,600 $ 30,600 Budgeting Assumptions: 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 Answer:
Answer rating: 100% (QA)
1 Expected Cash Collections for April May and June Given 60 of sales are cash sales and 40 are credi... View the full answer
Related Book For
Managerial Accounting
ISBN: 9781260247787
17th Edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
(a) ABC is a company that manufactures computer desk. The total costs (in RM'000) when x units of computer desk are produced is given by C(x) = 12x 3 - 198x 2 + 1080x Find the level of x that the...
-
Find a cubic function y = ax3 + bx2 + cx + d whose graph has horizontal tangents at the points (-2, 6) and (2, 0).
-
Summarize the nomenclature rules for alkanes, alkenes, alkynes, and aromatic compounds. Correct the following false statements regarding nomenclature of hydrocarbons. a. The root name for a...
-
A company manufactures geometrically similar airplane propellers up to \(4.0 \mathrm{~m}\) in diameter. Wind tunnel tests are run on geometrically similar propellers up to \(0.33 \mathrm{~m}\) in...
-
Assume Mables of Montana, Inc., completed the following transactions during 2014, the companys 10th year of operations: Feb 3 Issued 10,000 shares of common stock ($ 3.00 par) for cash of $ 297,000....
-
In organizational behavior, understanding the factors that predict organizational performance is crucial for managers and researchers. Numerous theories and studies have attempted to shed light on...
-
Sally Medavoy will invest $8,960 a year for 24 years in a fund that will earn 12% annual interest. Click here to view factor tables If the first payment into the fund occurs today, what amount will...
-
Communication Foundation https://www.linkedin.com/learning/communication-foundations-2 Write about two paragraphs describing "One Day in the life of a Hanson student" as per the attached details....
-
Describe one or more situations that you have encountered thus far in your career in which deeper understanding of lawmaking by legislatures, agencies, or courts would have made you more effective....
-
The cultures and values of different countries must be considered when developing data privacy laws." Can you give us an example of such obstacles to any international legislation?
-
The outsourcing phenomenon has, as one might expect, caused tremendous consternation in the ranks of American workers. To what degree do you think that outsourcing has been a driver for the continued...
-
Developers are required to sell within certain timelines, and ABSD could affect them significantly. With reference to the report, comment on what had happened?...
-
Briefly, describe what is meant by confirmation bias and framing effect and suggest two specific actions managers could take to guard against the influence of these biases.
-
The swap spread is the difference between the swap rate and the equivalent-maturity Treasury bond yield. Explain why a widening swap spread may be a signal of deteriorating economic conditions. Plot...
-
Vertical analysis would rarely be performed on which of the following statements or schedules? a. Income statement b. Adjusting entry worksheet c. Balance sheet d. All of the above are common targets...
-
A statement that lists the assets, liabilities, and stockholders equity of a company in percentages only with no dollar amounts is a a. common-size income statement. b. benchmarking analysis. c....
-
In vertical analysis, the base used for comparison on the income statement is a. total expenses. b. total assets. c. net sales. d. gross profit.
Study smarter with the SolutionInn App