E8-18 (Algo) Preparing Cash Receipts and Cash Payments Budgets [LO 8-4] Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to Individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Cash Expenses Paid Month May June Sales $97,000 115,000 July 139,000 August 131,000 Purchases $ 68,000 90,000 116,000 74,000 $ 21,000 29,000 33,250 33,600 The majority of Martin's sales (65 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 45 percent are collected in the month of sale and 55 percent are collected in the following month. All of Martin's purchases are on account with 50 percent paid in the month of purchase and 50 percent paid the following month. Required: 1. Determine budgeted cash collections for July and August. 2. Determine budgeted cash payments for July and August.