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 Deacon Company Balance Sheet March 31 Assets 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 $ 71,800 42,800 46,000 149,000 $ 309,600 $ 125,100 70,000 114,500 $ 309,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 18,100 19,600 22,600 Net operating income $ 29,900 $ 32,400 $ 37,400 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,850 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 Deacon Company Balance Sheet March 31 Assets 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 $ 71,800 42,800 46,000 149,000 $ 309,600 $ 125,100 70,000 114,500 $ 309,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 18,100 19,600 22,600 Net operating income $ 29,900 $ 32,400 $ 37,400 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,850 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:
Related Book For
Managerial Accounting
ISBN: 9781260247787
17th Edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
Each student in a class of 40 plays either ml,dota or cs go.18 play ml,20 play cs go,and 27 play dota.7 play ml and cs go,12 play cs go and dota,and 4 play ml,dota and cs go.find the number of...
-
In Problems 11 54, simplify each expression. Assume that all variables are positive when they appear. 2 ( 5 29 )
-
Consider Exercise 8-38. Determine the sensitivity of the control limits on the complication rate, using values of 0.2% and 0.5%. TABLE 8-27 Complication NumberofComplication Number of Complication...
-
Aggregate planning should consider information from only the enterprise as its breadth of scope. only downstream partners to produce forecasts. only upstream partners to determine constraints. all of...
-
Shahrukh Khanna promotes Shahrukh Khanna and Sons, his proprietary firm, to start business of trading in mobile phones on 1st April 2006. He hires a showroom at D-15, South Ext., New Delhi @ ` 12,000...
-
A handclap on stage in an amphitheater sends out sound waves that scatter from terraces of width w = 0.75 m (Figure). The sound returns to the stage as a periodic series of pulses, one from each...
-
On May 20, the board of directors for Auction.com declared a cash dividend of 50 cents per share payable to stockholders of record on June 14. The dividends are paid on July 14. The company has...
-
1. How many inner, outer, and valence electrons are present in an atom of each of the following elements? (a) O (b) Sn (c) Ca (d) Fe 2. Identify each element below, and give the symbols of the other...
-
Population growth leads to increased industrial output and societal well-being until 2030, after which a crash occurs. Stable population and industrial output lead to a gradual improvement in...
-
Choose a project that you have worked with in your organisation and define clearly, what is meant by resource smoothing. Thereafter, proceed to elucidate the steps that you, as the project manager,...
-
On the menu at "UPRC Caf" there is a lamb dish that sells for about $25.00, the variable costs associated with this dish, as scheduled, is about $9.75. What is the contribution margin for this dish?...
-
During 20X6, W sold the interest she had held for five years in the WX Partnership for $15,000 cash. The buyer also assumed W's $2,000 share of the partnership liabilities. W's tax basis in the...
-
On a MS Project file, I've already done the first step of the assignment. Now I have to do the other part. It's asking me: Assume that roughly 50% of the project duration has now passed. Change the...
-
1. What are the business costs or risks of poof data quality? 2. What is data mining? 3. What is text mining?
-
Reduction in sales All of the above 29. Belt of an electric motor is broken, it needs a. Corrective maintenance b. Scheduled maintenance c. Preventive maintenance d. Timely maintenance. 30. The...
-
Scientists propose that the first macromolecules in protobionts were a. DNA molecules. b. RNA molecules. c. proteins. d. all of the above.
-
Which of the following function(s) is/are carried out by piRITS or piRISC? a. Inhibits transcription of TEs b. Causes the degradation of TE RNA c. Causes chromosome breakage d. Both a and b are...
-
In the CRISPR-Cas system, what does tracrRNA bind to? a. crRNA and Cas1 protein b. crRNA and Cas2 protein c. crRNA and Cas9 protein d. Cas1 and Cas2 proteins
Study smarter with the SolutionInn App