Supporting calculations:

Collections of accounts receivable:

Sales on

Account

Percentage

June

July

August

April sales

May sales:

Collected in June

Collected in July

June sales:

Collected in July

Collected in August

July sales

Payments for manufacturing costs:

Costs on

Account

Percentage

Payments

Paid in June:

Incurred in May

Incurred in June

Total

Paid in July:

Incurred in June

Incurred in July

Total

Paid in August:

Incurred in July

Incurred in August

Total

The Bottom is the format it needs to be in. I already asked the question, but can't figure out where the numbers go. if you could explain the answers you get to me that would help out a bunch. Thank You.

	MERCURY SHOES INC.
	Cash Budget
	For the Three Months Ending June 30, 2016
			June		July		August
Estimated cash receipts from:
	Cash sales
	Collections from accounts receivable
		Total cash receipts
Estimated cash payments for:
	Manufacturing costs
	Selling and administrative expenses
	Capital expenditures
	Other purposes:
		Income tax
		Dividends
		Total cash payments
Cash increase (decrease)
Cash balance at beginning of month
Cash balance at end of month
Minimum cash balance
Excess (deficiency)

OBJ PR 6-4B Cash budget instructs you to prepare a monthly cash The controller of Mercury shoes the following budget information: the next three months. You are presented with July budget for August $160,000 185,000 $200,000 82,000 66,000 105000 46,000 40,000 Manufacturing costs 51,000 Selling and administrative expenses 120,000 capital expenditures The expects to sell about 10% of its merchandise for cash. of sales count, company collected in the month following the sale and the remainder 60% expected to be the following month (second month after sale). Depreciation, insurance, and property represent s 12,000 of the estimated monthly manufacturing nual insurance premium is paid in February, and the annual property taxes are paid in November. of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. and Current assets as June 1 include cash of $42,000, marketable securities of $25,000 accounts receivable of s198,000 ($150,000 from May sales and $48000 from sales). Sales on account in Anril