Magic Floor produces and sells a complete line of floor care products: wax strippers, floor soaps, and floor waxes. All of these products are packaged on a new high-speed bottling fill line. Empty bottles (pints, quarts, half gallons, or gallons) are automatically removed from their boxes and placed on the line. The empty bottles are then filled, sealed with a foil closure, capped with a screw, and labeled. The filled, sealed, capped, and labeled bottles go to a weigh station to insure each bottle has the correct amount of fill, and the nonrejected packaged bottles are placed in boxes and a bar-coded shipping label is attached. The fill line requires minimal direct labor once it is programmed for the bottle size, contents, and the bar-coded labels. The decision to purchase the fill line in 2010 was justified under the assumption that the line would run 7 hours a day, 5 days a week, and 50 weeks a year.
The 2012 budget for the fill line is:
Maintenance | $ 77,000 |
Indirect labor | 182,000 |
Depreciation | 127,000 |
utilities | 29,000 |
Indirect supplies | 27,000 |
Magic Floor’s 2012 budgeted production is:
Filled Bottles | Pints | Quarts | Half-Gallons | Gallons |
Wax stripper | 40,000 | 50,000 | 60,000 | 47,000 |
Soap | 48,000 | 62,000 | 79,000 | 70,000 |
Wax | 44,000 | 55,000 | 68,000 | 49,000 |
Magic Floor allocates the fill line costs to the various bottled products using a predetermined overhead absorption rate calculated based on budgeted costs divided by budgeted volume. Budgeted volume is measured in seconds on the fill line. Pints are filled in 3 seconds, quarts in 5 seconds, halfgallons in 9 seconds, and gallons in 17 seconds.
During 2012, the following times (in seconds) were recorded for filling bottles on the fill line:
Pints | Quarts | Half-Gallons Gallons | |
Wax stripper Soap Wax | 118,000 145.000 130.000 | 246.000 305.000 270.000 | 542.1 800,000 703.1 1,180,000 608.1 840,000 |
Actual overhead costs incurred in 2012 on the fill line are:
Maintenance | $ 76,000 |
Indirect labor | 179,000 |
Depreciation | 127,000 |
utilities | 28,000 |
Indirect supplies | 25,000 |
Required:
a. Calculate the expected volume of the bottling fill line for 2012.
b. Calculate the normal volume of the bottling fill line for 2012.
c. Calculate the overhead absorption rate for the bottling fill line for 2012 based on expected volume (round overhead rate to four decimals).
d. Calculate the overhead absorption rate for the bottling fill line for 2012 based on normal volume (round overhead rate to four decimals).
e. Calculate the over/underabsorbed overhead amount for the bottling fill line for 2012 based on expected volume.
f. Calculate the over/underabsorbed overhead amount for the bottling fill line for 2012 based on normal volume.
g. Explain in intuitive terms why your answers in parts (e) and (f) differ.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.