Question

In: Accounting

2 . Atlantic Company has the following monthly flexible budget information based on an expectation of...

2 . Atlantic Company has the following monthly flexible budget information based on an expectation of operating at 80% of the factory’s capacity or 10,000 units produced:

Operating Levels
70% 80% 90%
Budgeted output in units 8,000 10,000 12,000
Budgeted labor (standard hours) 16,000 20,000 24,000
Budgeted overhead
Variable overhead $ 48,000 $60,000 $ 72,000
Fixed overhead 40,000 40,000 40,000
Total overhead $ 88,000 $100,000 $112,000

During the current month, the company operated at 70% of capacity and employees worked 16,500 hours and the flowing actual overhead costs were incurred:

Variable overhead $ 47,300
Fixed overhead 41,000
Total overhead $88,300

Required:

  1. Compute the predetermined overhead rate per direct labor hour for variable overhead, fixed overhead, and total overhead.
  2. Compute the variable overhead spending and efficiency variances.

Compute the fixed overhead spending and volume variance

Solutions

Expert Solution

Solution 1:

Predetermined variable overhead rate = Budgeted variable overhead at 80% capacity / Budgeted labor hours

= $60,000 / 20000 = $3 per hour

Predetermined fixed overhead rate = Budgeted fixed overhead / Budgeted labor hours = $40,000 / 20000 = $2 per labor hour

Total overhead rate = $3 + $2 = $5 per labor hour

Solution 2:

Variable Overhead Cost Variance
Actual Cost Standard cost for actual quantity Standard Cost
AH * AR = AH * SR = SH * SR =
16500 $2.87 $47,300.00 16500 $3.00 $49,500.00 16000 $3.00 $48,000.00
$2,200.00 Favorable $1,500.00 Unfavorable
Variable overhead spending variance Variable overhead efficiency variance
Variable overhead Spending variance $2,200.00 Favorable
Variable overhead efficiency variance $1,500.00 Unfavorable
Fixed Overhead Cost Variance
Actual Fixed OH Cost Budgeted Fixed Overhead Standard Cost (FOH Applies)
SH* BR
$41,000.00 $40,000.00 16000 $2.00 $32,000.00
$1,000.00 Unfavorable $8,000.00 Unfavorable
Fixed overhead Spending Variance Fixed overhead volume variance
Fixed overhead Spending Variance $1,000.00 Unfavorable
Fixed overhead volume variance $8,000.00 Unfavorable

