Question

In: Accounting

The following is total monthly budgeted cost and activity information for the four activity centers in...

The following is total monthly budgeted cost and activity information for the four activity centers in the billing department of Oregon Power Company:

Activity Center

Variable

Fixed

Cost Driver

Statement inquiry

$77,385

$150,000

3,300 labor hours

Correspondence

$9,585

$26,000

2,700 letters

Account billing

$171,500

$79,000

2,450,000 lines

Payment verification

$12,980

$78,000

22,000 accounts


In September, actual total costs and activity were as follows:

Activity Center

Total Costs

Driver Amount

Statement inquiry

$225,403

3,220 labor hours

Correspondence

$35,231

2,650 letters

Account billing

$241,504

2,330,000 lines

Payment verification

$90,939

22,050 accounts


Required
Compute the flexible-budget variances for the following two activity cost items (round unit costs to two decimal places and enter favorable variances as positive numbers and unfavorable variances as negative numbers):

  Correspondence   

  Statement inquiry   

Solutions

Expert Solution

First let us calculate the Flexible Budget Amounts

Activity Center Cost Driver Variable Fixed Flexible Cost driver Flexible Total
A B C D B / A X D C + Flexible
Statement inquiry 3,300 labor hours $   77,385 $ 150,000 3,220 labor hours $       75,509 $ 225,509
Correspondence 2,700 letters $      9,585 $   26,000 2,650 letters $         9,408 $    35,408
Account billing 2,450,000 lines $ 171,500 $   79,000 2,330,000 lines $     163,100 $ 242,100
Payment verification 22,000 accounts $   12,980 $   78,000 22,050 accounts $       13,010 $    91,010
Activity Center Flexible Actual Variance
Statement inquiry $        225,509.00 $ 225,403.00 $ -106.00 Unfavorable
Correspondence $          35,407.50 $   35,231.00 $ -176.50 Unfavorable

Related Solutions

