Can anyone please help me solve this question?

using this format below

Jumba Juice Company manufactures and sells lighting foctures Estimated sales for the next three months we Set O 500.000 400.000 11 12 Sales for Augese were $600,000. Al sites are an account. Namba dulce Company estimates that 80% of the accounts receivable are collected in the month of sale with the remaining on collected the following month. The units for $25 each. The cash balance for September 11 $100,000 Generally, con of purchasm are dotad povable in the month of purchase with the remainder due the following month Purchase cont per unit for natural Sis. The company maintains wendet. the month viventory of 10% of next month's sales Selling and administrative pense pad in cash $120.000 per month Erroneamhly Cathbert for bestemte forme Company LEED COMPANY Planned Cash Flows and Balances Quarter Ending March 31, June 30, 2019 2019 Planned balance at beginning of quarter $130,000* $ 90,000 Planned cash receipts Collections of accounts receivable (per Exhibit 22 13) 440,000 580,000 $570,000 $670,000 Planned cash disbursements: Payment of accounts payable (per Exhibit 22.12) $ 80,000 $ 56,000 Payment of accrued liabilities payable (per Exhibit 22.12) 330,000 354,000 Payment of income tax liability 50,000 50.000 Payment of dividends 20,000 40.000 Expenses prepaid (per Exhibit 22.12) 10,000 Total cash disbursements $480.000 $510.000 Planned balance at end of quarter $ 90,000 $160,000 * Actual on January 1