In: Accounting
Differential Analysis for Further Processing
The management of International Aluminum Co. is considering whether to process aluminum ingot further into rolled aluminum. Rolled aluminum can be sold for $2,200 per ton, and ingot can be sold without further processing for $1,100 per ton. Ingot is produced in batches of 80 tons by smelting 500 tons of bauxite, which costs $105 per ton of bauxite. Rolled aluminum will require additional processing costs of $620 per ton of ingot, and 1.25 tons of ingot will produce 1 ton of rolled aluminum (due to trim losses).
Required:
1. Prepare a differential analysis as of February 5 to determine whether to sell aluminum ingot (Alternative 1) or process further into rolled aluminum (Alternative 2). Use a minus sign to indicate subtracted amounts, negative amounts, or a loss.
Differential Analysis | |||
Sell Ingot (Alt. 1) or Process Further into Rolled Aluminum (Alt. 2) | |||
February 5 | |||
Sell Ingot (Alternative 1) | Process Further into Rolled Aluminum (Alternative 2) | Differential Effect on Income (Alternative 2) | |
Revenues, per ton | $ | $ | $ |
Costs, per ton | |||
Income (loss), per ton | $ | $ | $ |
Particulars | Sell ingot(Alternative 1) | Process further into Rolled Aluminium (Alternative 2) | Differential Effect on Income (Alternative 2 |
Revenues,per ton | $1,100.00 | $2,200.00 | $1,100.00 |
Cost, per ton | ($656.25) | ($1,595.31) | ($939.06) |
(Working 1) | (Working 2) | ||
Income (loss), per ton | $443.75 | $604.69 | $160.94 |
($1100-$656.25) | ($2200-$1595.31) | ||
The product should be further processed into rolled aluminium as there would eb increamental profit of $604.69 per tom of rolled aluminum | |||
Working 1 | |||
500 tons of bauxite produces 80 tons of ingot | |||
Cost for 1 ton of bauxite = $105 | |||
1 ton of ingot = | 500/80 | tons of bauxite | |
6.25 | tons of bauxite | ||
Cost of 1 ton of ingot | $105*6.25 | ||
Cost of 1 ton of ingot | $656.25 | ||
Working 2 | |||
Cost of 1 ton of rolled aluminium | |||
1.25 ton of ingot = | 1 ton of rolled aluminium | ||
Cost for 1 ton of aluminium | $ 656.25 per ton*1.25 | ||
$820.31 | |||
Additional processing cost | $ 620 per ton of ingot | ||
Additional cost of processing 1 ton of rolled aluminium | $620*1.25 | ||
$775 | |||
Total processing cost | $ 820.31+$775 | ||
$1,595.31 | |||