60.1K

Verified Solution

Link Copied!

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

File Edit Insert Format Help Calibri 11 B I y 5 D E F H 1 2 Sales Budget 3 October November December Quarter 4 Sales in Units 9,750 1,170 146,250 157,170 5 Selling price $10 $10 $10 $10 6 Sales in Dollars $97,500.00 -0 5117,000.00 1-0 $146,250.00 $360,750.00 7 8 9 10 11 1 Schedule of expected cash collections: 12 13 October November December Quarter 14 Cash sales $58,500 $70.200 $87.750 $216,450 15 Credit sales 20,000 39,000 46,800 105.800 16 Total collections $78,500 $109.200 $134,550 3322,250 17 18 40% of the preceding month's sales. 19 * Given 20 21 2 Merchandise purchases budget: 65% cost 22 23 October November December Quarter 24 Budgeted cost of goods soldi $63.375 $76,050 $95.063 $234,488 Add desired ending 25 merchandise 560.840.0 $76,050.0 $24.960.0 $24.960 26 Total needs 124.215 152.100 120.023 259.448 23 Less beginning merchandise inventory Required purchases 36.000 $88.215 60.840 591.260 76.050 343.923 $36.000 3223.448 28 29 30 IFor Oct sales: 578.00 sales 50% contrato-339.000 GOUDA Group B Groupe Calibri D E F G H 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 Other expenses $5.850.0 $7,020.0 $8.775.0 $21,645 53 Depreciation Expense $900 $900 $900 $2.700 54 Total operating expenses $20.950 $24.460 $29.725 $75.135 55 Less Depreciation $900 $900 5900 $2.700 56 Total disbursements $20.050 $23.560 $28.825 $722435 57 58 Commissions = 12% of sales 59 Rent is fixed 60 Other expenses - 6'N of sales 61 82 63 64 65 Group B

Answer & Explanation Solved by verified expert

See Answer