Question

Lower-of-Cost-or-Market Inventory Data on the physical inventory of Ashwood Products Company as of December 31 follow:...

Lower-of-Cost-or-Market Inventory

Data on the physical inventory of Ashwood Products Company as of December 31 follow:


Description
Inventory
Quantity
Unit Market
Price
B12 38 $ 57
E41 18 180
G19 33 126
L88 18 550
N94 400 7
P24 90 18
R66 8 250
T33 140 20
Z16 15 752

Quantity and cost data from the last purchases invoice of the year and the next-to-the-last purchases invoice are summarized as follows:

Last
Purchases Invoice
Next-to-the-Last
Purchases Invoice

Description
Quantity
Purchased
Unit
Cost
Quantity
Purchased
Unit
Cost
B12 30 $ 60 30 $ 59
E41 35 178 20 180
G19 20 128 25 129
L88 10 563 10 560
N94 500 8 500 7
P24 80 22 50 21
R66 5 248 4 260
T33 100 21 100 19
Z16 10 750 9 745

Required:

Determine the inventory at cost and also at the lower of cost or market, using the first-in, first-out method. Record the appropriate unit costs on the inventory sheet and complete the pricing of the inventory. When there are two different unit costs applicable to an item, proceed as follows:

  1. Insert the quantity and unit cost of the last purchase.
  2. Insert the quantity and unit cost of the next-to-the-last purchase.
  3. Total the cost and market columns and insert the lower of the two totals in the Lower of C or M column.

The first item on the inventory sheet has been completed as an example.

Inventory Sheet
December 31
Description Inventory Quantity Unit Cost Price Unit Market Price
Total Cost Total Market Total Lower of C or M
B12 38 30 $60 $57 $1,800 $1,710
8 59 57 472 456
2,272 2,166 $2,166
E41 18
G19 33
L88 18
N94 400
P24 90
R66 8
T33 140
Z16 15
Total $ $ $

Homework Answers

Answer #1

Answer:

Inventory Sheet

December 31, 2016

Know the answer?
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
Similar Questions
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. Total Product Inventory Quantity Cost per Unit Market Value per Unit (Net Realizable Value) Cost Market LCM Adams 100 $140 $125 $_____ $_____ $______ Coolidge 375 90 112 ______ ______ ______ McKinley 220 60 59 ______ ______ ______ Garfield 900 120 115 ______ ______ ______ Lincoln 626 140 145 ______ ______ ______ 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 9. Inventory Item Inventory Quantity Cost per Unit Market Value per Unit (Net Realizable Value) Birch 44 $71 $47 Cypress 38 207 232 Mountain Ash 32 44 36 Spruce 25 223 198 Willow 24 254 238 Inventory at the Lower of Cost or Market Commodity Total Cost Total Market...
On the basis of the following data, determine the value of the inventory at the lower-of-cost-or-market...
On the basis of the following data, determine the value of the inventory at the lower-of-cost-or-market by applying lower-of-cost-or-market to each inventory item, as shown in Exhibit 10. Item Inventory Quantity Unit Cost Price Unit Market Price MX62 116 $31 $26 BJ54 225 16 18 $_____
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. Commodity Inventory Quantity Unit Cost Price Unit Market Price Ash 80 $140 $125 Aspen 120 90 112 Beech 30 75 74 Maple 75 88 86 Oak 60 140 145 Inventory at the Lower of Cost or Market Commodity Total Cost Total Market Total Lower of C or M...
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 18 $108 $84 Model B 21   88 85 Model C 47 201   196 Class 2: Model D 17   67   48 Model E 28 210 185 a. Determine the value of the...
Lower-of-Cost-or-Market Method On the basis of the following data, determine the value of the inventory at...
Lower-of-Cost-or-Market Method On the basis of the following data, determine the value of the inventory at the lower-of-cost-or-market by applying lower-of-cost-or-market to each inventory item, as shown in Exhibit 9. Item Inventory Quantity Cost per Unit Market Value per Unit (Net Realizable Value) JFW1 82 $32 $28 SAW9 167 16 18 $
Lower-of-Cost-or-Market (LCM) Method The following data are taken from the Smith & Wesson Corporation's inventory accounts:...
Lower-of-Cost-or-Market (LCM) Method The following data are taken from the Smith & Wesson Corporation's inventory accounts: Item Code Quantity Unit Cost Replacement Cost ZXE 100 $42 $40 XYF 300 53 54 MNJ 400 42 40 UBS 200 53 57 Calculate the value of the company's ending inventory using the lower-of-cost-or-market method applied to each item of inventory.
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 21 $116 $119 Model B 29 255 259 Model C 8 65 41 Model D 24 125 105 Model E 23 281 298 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...
A physical inventory of Liverpool Company taken at December 31 reveals the following. Per Unit Item...
A physical inventory of Liverpool Company taken at December 31 reveals the following. Per Unit Item Units Cost Market Car audio equipment Speakers 340 $ 95 $ 103 Stereos 255 116 105 Amplifiers 321 91 100 Subwoofers 199 57 46 Security equipment Alarms 475 155 130 Locks 286 98 89 Cameras 207 315 327 Binocular equipment Tripods 180 75 89 Stabilizers 165 102 110 Required: 1. Calculate the lower of cost or market for the inventory applied separately to each...
Determining Lower of Cost or Net Realizable Value (NRV) The following data refer to Froning Company’s...
Determining Lower of Cost or Net Realizable Value (NRV) The following data refer to Froning Company’s ending inventory. Item Code Quantity Unit Cost Unit NRV LXC 500 $45 $48 KWT 180 38 34 MOR 300 22 20 NES 200 27 32 Determine the ending inventory amount by applying the lower of cost or net realizable value rule to: (a) each item of inventory $Answer (b) the total inventory. $Answer
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT