Answer question 5

case study software associate fCompatibility Mode)-Excel HOME INSERT PAGE LAYOUT FORMULAS REMEw view ADD INs DATA a wrap Tet Genera Arial A A Format Painter E +E E Merge &Center Conditional Format Table styles Font HARVARD BUSINEs s I s CH o o L Exhibit 5: Line of Business Budget and Actual operating Statistics: Q2 2000 ACTUAL Contract Solutions Total Contract Solutions rotai 49 13 Number of Consul FTE) 105 15750 35,910 1,920,000 2143260 Hours supplied 28,800 202g 050 Question 5: Prepare an analysis of actual versus budgeted revenues, consultant expenses, and margins using the additional information supplied in Exhibit 5 Formulas and approach: Price variance variance (AP-EP) AQ Mx variance variance (AQ-EQ) (EP-EASP) Decompose the information above into Revenue Rate. Consultant Quantity and Rate, and Billing %for both Contract and Solutions. Conduct a variance for each to determine which factors were Favorable or Unfavorable. Your Solution: Question 4 Question 3 Copyright Question 1