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:

MonthSalesPurchasesCash

Expenses

PaidMay$95,000$66,000$22,000June120,00088,00026,000July134,000112,00034,000August132,00074,00031,500

The majority of Martins sales (65 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 30 percent are collected in the month of sale and 70 percent are collected in the following month. All of Martins 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.

July August

Budgeted Cash Collections:

2. Determine budgeted cash payments for July and August.

July August

Budgeted Cash Payments:

I need help figuring out how to determine the "budgeted cash collections" and the "budgeted cash payments".

Thank you!