Executive Solutions is a strategy consulting firm. Other than the senior leaders

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 blled to dlients 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 $930 per hour and staff at a rate of $465 per hour. Managers are paid $255 per hour worked (including nonbillable time) and staff are paid $140 per hour. The current plan calls for managers to bill 1,230 hours in May and 780 hours in June. Staff are expected to bill 6,460 hours in May and 4,560 hours in June. Managers will work a total of 2,460 hours in both months and staff will work a total of 9,660 hours in both months. Other monthly costs (all fixed) are $551,500 SG&A;, $226,500 in depreciation, and $351,500 in marketing. Required Prepare a budgeted income statement for Executive Solutions for May and June (separately) EXECUTIVE SOLUTIONS Budgeted Income Statement May June Revenues Managers Staff Total revenue Expenses: Manager compensation Staff compensation Total compensation SG&A; Depreciation Marketing Total expenses Income (Loss)

Explanation / Answer

Solution :-

Particulars May June Revenues :- Managers (1230*$930) = $1143900 (780*$930) = $725400 Staff (6460*$465) = $3003900 (4560*$465) = $2120400 Total Revenue (A) $4147800 $2845800 Expenses :- Manager Compensation ((2460/2)*$255)= $313650 ((2460/2)*$255)= $313650 Staff Compensation ((9660/2)*$140)= $676200 ((9660/2)*$140)= $676200 Total Compensation (B) $989850 $989850 SG&A (C) $551500 $551500 Depreciation (D) $226500 $226500 Marketing (E) $351500 $351500 Total Expense (B+C+D+E) $2119350 $2119350 Income/(Loss) $2028450 $726450

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.