Piano Man, Inc., has a 50-day average collection period and wants to maintain a minimum cash balance of $40 million, which is what the company currently has on hand. The company currently has a receivables balance of $198 million and has developed the following sales and cash disbursement budgets in millions:

	Q1				Q2				Q3				Q4
Sales		$	459			$	531			$	612			$	576
Total cash disbursement			302				466				720				477

Complete the following cash budget for the company.

PIANO MAN, INC. Cash Budget (in millions)
	Q1	Q2	Q3	Q4
Beginning receivables	$	$	$	$
Sales	459	531	612	576
Cash collections
Ending receivables	$	$	$	$
Total cash collections	$	$	$	$
Total cash disbursements	302	466	720	477
Net cash inflow	$	$	$	$
Beginning cash balance	$	$	$	$
Net cash inflow
Ending cash balance	$	$	$	$
Minimum cash balance	$	$	$	$
Cumulative surplus (deficit)	$	$	$	$