Please fill out last part

imagine , Inc. Sales Budget For the 6 months ending June 2020 Nov '19 Budged unit sales Selling price per unit ,Tpta Sal Cash Sales % redit Sales % Credit Sales Total Sales Current month AIR Collectio I month prior AIR Collections 2 months prior NR Collections uncollectible Current month cash Sales Current month AIR Collections 1 month prior AIR Collections 2 months prior A/R Collections Total cash collections ad Debt Expense ending inventory Apr '20 Budged unit sales Add desired ending inventory Total needs Less Beginning Inventory Required Purchases Cost per unit urchases OfPrChase Paid in Month after P Jan '20 Cash purchases 1 month prior AIP Collections (Pesh disbursements fprnerchandise Purch. fixed Operating expenses. Salaries and Wages Rent Supplies Expense Other - Overhead 9!Oeepepreciation Salaries and Wages Sales Commissions Rent Other Variable Cash Expenses Supplies Expense Other - Overhead Other - Depreciation Bad Debt Expense Total operating expenses Depreciation and noncash items Bad Debt Expense disbursements for operating expen Dec 19 11.600 10 116.000 34.800 81,200 116.0001 Jan '20 10.000 100.000 30,000 70,000 100.000 Feb '20 11,400 10 114.000 34.200 79,800 114.000 Mar '20 12.000 10 120.000 36.000 84,000 120.000 Apr '20 15.600 10 156.000 109,200 156.000 Jun '20 6 mos total Imagine , Inc. Cash Collections For the 6 months ending June 2020 Jan 11,250 10 112.500 33.750 78,750 112.500 '20 30,000 21 ,ooo 40,600 12,600 104,200 4,500 Feb 20 34,200 23,940 35,000 12,992 106.132 Mar 20 36,000 25,200 39,900 11 ,200 112,300 magine, Inc. Purchase Budget For the 6 months ending June 2020 Nov 'I g 11.250 15.890 Dec lg 11.600 4.000 15,600 10.960 43,840 Imagine. Inc. 10,000 4,560 14,560 4,000 10,560 42,240 Apr '20 46.800 32,760 42.000 12,768 134,328 Feb 20 11.400 4.800 16.200 4,560 11.640 46,560 22.000 220.000 154,000 220.000 Jun 20 7.200 29.200 8,800 20.400 4.41 89,964 89.000 267.000 623,000 890.000 6 mos total 89,000 38,800 127.800 35,600 92.200 391 ,200 Schedule of Budgeted Cash Disbursements for Merchandise Purchases For the 6 months ending June 2020 Jan 42,240 16.896 25,344 3.000 8, OOO 24,000 3,000 8,000 2,000 24.000 24,000 3.1501 77,150 50,000 30.000 12,000 Feb 20 46,560 18.624 27,936 Mar 20 56,448 22.579 33,869 Apr '20 6g,552 27,821 41,731 Variable Operating Expense Sales Commissions. % of Revenue Other Variable Cash Expenses, % of Revenue magine. Operating Expense Budget For the 6 months ending June 2020 Feb 20 3,000 7.980 8,000 2,000 24.000 24,000 3.2481 79,068 24.000 3,248 51.820 Mar 20 3,000 8.400 8,000 7.200 2,000 24,000 24,000 2.8001 79,400 24,000 2,800 52,600 Equipment payment - Janu Equipment payment - February Dividends - March Monthly Cash B Cash balance, beginning Add collections from customers Total cash available Less disbursements: Cash disbursements for merchandise Purch. Cash disbursements for operating expenses Equipment purchases Dividends Total cash disbursements Excess of receipts over disbursements Financing: Borrowing-note Repayrnentsnote Imagine, Inc. Cash Budget For the 6 months ending June 2020 Jan '20 | 15,000 104.2001 119,200 43,200 50.000 50,000 143,200 -24.000 39,000 Feb 20 15.000 106.1321 121,132 43,968 51820 30,000 125,788 4656 Mar 20 15,344 112.3001 127,644 50,515 52.600 12.000 115, 115 12.529 Apr '20 3,000 10,920 8,000 9,360 2,000 24,000 24,000 3, 1921 84,472 24,000 3,192 57 ,280 Apr '20 | 15.529 134.3281 149,857 61,690 57,280 118,g70 30.887 -15,000 May '20 54,000 37,800 13,440 159.840 Mar '20 12.000 6,240 18.240 13.440 56.44B May '20 86,436 34.574 51 ,862 68 May 20 14.175 8,000 12.150 24,000 90,685 24,000 63,325 May 20 | 15,887 171.3151 187,202 76,306 63.325 139,631 47.571 -32,000 Jun 20 66,000 46,200 17,472 192,672 15.600 7,200 22.800 6,240 16.560 69,552 Jun 20 8g,g64 35,985.6 53,978.4 Jun 20 3,000 17.325 8,000 14.850 2,000 24.000 4.3681 97,543 24.000 69,175 Jun 20 15,571 214.5721 230,143 87,847 69.175 157 ,022 73.121 .15.00@ May '20 18.000 10 180.000 126,000 180.000 6 rnos total 267,000 186,900 275.100 80,472 809.472 28,740 May 20 18.000 26.800 19.600 4.41 86.436 6 rnos total 391 ,200 156.479.6 234,720.4 6 mos total 18,000 65.800 48,000 12,000 144.000 144,000 20.118 508,318 20,118 6 mos total 92.331 842.847 935,178 363,526 80,000 12.000 799,726 135.452 62.000 -62,000