CFO presented variance analysis to the CEO. It was noted as follows: (a) Total profit variance...

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

Answer rating: 100% (QA)

Answer Particulars Contracts business Solutions business Revenue variance 264360 U ... View the full answer