Creat a cash collections budget with the given information

INPUT AREA:
CREDIT SALES AND NET CASH SALES INFORMATION: FROM "NETSALES" WORKSHEET
CREDIT SALES COLLECTED IN MONTH OF SALE						70%
AMOUNT COLLECTED IN MONTH OF SALE IS SUBJECT TO DISCOUNT OF						1%
CREDIT SALES COLLECTED IN THE MONTH SUBSEQUENT TO THE MONTH OF SALE						10%
OUTPUT AREA:			CASH COLLECTIONS BUDGET
			FOURTH QUARTER, 2018
			MONTH OF COLLECTION - AMOUNT COLLECTED					NET*
MONTH OF SALE	CREDIT SALES		OCTOBER	NOVEMBER	DECEMBER			ACCOUNTS
								RECEIVABLE
SEPTEMBER	$989,352			-	-
OCTOBER	$930,384				-				@ 10/31/18
NOVEMBER	$1,051,596		-						@ 11/30/18
DECEMBER	$148,176		-	-					@ 12/31/18
COLLECTIONS FROM CREDIT SALES
MONTH OF SALE	NET CASH SALES
-	-
OCTOBER	$394,749		-
NOVEMBER	$446,177			-
DECEMBER	$62,869				-
TOTAL CASH COLLECTIONS
			=	=	=============