Question

Answer the questions in the following into Hans This per ater Y ep out the store's operations are below budget for the 3rd quarter of the crew year l and the date 196.000 Assets Cash Accounts Receivable (Net) Merchandise Inventory Pronty Equip (Net) Total Assets Balance Sheets of June 30th Liabilities and Stockholdex Eauit 22.000 Accounts Payable 35.000 73.500 Common Stock 1.004.000 Retained in S 1.134.500 Total Liabilities & Equity 487.100 451 400 1.134.300 S . For the upcoming quarter, Sales are budgeted at: 350.000 August $ 300.000 September 320,000 • Collections are expected to be as in the month of sale, 10% in the month following the sale, with 5% 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. $ 287,000 B. $ 302,000 C. $ 317,000 D. $ 307,000 E. None of the above

Answer 1

The answer has been presented in the supporting sheet. All the parts has been solved with detailed explanation and format. For detailed answer refer to the supporting sheet.

Answer 2 Part 5) 3 The correct answer is B) $ 302000 5 The budgeted cash collection = september sales *85% +august sales 10% 6 = (320000*85%)+(300000*10%) 7 = $302000 9 Thus the correct answer 11 Part 6) 12 The correct answer is c) $ 188790 14 Firstly we have to calculate the purchases for 2 months that is july and august 15 19 Statement for calculation of Purchases 17 Particulars July August 18 Reuired for sales 210000 180000 (350000*0.6) (300000*0.6) 20 Desired ending inventory 63000 67200 21 (180000*35%) (320000*60%*35%) 22 Less Beginning inventory 73500 63000 23 Purchases 199500 184200

5 6 Cash disbursement for purchases = august purchases*70%+july purchases *30% 7 = (184200*70%)+(199500*30%) 8 = $ 188790 Thus the correct answer is $ 188790 2 Part 7) 4 The correct answer is C) $ 535400 5 Budgeted retained earning at the end of july 7 = opening balance + net income - dividend 3 = opening balance +(sales -COGS - operating expenses-depreciation) - dividend 9 =451400 + (350000-(350000*60%)-25000-21000)-10000 D = $ 535400 2 The correct answer is $ 535400