I'm having a hard time with figuring out the table below. It is for a question in Managerial Accounting. The question is: The managing partner of the law firm Sewell, Bagan, and Clark, LLP makes asset acquisition and disposal decisions for the firm. As managing partner, she supervises the partners in charge of the firm's three branch offices. Those partners have the authority to make employee compensation decisions. The partners' compensation depends on the profitability of their branch office. Vanessa Smith manages the City Branch, which has the following master budget and actual results for the year ended December 31.

One of my main issues is that even when putting in the numbers given by the book I am receiving errors in my calculations. Can you help. Below is the table given in the book. Below that is what I have filled in so far.

	Master Budget	Actual Results
Billed Hours	5,000	4,900
Revenue	$ 250,000.00	$ 254,800.00
Controllable Variable Costs:
Direct Labor	(120,000)	(137,200)
Variable Overhead	(90,000)	(34,300)
Contribution Margin	$ 90,000.00	$ 83,300.00
Controllable Fixed Costs:
Rent	(30,000)	(30,000)
Other Admin expenses	(45,000)	$ (42,000.00)
Branch Operating Income	$ 15,000.00	$ 11,300.00

Here is the table I am filling in to complete the answers.

Sewell, Bagan, and Clark, LLP

City Branch

Performance Report

For the Year Ended December 31

Partner in Charge: Vanessa Smith

Actual results

Variance

Flexible budget

Variance

Master budget

Billed hours

4,900

0

4,900

$100

*

U

5,000

Revenue

$254,800

*

($9,800)

*

F

$245,000

*

$5,000

*

F

$250,000

*

Controllable variable

costs:

Direct labor

(137,200)

(19,600)

U

$117,600

*

2,400

F

(120,000)

Variable overhead

(34,300)

4,900

F

$39,200

*

800

F

(90,000)

*

Contribution margin

$83,300

*

$4,900

*

U

$88,200

*

($1,800)

*

U

$90,000

*

Controllable fixed costs:

Rent

(30,000)

0

(30,000)

0

(30,000)

Other administrative

expenses

(42,000)

3,000

F

(45,000)

0

(45,000)

Branch operating income

$11,300

*

($1,900)

*

U

$13,200

*

($1,800)

*

U

$15,000

*

a.

Actual

Flexible

Master

ROI =

=

Residual Income =

=