Question

In: Accounting

#4 Lower of Cost or Market Weldon Animal Feeds has developed the following data to calculate...

#4 Lower of Cost or Market

Weldon Animal Feeds has developed the following data to calculate LIFO lower of cost or market for its products. The individual products are listed individually among their categories of feed (in thousands):

Selling

Cost to

Price

Cost

Replace

Large animals:

    Cattle

$320

$160

$170

    Horse

400

400

325

Small animals:

    Cat

$360

$320

$280

    Dog

120

90

40

Exotic pets:

    Ferret

$140

$112

$98

    Iguana

70

48

21

The disposal costs are 20% of the selling price and the normal profit margin on all feed is 25% of the selling price.

            Required: Determine the reported inventory value assuming the LIFO lower of cost or market rule is applied to categories of feed products.

Solutions

Expert Solution

Selling Price Cost Cost to Replace Disposal cost Net Realizable Value(Selling price - Disposal Cost) Normal profit NRV-Normal Profit Market Lower of Cost or Market
Large animals:
    Cattle              320              160              170               64                 256               80            176            176            160
    Horse              400              400              325               80                 320            100            220            320            320
Small animals:
    Cat              360              320              280               72                 288               90            198            280            280
    Dog              120                90                40               24                    96               30               66               66               66
Exotic pets:
    Ferret              140              112                98               28                 112               35               77               98               98
    Iguana                70                48                21               14                    56               18               39               39               39
Total Ending Inventory Value            963
Note 1: Market price is same as replacement cost, but if replacement cost is more than NRV then NRV will be the market value(as in Horse), Also market price should not be less then NRV-NP.otherwise NRV-Normal profit will be market price (As in Cattle , Dog and Iguana)

Related Solutions

Novelli's Nursery has developed the following data for lower of cost or market for its products....
Novelli's Nursery has developed the following data for lower of cost or market for its products. The individual types of trees are separated as to their categories: Selling Cost to Price Cost Replace Broad leaf trees: Ash $1,800 $1,000 $800 Beech 2,200 1,600 1,400 Needle leaf trees: Cedar $2,500 $1,750 $1,800 Fir 3,600 3,350 3,200 Fruit trees: Apple $1,800 $1,400 $1,300 Cherry 2,300 1,800 1,700 The costs to sell are 10% of the selling price, and the normal profit margin...
Lower-of-Cost-or-Market Method On the basis of the following data: Item Inventory Quantity Cost per Unit Market...
Lower-of-Cost-or-Market MethodOn the basis of the following data: $$ \begin{array}{lccc} \text { Item } & \text { Inventory Quantity } & \text { Cost per Unit } & \begin{array}{l} \text { Market Value per Unit } \\ \text { (Net Realizable Value) } \end{array} \\ \hline \text { JFW1 } & 6,330 & \$ 10 & \$ 11 \\ \text { SAW9 } & 1,140 & 36 & 34 \end{array} $$Determine the value of the inventory at the lower-of-cost-or-market by applying...
Lower-of-Cost-or-Market Inventory On the basis of the following data: Product Inventory Quantity Cost per Unit Market...
Lower-of-Cost-or-Market Inventory On the basis of the following data: Product Inventory Quantity Cost per Unit Market Value per Unit (Net Realizable Value) Model A 13 $198 $223 Model B 42 63 56 Model C 36 126 144 Model D 13 241 237 Model E 33 144 152 Determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 9. Inventory at the Lower of Cost or Market Product Total...
Lower-of-Cost-or-Market Inventory On the basis of the following data: Product Inventory Quantity Cost per Unit Market...
Lower-of-Cost-or-Market Inventory On the basis of the following data: Product Inventory Quantity Cost per Unit Market Value per Unit (Net Realizable Value) Model A 12 $106 $102 Model B 45 84 70 Model C 36 254 243 Model D 31 85 88 Model E 41 132 148 Determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 9. Inventory at the Lower of Cost or Market Product Total...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 10. Product Inventory Quantity Cost Per Unit Market Value per Unit (Net Realizable Value) Class 1: Model A 19 $299 $295 Model B 23   78 86 Model C 44 237   241 Class 2: Model D 9   78   83 Model E 9 244 228 a. Determine the value of the...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 10. Product Inventory Quantity Cost Per Unit Market Value per Unit (Net Realizable Value) Class 1: Model A 10 $164 $144 Model B 20   253 269 Model C 47 48   33 Class 2: Model D 26   48   37 Model E 35 49 37 a. Determine the value of the...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 10. Product Inventory Quantity Cost Per Unit Market Value per Unit (Net Realizable Value) Class 1: Model A 300 $140 $125 Model B 500   90 112 Model C 150 60   59 Class 2: Model D 800   120   115 Model E 400 140 145 a. Determine the value of the...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 10. Product Inventory Quantity Cost Per Unit Market Value per Unit (Net Realizable Value) Class 1: Model A 32 $256 $251 Model B 8   94 79 Model C 18 178   194 Class 2: Model D 23   247   263 Model E 34 98 77 a. Determine the value of the...
How to calculate the cost of inventory using the lower of cost or market (LCM) inventory...
How to calculate the cost of inventory using the lower of cost or market (LCM) inventory valuation method? How to record the adjustment to write-down inventory under the LCM inventory valuation method?
1. Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory...
1. Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 9. Inventory Item Inventory Quantity Cost per Unit Market Value per Unit (Net Realizable Value) Birch 43 $244 $231 Cypress 15 68 58 Mountain Ash 37 230 245 Spruce 49 151 170 Willow 43 113 111 Inventory at the Lower of Cost or Market Inventory Item Total Cost...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT