Question: please include interpretation of solution in 5 sentences Exhibit 5: Line of Business Budget and Actual Operating Statistics: Q2 2000 Contract ACTUAL Solutions Total Contract

please include interpretation of solution in 5 sentences

Exhibit 5: Line of Business Budget and Actual Operating Statistics: Q2 2000 Contract ACTUAL Solutions Total Contract Number of Consultants.(FTEL.. Biled. Havrs. Biled. Revenvea. BUDGET Solutions 49 .15.750. 2.143.280 24.099. 1.344.000 15.090. 1.929.000 39.000. 3.264.000. 20.169 1.088.640 Total 105 35.910. 3.23.1.999, Houts Suprliest Consultant Costs. 28.800. 1.036.800 .22.050 992.250 50.850. 2.029.050 .25.290. 756.000 22.050 992 250 47.250. 1.748,250 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 Mix 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: Cootrest. ACTUAL Solutions 15.990. Total BUDGET Solutions 15.759. Tata! 39.09. .35.9.10. .Contrast. 29.162. 1.088.640. 756.099 .3.264.999. 2.143.250 Billed. Hovs. Biling Rate Revenues. Consultant expense. House Suralios Houdy.cost/consultant Biled.%. Gras Marain... Gross Macain Porcent .1349.000 1.036.890 28.8.00 .1.929.000. .992.250. 2.9.50 .3.23.1.999. 1.748.250. 47.259. Contrast. FLY Solution....... Total Fayecable/Mofavorable Decomposition Pure billing rate price variance Mix variance Revenue rate variance Pure consultant cost price variance Mix variance Consultant expense rate variance F Exhibit 5: Line of Business Budget and Actual Operating Statistics: Q2 2000 Contract ACTUAL Solutions Total Contract Number of Consultants.(FTEL.. Biled. Havrs. Biled. Revenvea. BUDGET Solutions 49 .15.750. 2.143.280 24.099. 1.344.000 15.090. 1.929.000 39.000. 3.264.000. 20.169 1.088.640 Total 105 35.910. 3.23.1.999, Houts Suprliest Consultant Costs. 28.800. 1.036.800 .22.050 992.250 50.850. 2.029.050 .25.290. 756.000 22.050 992 250 47.250. 1.748,250 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 Mix 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: Cootrest. ACTUAL Solutions 15.990. Total BUDGET Solutions 15.759. Tata! 39.09. .35.9.10. .Contrast. 29.162. 1.088.640. 756.099 .3.264.999. 2.143.250 Billed. Hovs. Biling Rate Revenues. Consultant expense. House Suralios Houdy.cost/consultant Biled.%. Gras Marain... Gross Macain Porcent .1349.000 1.036.890 28.8.00 .1.929.000. .992.250. 2.9.50 .3.23.1.999. 1.748.250. 47.259. Contrast. FLY Solution....... Total Fayecable/Mofavorable Decomposition Pure billing rate price variance Mix variance Revenue rate variance Pure consultant cost price variance Mix variance Consultant expense rate variance F

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

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...

Fill this worksheet and show formula too Exhibit 5: Line of Business Budget and Actual Operating Statistics: Q2 2000 Number of Consultants(FTE) Billed Hours Billed Revenues Contract 64 24.000...

please include interpretation of solution in 5 sentences There is no solution 5. Its only the question in the picture provided. Im asking you to provide an interpretation of your answer in 5...

please include interpretation of the solution in 5 sentences. Exhibit 2: Budget and Actual Income Statement: Quarter 2 2000 Actual 3.264,000 Budget 3.231.900 $ $ $ $ $ Revenues Less: Consultants...

VARIANCE ANALYSIS Use Exhibits below to answer questions. Do variance analysis. Jenkins was finally driving home at 2 AM. She felt well equipped for the meeting the next morning but wondered about...

Online Class EMB 834 Question 1. Case Study Budgeting, Budgetary Control and Performance Evaluation: A Case Study of Techville Solution Preface Tarry Williams, the founder and CEO of Techville...

MGT489 Point of View Analyses (2 of them for this summer's class) Guidelines: No more than four pages, single spaced, no smaller than 11 point type. Your name, date, title of the case and what number...

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Please read carefully, all necessary information is attached, need to show work let me know if there is something missing. Microsoft word can be used thanks. You are Cindy, completing the analysis...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

For the three-cart system illustrated in Figure AP2.5, obtain the equations of motion. The system has three inputs u1, u2, and u3 and three outputs x1, x2, and x3. Obtain three second-order ordinary...

2 If y = x^x, then prove that d2y/dx2-1/y(dy/dx)^2 - Y/X = 0.

Consider an ordinary simple perpetuity with annual payments. If the first payment happens in one year, when does the term of the perpetuity begin?

Family coordination. Despite the eroding of the traditional family in many of the Soviet republics, there is evidence that family traditions and ties had survived despite Sovietization and...

branch ministries to which enterprises were directly subordinated, and which were responsible for translating directives of the functional committees into concrete operating decisions for the...

Self-governing coordination. The nominal character of cooperative enterprises was of self-governance, but only vestiges of a system of proposals or criticisms from below pertained in practice. It is...