In this problem, you must create the flexible budget and flexible budget varianc
ID: 2465779 • Letter: I
Question
In this problem, you must create the flexible budget and flexible budget variances for two cost items. I suggest the following steps for each item:
determine the cost function for the two items
plug in the appropriate activity amount and compute the budget
subtract the actual cost and compute the variance.
Be sure to follow the instructions about the sign that you should enter with your numerical answer. There is no partial credit - you must get both variances correct in order to get the full 10 points.
______________________________________________________
The following is monthly budgeted cost and activity information for the four activity centers in the billing department of Oregon Power Company:
Variable
Fixed
Cost Driver
$74,336
$156,000
3,200 labor hours
$9,940
$26,000
2,800 letters
$144,000
$73,000
2,400,000 lines
$9,555
$78,000
19,500 accounts
In September, actual costs and activity were as follows:
Total Costs
Driver Amount
$225,727
3,010 labor hours
$36,945
2,980 letters
$206,054
2,230,000 lines
$87,065
19,700 accounts
Required
Compute the flexible-budget variances for the following two activity cost items (round all answers to the nearest dollar and enter favorable variances as positive numbers and unfavorable variances as negative numbers):
Bill verification ____________
Account billing _____________
Variable
Fixed
Cost Driver
Account inquiry$74,336
$156,000
3,200 labor hours
Correspondence$9,940
$26,000
2,800 letters
Account billing$144,000
$73,000
2,400,000 lines
Bill verification$9,555
$78,000
19,500 accounts
Explanation / Answer
Rate Variance =(4.49 - 4.42) 19700 = $1388F
Efficiency Variance = (19500 - 19700) 4.49 = $898U
Spending variance = 87555 - 87065 = $490F
Rate Variance =(0.090 - 0.092) 2,230,000 = $4354U
Efficiency Variance = (2,400,000 - 2,230,000) 0.090 = $15300F
Spending variance = $217000 - $206,054 = $10946F
COST ITEMS BUDGETED ACTUAL VARIANCE 1. Bill verification $9,555 + $78,000 = $87555 (19500 accounts) $87,065 (19700 accounts)Rate Variance =(4.49 - 4.42) 19700 = $1388F
Efficiency Variance = (19500 - 19700) 4.49 = $898U
Spending variance = 87555 - 87065 = $490F
2. Account billing $144,000 + $73000 = $217000 (2,400,000 lines) $206,054 (2,230,000 lines)Rate Variance =(0.090 - 0.092) 2,230,000 = $4354U
Efficiency Variance = (2,400,000 - 2,230,000) 0.090 = $15300F
Spending variance = $217000 - $206,054 = $10946F
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.