Question

Answer the next the questions using the following information Buchanan Home Goods purchases merchandise from suppliers for sale in its re budget for the 3rd quarter of the current year. It's Balance Sheet and other data 60 suppliers for sale in its retail store. The company is preparing its and other data about the store's operations are below Assets Cash Accounts Receivable (Net) Merchandise Inventory Property & Equip (Net) Total Assets Balance Sheet as of June 30th Liabilities and Stockholders' Equity 196.000 22.000 Accounts Payable 33,000 480.900 69,300 Common Stock 451,400 1,004,000 Retained Earnings $ 1,128,300 Total Liabilities & Equity $ 1,128,300 July • For the upcoming quarter, Sales are budgeted at: 330,000 August $ 300,000 September $ 320,000 • Collections are expected to be 85% in the month of sale. 10% in the month following the sale, with so uncollectible. The company recognizes bad debt expenses in the month of sale. • Cost of goods sold is 60% of sales. • Desired Ending Merchandise Inventory is 35% of the following months' sales needs. • 70% of merchandise purchases are paid in the month of purchase, with the remaining 30% paid in the month following the purchase. • Other monthly expenses to be paid in cash are $25,000. • Monthly Depreciation is $21,000. • A dividend of $10,000 will be declared in the month of July for payment to shareholders in the month of August. . Ignore any interest and taxes. 5 Budgeted cash collections in the month of September would be: A. $ 302,000 B. $ 317,000 CS 287,000 D. $ 305,000 E. None of the above

Answer 1

5) Budgeted Cash collection in September = (300000*10%+320000*85%) = 302000

So answer is a) $302000

6) July Purchase = (330000*60%)+(300000*60%*35%)-(330000*60%*35%) = 191700

August purchase = (300000*60%)+(320000*60%*35%)-(300000*60%*35%) = 184200

Cash disbursement = (191700*30%+184200*70%) = 186450

So answer is b) $186450

7) Net income August = 330000*40%-25000-21000 = 86000

Retained earning (July) = 451400+86000-10000 = 527400

So answer is b)$527400