Share
Explore BrainMass

Accounting Budgeting and Variances

A manufacturing company produces a large variety of products within the Butler family of Products. They are produced in three finishing departments (A, B, C) which have identical assembly operations but package the products differently for different lines of business. Each finishing line packages units as either single unit of multiple units per package. For allocating overhead, volume is defined in terms of machine hours. Each department can package 1140 single units per hour. Department A has the oldest equipment, which is in the last year of its depreciable life. Department BÃ?¢??s equipment is about half depreciated. Department CÃ?¢??s equipment is in the second year of its life. The budget prepared for each department in 2010 included the following costs, volumes, and overhead rates (M denotes million):

A B C
Expected Number of units 73M 73M 55M
Fixed Overhead
General Expenses $1.5M 2.0M 1.25M
Rent $1.5M 2.0M 1.25M
Depreciation $.5M 2.0M 5.0M
Variable overhead $150/machine hours 131/machine hours 150/machine hours
Machine Rate 1140 units/hour 1140 units/hours 1140 units/hour
Direct materials $.50/ unit .52/ unit .55/unit
Direct Labor $.15 /unit .15 /unit .135/unit

The general expense portion of the overhead is set by each department at the beginning of the year for training capital items under $2500 and other department needs. The rent charged to each department is determined by the age and the structure of the building in which the department operates. In general, machines that are shut down because of volume decreases are not removed, so rent charges do not decrease the volume. The company currently determines unit manufacturing cost UMC charges on a department basis, with one UMC for all types of products finished in that department, Under- over absorbed overhead is aggregated over the entire division and distributed to the departments based on normal volume. The packaging machines in each department require different amounts of maintenance (Variable overhead). In dept. A, the maintenance is higher because of older drive and logic systems. In department C, it is higher due to startup costs that should decrease wit time.

Direct materials costs depend on the products each department has been designated to run and the age of the equipment. They are outside the control of the department. In 2012, Butler sales softened and not all of the capacity in departments A, B, C is needed in 2011. Some capacity will be eliminated in one of the departments.

The UMC for 2010 were are follows:
UMCÃ?¢??s for 2010 A B C
Actual units packaged 67M 73M 49M
Direct Labor per unit $.15 .15 .135
Direct materials per unit $.50 .52 .55
Actual overhead charge $12.7M 14.7M 14.3M
Actual machine hours 58772 64035 42982

a. Calculate all variances. Which department best manages the overhead tat is within its control?
b. How would you recommend that the division distribute the fixed overhead that is not controllable by the departments?
c. Given the reduced demand, which department should reduce volume? Why?

Attachments

Solution Preview

Hi,

Please find your solution in the attached excel work file: 516989 Variances Butler Products.

a. Which department best manages the overhead that is within its control? Department A has the lowest unfavorable Variable OH and it would be considered the ...

Solution Summary

Study of accounting variances in a multi process environment. The process has various aged and capacity in three different processes. Budgets are prepared and variances calculated. A report is prepared for management.

$2.19