Question
Prepare an analysis of actual versus budgeted revenues, consultant expenses, and margins using the additional information supplied in Exhibit 4. Exhibit 4 Line of Business
Prepare an analysis of actual versus budgeted revenues, consultant expenses, and margins using the additional information supplied in Exhibit 4.
Exhibit 4 Line of Business Budget and Actual Operating Statistics: Q2 2000
| Contract | Solutions | Total |
Actual Number of consultants (FTE) |
64 |
49 |
113 |
Billed hours | 24,000 | 15,000 | 39,000 |
Billed revenues | $1,344,000 | $1,920,000 | $3,264,000 |
Hours supplied |
28,800 |
22,050 |
50,850 |
Consultant costs
| $1,036,800
| $992,250
| $2,029,050
|
Budget Number of consultants (FTE) |
56 |
49 |
105 |
Billed hours | 20,160 | 15,750 | 35,910 |
Billed revenues
| $1,088,640
| $2,143,260
| $3,231,900
|
Hours supplied | 25,200 | 22,050 | 47,250 |
Consultant costs $756,000 $992,250 $1,748,250
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started