I'm working on following problem for last three days but really can't figure out how to solve it. Can anybody help me out - hints/resources/examples - anything would be appreciated.

 Consider the following June actual ending balances and July 31, 2012, budgeted amounts for Orleans.com:
a. June 30 inventory balance, $17,750
b. July payments for inventory, $4,300
c. July payments of accounts payable and accrued liabilites, $ 8,200
d. June 30 accounts payable balance, $10,600
e. June 30 furniture and fixtures balance, $34,500; accumulated depreciation balance, $29,830
f. June 30 equity, $28,360
g. July depreciation expense, $900
h. Cost of goods sold, 50% of sales
i. Other July expenses, including income tax, total $6,000, paid in cash
j. June 30 cash balance, $11,400
k. July budgeted credit sales, $12,700
l. June 30 accounts receivable balance, $5,140
m. July cash receipts, $14,200

Requirement

Prepare a budgeted balance sheet

Just an example, Not populated from your data

Budgeted Balance Sheet
Assets					Liabilities and Stockholders' Equity
Current assets:					Current liabilities:
Cash	$	12,200			Accounts payable				1,800
Accounts receivable		8,100			Stockholders' equity:
Supplies inventory		3,200			Common stock	$	5,000
Total current assets			$	23,500	Retained earnings		34,700
Plant and equipment:					Total stockholders' equity				39,700
Equipment		34,000
Accumulated depreciation		-16,000
Plant and equipment, net				18,000
Total assets			$	41,500	Total liabilities and stockholders' equity			$	41,500