BK Consulting is a management consulting firm. Other than the senior leadership
ID: 2453263 • Letter: B
Question
BK Consulting is a management consulting firm. Other than the senior leadership (who manage the firm, but do not actively consult), the managers and staff are billed to clients on an hourly basis. The workload varies quite a bit from month to month requiring careful planning. Managers are billed to clients at a rate of $800 per hour and staff at a rate of $400 per hour. Managers are paid $200 per hour worked (including nonbillable time) and staff are paid $100 per hour. The current plan calls for managers to bill 800 hours in May and 500 hours in June. Staff are expected to bill 4,800 hours in May and 3,000 hours in June. Managers will work a total of 1,600 hours in both months and staff will work a total of 6,400 hours in both months. Other monthly costs (all fixed) are $500,000 SG&A, $200,000 in depreciation, and $300,000 in marketing.
Required: Prepare a budgeted income statement for BK Consulting for May and June (separately).
Explanation / Answer
BK Consulting
Budgeted income statement
for May and June
May
June
Revenue:
Manager's Hours Billing
$ 640,000
$ 400,000
(800 Hours * $800)
(500 Hours * $800)
Staff's Hours Billing
$ 1,920,000
$ 1,200,000
(4800 Hours * $400)
(3000 Hours * $400)
Total Revenue
$ 2,560,000
$ 1,600,000
Less: Expenses:
Manager's Salaries
$ 320,000
$ 320,000
(1600 Hours * $200)
(1600 Hours * $200)
Staff's Salaries
$ 640,000
$ 640,000
(6400 Hours * $100)
(6400 Hours * $100)
Selling and General Admn. Costs
$ 500,000
$ 500,000
Depreciation Expense
$ 200,000
$ 200,000
Marketing Expenses
$ 300,000
$ 300,000
Total Expenses
$ 1,960,000
$ 1,960,000
Net income ( Total Revenue - Total Expenses)
$ 600,000
$ (360,000)
BK Consulting
Budgeted income statement
for May and June
May
June
Revenue:
Manager's Hours Billing
$ 640,000
$ 400,000
(800 Hours * $800)
(500 Hours * $800)
Staff's Hours Billing
$ 1,920,000
$ 1,200,000
(4800 Hours * $400)
(3000 Hours * $400)
Total Revenue
$ 2,560,000
$ 1,600,000
Less: Expenses:
Manager's Salaries
$ 320,000
$ 320,000
(1600 Hours * $200)
(1600 Hours * $200)
Staff's Salaries
$ 640,000
$ 640,000
(6400 Hours * $100)
(6400 Hours * $100)
Selling and General Admn. Costs
$ 500,000
$ 500,000
Depreciation Expense
$ 200,000
$ 200,000
Marketing Expenses
$ 300,000
$ 300,000
Total Expenses
$ 1,960,000
$ 1,960,000
Net income ( Total Revenue - Total Expenses)
$ 600,000
$ (360,000)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.