Use the following information to prepare determine the budgeted cash balance for Arbor Company at the end of June. a. Beginning cash balance on June 1 is $52,000. b. Cash receipts from sales: 40% is collected in the month of sale, 50% in the next month, and 10% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: April (actual), $1,450,000, May (actual), $1,600,000, and June (budgeted), $1,700,000. c. Payments on merchandise purchases: 80% in the month of purchase and 20% in the month following purchase. Purchases amounts are May (actual), $830,000; and June (budgeted), $867,000. d. Budgeted cash disbursements for salaries in June: $260,000. Salaries payable on May 31 are $60,000 e. Budgeted depreciation expense for June: $24,000. f. Other cash expenses budgeted for June: $282,000..