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	9500	13000	11000	33500
Selling price per unit	x $40	x $40	x $40
Sales revenue	$380000	$520000	$440000	$1340000

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

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

Cash receipts budget
	April	May	June	Total
Collect from current sales	152000	208000	176000	536000
Collect from last month	138000	114000	156000	408000
Collect from 2 mos. Prior	126000	138000	114000	378000
Cash receipts	$ 416000	$ 460000	$ 446000	$ 1322000

Quagmire expects cost of goods sold to be 30% of sales. They keep 10% 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	114000	156000	132000	402000
plus desired ending inventory	15600	13200	10200	10200
Total needs	129600	169200	142200	412200
less beginning inventory	(11400)	(15600)	(13200)	(11400)
Cost of purchases	118200	153600	129000	400800

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 12750 each month.

Sales and Admin Budget
	April	May	June	Total
Variable S&A expenses	76000	104000	88000	268000
Fixed S&A (including depreciation)	127500	127500	127500	382500

Quagmire has $185000 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.