Hamilton, Inc. produces chemicals for large biotech
companies. If has the following data for manufacturing overhead
costs during August 2017.
Variable
Fixed
Actual costs
incurred
$30,500 $14,500
Costs allocated to products
27,000 14,800
Flexible
budget
--
16,000
Actual input x budgeted rate
31,200
---
( If no variance exists leave the dollar value blank. Label the variances as a favorable (F), unfavorable (U) or never a variance (N) )
Fill in the blanks.
Variable Fixed
1. Spending
variance
$
$
2. Efficiency
variance
3. Production- volume variance
4. Flexible- budget variance
5. Underallocated (over allocated)
manufacturing overhead
Hamilton, Inc. produces chemicals for large biotech companies. If has the following data for manufacturing overhead...
ComplexChem, Inc., produces chemicals for large biotech companies. It has the following data for manufacturing overhead costs during August 2017: Variable Fixed Actual costs incurred $31,500 $13,000 Costs allocated to products 35,000 15,400 Flexible budget — 14,400 Actual input x budgeted rate 31,000 — Requirements (If no variance exists leave the dollar value blank. Label the variance as favorable (F), unfavorable (U) or never a variance (N).) Variable Fixed (1) Spending variance $ $ (2) Efficiency variance (3) Production-volume...
Excel with formulas please and thank you! ProChem, Inc., produces chemicals for large biotech companies. It has the following data for manufacturing overhead costs during August 2017: Variable Fixed 35,000$ 16,500 15,200 16,000 Actual costs incurred Costs allocated to products Flexible budget Actual input x budgeted rate 31,500 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will...
Requirement Fill in the blanks. Use F for favorable and U for unfavorable: (Click the icon to view the table.) Nivola, Inc., produces chemicals for large biotech companies. It has the following data for manufacturing overhead costs during August 2017: Variable Fixed Actual costs incurred $31,500 $13,500 Costs allocated to products 35,000 15,400 Flexible budget 14,400 Actual input x budgeted rate 30,800 Variable Fixed (1) Spending variance (2) Efficiency variance (3) Production-volume variance (4) Flexible-budget variance (5) Underallocated (overallocated) manufacturing...
Chubbs Inc.’s manufacturing overhead budget for the first quarter of 2020 contained the following data. Variable Costs Fixed Costs Indirect materials $11,500 Supervisory salaries $36,900 Indirect labor 11,000 Depreciation 7,100 Utilities 7,500 Property taxes and insurance 8,000 Maintenance 5,900 Maintenance 5,000 Actual variable costs were indirect materials $14,500, indirect labor $9,200, utilities $9,100, and maintenance $5,300. Actual fixed costs equaled budgeted costs except for property taxes and insurance, which were $8,800. The actual activity level equaled the budgeted level. All...
Sunland Inc.'s manufacturing overhead budget for the first quarter of 2020 contained the following data. Variable Costs Fixed Costs Indirect materials $11,100 Supervisory salaries Indirect labor 10,700 Depreciation Utilities 7,800 Property taxes and insurance Maintenance 5,700 Maintenance $35,400 7,500 7,300 4,000 Actual variable costs were indirect materials $15, 100, indirect labor $9,500, utilities $9.600, and maintenance $5,200. Actual fixed costs equaled budgeted costs except for property taxes and insurance, which were $8,300. The actual activity level equaled the budgeted level....
Chubbs Inc.'s manufacturing overhead budget for the first quarter of 2020 contained the following data. Variable Costs Fixed Costs Indirect materials $11.800 Supervisory salaries $36,100 Indirect labor 10,800 Depreciation 6.200 Utilities 7,800 Property taxes and insurance 7,500 Maintenance 5.900 Maintenance 5,000 Actual variable costs were indirect materials $14,700, indirect labor $9.300, utilities $9.900, and maintenance $4,600. Actual fixed costs equaled budgeted costs except for property taxes and insurance, which were $8,500. The actual activity level equaled the budgeted level. All...
ABC Company has the following standards and flexible budget data: Standard Variable Overhead Rate $5.40 Per direct labour hour Standard quantity of direct labor $1.80 hours per unit of output Budgeted fixed overhead rate $100,000 Budgeted Output 25,000 units Standard Variable Overhead $10.80 per unit Standard Fixed Overhead $3.60 per unit Actual Results for November are given below: Actual Output 30,000 units Actual variable overhead $360,000 Actual Fixed Overhead $106,000 Actual Direct Labor 56,000 hours REQUIRED: A) Variable manufacturing overhead...
The Taravez Company uses standard costing in its manufacturing plant for auto parts. The standard cost of a particular auto part, based on a denominator level of 3,900 output units per year, included 5 machine-hours of variable manufacturing overhead at $7 per hour and 5 machine-hours of fixed manufacturing overhead at $16 per hour. Actual output produced was 4,300 units. Variable manufacturing overhead incurred was $260,000. Fixed manufacturing overhead incurred was $265,000. Actual machine-hours were 30,000. Requirements 1. Prepare an...
Crystal Glassware Company has the following standards and flexible-budget data. Standard variable-overhead rate Standard quantity of direct labor Budgeted fixed overhead Budgeted output $ 6.00 per direct-labor hour 2 hours per unit of output $144,000 24,000 units Actual results for April are as follows: 1 + Actual output Actual variable overhead Actual fixed overhead Actual direct labor 17,000 units $306,000 $141,000 50,000 hours Required: Use the variance formulas to compute the following variances. (Indicate the effect of each variance by...
Chubbs Inc's manufacturing overhead budget for the first quarter of 2020 contained the following data. Variable Costs Fixed Costs Indirect materials $11300 Supervisory salaries $37,000 Indirect labor 10,800 Depreciation 6,000 Property taxes and insurance Utilities 7,200 7,400 Maintenance 5,900 Maintenance 5,000 Actual variable costs were indirect materials $14,600, indirect labor $9.400, utilities $9.600, and maintenance $5,100. Actual fixed costs equaled budgeted costs except for property taxes and insurance, which were $8,700. The actual activity level equaled the budgeted level. All...