60.1K

Verified Solution

Link Copied!

prepare a budgeted income statement for the quarter ending in december 31 2020. show activity only for the quarter not by individual months ?

hope these pictures are better thank you for the update

4:09 Schedule of expected cash disbursements merchandise purchases D DET 013 14 Cash IS O 000 320300 . 17 2 Merchandisha ET Orolo 4:09 a BIRSA BARON Septh October 1.750 44100 . M w che oferecendo A 311.700 2500 OU Other DO 100 0449 si 2009 2 Group B X project Student Solution (2) (1).xls Insert Format Help File Edit Calibri 11 BI $ f* B D E F G H 1 2 3 4 5 6 7 Sales Budget October November December Quarter Sales in Units 9.750 1,170 146,250 157,170 Selling price $10 $10 $10 $10 Sales in Dollars $97.500.000 117.000.000 $146,250.00 $360,750.00 8 10 11 1 Schedule of expected cash collections: 12 13 October November December 14 Cash sales $58,500 $70.200 $87.750 15 Credit sales 20.000 39.000 46,800 16 Total collections $78,500 $109.200 $134.550 17 18 40% of the preceding month's sales 19 Given Quarter $216,450 105.800 $322.250 2 Merchandise purchases budget: 65% cost October November December Quarter $63.375 $76.050 $95.063 $234,488 24 Budgeted cost of goods soldi Add desired ending 25 merchandise 26 Total needs 560.840.0 124 215 $76,050.0 152.100 $24.960.0 120,023 $24.960 259448 22 Less beginning merchandise inventory Required purchases 36.000 $88.215 60,840 2260 76,050 3:43:223 336.000 3223.448 28 29 30 1For Oct sales78.000 sales SON cost ratio $39.000 Group B Group ee Calibri 11 BTS A D E F G H 20 30 1For Oct sales: $78,000 sales K 50% cost ratio $39,000 31 32 2At Oct 31: $46,800 x 80%= $37.440 33 34 35 Given. 36 37 Schedule of expected cash disbursements-merchandise purchases 38 39 October November December Quarter 40 Sept. purchases $21,750 $21.750 41 October purchases 44,108 $44,108 - $88,215 42 November purchases 45.630 $45,630 $91,260 43 December purchases 21.986 $21.986 44 Total disbursements $65,858 $89.738 $67,616 $223,211 45 46 * Given 47 48 Schedule of expected cash disbursements - operating expenses 49 April May June Quarter 50 Commissions $11.700 $14,040 $17.550 $43,290 51 Rent 2.500 2.500 2.500 $7.500 52 $5.850,0 $7.020.0 $8.775.0 $21,645 53 Depreciation Expense 3900 $900 $900 $2,700 54 Total operating expenses $20.950 $24.460 $29.725 $75.135 55 Less Depreciation $900 $900 $900 $2.700 56 Total disbursements $20.050 $23,560 $28.825 $72.435 57 58 Commissions - 12% of sales 59 Rent is fixed 60 Other expenses of sales 61 62 Other expenses Group B

Answer & Explanation Solved by verified expert

See Answer