Comprehensive Variance Analysis Bayfield Chemical Company manufactures chemicals 1 , 2, 3, and 4 using five ingredients:

chemicals A, B, C, D, and E. The planned amount of input used to make 100 liters of each of the four products, the standard cost of the input chemicals, the amount of each of the input chemicals that is available for purchase, and the expected price received for each 100 liters of each product are shown in the following table.

Chemicals 1, 2, 3, and 4 are made in batches of either 2,000 or 5,000 liters. There are costs of setting up the blending tanks before a batch and cleaning them after a batch.
These costs, along with ,the planned number of batches, are shown in the following table.

With the exception of short-term variable inventory carrying costs, all the costs relating to the chemical-making operation are committed capacity-related costs that Bayfield Company feels are not avoidable in the short run. Therefore, they are ignored for short-run planning purposes. · The invt:ntory carrying costs are related to cost of carrying inventory including storage costs, the opportunity cost of capital tied up in inventory, obsolescence cost, loss, and waste. Input chemicals are purchased and arrive as needed, therefore they inflict no carrying cost in Bayfield Chemical. The inventory-related costs for chemicals 1 , 2, 3, and 4 are estimated using the following steps.

1. For each of the four products, compute the weighted average number of units per batch by multiplying the number of units in each batch by the number of times that batch size is made, summing all the results, and dividing by the number of batches.
2. Since the sales of all four chemicals occur fairly uniformly during the planning period, for each of the four products, estimate the average inventory held by dividing the weighted average number of units per batch by two.
3. For each of the four products, compute the inventory carrying cost by multiplying the average inventory held by $400, $800, $300, $500 for each of chemical 1 , 2, 3, and 4, respectively.
Therefore, the inventory carrying costs for the planned pattern of production are estimated as follows.

The following table shows the actual amount of input chemicals used, the price received for each product, and the cost of the input chemicals.

Required Prepare a variance analysis of the operations in this period.

Transcribed Image Text:

PLANNED INGREDIENT USE CHEMICAL A B C D E PRICE COST MARGIN 1 23 23 45 45 0 32 0 $8,500 $5,567 $2,933 2 12 29 33 18 14 $9,300 $7,047 $2,253 3 12 19 34 14 43 $9,000 $7,169 $1,831 4 23 57 10 0 10 $7,200 $4,779 $2,421 Cost $67 $34 $107 $78 $23 Available 120,000 240,000 320,000 190,000 280,000