formulas and numbers for disinformation that goes with the circled information.

how to calculate the beginning cash balance?

Schedule of Budgeted Cash Disbursements for Merchandise Purchases For the 6 months ending June 2020 $ Cash purchases month prior A/P Collections Cash disbursements for merchandise purch. Jan 20 16,896 $ 26,304 43,200 $ Feb 20 18,624 $ 25,344 43,968 $ Mar 20 22,579 $ 27,936 50,515$ Apr 20 27,821 $ 33,869 61,690 $ May 20 34,574 $ 41 731 76,306 $ Jun 20 35,986 $ 51.862 87,847 $ 6 mos total 156,480 207,046 363,526 $ 7% 6% ixed Operating expenses: Salaries and Wages Rent Supplies Expense Other - Overhead Other - Depreciation Variable Operating Expenses: 3,000 Sales Commissions, % of Revenue 8,000 Other Variable Cash Expenses, % of Revenue 2,000 24,000 24,000 Imagine, Inc. Operating Expense Budget For the 6 months ending June 2020 $ salaries and Wages bales Commissions Rent Other Variable Cash Expenses Supplies Expense ther - Overhead Other - Depreciation Sad Debt Expense otal operating expenses Depreciation and noncash items Bad Debt Expense Lash disbursements for operating expenses Jan 20 3,000 $ 7,000 8,000 6,000 2,000 24,000 24,000 3,150 77,150 24,000 3,150 50,000 $ Feb 20 3,000 $ 7,980 8,000 6,840 2,000 24,000 24,000 3.248 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.800 79,400 24,000 2.800 52.600 $ Apr 20 3,000 $ 10.920 8,000 9,360 2,000 24,000 24,000 3,192 84,472 24,000 3,192 57,280 $ May 20 3,000 $ 14,175 8,000 12,150 2,000 24,000 24,000 3,360 90,685 24,000 3,360 63,325 $ Jun 20 3,000 $ 17,325 8,000 14,850 2.000 24,000 24,000 4,368 97,543 24.000 4,368 69,175 $ 6 mos total 18,000 65,800 48,000 56,400 12,000 144,000 144,000 20.118 508,318 144,000 20,118 344,200 $ Equipment payment - January quipment payment - February Dividends - March Minimum Monthly Cash Budget $ $ $ 50,000 30,000 12,000 15,000 Imagine, Inc. Cash Budget For the 6 months ending June 2020 Jan 20 Feb 20 Mar 20 Apr 20 May 20 Jun 20 6 mos total 106,132 112 300 134,328 171,315 214,572 $ 842,847 ash balance, beginning Add collections from customers otal cash avalable oss disbursements: Cash disbursements for merchandise purch 104,200 104,200 43,200 43.969 50515 61.690 76.306 87847_$ 363.526 % Paid in Month of Purchase % Paid in Month after Purchase 40% 60% Imagine, Inc. Schedule of Budgeted Cash Disbursements for Merchandise Purchases For the 6 months ending June 2020 $ Cash purchases 1 month prior NP Collections Cash disbursements for merchandise purch. Jan 20 16,896 $ 26,304 43,200 $ Feb 20 18,624 $ 25,344 43,968 $ Mar 20 22,579 27,936 50,515 $ Apr 20 27,821 $ 33,869 61,690 $ May 20 34,574 $ 41,731 76,306 $ Jun 20 35,986 $ 51,862 87,847 $ 6 mos total 156,480 207,046 363,526 $ 7% 6% Fixed Operating expenses: Salaries and Wages Rent Supplies Expense Other - Overhead Other - Depreciation Variable Operating Expenses: 3,000 Sales Commissions, % of Revenue 8,000 Other Variable Cash Expenses, % of Revenue 2,000 24,000 24,000 Imagine, Inc. Operating Expense Budget For the 6 months ending June 2020 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 Cash disbursements for operating expenses Jan 20 3,000 $ 7,000 8,000 6,000 2,000 24,000 24,000 3,150 77,150 24,000 3,150 50,000 $ Feb 20 3,000 $ 7,980 8,000 6,840 2,000 24,000 24,000 3,248 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,800 79,400 24,000 2,800 52,600 $ Apr 20 3,000 $ 10,920 8,000 9,360 2,000 24,000 24,000 3,192 84,472 24,000 3,192 57,280 $ May 20 3,000 $ 14,175 8,000 12.150 2,000 24,000 24,000 3360 90,685 24,000 3,360 63,325 $ Jun 20 3,000 $ 17,325 8,000 14,850 2.000 24,000 24,000 4,368 97,543 24,000 4,368 69,175 $ 6 mos total 18,000 65,800 48,000 56,400 12,000 144,000 144,000 20.118 508,318 144,000 20.118 344,200 Equipment payment - January Equipment payment - February Dividends - March Minimum Monthly Cash Budget 50,000 30,000 12,000 15,000 Imagine, Inc. Cash Budget For the 6 months ending June 2020 Sales Budget For the month ending June 2020 Nov 19 Dec '10 Jan 20 11.50 11.600 10,000 10.00 $ 10.00 10 DO 112.500 116.000 100.000 Feb 20 M2 11.400 12000 10.00 $ 10 DO $ 120.000 mos total 09000 15.600 May 20 18.000 11.25$ 209.500 22.000 11.25 242300 140.000 Budged unt sales Selling priceperunt Tot Sales Cash Sales Credit Sales Cash Sales Credit Sales Total Sales 30% 70% 5 300S 30.000 $ 30.7505 78.790 1128993 2005 79 800 36.000 $ 84.000 6500$ 109 200 60,750 $ 141,750 74.250 $ 173.250 27500 262.000 658 000 940.000 100.000 Current month AR Collections 1 month prior AR Collections 2 months prior Ar Collections Uncollectie 30% 50% 10% MODO 10750 Imagine, Inc Cash Collections For the 6 months ending June 2000 Jan 20 30.000 1.200 21.000 23.00 25.200 40.600 35.000 30,500 12.600 12.092 11.200 100.122 3.150 2.800 32.700 42.000 12 1203 51975$ 70.8755 Current morth cash Sales Current month AR Collections 1 month prior MR Collections 2 months prior Ar Collections Total cash collections Sad Dette Desired and very 54,600 19.440 2827000 197400 282,975 10472 842841 9.34 3.192 MO 20.118 Imagine, Inc Purchase For the months ending June 2020 Busged until Add desired ending inventory Tone Les Bering Inventory Required Purchase 11 800 6.000 15.600 44 10 10,000 40 14.560 11.400 100 10.200 4 1104 12.000 0.240 16.240 4.100 13440 15.000 7200 22.00 240 May 22 16.000 MOO 26.800 7.200 10.000 22.000 7.200 20. 200 80.000 MOO 127 800 400 02 Cost per 4.00 $ 4.00 4.00 420 $ 4:20 441