• How does the budget help the manager with forecasting?

Market Department Master Budget - June (complete the below schedules)

	June
Consulting Revenues (Chapter 20 - PAGE 1005)	$200,000
Less: Commissions	$ 10,250
Less: Subcontractor expenses	$ 92,250
Net revenues	$ 97,500
Expenses
Salaries and benefits	$48,000
Web site operations	$21,000
Online advertising expenses	$15,000
Other misc. expenses	$ 3,500
Total expenses	$87,500
Net department expenses	$87,500
Expected Cash Collections (Chapter 20 - PAGE 1008-1009)
June collections on account:
April sales	$190,000
May sales	$200,000
June sales	$205,000
Total cash collections	$595,000
Expected Cash Disbursements (Chapter 20 - PAGE 1009-1010)
Salaries and benefits	$ 48,000
Web site operations	$ 21,000
Other misc. expenses	$ 3,500
Online advertising expenses	$ 15,000
Sales commissions (5% of sales)	$ 29,,750
Cost of sales (45% of sales)	$267,750
Total cash disbursements	$385,000
Net impact on cash	$210,000