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

Office Editing for Docs, Sheets & X UTF-8"Course project Student Solution(2).xls Insert Format Help Unsaved changes File Edit Calibri 11 @ @ B IyfA f Sept. purchases B D F 1 2 3 4 1 Sales Budget October Sales in Units 7,800 Selling price $10 Sales In Dollars $78,000.00 November 9,360 $10 $93,600.00 December Quarter 11,700 28,860 $10 $10 $117,000.00 $288,600.00 5 6 7 9 Schedule of expected cash collections: 10 11 October November 12 Cash sales $54,600 $65,520 13 Credit sales 15,000 23.400 14 Total collections $69,600 $88,920 15 16 17 5,000 x $10 x 30% December $81,900 28,080 $109.980 Quarter $202,020 66,480 $268,500 1B 19 20 2 Merchandise purchases budget: 21 22 23 Budgeted cost of goods 24 Add desired ending 25 Total needs 26 Less beginning 27 Required purchases 28 129 October $46,800 $0 $44.928.0 91.728 36.000 $55.728 November $56.160 90 $56.160.0 112 320 40928 567392 December Quarter $70.200 $173.160 $39.936.0 $39.936 110.136 213,096 56.160 $36.000 $53.976 $177,096 For et sales. 578.000 sales 60 cost ratio = $46.800 Group A Group C f* Sept. purchases H B E D 30 2At Oct 31: $56,160 x 80% = $59.904 31 32 33 Given. 34 35 36 Schedule of expected cash disbursements-merchandise purchases 37 38 October November December Quarter 39 Sept. purchases $21,750 - $21,750 40 October purchases 27.864 $27,864 $55.728 41 November purchases 33,696 $33.696 $67.392 42 December purchases 26.988 $26.988 43 Total disbursements $49.614 $61.560 $60,684 $171.858 44 45 Given. 46 47 3 Schedule of expected cash disbursements - operating expenses 48 April May June Quarter 49 Commissions $9.360 $11.232 $14.040 $34.632 2.500 2.500 2.500 $7.500 51 Other expenses $4.680 $5,616 $7,020 $17.316 52 Depreciation expense $900 5900 $900 $2.700 53 Total operating expenses $17.440 50 $20.248 50 $24.460 562.148 54 Less Depreciation Expens $900 $900 $900 $2.700 55 Total disbursements $16.540 $19.348 $23.560 $59.448 56 52 Commissions 12% of sales ESH Rentistixed 59 Other expenses of sales 50 Rent 160 Groupe