Related Solutions

Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: • Four welding units, with a lease cost of $15,000 per year per unit • Six welding employees each paid a salary of $60,000 per year (A total of 9,000 welding hours are supplied by the six workers.) • Welding supplies: $300 per job • Welding hours: 3 hours used per job...
I need assistance in preparing a flexible budget based on the following scenario and information. Scenario:...
I need assistance in preparing a flexible budget based on the following scenario and information. Scenario: Green Pastures is a 400-acre farm on the outskirts of the Kentucky Bluegrass, specializing in the boarding of broodmares and their foals. A recent economic downturn in the thoroughbred industry has led to a decline in breeding activities, and it has made the boarding business extremely competitive. To meet the competition, Green Pastures planned in 2017 to entertain clients, advertise more extensively, and absorb...
Problem 1) Static budget variance and Flexible budget variance Sonnet Inc. has the following information for...
Problem 1) Static budget variance and Flexible budget variance Sonnet Inc. has the following information for March 2018. Master Budget for March 2018 Sales volume………………………...……………….2,100 diskettes Average selling price per diskette……………………$5.00/diskette DM costs per diskette………………………………..$0.85/diskette DM cost per lb……………………………….$17.00/lb DM per diskette……………………………..0.05 lb/diskette Direct Labor: Direct labor cost per hour……………………..$15.00/hr # of diskettes produced per labor hour……….. 30 diskettes Direct Marketing costs………………………………$0.30 /diskette Fixed overhead costs………………………………..$850/month Actual for March 2018 Sales volume ………………………………………..1,800 diskettes Average selling price………………………………..$4,80/diskette DM costs per...
Kite Company has the following report for August: Flexible Sales Actual budget Flexible activity Master Results...
Kite Company has the following report for August: Flexible Sales Actual budget Flexible activity Master Results variances budget variances budget Units ? 12000 4000 U ? Sales revenue ? 12000 F 168000 ? ? Variable mfg. costs 96000 ? ? ? 120000 Variable mktg. costs ? 4800 U 21600 ? ? Contribution margin 57600 ? ? 18800 U 75200 Fill in the missing amounts. For items in the variances columns, indicate F or U.
Jackson company manufacture products and has prepared a monthly budget based on 10,000 units (produced and...
Jackson company manufacture products and has prepared a monthly budget based on 10,000 units (produced and sold): Per unit cost Labour (2 DLH x $11) $22 Materials 0.5kg x $30/kg $15 Fixed overhead $10 Selling price $65 In January, 9,000 units were produced and sold. The actual budget for January is shown below: Sales $594,000 Labour 18,900 hours $226,800 Material 4,700kg $131,600 Fixed overhead $92,000 Profit $143,600 A) Calculate all the variances (DM price variance, DM material variance, DL price...
Prepare a monthly flexible selling expense budget for Cottonwood Company for sales volumes of $300,000, $350,000,...
Prepare a monthly flexible selling expense budget for Cottonwood Company for sales volumes of $300,000, $350,000, and $400,000, based on the following data: Sales commissions 6% of sales Sales manager's salary $120,000 per month Advertising expense $90,000 per month Shipping expense 1% of sales Miscellaneous selling expense $6,000 per month plus 1.5% of sales Cottonwood Company Monthly Selling Expense Budget Sales volume $ $ $ Variable expense: Sales commissions $ $ $ Shipping expense Miscellaneous selling expense Total variable expense...
1. Which of the following statements is true concerning the flexible budget? a. The flexible budget...
1. Which of the following statements is true concerning the flexible budget? a. The flexible budget shows the expected relation between costs and volume. b. The flexible budget has a fixed cost component which is expected to be incurred regardless of the level of activity. c. The flexible budget has a variable cost per unit of activity component where variable costs change in total as the level of activity changes. d. all of the above.    2.   What is the...
A. Complete a flexible budget for 20,000 units produced. Use the following information at a production...
A. Complete a flexible budget for 20,000 units produced. Use the following information at a production level of 15,000 units to complete the flexible budget: Budgeted units 15,000 Revenue $1,500,000 Expenses: Wages and Salaries ($200,000 + $10Q) $350,000 Utilities (variable) $300,000 Depreciation (fixed) $200,000 Total expenses $850,000 Net operating income $650,000 Q = units produced Budgeted units 20,000 Revenue Expenses: Wages and Salaries ($200,000 + $10Q) Utilities (variable) Depreciation (fixed) Total expenses Net operating income B. Calculate the activity variances...
The monthly flexible overhead budget and activities of Forest Ltd. are as follows: Machine hours -...
The monthly flexible overhead budget and activities of Forest Ltd. are as follows: Machine hours - 4,000; 5,200; 6,500 and Budgeted monthly overhead cost (Rs)- 98,000; 1,12,400; 1,28,000 respectively. The budgeted fixed overhead cost per month at the level of 6,800 machine hours is: a) Rs 30,000 b) Rs 40,000 c) Rs 45,000 d) Rs 50,000
Flexible Budget for Selling and Administrative Expenses Cloud Productivity Inc. uses flexible budgets that are based...
Flexible Budget for Selling and Administrative Expenses Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 14% of sales Advertising expense 18% of sales Miscellaneous administrative expense $9,000 per month plus 12% of sales Office salaries expense $28,000 per month Customer support expenses $13,000 per month plus 20% of sales Research and development expense $31,000 per month Prepare a flexible selling and administrative expenses budget for March for sales volumes of $400,000, $500,000, and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT