In: Accounting
Allocating Joint Costs Using the Constant Gross Margin Method
A company manufactures three products, L-Ten, Triol, and Pioze, from a joint process. Each production run costs $12,900. None of the products can be sold at split-off, but must be processed further. Information on one batch of the three products is as follows:
Product |
Gallons | Further Processing Cost per Gallon |
Eventual
Market Price per Gallon |
L-Ten | 3,500 | $0.50 | $ 2.00 |
Triol | 4,000 | 1.00 | 5.00 |
Pioze | 2,500 | 1.50 | 6.00 |
Required:
1. Calculate the total revenue, total costs, and total gross profit the company will earn on the sale of L-Ten, Triol, and Pioze.
Total Revenue | $ |
Total Costs | $ |
Total Gross Profit | $ |
2. Allocate the joint cost to L-Ten, Triol, and Pioze using the constant gross margin percentage method. Round the gross margin percentage to four decimal places and round all other computations to the nearest dollar.
Joint Cost | |
Product | Allocation |
L-Ten | $ |
Triol | |
Pioze | |
Total | $ |
(Note: The joint cost allocation does not equal $12,900 due to rounding.)
3. What if it cost $2 to process each gallon of Triol beyond the split-off point? How would that affect the allocation of joint cost to these three products? Round the gross margin percentage to four decimal places and round all other computations to the nearest dollar.
Joint Cost | |
Product | Allocation |
L-Ten | $ |
Triol | |
Pioze | |
Total | $ |
(Note: The joint cost allocation does not equal $12,900 due to rounding.)
Requiemnt -1 | |||||
Product | Gallons (a) | Sales Price(b) | Revenue (aXb) | Further cost (c ) | Total Further cost (aXc) |
L-Ten | 3500 | $2.00 | $7,000.00 | $0.50 | $1,750.00 |
Triol | 4000 | $5.00 | $20,000.00 | $1.00 | $4,000.00 |
Pioze | 2500 | $6.00 | $15,000.00 | $1.50 | $3,750.00 |
Total | $42,000.00 | $9,500.00 |
Total Revenue | $42,000.00 |
Total costs (9500+12900) |
$22,400.00 |
Total Gross Profit | $19,600.00 |
Requiremnt -2 | |||
Product | L-Ten | Triol | Pioze |
Sales (a) | $7,000.00 | $20,000.00 | $15,000.00 |
Gross Margin (b) (aX46.67%) |
$3,266.90 | $9,334.00 | $7,000.50 |
Total Cost (c=a-b) | $3,733.10 | $10,666.00 | $7,999.50 |
Separable cost (d) | $1,750.00 | $4,000.00 | $3,750.00 |
Joint Cost Allocation (c-d) | $1,983.10 | $6,666.00 | $4,249.50 |
Gross Margin Percentage = 19600/42000 = 46.67% |
Requiemnt -3 | |||||
Product | Gallons (a) | Sales Price(b) | Revenue (aXb) | Further cost (c ) | Total Further cost (aXc) |
L-Ten | 3500 | $2.00 | $7,000.00 | $0.50 | $1,750.00 |
Triol | 4000 | $5.00 | $20,000.00 | $2.00 | $8,000.00 |
Pioze | 2500 | $6.00 | $15,000.00 | $1.50 | $3,750.00 |
Total | $42,000.00 | $13,500.00 |
Total Revenue | $42,000.00 |
Total cost (12900+13500) |
$26,400.00 |
Total Gross Profit | $15,600.00 |
Requiremnt -4 | |||
Product | L-Ten | Triol | Pioze |
Sales (a) | $7,000.00 | $20,000.00 | $15,000.00 |
Gross Margin (b) (aX37.14%) |
$2,599.80 | $7,428.00 | $5,571.00 |
Total Cost (c=a-b) | $4,400.20 | $12,572.00 | $9,429.00 |
Separable cost (d) | $1,750.00 | $8,000.00 | $3,750.00 |
Joint Cost Allocation (c-d) | $2,650.20 | $4,572.00 | $5,679.00 |
Gross Margin Percentage = 15600/42000 = 37.14% | |||