Managerial Accounting

Unit4_IPScheduleExcelTemplate.xlsx

Budget Data

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