Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CFO presented variance analysis to the CEO. It was noted as follows: (a) Total profit variance = 309960 (U) comprising revenue variance = 32100


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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Answer Particulars Contracts business Solutions business Revenue variance 264360 U ... 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

Advanced Accounting

Authors: Gail Fayerman

1st Canadian Edition

9781118774113, 1118774116, 111803791X, 978-1118037911

More Books

Students also viewed these Accounting questions