Question

Question part 2 of 2.

Schedules:

Reliable Company Marketing Department Master Budget
Data	April	May	June
Budgeted consulting revenues	$     190,000	$     200,000	$     205,000
Less: Sales commissions (5% of sales)	$          9,500	$        10,000	$        10,250
Less: Cost of sales (45% of sales)	$        85,500	$        90,000	$        92,250
Net consulting revenues	$        95,000	$     100,000	$     102,500
Accounts Receivable Collections
Month of sale	20%
Month following sale	70%
Second month following sale	10%
Monthly Budgeted Expenses
Salaries and benefits	$        48,000
Web site operations	$        21,000
Online advertising expenses	$        15,000
Other misc. expenses	$          3,500
Accounts Payable Payments
Month of sale	40%
Month following sale	60%
Accounts Payable
Online advertising expenses	$        15,000

Marketing Department Master Budget
	June
Consulting Revenues
Less: Commissions
Less: Subcontractor expenses
Net revenues
Expenses
Salaries and benefits
Web site operations
Online advertising expenses
Other misc. expenses
Total expenses
Net department expenses
Expected Cash Collections
June collections on account:
April sales
May sales
June sales
Total cash collections
Expected Cash Disbursements
Salaries and benefits
Web site operations
Other misc. expenses
Online advertising expenses
Sales commissions (5% of sales)
Cost of sales (45% of sales)
Total cash disbursements
Net impact on cash

Answer 1

Following is the budget with available information,information of Subcontractor expenses was missing in schedule given, so assumed as 0.

Hope it helps.