Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...

90.2K

Verified Solution

Question

Accounting

Beech Corporation is a merchandising company that is preparing amaster budget for the third quarter of the calendar year. Thecompany’s balance sheet as of June 30th is shown below:

Beech Corporation
Balance Sheet
June 30
Assets
Cash$84,000
Accounts receivable144,000
Inventory63,750
Plant and equipment, net of depreciation223,000
Total assets$514,750
Liabilities and Stockholders’Equity
Accounts payable$84,000
Common stock349,000
Retained earnings81,750
Total liabilities and stockholders’ equity$514,750

Beech’s managers have made the following additional assumptionsand estimates:

  1. Estimated sales for July, August, September, and October will be$340,000, $360,000, $350,000, and $370,000, respectively.

  2. All sales are on credit and all credit sales are collected. Eachmonth’s credit sales are collected 35% in the month of sale and 65%in the month following the sale. All of the accounts receivable atJune 30 will be collected in July.

  3. Each month’s ending inventory must equal 25% of the cost of nextmonth’s sales. The cost of goods sold is 75% of sales. The companypays for 40% of its merchandise purchases in the month of thepurchase and the remaining 60% in the month following the purchase.All of the accounts payable at June 30 will be paid in July.

  4. Monthly selling and administrative expenses are always $44,000.Each month $6,000 of this total amount is depreciation expense andthe remaining $38,000 relates to expenses that are paid in themonth they are incurred.

  5. The company does not plan to borrow money or pay or declaredividends during the quarter ended September 30. The company doesnot plan to issue any common stock or repurchase its own stockduring the quarter ended September 30.

Required:

1. Prepare a schedule of expected cash collections for July,August, and September. Also compute total cash collections for thequarter ended September 30.

2-a. Prepare a merchandise purchases budget for July, August,and September. Also compute total merchandise purchases for thequarter ended September 30.

2-b. Prepare a schedule of expected cash disbursements formerchandise purchases for July, August, and September. Also computetotal cash disbursements for merchandise purchases for the quarterended September 30.

3. Prepare an income statement for the quarter ended September30.

4. Prepare a balance sheet as of September 30.

Complete this question by entering your answers in thetabs below.

Prepare a schedule of expected cash collections for July,August, and September. Also compute total cash collections for thequarter ended September 30.

Schedule of Expected CashCollections
Month
JulyAugustSeptemberQuarter
$0
From July sales0
From August sales0
From September sales0
Total cash collections$0$0$0$0

Req 2A

Prepare a merchandise purchases budget for July, August, andSeptember. Also compute total merchandise purchases for the quarterended September 30.

Merchandise Purchases Budget
JulyAugustSeptemberQuarter
Total needs
Required purchases

Req 2B

Prepare a schedule of expected cash disbursements formerchandise purchases for July, August, and September. Also computetotal cash disbursements for merchandise purchases for the quarterended September 30.

Schedule of Cash Disbursements forPurchases
JulyAugustSeptemberQuarter
$0
From July purchases0
From August purchases0
From September purchases0
Total cashdisbursements$0$0$0

$0

Req 3

Prepare an income statement for the quarter ended September30.

Beech Corporation
Income Statement
For the Quarter Ended September 30
0
0
$0

Req 4

Prepare a balance sheet as of September 30.

Beech Corporation
Balance Sheet
September 30
Assets
Total assets$0
Liabilities and Stockholders'Equity
Total liabilities andstockholders' equity$0

Answer & Explanation Solved by verified expert
3.9 Ratings (488 Votes)
Schedule of Expected Cash Collections Month July August September Quarter October From Accounts receivable 144000 144000 From July sales 34000035 than 65 119000 221000 340000 From August sales 36000035and 65 12600000 23400000 360000 From September sales 12250000 122500 Total cash collections 263000 347000 356500 966500 working Total sales T 340000 360000 350000 1050000 370000 ans 2a Inventory Purchases Budget    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students