Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 Salaries and Fringes Operating Expenses Total Expenses Operating Profit Profit % Operating Statistics Number of Consultants(FTE) Hours Supplied Hours Billed Average Billing Rate 2.029.050 $ 938.560 $ 2967 610$ 296,390 $ 9.1% 1,748.250 877,300 2.625.550 606,350 18.8% 113 50.850 39,000 83.69 105 47.250 35,910 90.00 $ Question 2: Prepare a variance analysis report based on the information in Exhibit2 Formulas and approach: Variance analysis formula: Total revenue variance = AR-ER Revenue decomposition: Revenue = Price per unit" Quantity of units sold (R =P) Quantity Efficiency variance: variance = (AQ - EQ) EP Price/Rate variance: variance = (AP-EP)'AQ Decompose the information above into Revenue Quantity & Rate. Consultant Quantity and Rate. and Billing %. Conduct a variance for each to determine which factors were Favorable or Unfavorable. Your Solution: Actual Quantity Budgeted Quantity Expected Price Favorable! Variance Amount Unfavorable? Revenue Quantity (# Hours) Actual Price Expected Price Actual Quantity Favorable! Variance Amount Unfavorable? Revenue Rate (Hourly Rate) Total Revenue Variance Actual Quantity Budgeted Quantity Expected Price Favorable Variance Amount Unfavorable? Consultant Expense Quantity Actual Price Expected Price Actual Quantity Favorable Variance Amount Unfavorable? Consultant Expense Rate Total Consultant Expense Variance Actual Operating Expenses Expected Operating Expenses Favorable! Variance Amount Unfavorable? Operating Expense Total Expense Variance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Auditing Basics Video Learning Guide

Authors: Charles A. Cianfrani & John E. West, James P. Gildersleeve

1st Edition

1891578251, 978-1891578250

More Books

Students also viewed these Accounting questions

Question

Identify the main sources of stress and how it affects health.

Answered: 1 week ago

Question

2. What are the components of IT infrastructure?

Answered: 1 week ago