The units of an item available for sale during the year were as follows: Jan, 1 Inventory 2,500 units at $3 Feb. 17 Purchase 2,900 units at $5 Jul. 21 Purchase 3,100 units at $7 Nov. 23 Purchase 1,500 units at $9 There are 2,100 units of the item in the physical inventory at December 31. The periodic inventory system is used. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the inventory cost by the first-in, first-out method. b. Determine the inventory cost be the last-in, first-out method. c. Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar. Feedback Check My Work a. Note that this exercise uses the periodic inventory system. FIFO means that the first units purchased are assumed to be the first to be sold. Therefore, ending inventory costs for the period are calculated by taking the number of items remaining in the physical inventory times the most recent purchase price. If the number of tems in last purchase laver in less than

The units of an item available for sale during the year were as follows: Jan, 1 Inventory 2,500 units at $3 Feb. 17 Purchase 2,900 units at $5 Jul. 21 Purchase 3,100 units at $7 Nov. 23 Purchase 1,500 units at $9 There are 2,100 units of the item in the physical inventory at December 31. The periodic inventory system is used. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the inventory cost by the first-in, first-out method. b. Determine the inventory cost be the last-in, first-out method. c. Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar. Feedback Check My Work a. Note that this exercise uses the periodic inventory system. FIFO means that the first units purchased are assumed to be the first to be sold. Therefore, ending inventory costs for the period are calculated by taking the number of items remaining in the physical inventory times the most recent purchase price. If the number of tems in last purchase laver in less than

Name: PLEASE HELP ME lodic inventory by three methodsThe units of an item av
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: PLEASE HELP ME lodic inventory by three methodsThe units of an item available for sale during the year were as follows:Jan. 1 Inventory 2,500 units at $3Feb. 17Purchase 2,900 units at $5Jul. 21 Purchase3,100 units at $7Nov. 23 Purchase 1,500 units at

Financial Accounting

15th Edition

ISBN:9781337272124

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter7: Inventories

Section: Chapter Questions

Problem 4PB: The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are...

See similar textbooks

Similar questions

Hurst Companys beginning inventory and purchases during the fiscal year ended December 31, 20-2, were as follows: There are 1,200 units of inventory on hand on December 31, 20-2. REQUIRED 1. Calculate the total amount to be assigned to the cost of goods sold for 20-2 and ending inventory on December 31 under each of the following periodic inventory methods: (a) FIFO (b) LIFO (c) Weighted-average (round calculations to two decimal places) 2. Assume that the market price per unit (cost to replace) of Hursts inventory on December 31 was 18. Calculate the total amount to be assigned to the ending inventory on December 31 under each of the following methods: (a) FIFO lower-of-cost-or-market (b) Weighted-average lower-of-cost-or-market 3. In addition to taking a physical inventory on December 31, Hurst decides to estimate the ending inventory and cost of goods sold. During the fiscal year ended December 31, 20-2, net sales of 100,000 were made at a normal gross profit rate of 35%. Use the gross profit method to estimate the cost of goods sold for the fiscal year ended December 31 and the inventory on December 31.
Beginning inventory, purchases, and sales for WCS12 are as follows: Assuming a perpetual inventory system and using the weighted average method, determine (a) the weighted average unit cost after the October 22 purchase, (b) the cost of goods sold on October 29, and (c) the inventory on October 31.
Beginning inventory, purchases, and sales for WCS12 are as follows: Assuming a perpetual inventory system and using the weighted average method, determine (a) the weighted average unit cost after the October 22 purchase, (b) the cost of the merchandise sold on October 29, and (c) the inventory on October 31.
Beginning inventory, purchases, and sales for 30xT are as follows: Assuming a perpetual inventory system and using the weighted average method, determine (a) the weighted average unit cost after the May 23 purchase, (b) the cost of the merchandise sold on May 26, and (c) the inventory on May 31.
Pappas Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the year, and the inventory count at December 31 are summarized as follows: Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out method. Present data in columnar form, using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. 2. Determine the cost of the inventory on December 31 by the last-in, first-out method, following the procedures indicated in (1). 3. Determine the cost of the inventory on December 31 by the weighted average cost method, using the columnar headings indicated in (1). 4. Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.
Beginning inventory, purchases, and sales for Item ProX2 are as follows: Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on January 25 and (b) the inventory on January 31.
Jessie Stores uses the periodic system of calculating inventory. The following information is available for December of the current year when Jessie sold 500 units of inventory. Using the FIFO method, calculate Jessies inventory on December 31 and its cost of goods sold for December.
The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are shown in Problem 7-1B. Instructions 1. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the first-in, first-out method and the periodic inventory system. 2. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the last-in, first-out method and the periodic inventory system. 3. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the weighted average cost method and the periodic inventory system. Round the weighted average unit cost to the dollar. 4. Compare the gross profit and June 30 inventories using the following column headings:
Beginning inventory, purchases, and sales for Item Foxtrot are as follows: Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on March 27 and (b) the inventory on March 31.
Jessie Stores uses the periodic system of calculating inventory. The following information is available for December of the current year when Jessie sold 500 units of inventory. Using the FIFO method, calculate Jessies inventory on December 31 and its cost of goods sold for December. RE7-11 Using the information from RE7-10, calculate Jessie Storess inventory on December 31 and its cost of goods sold for December using the LIFO method.
Beginning inventory, purchases, and sales for Item Delta are as follows: Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on July 24 and (b) the inventory on July 31.
Dymac Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the next 12 months, and the inventory count at December 31 are summarized as follows: Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out method. Present data in columnar form, using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. 2. Determine the cost of the inventory on December 31 by the last-in, first-out method, following the procedures indicated in (1). 3. Determine the cost of the inventory on December 31 by the weighted average cost method, using the columnar headings indicated in (1). 4. Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.