Prepare a manufacturing overhead flexible budget


 

Lowell Company's manufacturing overhead budget for the first quarter of 2012 contained the following data.

Variable Costs


Fixed Costs

Indirect materials
$11,633
Supervisory salaries
$35,906
Indirect labor
10,472
Depreciation
6,179
Utilities
7,595
Property taxes and insurance
7,190
Maintenance
5,507
Maintenance
5,751

Actual variable costs were: indirect materials $14,802, indirect labor $9,424, utilities $9,718, and maintenance $5,050. Actual fixed costs equaled budgeted costs except for property taxes and insurance, which were $8,513. The actual activity level equaled the budgeted level.

All costs are considered controllable by the production department manager except for depreciation, and property taxes and insurance.

(a) Prepare a manufacturing overhead flexible budget report for the first quarter.

LOWELL COMPANY
Manufacturing Overhead Flexible Budget Report
For the Quarter Ended March 31, 2012




Difference



Budget


Actual

Favorable F
Unfavorable U
Neither Favorable
nor Unfavorable N

Variable Costs



pixel.gif Total CostsUtilitiesTotal Fixed CostsIndirect MaterialsVariable CostsTotal Variable CostsMaintenanceDepreciationFixed CostsIndirect LaborProperty Taxes and InsuranceSupervisory Salaries

$pixel.gif

$pixel.gif

$pixel.gif

pixel.gif FUN

pixel.gif DepreciationTotal CostsTotal Variable CostsIndirect MaterialsFixed CostsMaintenanceSupervisory SalariesTotal Fixed CostsProperty Taxes and InsuranceUtilitiesVariable CostsIndirect Labor

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif Indirect MaterialsDepreciationTotal Fixed CostsUtilitiesTotal CostsTotal Variable CostsFixed CostsVariable CostsIndirect LaborSupervisory SalariesMaintenanceProperty Taxes and Insurance

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif Property Taxes and InsuranceVariable CostsDepreciationMaintenanceTotal Variable CostsFixed CostsUtilitiesSupervisory SalariesIndirect LaborIndirect MaterialsTotal CostsTotal Fixed Costs

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif Supervisory SalariesTotal Variable CostsTotal CostsTotal Fixed CostsUtilitiesVariable CostsDepreciationFixed CostsProperty Taxes and InsuranceIndirect LaborIndirect MaterialsMaintenance

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

Fixed Costs



pixel.gif Supervisory SalariesFixed CostsUtilitiesMaintenanceTotal CostsTotal Fixed CostsTotal Variable CostsIndirect MaterialsVariable CostsDepreciationIndirect LaborProperty Taxes and Insurance

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif DepreciationSupervisory SalariesTotal Fixed CostsProperty Taxes and InsuranceIndirect MaterialsIndirect LaborVariable CostsTotal CostsTotal Variable CostsUtilitiesMaintenanceFixed Costs

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif Total Fixed CostsUtilitiesIndirect LaborVariable CostsDepreciationFixed CostsProperty Taxes and InsuranceTotal Variable CostsIndirect MaterialsMaintenanceSupervisory SalariesTotal Costs

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif Indirect MaterialsTotal Fixed CostsProperty Taxes and InsuranceSupervisory SalariesUtilitiesTotal CostsTotal Variable CostsVariable CostsDepreciationFixed CostsIndirect LaborMaintenance

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif Indirect MaterialsFixed CostsTotal CostsTotal Fixed CostsTotal Variable CostsIndirect LaborVariable CostsUtilitiesDepreciationMaintenanceProperty Taxes and InsuranceSupervisory Salaries

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif DepreciationFixed CostsVariable CostsMaintenanceSupervisory SalariesTotal Variable CostsTotal Fixed CostsUtilitiesIndirect LaborIndirect MaterialsProperty Taxes and InsuranceTotal Costs

$pixel.gif

$pixel.gif

$pixel.gif

pixel.gif FUN

(b) Prepare a responsibility report for the first quarter.

LOWELL COMPANY
Manufacturing Overhead Responsibility Report
For the Quarter Ended March 31, 2012




Difference


Controllable Costs


Budget


Actual

Favorable F
Unfavorable U
Neither Favorable
nor Unfavorable N

pixel.gif Supervisory SalariesProperty Taxes and InsuranceUtilitiesDepreciationIndirect MaterialsIndirect LaborMaintenance

$pixel.gif $pixel.gif $pixel.gif

pixel.gif FUN

pixel.gif Indirect MaterialsProperty Taxes and InsuranceSupervisory SalariesUtilitiesIndirect LaborMaintenanceDepreciation

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif UtilitiesMaintenanceDepreciationProperty Taxes and InsuranceIndirect MaterialsSupervisory SalariesIndirect Labor

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif DepreciationIndirect MaterialsMaintenanceIndirect LaborProperty Taxes and InsuranceSupervisory SalariesUtilities

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN

pixel.gif UtilitiesMaintenanceIndirect LaborIndirect MaterialsSupervisory SalariesDepreciationProperty Taxes and Insurance

pixel.gif

pixel.gif

pixel.gif

pixel.gif FUN


$pixel.gif

$pixel.gif

$pixel.gif

pixel.gif FUN

Request for Solution File

Ask an Expert for Answer!!
Accounting Basics: Prepare a manufacturing overhead flexible budget
Reference No:- TGS0673808

Expected delivery within 24 Hours