Question

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:

Month	Sales		Purchases		Cash Expenses Paid
May	$	94,000	$	66,000	$	18,000
June		122,000		92,000		25,500
July		139,000		117,000		32,750
August		125,000		71,000		32,900

The majority of Martin’s sales (70 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:
1. Determine budgeted cash collections for July and August.

2. Determine budgeted cash payments for July and August. ​

Answer 1

1

	July	August
Cash received from cash sales	$139,000*70% = $97,300	$125,000*70% = $87,500
Cash received from credit sales
June sales	$122,000*30%*35% = $23,790
July sales	$139,000*30%*35% = $14,595	$139,000*30%*65% = $27,105
August sales		$125,000*30%*35% = $13,125
Total cash collected	$                                            135,685	$                                            127,730

2.

	July	August
Cash paid for June purchases	$92,000*45% = $41,400
Cash paid for July purchases	$117,000*55% = $64,350	$117,000*45% = $52,650
Cash paid for August purchases		$71,000*55% = $39,050
Cash expenses paid	$                                   32,750	$                                   32,900
Total cash paid	$                                 138,500	$                                 124,600

You can reach me over comment box if you have any doubts. Please rate this answer