Question

The Brite Beverage Company bottles soft drinks into aluminum cans. The manufacturing process consists of three activities:

Mixing: water, sugar, and beverage concentrate are mixed.
Filling: mixed beverage is filled into 12-oz. cans.
Packaging: properly filled cans are boxed into cardboard "fridge packs."
The activity costs associated with these activities for the period are as follows:

Mixing $286,000
Filling 253,500
Packaging 110,500
Total $650,000

The activity costs do not include materials costs, which are ignored for this analysis. Each can is expected to contain 12 ounces of beverage. Thus, after being filled, each can is automatically weighed. If a can is too light, it is rejected, or "kicked," from the filling line prior to being packaged. The primary cause of kicks is heat expansion. With heat expansion, the beverage overflows during filling, resulting in underweight cans. This process begins by mixing and filling 6,760,000 cans during the period, of which only 6,500,000 cans are actually packaged. 260,000 cans are rejected due to underweight kicks. A process improvement team has determined that cooling the cans prior to filling them will reduce the amount of overflows due to expansion. After this improvement, the number of kicks is expected to decline from 260,000 cans to 65,000 cans, thus increasing the number of filled cans to 6,695,000 [6,500,000 (260,000 - 65,000)].

Required:
a. Determine the total activity cost per packaged can under present operations.
b. Determine the amount of increased packaging activity costs from the expected improvements.
c. Determine the expected total activity cost per packaged can after improvements.

Answer 1

A. $0.1 per can

B. $3,315

C. 0.098 per packaged can

Step-by-step explanation:

a) Calculation to Determine the total activity cost per packaged can under present operations.

Using this formula

Total activity cost per packaged = Total activity cost under present operations ÷ total cans packaged

Let plug in the formula

Total activity cost per packaged= $650,000 ÷ 6,500,000

Total activity cost per packaged= $0.1 per can

Therefore the total activity cost per packaged can under present operations is $0.1 per can

b) Calculation to Determine the amount of increased packaging activity costs from the expected improvements.

First step is to calculate the Packaging cost per bottle =

Using this formula

Packaging cost per bottle = Current packaging cost ÷ total cans packaged

Let plug in the formula

Packaging cost per bottle = 110,500 ÷ 6,500,000

Packaging cost per bottle = $0.017 per bottle

Second step is to calculate the Total packaging cost

Using this formula

Total packaging cost = Total bottle × cost per bottle

Let plug in the formula

Total packaging cost= 6,695,000 × $0.017

Total packaging cost= $113,815

Now let determine the amount of increased packaging activity costs from the expected improvements.

Using this formula

Amount of increased packaging activity costs = total packaging cost - current packaging cost

Let plug in the formula

Amount of increased packaging activity costs= $113,815 - 110,500

Amount of increased packaging activity costs= $3,315

Therefore the amount of increased packaging activity costs from the expected improvements is $3,315

c) Calculation to Determine the expected total activity cost per packaged can after improvements

First step is to calculate Total activity cost using this formula

Total activity cost = Mixing cost + filling cost + packaging cost

Let plug in the formula

Total activity cost == $286,000 + $253,500 + $113,815

Total activity cost == $653,315

Now let determine the Expected total activity cost per packaged can

Using this formula

Expected total activity cost per packaged can = Total activity cost ÷ no. of bottles

Let plug in the formula

Expected total activity cost per packaged can= $653,315 ÷ 6,695,000

Expected total activity cost per packaged can=0.098 per packaged can

Therefore the expected total activity cost per packaged can after improvements is 0.098 per packaged can