Question

In: Accounting

The Rainbow Oil Company buys crude vegetable oil. Refining this oil results in four products at...

The Rainbow Oil Company buys crude vegetable oil. Refining this oil results in four products at the splitoff point.​ A, B,​ C, and D. Product C is fully processed by the splitoff point. Products​ A, B, and D can individually be further refined into Super​ A, Super​ B, and Super D. In the most recent month​ (December), the output at the splitoff point was as​ follows:

times •

Product​ A, 275,000 gallons

times •

Product​ B, 100,000 gallons

times •

Product​ C, 75,000 gallons

times •

Product​ D, 50,000 gallons

The joint costs of purchasing and processing the crude vegetable oil were

$105,000. Rainbow had no beginning or ending inventories. Sales of product C in December were $45,000. Products​ A, B, and D were further refined and then sold. Data related to December are as​ follows:

Separable Processing Costs

to Make Super Products

Revenues

Super A

$240,000

$375,000

Super B

60,000

150,000

Super D

45,000

75,000

Rainbow had the option of selling products​ A, B, and D at the splitoff point. This alternative would have yielded the following revenues for the December​ production:

times •

Product​ A, $ 75 comma 000$75,000

times •

Product​ B, $ 62 comma 500$62,500

times •

Product​ D, $ 67 comma 500$67,500

1.

Compute the​ gross-margin percentage for each product sold in​ December, using the following methods for allocating the $105,000 joint​ costs:

a.

Sales value at splitoff

b.

​Physical-measure

c.

NRV

2.

Could Rainbow have increased its December operating income by making different decisions about the further processing of products​ A, B, or​ D? Show the effect on operating income of any changes you recommend.

Solutions

Expert Solution

Answer 1-a. Sales Value at Splitoff
Computation of Joint Cost Allocations
Product Sales Value of Total Production at Split-off Weighting Allocation of Joint Costs
A                   75,000.00 30%              31,500.00
B                   62,500.00 25%              26,250.00
C                   45,000.00 18%              18,900.00
D                   67,500.00 27%              28,350.00
                250,000.00 100%           105,000.00
Computation of Gross Margin Percentage
Super A Super B C Super D Total
Revenues                 375,000.00         150,000.00              45,000.00       75,000.00           645,000.00
Joint Costs                   31,500.00           26,250.00              18,900.00       28,350.00           105,000.00
Separable Costs                 240,000.00           60,000.00                             -         45,000.00           345,000.00
Total Cost of Goods Sold                 271,500.00           86,250.00              18,900.00       73,350.00           450,000.00
Gross Margin                 103,500.00           63,750.00              26,100.00          1,650.00           195,000.00
Gross Margin Percentage 27.60% 42.50% 58.00% 2.20% 30.23%
Answer 1-b. Physical measure Method
Product Physical Measure of Total Production (In Gallons) Weighting Allocation of Joint Costs
A                 275,000.00 55%              57,750.00
B                 100,000.00 20%              21,000.00
C                   75,000.00 15%              15,750.00
D                   50,000.00 10%              10,500.00
Total                 500,000.00 100%           105,000.00
Computation of Gross Margin Percentage
Super A Super B C Super D Total
Revenues                 375,000.00         150,000.00              45,000.00       75,000.00           645,000.00
Joint Costs                   57,750.00           21,000.00              15,750.00       10,500.00           105,000.00
Separable Costs                 240,000.00           60,000.00                             -         45,000.00           345,000.00
Total Cost of Goods Sold                 297,750.00           81,000.00              15,750.00       55,500.00           450,000.00
Gross Margin                   77,250.00           69,000.00              29,250.00       19,500.00           195,000.00
Gross Margin Percentage 20.60% 46.00% 65.00% 26.00% 30.23%
Answer 1-c. NRV Method
Product Final Sales Value of Total Production Separable Costs NRV at Splitoff Weighting Allocation of Joint Costs
Super A                 375,000.00         240,000.00           135,000.00 45%             47,250.00
Super B                 150,000.00           60,000.00              90,000.00 30%             31,500.00
C                   45,000.00                           -                45,000.00 15%             15,750.00
Super D                   75,000.00           45,000.00              30,000.00 10%             10,500.00
Total                 645,000.00         345,000.00           300,000.00 100%           105,000.00
Computation of Gross Margin Percentage
Super A Super B C Super D Total
Revenues                 375,000.00         150,000.00              45,000.00       75,000.00           645,000.00
Joint Costs                   47,250.00           31,500.00              15,750.00       10,500.00           105,000.00
Separable Costs                 240,000.00           60,000.00                             -         45,000.00           345,000.00
Total Cost of Goods Sold                 287,250.00           91,500.00              15,750.00       55,500.00           450,000.00
Gross Margin                   87,750.00           58,500.00              29,250.00       19,500.00           195,000.00
Gross Margin Percentage 23.40% 39.00% 65.00% 26.00% 30.23%
Answer 2.
Further Processing of
A Into Super A B Into Super B D Into Super D
Incremental Revenue                 300,000.00           87,500.00                7,500.00
Incremental Cost                 240,000.00           60,000.00              45,000.00
Incremental Operating Income (Loss) from Further Processing                   60,000.00           27,500.00           (37,500.00)