The following is total monthly budgeted cost and activity information for the four activity centers in...
The following is total monthly budgeted cost and activity information for the four activity centers in the billing department of Oregon Power Company: Activity Center Variable Fixed Cost Driver Statement inquiry $79,200 $156,000 3,200 labor hours Correspondence $9,639 $22,000 2,700 letters Account billing $144,000 $77,000 2,400,000 lines Payment verification $12,095 $80,000 20,500 accounts In September, actual total costs and activity were as follows: Activity Center Total Costs Driver Amount Statement inquiry $234,023 3,140 labor hours Correspondence $31,154 2,550 letters Account...
The following is total monthly budgeted cost and activity information for the four activity centers in...
The following is total monthly budgeted cost and activity information for the four activity centers in the billing department of Oregon Power Company: Activity Center Variable Fixed Cost Driver Statement inquiry $73,888 $166,000 3,200 labor hours Correspondence $9,604 $27,000 2,800 letters Account billing $130,000 $70,000 2,600,000 lines Payment verification $11,825 $77,000 21,500 accounts In September, actual total costs and activity were as follows: Activity Center Total Costs Driver Amount Statement inquiry $241,803 3,240 labor hours Correspondence $36,377 2,660 letters Account...
The following is total monthly budgeted cost and activity information for the four activity centers in...
The following is total monthly budgeted cost and activity information for the four activity centers in the billing department of Oregon Power Company: Activity Center Variable Fixed Cost Driver Account inquiry $76,416 $150,000 3,200 labor hours Correspondence $10,063 $24,000 2,900 letters Account billing $182,000 $82,000 2,600,000 lines Bill verification $10,750 $79,000 21,500 accounts In September, actual costs and activity were as follows: Activity Center Total Costs Driver Amount Account inquiry $224,331 3,080 labor hours Correspondence $34,101 2,990 letters Account billing...
The following is total monthly budgeted cost and activity information for the four activity centers in...
The following is total monthly budgeted cost and activity information for the four activity centers in the billing department of Oregon Power Company: Activity Center Variable Fixed Cost Driver Account inquiry $82,926 $167,000 3,400 labor hours Correspondence $9,396 $25,000 2,700 letters Account billing $147,000 $88,000 2,450,000 lines Bill verification $11,890 $77,000 20,500 accounts In September, actual costs and activity were as follows: Activity Center Total Costs Driver Amount Account inquiry $252,913 3,540 labor hours Correspondence $34,868 2,630 letters Account billing...
PROBLEM # 7 [ VARIANCE ANALYSIS ... The following is total monthly budgeted cost and activity...
PROBLEM # 7 [ VARIANCE ANALYSIS ... The following is total monthly budgeted cost and activity information for the four activity centers in the billing department of Oregon Power Company: Activity Center Variable Fixed Cost Driver Account inquiry $75,936 $165,000 3,200 labor hours Correspondence $10,324 $21,000 2,900 letters Account billing $156,000 $76,000 2,600,000 lines Bill verification $10,105 $78,000 21,500 accounts In September, actual costs and activity were as follows: Activity Center Total Costs Driver Amount Account inquiry $236,390 3,030 labor...
The following budgeted information is available for Zeta Company: Activity Budgeted Cost Activity Driver Consumption of...
The following budgeted information is available for Zeta Company: Activity Budgeted Cost Activity Driver Consumption of Drivers for Zeta’s Product Lines Total Activity Driver Product A Product B Processing & Testing Developing test programs $400,000 Engineering hours 10,000 2,500 7,500 Making probe cards 58,750 Development hours 4,000 400 3,600 Testing products 300,000 Test hours 20,000 2,000 18,000 Setups 40,000 Number of batches 100 55 45 Engineering design 80,000 Number of change orders 60 9 51 Handling lots 90,000 Number of...
Orion Limited had total overheads for a month of £24,000. The total monthly budgeted labour hours...
Orion Limited had total overheads for a month of £24,000. The total monthly budgeted labour hours were 1,200 and the total budgeted material usage was 1,600 kg. During the month the company gives a quotation for a job which requires 60 kg of materials at £7.50 per kg and 12 direct labour hours at £25 per hour. Overheads are recovered on the basis of direct labour hours. The profit is 25% based on selling price. (i) if the actual direct...
Ruby Company follows activity-based budgeting. From the information given below, calculate the total activity cost of...
Ruby Company follows activity-based budgeting. From the information given below, calculate the total activity cost of the company. Activity description Activity driver Cost per unit of driver Amount of driver Processing mail Number of clients $120 $75 Paying bills Number of bills $ 2.5 $10,000 Investigating Number of new hires $110 $75 Writing reports Number of clients $150 $75 a. $52,500 b. $52,800 c. $53,500 d. $53,200
a company provides the following abc costing information: activities total costs activity cost drivers labor 384000...
a company provides the following abc costing information: activities total costs activity cost drivers labor 384000 8000 hours gas 36000 6000 gallons invoices 180000 total costs 600000 the above activities used by their three departments are : department 1 department 2 department 3 labor 2500 hours 1400 hours 4100 hours gas 1800 gallons 1000 gallons 3200 gallons invoices 1300 invoices 300 invoices 5900 invoices how much of invoice cost will be assigned to department 2?
Assume Domino's Pizza has the following monthly revenue and cost functions: Total Revenue= $10.00x Total Cost=...
Assume Domino's Pizza has the following monthly revenue and cost functions: Total Revenue= $10.00x Total Cost= $16000+$4.00x a. Prepare a graph illistrating Domino's cost-volume-profit relationship. The vertical axis should range from $0 to $72,000, in increments os $12,000. The horizontal axis should range from 0 units to 6,000 units, in increments of 2,000 units. b. Prepare a graph illustrating Domino's profit-volume relationship. The horizontal axis should range from 0 units to 6,000 units, in increments of 2,000 units. c. When...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT