$14$

E$8-18($Algo$)$ Preparing Cash Receipts and Cash Payments Budgets $[$LO $8-4]$

$1\mathrm{.}75$ points points

$\backslash$table$[[,,,,,],[$eBook$,$Month,Sales,$\backslash$table$[[$Cash$],[$Expenses$],[$Paid$]],],[,$May,$$44,000,$$$67,000,$$$,24,000],[,$June,$120,000,90,000,25,000,],[$Hint$,$July,$131,000,118,000,35,000,],[,$August,$126,000,79,000,32,200,]]$

References

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:

$\backslash$table$[[,,,,\backslash$table$[[$Cash$],[$Expenses$]]],[$Month$,$Sales,Purchases,$\backslash$table$[[$Paid$]],,],[$May$,$$$4,000,$$$,67,000,$$$24,000,],[$June$,120,000,90,000,25,000,,],[$July$,131,000,118,000,35,000,,],[$August$,126,000,79,000,32,200,,]]$

The majority of Martin's sales $(65$ percent$)$ are cash, but a few of the excursion companies purchase on credit. Of the credit sales, $35$ percent are collected in the month of sale and $65$ percent are collected in the following month. All of Martin's purchases are on account with $55$ percent paid in the month of purchase and $45$ percent paid the following month.

Required:

Determine budgeted cash collections for July and August.

Determine budgeted cash payments for July and August.

Complete this question by entering your answers in the tabs below.

Required $2$

Determine budgeted cash payments for July and August.

$\backslash$table$[[,,$fuly,August$],[$Budgeted Cash Payments,$$,137,500,136,650]]$