In: Accounting
X—75 tons sold for $1,800 per ton
Y—225 tons sold for $1,300 per ton
Z—280 tons sold for $800 per ton
The total joint manufacturing costs for the year were $328,000. Evrett spent an additional $120,000 to finish product Z. There were no beginning inventories of X, Y, or Z. At the end of the year, the following inventories of completed units were on hand: X, 175 tons; Y, 75 tons; Z, 70 tons. There was no beginning or ending work in process.
Compute the cost of inventories of X, Y, and Z for balance sheet purposes and the cost of goods sold for income statement purposes as of December 31, 2012, using the NRV method.(2pts)
solve it in Microsoft word please
Total production for the year was: | |||||
Inventory | Sold [A] | Ending Inventory[B] | Total Production[C] | Ending inventory percentage [B]/[C]*100 | |
X | 75 | 175 | 250 | 70% | |
Y | 225 | 75 | 300 | 25% | |
Z | 280 | 70 | 350 | 20% | |
X | Y | Z | Total | ||
Final sales value of total production | 450000 | 390000 | 280000 | 1120000 | |
(250 tonn*$1800) | (300 tonn*1300) | (350 tonne*$800) | |||
Deduct separable costs | 0 | 0 | 120000 | 120000 | |
Net realizable value at splitoff point | 450000 | 390000 | 160000 | 1000000 | |
Weighting | 0.45 | 0.39 | 0.16 | ||
Joint costs allocated [$328000*weights] | 147600 | 127920 | 52480 | 328000 | |
Income Statement | X | Y | Z | TOTAL | |
Revenues | $ 135,000.00 | $ 292,500.00 | $ 224,000.00 | $ 651,500.00 | |
(75 tonn*$1800) | (225 tonn*1300) | (280 tonne*$800) | |||
Less: Cost of goods sold: | |||||
Joint costs allocated | $ 147,600.00 | $ 127,920.00 | $ 52,480.00 | $ 328,000.00 | |
Separable costs | $ 120,000.00 | $ 120,000.00 | |||
Production Cost | $ 147,600.00 | $ 127,920.00 | $ 172,480.00 | $ 448,000.00 | |
$ - | |||||
Deduct ending inventory, | $ - | ||||
70%, 25%, 20% of production Cost | $ (103,320.00) | $ (31,980.00) | $ (34,496.00) | $ (169,796.00) | |
$ - | |||||
COGS | $ 44,280.00 | $ 95,940.00 | $ 137,984.00 | $ 278,204.00 | |
Gross margin [Revenues - COGS] | $ 90,720.00 | $ 196,560.00 | $ 86,016.00 | $ 373,296.00 | |
Gross-margin percentage | 67.20% | 67.20% | 38.40% | ||
X | Y | Z | |||
COST OF CLOSING INVENTORY | $ 103,320.00 | $ 31,980.00 | $ 34,496.00 | ||
COST OF GOODS SOLD | $ 90,720.00 | $ 196,560.00 | $ 86,016.00 |