FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Topic Video
Question
eBook
Calculator
Print Item
Lower-of-Cost-or-Market Inventory
Data on the physical inventory of Ashwood Products Company as of December 31 follows:
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:
- Insert the quantity and unit cost of the last purchase.
- On the following line, insert the quantity and unit cost of the next-to-the-last purchase.
- Total the cost and market columns and insert the lower of the two totals in the LCM column.
The first item on the inventory sheet has been completed as an example.
Inventory Sheet December 31 |
|||||||
---|---|---|---|---|---|---|---|
Description | Inventory Quantity | Cost Price Unit | Market Value per Unit (Net Realizable Value) |
||||
Cost | Market | LCM | |||||
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 | $ | $ | $ |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 1,300 units at $26 May 10 650 units at $28 May 12 910 units 20 585 units at $30 14 780 units 31 390 units Question Content Area a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Merchandise SoldLIFO MethodPrepaid Cell Phones Date QuantityPurchased PurchasesUnit Cost PurchasesTotal Cost QuantitySold Cost ofMerchandiseSoldUnit Cost Cost…arrow_forwardeBook Perpetual Inventory Using LIFO The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 4,000 units at $20 Apr. 19 Sale 2,500 units June 30 Purchase 6,000 units at $24 Sept. 2 Sale 4,500 units Nov. 15 Purchase 1,000 units at $25 The firm maintains a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale, assuming the last-in, first-out method. Present the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two or more different costs, enter the units with the LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Goods SoldLIFO Method Purchases Cost of Goods Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Jan. 1 fill in the blank 1 $fill in the blank 2 $fill in the blank 3 Apr. 19 fill in the blank 4 $fill…arrow_forwardeBOOk Inventory Costing Methods Tyler Company has the following information related to purchases and sales of one of its inventory items. Date Description Units Purchased at Cost Units Sold at Retail Sept. 1 Beginning inventory 400 units @ $16 10 Purchase 600 units @ $17 20 Sales 660 units @ $29 25 Purchase 800 units at $19 Assume Tyler uses a perpetual inventory system. Required: Calculate ending inventory and cost of goods sold using the FIFO, LIFO, and average cost methods. FIFO LIFO Avg Cost Cost of goods sold Ending inventory 2. Which inventory costing method produces the highest amount for net income? FIFO 3. Which inveitory costing method produces the lowest amount for taxes? LIFO 4. Which inventory costing method produces the highest amount for ending inventory? FIFO Feedback Check My Work All work saved. Email Instructor 80 F2 F3 DD F4 F5 F6 F7 F9 %23 2$ & * 3 6 7arrow_forward
- Assignment/takeAssignmentMain.do?invoker-&takeAssignmentSessionLocator=assignment-take&inprogress-f Calculator Show Me How eBook Periodic Inventory by Three Methods; Cost of Merchandise Sold The units of an item available for sale during the year were as follows: 1,800 units at $108 Jan. 1 Inventory 2,240 units at $110 Purchase Mar. 10 2,000 units at $116 Purchase Aug. 30 Purchase 1,960 units at $120 Dec. 12 There are 2,000 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost and the cost of merchandise sold by three methods. Cost of Merchandise Inventory and Cost of Merchandise Sold Merchandise Inventory Merchandise Sold Inventory Method First-in, first-out (FIFO) Last-in, first-out (LIFO) Weighted average cost Feజcosok y Check My Work Note that this exercise uses the periodic inventory System. FIFO means that the first units purchased are assumed inventory costs for the period are calculated by taking the…arrow_forwardPerpetual Inventory Using FIFO Beginning inventory, purchases, and sales for Item PK95 are as follows: August 1 Inventory 78 units @ $20 9 Sale 64 units 13 Purchase 86 units @ $24 25 Sale 20 units Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on August 25 and (b) the inventory on August 31. a. Cost of merchandise sold on August 25 $fill in the blank 1 b. Inventory on August 31 $fill in the blank 2arrow_forwardPeriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 8 units at $33 $264 Aug. 7 Purchase 18 units at $35 630 Dec. 11 Purchase 15 units at $37 555 41 units $1,449 There are 16 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out (FIFO) method; (b) the last-in, first-out (LIFO) method; and (c) the weighted average cost method (round per unit cost to two decimal places and your final answer to the nearest whole dollar). a. First-in, first-out (FIFO) $ b. Last-in, first-out (LIFO) $ c. Weighted average cost $arrow_forward
- Subject: accountingarrow_forwardsavitaarrow_forwardPerpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item 88-HX are as follows: Oct. 1 Inventory 88 units @ $27 8. Sale 70 units 15 Purchase 98 units @ $29 27 Sale 82 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of goods sold on Oct. 27 and (b) the inventory on Oct. 31. a. Cost of goods sold on Oct. 27 b. Inventory on Oct. 31 $arrow_forward
- Perpetual Inventory Using FIFO The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 4,000 units at $39 Apr. 19 Sale 2,500 units June 30 Purchase 4,400 units at $43 Sept. 2 Sale 5,200 units Nov. 15 Purchase 2,000 units at $46 The firm maintains a perpetual inventory' system. Determine the cost of goods sold for each sale and the inventory balance after each sale, assuming the first-in, first-out method. Present the data in the form illustrated in Exhibit 3. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost cólumn. Schedule of Cost of Goods Sold FIFO Method Purchases Cost of Goods Sold Inventor Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Jan. 1 Apг. 19 June 30arrow_forwardPerpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item PK95 are as follows: October 1 Inventory 108 units @ $20 5 Sale 86 units 11 Purchase 120 units @ $24 21 Sale 101 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on October 21 and (b) the inventory on October 31. a. Cost of merchandise sold on October 21 $fill in the blank 1 b. Inventory on October 31 $fill in the blank 2arrow_forwardPerpetual inventory using LIFO Beginning inventory, purchases, and sales for Item 88-HX are as follows: July 1 Inventory 82 units @ $20 July 8 Sale 66 units July 15 Purchase 91 units @ $24 July 27 Sale 76 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of goods sold on July 27 and (b) the inventory on July 31. a. Cost of goods sold on July 27 b. Inventory on July 31arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education