Based on the information provided please help me complete Schedule E & Schedule F worksheet

Based on the information provided please help me complete the worksheet

Wolf's Gear Zone is a retail establishment that sells hiking and kayaking gear. The owner, Timothy Wolf, has enlisted you to prepare a budget for the next quarter, which is his busiest time of year. His primary concern is his cash position. He anticipates having to finance inventory purchases in anticipation of an upswing in demand.

Based on the information provided in the attached document:

Schedule A
Sales Budget
	April	May	June
Credit Sales- 80%	56000	68000	72000
Cash Sales- 20%	14000	17000	18000
	70000	85000	90000
Schedule B- Expected Cash Collections
	April	May	June
Credit Sales-Preceding month	48000	56000	68000
Cash Sales- Current month	14000	17000	18000
	62000	73000	86000
Schedule C- Purchase budget for merchandise inventory
	April	May	June
Opening Balance	12600	15300	16200
Add: Purchase - Balancing Figure	44700	51900	46800
Less: Sales (60% of sales)	42000	51000	54000
Closing Balance 30% of next month COGS	15300	16200	9000
Schedule D- Expected cash disbursements for inventory purchase
Cash Purchase - 50% of current month purchase	22350	25950	23400
Credit Purchase- 50% of last month purchase	18300	22350	25950
	40650	48300	49350

Balance Sheet as of March 31 2017 Assets Cash Accounts Receivable Inventory Plant and Equipment (Net of Depreciation) Total Assets Liabilities Interest Payable Note Payable Accounts Payable Total Liabilities Equity Capital Stock Retained Earnings Total Equity Total Liabilites Equity 9,000 48,000 12,600 200,000 269,600 18,300 18,300 180,000 71,300 251,300 269,600