Scrooge & Zilch is a law firm with partners and staff members. Each billable hour of partner time has ©

a $275 budgeted price and $130 budgeted variable cost. Each billable hour of staff time has a budgeted price of $65 and budgeted variable cost of $35. This month, the partnership budget called for 8,500 billable partner hours and 34,650 staff hours. Actual results follow:

Revenue Billable Hours Variable Cost Partnetittataa gece ee oe eee $2,245,000 8,000 hours $ 995,000 SLATE eesas eam ee ee Zrloo O00 34,000 hours 1,200,000 Required ;
Compute the following variances from a revenue perspective:

a. Sales-price and sales-volume variances.

b. Sales-mix and sales-quantity variances.

c. BUILD YOUR OWN SPREADSHEET. Build an Excel spreadsheet to complete requirements

(a) and (b).