Question

The December 31, 2017 inventory of Gwynn Company consisted of four products, for which the following...

The December 31, 2017 inventory of Gwynn Company consisted of four products, for which the following information is provided:

Product Original Cost Replacement Cost Estimated Disposal Cost Expected Selling Price Normal Profit on Sales
A $25 $22 $6 $37 $7
B 42 40 12 48 14
C 120 115 25 160 48
D 16 15 3 22 2

In the ending inventory the following quantities existed:

Product A 1,000 units

Product B 2,000 units

Product C     500 units

Product D 1,500 units

Required:    Please show all calculations (For calculations needed to determine elements of market value, LCM, and total inventory, you may indicate the formula you used to make the calculations.)

  1. Indicate the value of inventory that will be reported on the Balance Sheet assuming lower-of-cost-or-market (LCM) is applied to individual items.
  2. If the balance in the Allowance to Reduce Inventory to LCM has a credit balance of $8,000, using the loss method and the results derived in question 1 above, would a loss or a gain be recorded and in what amount?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Calculation of value of inventory assuming LCM is applied to individual items (Amounts in $)

Product Ceiling (expected selling price - estimated disposal cost) Floor (Ceiling price - normal profit on sales) Replacement Cost Market Value (lower of ceiling or replacement cost but not less than floor price) Cost Lower of Cost or Market Value
A 31 (37-6) 24 (31-7) 22 24 25 24
B 36 (48-12) 22 (36-14) 40 36 42 36
C 135 (160-25) 87 (135-48) 115 115 120 115
D 19 (22-3) 17 (19-2) 15 17 16 16

Calculation of Ending Inventory (Amounts in $)

Product Units in Ending Inventory (a) Cost per unit (b) Total Cost (a*b) LCM (c) Total value of Inventory (LCM) (a*c)
A 1,000 25 25,000 24 24,000
B 2,000 42 84,000 36 72,000
C 500 120 60,000 115 57,500
D 1,500 16 24,000 17 25,500
Total 193,000 179,000

Total loss on reduction in value of inventory = Cost - Value based on LCM

= $193,000 - $179,000 = $14,000

Additional loss to be recorded = $14,000 - $8,000 = $6,000

Add a comment
Know the answer?
Add Answer to:
The December 31, 2017 inventory of Gwynn Company consisted of four products, for which the following...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory...

    The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory is as follows: Product Cost $ 55 Per Unit Replacement Cost $ 50 Selling Price $ 75 115 95 ROA 85 95 55 115 35 70 85 145 45 43 Selling costs consist of a sales commission equal to 10% of selling price and shipping costs equal to 5% of cost. The normal profit is 30% of selling price. Required: What unit value should...

  • The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory...

    The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory is as follows: Product Cost $ 48 88 Per Unit Replacement Cost $ 43 78 63 Selling Price $ 68 108 48 88 Uw 108 28 138 38 Selling costs consist of a sales commission equal to 10% of selling price and shipping costs equal to 5% of cost. The normal profit is 40% of selling price. Required: What unit value should Royal Decking...

  • The December 31, 2020, Inventory of Balley Inc. consisted of four products, for which certain Information...

    The December 31, 2020, Inventory of Balley Inc. consisted of four products, for which certain Information is provided below: Replacement Estimated Expected Product Original Cost Disposal Cost Selling Price A $29.00 $22.00 $6.50 $40.00 B $44.00 $40.00 $8.00 $48.00 с $145.00 $125.00 $25.00 $190.00 $21.00 $15.80 $3.00 $28.00 Cost ** D | Replacement cost: Cost of Bailey to replace/replenish' the unit of inventory. Required: a. Using the lower of cost and NRV approach applied on an individual-item basis, calculate the...

  • The inventory of Royal Decking consisted of five products. Information about the December 31, 2018 inventory...

    The inventory of Royal Decking consisted of five products. Information about the December 31, 2018 inventory is as follows: Per Unit Selling Price $ 75 115 95 145 45 Product Cost $ 55 95 Replacement Cost $ 50 85 70 85 115 35 Selling costs consist of a sales commission equal to 10% of selling price and shipping costs equal to 5% of cost. The normal gross profit percentage is 30% of selling price Required What unit value should Royal Decking use for each...

  • The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory...

    The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory is as follows: Product Cost $ 59 Per Unit Replacement Cost $ 54 Selling Price $ 79 119 99 89 поопP 99 59 119 39 74 89 47 149 49 Selling costs consist of a sales commission equal to 15% of selling price and shipping costs equal to 5% of cost. The normal profit is 25% of selling price. Required: What unit value should...

  • The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory...

    The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory is as follows: Per Unit Product Cost Replacement Cost Selling Price A $ 48 $ 43 $ 68 B 88 78 108 C 48 63 88 D 108 78 138 E 28 36 38 Selling costs consist of a sales commission equal to 10% of selling price and shipping costs equal to 5% of cost. The normal profit is 40% of selling price. Required:...

  • The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory...

    The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory is as follows: Per Unit Product Cost Replacement Cost Selling Price $ 50 $ 45 $ 70 90 80 110 65 90 110 140 30 38 40 50 Selling costs consist of a sales commission equal to 15% of selling price and shipping costs equal to 5% of cost. The normal profit is 30% of selling price. Required: What unit value should Royal Decking...

  • The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory is as follows:

    The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory is as follows: Per UnitProductCostReplacement CostSelling PriceA$60$55$80B10090120C6075100D12090150E404850Selling costs consist of a sales commission equal to 10% of selling price and shipping costs equal to 5% of cost. The normal profit is 20% of selling price. Required:What unit value should Royal Decking use for each of its products when applying the lower of cost or market (LCM) rule to units of ending inventory? (Do not round intermediate calculations....

  • The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory...

    The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory is as follows: Per Unit Selling Price $ 74 Replacement Cost 49 Product Cost $54 A 94 84 114 C 54 69 94 114 84 144 E 34 42 44 Selling costs consist of a sales commission equal to 15% of selling price and shipping costs equal to 5% of cost. The normal profit is 35% of selling price. Required: What unit value should...

  • The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory...

    The inventory of Royal Decking consisted of five products. Information about the December 31, 2021, inventory is as follows: Product 1.5 points Cost $ 42 Per Unit Replacement Cost $ 37 82 Selling Price $ 62 102 82 132 Uow 42 102 Selling costs consist of a sales commission equal to 10% of selling price and shipping costs equal to 5% of cost. The normal profit is 20% of selling price. Required: What unit value should Royal Decking use for...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT