A.	Schedule of Expected Cash Collections
		July	August	September	Quarter
	Budgeted Sales	$ 52,000	$ 56,000	$ 60,000	$ 168,000
	Cash Sales	$ 13,520	$ 14,560	$ 15,600	$ 43,680
	Calculation	(52,000*.26)	(56000*.26)	(60000*.26)
	Credit Calculations	$ 29,250	$ 38,480	$ 41,440	$ 109,170
	Calculation		(52000*.74)	(56000*.74)
	Total Cash Collections	$ 42,770	$ 53,040	$ 57,040	$ 152,850
	Calculation	(13520+29250)	(14560+38480)	(15600+41440)
B.	Merchandise Purchase Budget
	For the Quarter Ended September 30	July	August	September	Quarter
	Cost of Goods Sold	$ 40,040	$ 43,120	$ 46,200	$ 129,360
	Calculation	(52000*.77)	(56000*.77)	(60000*.77)
	Plus: Desired Ending Inventory	$ 15,092	$ 16,170	$ 12,936	$ 12,936
	Calculation	(43120*.35)	(46200*.35)	(48000*0.35*.77)
	Total Needed	$ 55,132	$ 59,290	$ 59,136	$ 142,296
	Calculation	(40040+15092)	(43120+16170)	(46200+12936)	(129360+12936)
	Minus Beg. Inventory:	$ 14,014	$ 15,092	$ 16,170	$ 14,014
	Calculation	(40040*.35)	(43120*.35)	(46200*.35)
	Required Inventory Purchases:	$ 41,118	$ 44,198	$ 42,966	$ 128,282
	Calculation	(55132-14014)	(59260-15092)	(59136-16170)	(142296-14014)
C.	Schedule of Expected Cash Disbursments - Merchandise Purchases
		July	August	September	Quarter
	June Purchase	$ 22,400
	JulyPurchase	$ 19,737	$ 21,381
	Calculation	(41118*.48)	(411198*.52)
	August Purchase		$ 21,215	$ 22,983
	Calculation		(44198*.48)	(44198*.52)
	September Purchase			$ 20,624
	Calculation			(42966*.48)
	Total Disbursement	$ 42,137	$ 42,596	$ 43,607	$ 128,340
	Calculation	(22400+19737)	(21381+21215)	(22983+20624)	(42137+42596+43607)
D.	Schedule of Expected Cash Disbursments - Selling and Administrative Expenses
		July	August	September	Quarter
	Commissions	$ 9,000	$ 9,000	$ 9,000	$ 27,000
	Rent	$ 1,200	$ 1,200	$ 1,200	$ 3,600
	Other Expenses(8%)	$ 4,160	$ 4,480	$ 4,800	$ 13,440
	Calculation	(52000*.08)	(56000*.08)	(60000*.08)
	Total Cash for Expenses	$ 14,360	$ 14,680	$ 15,000	$ 44,040
	Calculation	(9000+1200+4160)	(9000+1200+4480)	(9000+1200+4800)
E.
	Cash Budget
		July	August	September	Quarter
	Total Cash Collections	$42,770	$ 53,040	$ 57,040	$ 152,850
	Minus:
	Total Disbursement	$ 42,137	$ 42,596	$ 43,607	$ 128,340
	Total Cash for Expenses	$ 14,360	$ 14,680	$ 15,000	$ 44,040
	Excess Cash	$ (13,727)	$ (4,236)	$ (1,567)	$ (19,530)
	Beginning Cash Balance( Add )	$ 4,000	$ (9,727)	$ (13,963)	$ 4,000
	Ending Cash Balance	$ (9,727)	$ (13,963)	$ (15,530)	$ (15,530)

I need help completing the The Absorbtion costing Income statement and the Balance sheet. And if you could look over at my other completed tables and check if those are right it would be very helpful. Thank you.