The expected sales for City Company shoes in the month of May are shown in the table below. Sherry Jones, the owner, gives credit to a select group of customers (20 percent of sales), but all others must pay cash. Of Sherry's credit customers, 80 percent pay her the month after the sale and 20 percent in the second month after sales. Sherry pays cash for 10 percent of her purchases. The other 90 percent she pays off by the end of the next month. Sherry's operating expenses are paid the month after incurrence. Her operating expenses are $7,000 each month, $500 of which is depreciation. Selling expenses are $1,500 a month, and property taxes are paid $5,000 in April and $6,000 in the month of May. Sherry began May with $9,000 in cash.

		Sales	Purchases
	March	$160,000	$120,000
	April	140,000	125,000
	May	150,000	130,000

Prepare a cash budget to determine City Company's ending cash balance for May. The sales number above is the total for cash and credit sales. PLEASE ANSWER** CAN YOU PLEASE ORGANIZE THE INFOR IT INTO A CASH BUDGET STATEMENT* THANKS