Inventory value with LCM applied to entire Inventory | ||||||||||
A | B | C | D | E=A*B | F=A*C | G=A*D | ||||
Unit | Unit | Total | Total | |||||||
Product | Quantity | Unit Cost | Replacement Cost | Selling Price | Total Cost | Replacement Cost | Market value | |||
A | 1,000 | $17 | $19 | $23 | $17,000 | $19,000 | $23,000 | |||
B | 700 | $22 | $18 | $25 | $15,400 | $12,600 | $17,500 | |||
C | 1,000 | $10 | $9 | $15 | $10,000 | $9,000 | $15,000 | |||
D | 900 | $14 | $11 | $13 | $12,600 | $9,900 | $11,700 | |||
E | 600 | $21 | $19 | $20 | $12,600 | $11,400 | $12,000 | |||
TOTAL | $67,600 | $61,900 | $79,200 | |||||||
Cost to sell | $11,880 | (79200*0.15) | ||||||||
(market Ceiling) | Net Realizable Value(NRV) | $67,320 | (79200-11880) | |||||||
Normal Profit | $31,680 | (0.4*79200) | ||||||||
Market floor | $35,640 | |||||||||
Replacement Cost | $61,900 | |||||||||
Market | $61,900 | |||||||||
NRV=Market Value -Cost To Sell | Historical Cost | $67,600 | ||||||||
NRV=Market Value *(1-0.15) | Lower of Cost or market | $61,900 | (LCM) | |||||||
NP=Net Profit =0.4*Market value | ||||||||||
F | H=G*(1-0.15) | I=H-0.4*G | E | |||||||
Product | Quantity | RC | NRV | NRV-NP | Market | Cost | Inventory Value | |||
A | 1,000 | $19,000 | $19,550 | $10,350 | $19,000 | $17,000 | $17,000 | |||
B | 700 | $12,600 | $14,875 | $7,875 | $12,600 | $15,400 | $12,600 | |||
C | 1,000 | $9,000 | $12,750 | $6,750 | $9,000 | $10,000 | $9,000 | |||
D | 900 | $9,900 | $9,945 | $5,265 | $9,900 | $12,600 | $9,900 | |||
E | 600 | $11,400 | $10,200 | $5,400 | $10,200 | $12,600 | $10,200 | |||
Total | $61,900 | $67,320 | $35,640 | Total Cost | $67,600 | $58,700 | (LCM) | |||
Inventory value with LCM applied to individual Product | $58,700 | |||||||||
Inventory value with LCM applied to entire Inventory | $61,900 | |||||||||
JOURNAL ENTRY | ||||||||||
Account | Debit | Credit | ||||||||
Loss on LCM adjustment | $8,900 | (67600-58700) | ||||||||
Finished goods Inventory | $8,900 | |||||||||
LCM applied to entire inventory: | ||||||||||
Loss on LCM adjustment | $5,700 | (67600-61900) | ||||||||
Finished goods Inventory | $5,700 | |||||||||
Problem 9-3 Lower of cost or market [LO9-1 Forester Company has five products in its inventory. I...
HELP
Forester Company has five products in its inventory. Information about the December 31, 2018, inventory follows. Unit Unit Unit Replacement Cost Selling Price Product Quantity 1,000 800 Cost A S 14 $16 $20 22 B 19 7 15 C 700 6 12 D 600 11 8 10 E 800 18 16 17 The cost to sell for each product consists of a 15 percent sales commission. The normal profit percentage for each product is 35 percent of the selling...
Forester Company has five products in its inventory. Information about the December 31, 2018, inventory follows Unit Unit Replacement Selling Price Unit Cost Quantity 900 900 Cost Product $31 $ 25 30 $27 26 A 33 B 23 17 19 18 500 C 21 22 700 D 28 27 29 500 E The cost to sell for each product consists of a 10 percent sales commission. The normal profit percentage for each product is 35 percent of the selling price....
help
Forester Company has five products in its inventory Information about the December 2013 Unit Cost 5 16 21 Replacement Cost $18 17 Unit Selling Price 522 Product Quantity 900 1,000 900 1,000 900 20 The cost to sell for each product consists of a 10 percent sales commission. The normal profit percentage for product is 40 percent of the selling price. Required: 1. Determine the carrying value of inventory at December 31, 2018, assuming the lower of cost or...
Forester Company has five products in its inventory. Information about the December 31, 2021, inventory follows. Product Quantity Unit Cost Unit Replacement Cost Unit Selling Price A 900 $ 29 $ 31 $ 35 B 900 34 30 37 C 900 22 21 27 D 900 26 23 25 E 1,000 33 31 32 The cost to sell for each product consists of a 20 percent sales commission. The normal profit for each product is 40 percent of the selling...
Forester Company has five products in its inventory. Information about the December 31, 2021, inventory follows.ProductQuantityUnitCostUnitReplacementCostUnitSellingPriceA800$27$29$33B800322835C600201925D800242123E500312930The cost to sell for each product consists of a 15 percent sales commission. The normal profit for each product is 35 percent of the selling price.Required:1. Determine the carrying value of inventory at December 31, 2021, assuming the lower of cost or market (LCM) rule is applied to individual products.2. Determine the carrying value of inventory at December 31, 2021, assuming the LCM rule...
Forester Company has five products in its inventory. Information about the December 31, 2018 , inventory follows.ProductQuantityCostCostPriceA800$13$15$19B600181421C5006511D9001079E600171516The cost to sell for each product consists of a 20 percent sales commission. The normal profit percentage for each product is 30 percent of the selling price.Required:1. Determine the carrying value of inventory at December 31, 2018, assuming the lower of cost or market (LCM) rule is applied to individual products.2a. Determine the carrying value of inventory at December 31, 2018, assuming the...
Problem 9-3 (Algo) Lower of cost or market; by product and by total inventory (LO9-1] Forester Company has five products in its inventory. Information about the December 31, 2021, inventory follows. Product A Unit Cost $ 30 35 23 27 Quantity 600 1,000 900 800 700 Unit Replacement Cost $32 31 22 24 32 Unit Selling Price $36 38 28 26 33 B с D E 34 The cost to sell for each product consists of a 10 percent sales...
Forester Company has five products in its inventory. Information about the December 31, 2021, inventory follows. Product Quantity Unit Cost Unit Replacement Cost Unit Selling Price A 1,000 $ 28 $ 30 $ 34 B 900 33 29 36 C 500 21 20 26 D 600 25 22 24 E 700 32 30 31 The cost to sell for each product consists of a 10 percent sales commission. The normal profit for each product is 35 percent of the selling...
Forester Company has five products in its inventory. Information about the December 31, 2021, inventory follows.ProductQuantityUnit CostUnit Replacement CostUnit Selling PriceA1,000$28$30$34B900332936C500212026D600252224E700323031The cost to sell for each product consists of a 10 percent sales commission. The normal profit for each product is 35 percent of the selling price.Required:1. Determine the carrying value of inventory at December 31, 2021, assuming the lower of cost or market (LCM) rule is applied to individual products.2. Determine the carrying value of inventory at December 31,...
Forester Company has five products in its inventory. Information about the December 31, 2021, inventory follows. Product Quantity Unit Cost Unit Replacement Cost Unit Selling Price A 600 $ 30 $ 32 $ 36 B 1,000 35 31 38 C 900 23 22 28 D 800 27 24 26 E 700 34 32 33 The cost to sell for each product consists of a 10 percent sales commission. The normal profit for each product is 25 percent of the selling...