In: Accounting
Wisconsin Milk and Ice Cream Manufacturing operates a single plant in Sun Prairie, Wisconsin. It manufactures milk and ice cream for retail and private label marketers in the Midwest.
Joint costs Joint costs of processing raw milk | Cream | Liquid Skim | ||||
Joint costs | $ 1,000,000 | |||||
[from 300,000 gallons of milk] | ||||||
Separable costs buttercream | $ 600,000 | |||||
Separable costs milk | $ 500,000 | |||||
Raw Milk is processed further to make Cream and Liquid Skim | Cream is processed further to make Buttercream | Liquid Skim is processed further to make Milk | ||||
Cream | Liquid Skim | Buttercream | Milk | |||
Beg Inventory (Gallons) | 0 | 0 | 0 | 0 | ||
Production | 100,000 | 150,000 | 90,000 | 125,000 | ||
Transfer | 100,000 | 150,000 | ||||
Sales in June | 80,000 | 115,000 | ||||
End inventory (Gallons) | 10,000 | 10,000 | ||||
Selling price per gallon | 25 | 18 | 40 | 50 | ||
Required: | ||||||
1). Compute the Net Realizable Value (NRV) Method | ||||||
2). Compute the Product Line Income statement for month ended June using the NRV Method |
Requirements:
Compute the Net Realizable Value (NRV) method.
Complete the Product Line Income statement for month ended June using the NRV Method
Net Realizable value = Sale value - Further processing cost
Here sale value should be taken for total production.
Butter cream | Milk | |
Units Produced | 90000 | 125000 |
Selling price | 40 | 50 |
Sale value of production | 3600000 | 6250000 |
(-) Further processing cost | ||
or separable cost (SC) | 600000 | 500000 |
NRV = Sale value - S.C | 3000000 | 5750000 |
Question - 2
The Joint cost of 1000,000 to be shared between these two products using the NRV method. That means we use NRV ratio = 3000,000 : 5750,000 or 12 :23
Butter cream = 1000,000 * 12/35 = 342,857
Milk = 23 / 35 * 1000,000 = 657,143
Product line Income statement
Butter cream | Milk | Total | |
Joint cost | 342857 | 657143 | 1000000 |
Seperable cost | 600000 | 500000 | 1100000 |
Total cost | 942857 | 1157143 | 2100000 |
Units produced | 90000 | 125000 | |
Cost per unit | 10.47618889 | 9.257144 | |
Sales Revenue | 3200000 | 5750000 | 8950000 |
(-) Cost of goods sold | 838095 | 1064572 | 1902667 |
Gross profit | 2361905 | 4685428 | 7047333 |