Question

Executive Solutions is a strategy 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 $970 per hour and staff at a rate of $485 per hour. Managers are paid $295 per hour worked (including nonbillable time) and staff are paid $160 per hour. The current plan calls for managers to bill 1,270 hours in May and 820 hours in June. Staff are expected to bill 6,540 hours in May and 4,640 hours in June. Managers will work a total of 2,540 hours in both months and staff will work a total of 9,740 hours in both months. Other monthly costs (all fixed) are $553,500 SG&A, $228,500 in depreciation, and $353,500 in marketing. Required: Prepare a budgeted income statement for Executive Solutions for May and June (separately).

Answer 1

Income(Loss) $960,600;($397,400)

Step-by-step explanation:

EXECUTIVE SOLUTIONS

Budgeted Income Statement

May June

Revenues:

Managers$1,231,900 $795,400

Staff $3,171,900 $2,250,400

Total revenue (i)$4,403,800 $3,045,800

Expenses:

Manager

compensation$749,300 $749,300

Staff compensation$1,558,400 $1,558,400

Total

compensation (ii)$2,307,700 $2,307,700

SG&A $553,500 $553,500

Depreciation $228,500 $228,500

Marketing $353,500 $353,50

Total

expenses (iii)$1,135,500 $1,135,500

Income(Loss)

(i)-(ii)-(iii) $960,600 ($397,400)

BMay June

Revenues:

Managers

[1,270 hours x $ 970] $1,231,900

[820 hours x $970] $795,400

Staff

[ 6,540hours x $485] $3,171,900

[4,640 hours x $485] $2,250,400

Expenses:

Manager compensation$749,300 $749,300

[2,540 hours x $295]

Staff compensation $1,558,400 $1,558,400

[9,740 hours x $160]