expand icon
book Fundamentals of Cost Accounting 3rd Edition by William N. Lanen, Shannon W. Anderson, Michael Maher cover

Fundamentals of Cost Accounting 3rd Edition by William N. Lanen, Shannon W. Anderson, Michael Maher

Edition 3ISBN: 0073527114
book Fundamentals of Cost Accounting 3rd Edition by William N. Lanen, Shannon W. Anderson, Michael Maher cover

Fundamentals of Cost Accounting 3rd Edition by William N. Lanen, Shannon W. Anderson, Michael Maher

Edition 3ISBN: 0073527114
Exercise 30

Profit Variance Analysis, Service Organization

Refer to the data in Exercise in 17-24. Prepare a profit variance analysis for Lowe&Rent like the one in Exhibit 16.5 of the previous chapter.

Step-by-step solution
Verified
like image
like image

Step 1 of 2

L&R is a law firm which specialize in probate works. The profit variance analysis of L&R firm is as under:

The difference between actual cost and the flexible budget is the cost variance/ price variance as calculated in column (2) and (3).

The activity variance is the difference between flexible budget amount (budgeted cost on the basis of actual hours of 6,900 and the master budget based on 6,000 hours as calculated in column (5).

L&R Firm

Flexible Budget for 6,900 Billable Hours

(1)

(2)

(3)

(4)

(5)

(6)

Actual cost (based on 6,900 hrs)

Cost Variance

Price Variance

Flexible Budget (based on 6,900 hrs)

Sales Activity variance

Master Budget (based on 6,000 hrs)

Revenues

$825,000

-

$37,500U

$862,500

$112,500F

$750,000

Professional salaries(all variable)

$465,000

$33,750U

-

$431,250

$56,250U

$375,000

Other variable cost

$108,000

$9,300F

-

$117,300

$15,300U

$102,000

Fixed cost

$174,000

$6,000F

-

$180,000

-

$180,000

Total cost

$747,000

$18,450U

-

$728,550

$71,550U

$657,000

Profit

$78,000

$55,950U

-

$133,950

$40,950F

$93,000

The cost/price variance is the difference between actual cost and the flexible budget calculated on actual hours taken.

    <div class=answer> L&R is a law firm which specialize in probate works. The profit variance analysis of L&R firm is as under: The difference between actual cost and the flexible budget is the cost variance/ price variance as calculated in column (2) and (3). The activity variance is the difference between flexible budget amount (budgeted cost on the basis of actual hours of 6,900 and the master budget based on 6,000 hours as calculated in column (5). L&R Firm Flexible Budget for 6,900 Billable Hours <table style=border-collapse:collapse; border=1>     <tbody>      <tr>       <td> </td>       <td> (1) </td>       <td> (2) </td>       <td> (3) </td>       <td> (4) </td>       <td> (5) </td>       <td> (6) </td>      </tr>      <tr>       <td> </td>       <td> Actual cost (based on 6,900 hrs) </td>       <td> Cost Variance </td>       <td> Price Variance </td>       <td> Flexible Budget (based on 6,900 hrs) </td>       <td> Sales Activity variance </td>       <td> Master Budget (based on 6,000 hrs) </td>      </tr>      <tr>       <td> Revenues </td>       <td> $825,000 </td>       <td> - </td>       <td> $37,500U </td>       <td> $862,500 </td>       <td> $112,500F </td>       <td> $750,000 </td>      </tr>      <tr>       <td> Professional salaries(all variable) </td>       <td> $465,000 </td>       <td> $33,750U </td>       <td> - </td>       <td> $431,250 </td>       <td> $56,250U </td>       <td> $375,000 </td>      </tr>      <tr>       <td> Other variable cost </td>       <td> $108,000 </td>       <td> $9,300F </td>       <td> - </td>       <td> $117,300 </td>       <td> $15,300U </td>       <td> $102,000 </td>      </tr>      <tr>       <td> Fixed cost </td>       <td> $174,000 </td>       <td> $6,000F </td>       <td> - </td>       <td> $180,000 </td>       <td> - </td>       <td> $180,000 </td>      </tr>      <tr>       <td> Total cost </td>       <td> $747,000 </td>       <td> $18,450U </td>       <td> - </td>       <td> $728,550 </td>       <td> $71,550U </td>       <td> $657,000 </td>      </tr>      <tr>       <td> Profit </td>       <td> $78,000 </td>       <td> $55,950U </td>       <td> - </td>       <td> $133,950 </td>       <td> $40,950F </td>       <td> $93,000 </td>      </tr>     </tbody>    </table> The cost/price variance is the difference between actual cost and the flexible budget calculated on actual hours taken.

    <div class=answer> L&R is a law firm which specialize in probate works. The profit variance analysis of L&R firm is as under: The difference between actual cost and the flexible budget is the cost variance/ price variance as calculated in column (2) and (3). The activity variance is the difference between flexible budget amount (budgeted cost on the basis of actual hours of 6,900 and the master budget based on 6,000 hours as calculated in column (5). L&R Firm Flexible Budget for 6,900 Billable Hours <table style=border-collapse:collapse; border=1>     <tbody>      <tr>       <td> </td>       <td> (1) </td>       <td> (2) </td>       <td> (3) </td>       <td> (4) </td>       <td> (5) </td>       <td> (6) </td>      </tr>      <tr>       <td> </td>       <td> Actual cost (based on 6,900 hrs) </td>       <td> Cost Variance </td>       <td> Price Variance </td>       <td> Flexible Budget (based on 6,900 hrs) </td>       <td> Sales Activity variance </td>       <td> Master Budget (based on 6,000 hrs) </td>      </tr>      <tr>       <td> Revenues </td>       <td> $825,000 </td>       <td> - </td>       <td> $37,500U </td>       <td> $862,500 </td>       <td> $112,500F </td>       <td> $750,000 </td>      </tr>      <tr>       <td> Professional salaries(all variable) </td>       <td> $465,000 </td>       <td> $33,750U </td>       <td> - </td>       <td> $431,250 </td>       <td> $56,250U </td>       <td> $375,000 </td>      </tr>      <tr>       <td> Other variable cost </td>       <td> $108,000 </td>       <td> $9,300F </td>       <td> - </td>       <td> $117,300 </td>       <td> $15,300U </td>       <td> $102,000 </td>      </tr>      <tr>       <td> Fixed cost </td>       <td> $174,000 </td>       <td> $6,000F </td>       <td> - </td>       <td> $180,000 </td>       <td> - </td>       <td> $180,000 </td>      </tr>      <tr>       <td> Total cost </td>       <td> $747,000 </td>       <td> $18,450U </td>       <td> - </td>       <td> $728,550 </td>       <td> $71,550U </td>       <td> $657,000 </td>      </tr>      <tr>       <td> Profit </td>       <td> $78,000 </td>       <td> $55,950U </td>       <td> - </td>       <td> $133,950 </td>       <td> $40,950F </td>       <td> $93,000 </td>      </tr>     </tbody>    </table> The cost/price variance is the difference between actual cost and the flexible budget calculated on actual hours taken.

    <div class=answer> L&R is a law firm which specialize in probate works. The profit variance analysis of L&R firm is as under: The difference between actual cost and the flexible budget is the cost variance/ price variance as calculated in column (2) and (3). The activity variance is the difference between flexible budget amount (budgeted cost on the basis of actual hours of 6,900 and the master budget based on 6,000 hours as calculated in column (5). L&R Firm Flexible Budget for 6,900 Billable Hours <table style=border-collapse:collapse; border=1>     <tbody>      <tr>       <td> </td>       <td> (1) </td>       <td> (2) </td>       <td> (3) </td>       <td> (4) </td>       <td> (5) </td>       <td> (6) </td>      </tr>      <tr>       <td> </td>       <td> Actual cost (based on 6,900 hrs) </td>       <td> Cost Variance </td>       <td> Price Variance </td>       <td> Flexible Budget (based on 6,900 hrs) </td>       <td> Sales Activity variance </td>       <td> Master Budget (based on 6,000 hrs) </td>      </tr>      <tr>       <td> Revenues </td>       <td> $825,000 </td>       <td> - </td>       <td> $37,500U </td>       <td> $862,500 </td>       <td> $112,500F </td>       <td> $750,000 </td>      </tr>      <tr>       <td> Professional salaries(all variable) </td>       <td> $465,000 </td>       <td> $33,750U </td>       <td> - </td>       <td> $431,250 </td>       <td> $56,250U </td>       <td> $375,000 </td>      </tr>      <tr>       <td> Other variable cost </td>       <td> $108,000 </td>       <td> $9,300F </td>       <td> - </td>       <td> $117,300 </td>       <td> $15,300U </td>       <td> $102,000 </td>      </tr>      <tr>       <td> Fixed cost </td>       <td> $174,000 </td>       <td> $6,000F </td>       <td> - </td>       <td> $180,000 </td>       <td> - </td>       <td> $180,000 </td>      </tr>      <tr>       <td> Total cost </td>       <td> $747,000 </td>       <td> $18,450U </td>       <td> - </td>       <td> $728,550 </td>       <td> $71,550U </td>       <td> $657,000 </td>      </tr>      <tr>       <td> Profit </td>       <td> $78,000 </td>       <td> $55,950U </td>       <td> - </td>       <td> $133,950 </td>       <td> $40,950F </td>       <td> $93,000 </td>      </tr>     </tbody>    </table> The cost/price variance is the difference between actual cost and the flexible budget calculated on actual hours taken.

    <div class=answer> L&R is a law firm which specialize in probate works. The profit variance analysis of L&R firm is as under: The difference between actual cost and the flexible budget is the cost variance/ price variance as calculated in column (2) and (3). The activity variance is the difference between flexible budget amount (budgeted cost on the basis of actual hours of 6,900 and the master budget based on 6,000 hours as calculated in column (5). L&R Firm Flexible Budget for 6,900 Billable Hours <table style=border-collapse:collapse; border=1>     <tbody>      <tr>       <td> </td>       <td> (1) </td>       <td> (2) </td>       <td> (3) </td>       <td> (4) </td>       <td> (5) </td>       <td> (6) </td>      </tr>      <tr>       <td> </td>       <td> Actual cost (based on 6,900 hrs) </td>       <td> Cost Variance </td>       <td> Price Variance </td>       <td> Flexible Budget (based on 6,900 hrs) </td>       <td> Sales Activity variance </td>       <td> Master Budget (based on 6,000 hrs) </td>      </tr>      <tr>       <td> Revenues </td>       <td> $825,000 </td>       <td> - </td>       <td> $37,500U </td>       <td> $862,500 </td>       <td> $112,500F </td>       <td> $750,000 </td>      </tr>      <tr>       <td> Professional salaries(all variable) </td>       <td> $465,000 </td>       <td> $33,750U </td>       <td> - </td>       <td> $431,250 </td>       <td> $56,250U </td>       <td> $375,000 </td>      </tr>      <tr>       <td> Other variable cost </td>       <td> $108,000 </td>       <td> $9,300F </td>       <td> - </td>       <td> $117,300 </td>       <td> $15,300U </td>       <td> $102,000 </td>      </tr>      <tr>       <td> Fixed cost </td>       <td> $174,000 </td>       <td> $6,000F </td>       <td> - </td>       <td> $180,000 </td>       <td> - </td>       <td> $180,000 </td>      </tr>      <tr>       <td> Total cost </td>       <td> $747,000 </td>       <td> $18,450U </td>       <td> - </td>       <td> $728,550 </td>       <td> $71,550U </td>       <td> $657,000 </td>      </tr>      <tr>       <td> Profit </td>       <td> $78,000 </td>       <td> $55,950U </td>       <td> - </td>       <td> $133,950 </td>       <td> $40,950F </td>       <td> $93,000 </td>      </tr>     </tbody>    </table> The cost/price variance is the difference between actual cost and the flexible budget calculated on actual hours taken.

    <div class=answer> L&R is a law firm which specialize in probate works. The profit variance analysis of L&R firm is as under: The difference between actual cost and the flexible budget is the cost variance/ price variance as calculated in column (2) and (3). The activity variance is the difference between flexible budget amount (budgeted cost on the basis of actual hours of 6,900 and the master budget based on 6,000 hours as calculated in column (5). L&R Firm Flexible Budget for 6,900 Billable Hours <table style=border-collapse:collapse; border=1>     <tbody>      <tr>       <td> </td>       <td> (1) </td>       <td> (2) </td>       <td> (3) </td>       <td> (4) </td>       <td> (5) </td>       <td> (6) </td>      </tr>      <tr>       <td> </td>       <td> Actual cost (based on 6,900 hrs) </td>       <td> Cost Variance </td>       <td> Price Variance </td>       <td> Flexible Budget (based on 6,900 hrs) </td>       <td> Sales Activity variance </td>       <td> Master Budget (based on 6,000 hrs) </td>      </tr>      <tr>       <td> Revenues </td>       <td> $825,000 </td>       <td> - </td>       <td> $37,500U </td>       <td> $862,500 </td>       <td> $112,500F </td>       <td> $750,000 </td>      </tr>      <tr>       <td> Professional salaries(all variable) </td>       <td> $465,000 </td>       <td> $33,750U </td>       <td> - </td>       <td> $431,250 </td>       <td> $56,250U </td>       <td> $375,000 </td>      </tr>      <tr>       <td> Other variable cost </td>       <td> $108,000 </td>       <td> $9,300F </td>       <td> - </td>       <td> $117,300 </td>       <td> $15,300U </td>       <td> $102,000 </td>      </tr>      <tr>       <td> Fixed cost </td>       <td> $174,000 </td>       <td> $6,000F </td>       <td> - </td>       <td> $180,000 </td>       <td> - </td>       <td> $180,000 </td>      </tr>      <tr>       <td> Total cost </td>       <td> $747,000 </td>       <td> $18,450U </td>       <td> - </td>       <td> $728,550 </td>       <td> $71,550U </td>       <td> $657,000 </td>      </tr>      <tr>       <td> Profit </td>       <td> $78,000 </td>       <td> $55,950U </td>       <td> - </td>       <td> $133,950 </td>       <td> $40,950F </td>       <td> $93,000 </td>      </tr>     </tbody>    </table> The cost/price variance is the difference between actual cost and the flexible budget calculated on actual hours taken.

    <div class=answer> L&R is a law firm which specialize in probate works. The profit variance analysis of L&R firm is as under: The difference between actual cost and the flexible budget is the cost variance/ price variance as calculated in column (2) and (3). The activity variance is the difference between flexible budget amount (budgeted cost on the basis of actual hours of 6,900 and the master budget based on 6,000 hours as calculated in column (5). L&R Firm Flexible Budget for 6,900 Billable Hours <table style=border-collapse:collapse; border=1>     <tbody>      <tr>       <td> </td>       <td> (1) </td>       <td> (2) </td>       <td> (3) </td>       <td> (4) </td>       <td> (5) </td>       <td> (6) </td>      </tr>      <tr>       <td> </td>       <td> Actual cost (based on 6,900 hrs) </td>       <td> Cost Variance </td>       <td> Price Variance </td>       <td> Flexible Budget (based on 6,900 hrs) </td>       <td> Sales Activity variance </td>       <td> Master Budget (based on 6,000 hrs) </td>      </tr>      <tr>       <td> Revenues </td>       <td> $825,000 </td>       <td> - </td>       <td> $37,500U </td>       <td> $862,500 </td>       <td> $112,500F </td>       <td> $750,000 </td>      </tr>      <tr>       <td> Professional salaries(all variable) </td>       <td> $465,000 </td>       <td> $33,750U </td>       <td> - </td>       <td> $431,250 </td>       <td> $56,250U </td>       <td> $375,000 </td>      </tr>      <tr>       <td> Other variable cost </td>       <td> $108,000 </td>       <td> $9,300F </td>       <td> - </td>       <td> $117,300 </td>       <td> $15,300U </td>       <td> $102,000 </td>      </tr>      <tr>       <td> Fixed cost </td>       <td> $174,000 </td>       <td> $6,000F </td>       <td> - </td>       <td> $180,000 </td>       <td> - </td>       <td> $180,000 </td>      </tr>      <tr>       <td> Total cost </td>       <td> $747,000 </td>       <td> $18,450U </td>       <td> - </td>       <td> $728,550 </td>       <td> $71,550U </td>       <td> $657,000 </td>      </tr>      <tr>       <td> Profit </td>       <td> $78,000 </td>       <td> $55,950U </td>       <td> - </td>       <td> $133,950 </td>       <td> $40,950F </td>       <td> $93,000 </td>      </tr>     </tbody>    </table> The cost/price variance is the difference between actual cost and the flexible budget calculated on actual hours taken.


Step 2 of 2

close menu
Fundamentals of Cost Accounting 3rd Edition by William N. Lanen, Shannon W. Anderson, Michael Maher
cross icon