Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:

Sales Budget
	April	May	June	Total
Sales in units	7500	11000	9000	27500
Selling price per unit	x $40	x $40	x $40
Sales revenue	$300000	$440000	$360000	$1100000

All of the sales are on credit. Quagmire collects from customers as follows:

40% of sales in the month of sale 25% in the month following the sale, and 35% in the second month following the sale.

Cash receipts budget
	April	May	June	Total
Collect from current sales	120000	176000	144000	440000
Collect from last month	100000	75000	110000	285000
Collect from 2 mos. Prior	119000	140000	105000	364000
Cash receipts	$ 339000	$ 391000	$ 359000	$ 1089000

Quagmire expects cost of goods sold to be 60% of sales. They keep 20% of next months expected cost of goods sold in ending inventory. Below are budgeted purchases of inventory. All purchases are paid for in the SAME month as the purchase.

Purchases Budget
	April	May	June	Total
Budgeted cost of goods sold	180000	264000	216000	660000
plus desired ending inventory	52800	43200	31200	31200
Total needs	232800	307200	247200	691200
less beginning inventory	(36000)	(52800)	(43200)	(36000)
Cost of purchases	196800	254400	204000	655200

Below is the budget for variable and fixed selling and administrative expenses. Selling and admin expenses are paid in the month AFTER they are incurred. Fixed expenses include depreciation of 19500 each month.

Sales and Admin Budget
	April	May	June	Total
Variable S&A expenses	60000	88000	72000	220000
Fixed S&A (including depreciation)	97500	97500	97500	292500

Quagmire has $152000 of cash on hand at he beginning of May. 1. Compute the beginning balance in cash for June. 2. Compute the ending balance in cash for June.