CFO presented variance analysis to the CEO. It was noted as follows: (a) Total profit variance...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
CFO presented variance analysis to the CEO. It was noted as follows: (a) Total profit variance = 309960 (U) comprising revenue variance = 32100 (F), consultant expense variance =280800 (U), and overhead variance = 61260 (U). (b) CFO's presentation was on the aggregate data of both contracts and solutions businesses that provided some sense about more volume in the contracts business, reduction in overall billing rate, increase in overall wage rate, etc. CEO wondered whether the variance analysis of revenues and consultant expenses separately for each business would provide more relevant information for example, the effect of additional manpower on revenue as well as consultant expenses (net gain or net loss), which business contributed additional revenue, which business incurred additional consultant expenses, etc. Consider the following details from the case: Particulars Budget Actual Contract business - hours billed 20160 24000 Billing rate per hour 54 56 Revenue amount 1088640 1344000 Solutions business - hours billed 15750 15000 Billing rate per hour 136.08 128 Revenue amount 2143260 1920000 Total revenue 3231900 3264000 Contract business - hour supplied 25200 28800 Consultant expenses Consultant expenses Consultant wage rate per hour Solutions business - hour supplied Consultant wage rate per hour Total consultant expenses 30 36 756000 1036800 22050 22050 45 992250 45 992250 1748250 2029050 Fill in the details in the following table that can provide more information to CEO. Particulars Revenue variance Divided into: (a) Billing rate variance (b) Billed variance hours' quantity Consultant expense variance Divided into: (a) Wage rate variance (b) Supplied hours' quantity variance Net gain/loss (revenue variance expense variance) Contracts business Solutions business CFO presented variance analysis to the CEO. It was noted as follows: (a) Total profit variance = 309960 (U) comprising revenue variance = 32100 (F), consultant expense variance =280800 (U), and overhead variance = 61260 (U). (b) CFO's presentation was on the aggregate data of both contracts and solutions businesses that provided some sense about more volume in the contracts business, reduction in overall billing rate, increase in overall wage rate, etc. CEO wondered whether the variance analysis of revenues and consultant expenses separately for each business would provide more relevant information for example, the effect of additional manpower on revenue as well as consultant expenses (net gain or net loss), which business contributed additional revenue, which business incurred additional consultant expenses, etc. Consider the following details from the case: Particulars Budget Actual Contract business - hours billed 20160 24000 Billing rate per hour 54 56 Revenue amount 1088640 1344000 Solutions business - hours billed 15750 15000 Billing rate per hour 136.08 128 Revenue amount 2143260 1920000 Total revenue 3231900 3264000 Contract business - hour supplied 25200 28800 Consultant expenses Consultant expenses Consultant wage rate per hour Solutions business - hour supplied Consultant wage rate per hour Total consultant expenses 30 36 756000 1036800 22050 22050 45 992250 45 992250 1748250 2029050 Fill in the details in the following table that can provide more information to CEO. Particulars Revenue variance Divided into: (a) Billing rate variance (b) Billed variance hours' quantity Consultant expense variance Divided into: (a) Wage rate variance (b) Supplied hours' quantity variance Net gain/loss (revenue variance expense variance) Contracts business Solutions business
Expert Answer:
Answer rating: 100% (QA)
Answer Particulars Contracts business Solutions business Revenue variance 264360 U ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A.Calculate the price of a call option using the binomial pricing model and assuming that the short rate follows the FabozziKalotay andWilliams model. The current rate is 6%, mu is .1 and vol is .23....
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
An astronaut must journey to a distant planet, which is 200 light-years from Earth. What speed will be necessary if the astronaut wishes to age only 10 years during the round trip?
-
How can a project manager help to prevent a project from being terminated early?
-
Jet fuel is the largest operating cost for Delta Air Lines. In 2015, Delta's CEO Richard Anderson announced that the firm was likely to save more than $2 billion during the year because of lower fuel...
-
On 1 January 2008 Scottish Castle Ltd had a balance on its debtors account and a provision for doubtful debts as follows: On 31 December 2008 the balance on the debtors account was 1,600,000. The...
-
The unadjusted trial balance of Frank Investment Advisers at December 31, 2016, follows: Adjustment data at December 31, 2016: a. Unearned Revenue earned during the year, $ 100. b. Office Supplies on...
-
10-9-8-7-6-5-4 321 3 723 6 -7 -8 9- 10+ 7 89.16 The focus F is at (1,2) The directrix has equation y=-4 The vertex V is at (1,-1) The line of symmetry has equation = 1 symmetry) The equation of the...
-
Analyze an environmental issue impacting the State of New York. How does this environmental issue impact human health or the environment? (New York) Explain how the environmental law regulates your...
-
You get a 30-year, $280,000 mortgage at 6.4% interest.Calculate the interest for the first calendar year if your first payment was made in July.
-
This is a thesis statement for the White Paper: The shortage of mental health doctors and nutritionists in the Kosovo Security Force undermines its members' well-being and operational effectiveness,...
-
On a consolidated business sheet are "cash equivalents" the same thing as "marketable securities"? If not, what are considered to be marketable securities?
-
During the first week of April, Gillian worked a total of 50 hours assembling products and had no idle time. Gillian is paid $15 per hour for regular time, and is paid time-and-a-half for all hours...
-
Pedro and Laura will have a baby in 3 months from now, and they have started to plan different financial aspects of their child's life. In this planning process, they are considering different...
-
Required information Exercise 6-8 (Algo) Record inventory purchase and purchase discount using a perpetual system (LO6-5) [The following information applies to the questions displayed below.] On June...
-
One Way Cellular accountants have assembled the following data for the year ended September 30, 2014: Prepare the operating activities section using the indirect method for One Way Cellulars...
-
Assume that a division of Sony, Inc. makes an electronic component for its speakers. Its manufacturing process for the component is a highly automated part of a just-in-time production system. All...
-
Consider these data regarding Muskoka Countys photocopying equipment: The county administrator is trying to decide whether to replace the old equipment. Because of rapid changes in technology, she...
-
Mussina Chemical Company produced three joint products at a joint cost of $117,000. These products were processed further and sold as follows: CHEMICAL PRODUCT ADDITIONAL SALES PROCESSING COSTS ABC...
Study smarter with the SolutionInn App