Related Solutions

The South Oil Company buys crude vegetable oil. Refining this oil results in four products at...
The South Oil Company buys crude vegetable oil. Refining this oil results in four products at the splitoff point.? A, B,? C, and D. Product C is fully processed by the splitoff point. Products? A, B, and D can individually be further refined into Super? A, Super? B, and Super D. In the most recent month? (December), the output at the splitoff point was as? follows: Requirements: Compute the? gross-margin percentage for each product sold in? December, using the following...
The Sunny Oil Company buys crude vegetable oil. Refining this oil results in four products at...
The Sunny Oil Company buys crude vegetable oil. Refining this oil results in four products at the splitoff​ point: A,​ B, C, and D. Product C is fully processed by the splitoff point. Products​ A, B, and D can individually be further refined into Super​ A, Super​ B, and Super D. Data related to December​ are: The output at the splitoff point​ was: Product A 400,000 litres Product B 200,000 litres Product C 100,000 litres Product D 100,000 litres The...
The Sunny Oil Company buys crude vegetable oil. Refining this oil results in four products at...
The Sunny Oil Company buys crude vegetable oil. Refining this oil results in four products at the splitoff​ point: A,​ B, C, and D. Product C is fully processed by the splitoff point. Products​ A, B, and D can individually be further refined into Super​ A, Super​ B, and Super D. Data related to December​ are: The output at the splitoff point​ was: Product A 400,000 litres Product B 200,000 litres Product C 100,000 litres Product D 100,000 litres The...
MIX DECISIONS. The Chicago Oil Company buys crude vegetable oil. Refining this oil results in four...
MIX DECISIONS. The Chicago Oil Company buys crude vegetable oil. Refining this oil results in four products at the splitoff point: A, B, C, and D. Product C is fully processed by the splitoff point. Products A, B, and D can individually be further refined into Super A, Super B, and Super D. In the most recent month (November), the output at the splitoff point was as follows: Product A, 550,000 gallons Product B, 200,000 gallons Product C, 150,000 gallons...
Unioil produces vegetable-based cooking oil and butter spreads. Unioil uses large quantities of crude palm oil...
Unioil produces vegetable-based cooking oil and butter spreads. Unioil uses large quantities of crude palm oil (CPO)in its production process as a main raw material. It is September 2020 now and Unioil estimates a need of 25,000 metric tons (MTs)of CPO in March 2021. Current spot price of CPO is RM2200 per MT. You as the procurement manager of Unioil, have the following alternatives to hedge the possible increase in the CPO price by March 2021: [EACH OPTION (a, b,...
Unioil produces vegetable based cooking oil and butter spreads. Unioil uses large quantities of crude palm...
Unioil produces vegetable based cooking oil and butter spreads. Unioil uses large quantities of crude palm oil (CPO)in its production process as a main raw material. It is September 2020 now and Unioil estimates a need of 25,000 metric tons (MTs)of CPO in March 2021. Current spot price of CPO is RM2200 per MT. You as the procurement manager of Unioil, have the following alternatives to hedge the possible increase in the CPO price by March 2021: The commodities analysist...
Unioil produces vegetable based cooking oil and butter spreads. Unioil uses large quantities of crude palm...
Unioil produces vegetable based cooking oil and butter spreads. Unioil uses large quantities of crude palm oil (CPO)in its production process as a main raw material. It is September 2020 now and Unioil estimates a need of 25,000 metric tons (MTs)of CPO in March 2021. Current spot price of CPO is RM2200 per MT. You as the procurement manager of Unioil, have the following alternatives to hedge the possible increase in the CPO price by March 2021: a) The commodities...
Unioil produces vegetable based cooking oil and butter spreads. Unioil uses large quantities of crude palm...
Unioil produces vegetable based cooking oil and butter spreads. Unioil uses large quantities of crude palm oil (CPO)in its production process as a main raw material. It is September 2020 now and Unioil estimates a need of 25,000 metric tons (MTs)of CPO in March 2021. Current spot price of CPO is RM2200 per MT. You as the procurement manager of Unioil, have the following alternatives to hedge the possible increase in the CPO price by March 2021: The commodities analysist...
Unioil produces vegetable based cooking oil and butter spreads. Unioil uses large quantities of crude palm...
Unioil produces vegetable based cooking oil and butter spreads. Unioil uses large quantities of crude palm oil (CPO)in its production process as a main raw material. It is September 2020 now and Unioil estimates a need of 25,000 metric tons (MTs)of CPO in March 2021. Current spot price of CPO is RM2200 per MT. You as the procurement manager of Unioil, have the following alternatives to hedge the possible increase in the CPO price by March 2021: The commodities analysist...
The rate of crude oil production from 2008 to 2013 by an oil company can be...
The rate of crude oil production from 2008 to 2013 by an oil company can be approximated by ?(?) = 6.2?^2 − 146? + 1910 million barrels per year where ? is time in years since the start of 2000. During that time, the price of oil was approximately ?(?) = 47?^0.046? dollars per barrel. Obtain an expression for the total oil revenue ?(?) from the start 0f 2008 to the start of year ? as a function of ?....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT