prepare a cash budget for terranova for the quarter ending in December 31, 2020 show activity by month abd in total ?

ft Schedule of expected cash disbursements-merchandise purchases B D E F G 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 10 $146.250.00 $360,750.00 7 8 9 10 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 $322.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 Total needs 124 215 152.100 120.023 259.418 22 Less beginning merchandise inventory 36.000 60.B40 76,050 $36.000 28 Required purchases 588.215 $91.260 $43.973 3223448 29 30 1For Oct sales: $ 78.000 sales 50% cost ratio=$39.000 GOUDA Group B Calibri 11 B I Y SA J D E F G H 30 1For Oct sales: $78,000 sales 50% cost ratio - $39,000 31 32 2At Oct 31: $46,800 x 80% - $37.440 33 34 35 Given 35 37 Schedule of expected cash disbursements-merchandise purchases 38 39 October November December Quarter 40 Sept. purchases $21,750 $21,750 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. Other expenses 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 5900 5900 $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 6 of sales 61 62 63 Group A Group B Group