LCS bills businesses that use their offices/rooms. The table below is the operating budget for LCS. Business A pays 50% of the amount billed the month after receiving the bill and pays the remainder two months after receiving the bill. Business B pays 50% the month it is billed, 50% one month after receiving a bill. Prepare a cash collections budget for LCS for the month of June. Attach an Excel Spreadsheet showing your analysis.

LCS Operating Budget	April	May	June
Families	$125	$150	$175
Business A	$170	$100	$175
Business B	$100	$100	$180
Total offices Revenue	$395	$350	$530