Question

Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...

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 $ 60,000
Accounts receivable 30,000
Inventory 43,900
Buildings and equipment, net of depreciation 131,000
Total assets $ 264,900
Liabilities and Stockholders’ Equity
Accounts payable $ 72,000
Common stock 70,000
Retained earnings 122,900
Total liabilities and stockholders’ equity $ 264,900
Budgeted Income Statements
April May June
Sales $ 113,000 $ 123,000 $ 143,000
Cost of goods sold 67,800 73,800 85,800
Gross margin 45,200 49,200 57,200
Selling and administrative expenses 17,000 18,500 21,500
Net operating income $ 28,200 $ 30,700 $ 35,700

Budgeting Assumptions:

  1. 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.

  2. Budgeted sales for July are $153,000.

  3. 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.

  4. Each month’s ending merchandise inventory should equal $10,000 plus 50% of the next month’s cost of goods sold.

  5. Depreciation expense is $1,050 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.)

Homework Answers

Answer #1

ANSWER

_____________________________________________

If you have any query or any Explanation please ask me in the comment box, i am here to helps you.please give me positive rating.

*****************THANK YOU**************

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
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 $ 55,000 Accounts receivable 36,000 Inventory 40,000 Buildings and equipment, net of depreciation 100,000 Total assets $ 231,000 Liabilities and Stockholders’ Equity Accounts payable $ 51,300 Common stock 70,000 Retained earnings 109,700 Total liabilities and stockholders’ equity $ 231,000 Budgeted Income Statements April May June Sales $ 100,000 $...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
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 $ 60,200 Accounts receivable 30,800 Inventory 60,400 Buildings and equipment, net of depreciation 124,000 Total assets $ 275,400 Liabilities and Stockholders’ Equity Accounts payable $ 71,100 Common stock 70,000 Retained earnings 134,300 Total liabilities and stockholders’ equity $ 275,400 Budgeted Income Statements April May June Sales $ 168,000 $ 178,000 $ 198,000 Cost of goods...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 79,200 Accounts receivable 68,600 Inventory 40,200 Buildings and equipment, net of depreciation 213,000 Total assets $ 401,000 Liabilities and Stockholders’ Equity Accounts payable $ 56,000 Common stock 100,000 Retained earnings 245,000 Total liabilities and stockholders’ equity $ 401,000 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Brothers Corporation is a merchandising company that is preparing a master budget for the third quarter...
Brothers Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: brothers Corporation Balance Sheet June 30 Assets Cash $ 81,000 Accounts receivable 132,000 Inventory 56,250 Plant and equipment, net of depreciation 214,000 Total assets $ 483,250 Liabilities and Stockholders’ Equity Accounts payable $ 75,000 Common stock 346,000 Retained earnings 62,250 Total liabilities and stockholders’ equity $ 483,250 The company...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Hamby Corporation Balance Sheet June 30 Assets Cash $ 76,000 Accounts receivable 137,000 Inventory 86,100 Plant and equipment, net of depreciation 230,000 Total assets $ 529,100 Liabilities and Stockholders’ Equity Accounts payable $ 91,000 Common stock 312,000 Retained earnings 126,100 Total liabilities and stockholders’ equity $ 529,100 The company...
Cousins Corporation is a merchandising company that is preparing a master budget for the third quarter...
Cousins Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Cousins Corporation Balance Sheet June 30 Assets Cash $ 81,000 Accounts receivable 132,000 Inventory 56,250 Plant and equipment, net of depreciation 214,000 Total assets $ 483,250 Liabilities and Stockholders’ Equity Accounts payable $ 75,000 Common stock 346,000 Retained earnings 62,250 Total liabilities and stockholders’ equity $ 483,250 The company...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 83,000 Accounts receivable 126,000 Inventory 69,750 Plant and equipment, net of depreciation 220,000 Total assets $ 498,750 Liabilities and Stockholders’ Equity Accounts payable $ 81,000 Common stock 348,000 Retained earnings 69,750 Total liabilities and stockholders’ equity $ 498,750 Exercise 8-12...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 85,000 Accounts receivable 141,000 Inventory 83,250 Plant and equipment, net of depreciation 226,000 Total assets $ 535,250 Liabilities and Stockholders’ Equity Accounts payable $ 87,000 Common stock 350,000 Retained earnings 98,250 Total liabilities and stockholders’ equity $ 535,250 Exercise 8-12...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Hamby Corporation Balance Sheet June 30 Assets Cash $ 95,000 Accounts receivable 142,000 Inventory 54,000 Plant and equipment, net of depreciation 225,000 Total assets $ 516,000 Liabilities and Stockholders’ Equity Accounts payable $ 86,000 Common stock 332,000 Retained earnings 98,000 Total liabilities and stockholders’ equity $ 516,000 The company...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Hamby Corporation Balance Sheet June 30 Assets Cash $ 84,000 Accounts receivable 144,000 Inventory 63,750 Plant and equipment, net of depreciation 223,000 Total assets $ 514,750 Liabilities and Stockholders’ Equity Accounts payable $ 84,000 Common stock 349,000 Retained earnings 81,750 Total liabilities and stockholders’ equity $ 514,750 The company...