Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 34 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.)
Date | Units purchased | Cost per unit |
Total cost | ||||
January 1 | 51 | $ | 7.10 | $ | 362.10 | ||
April 1 | 46 | 6.35 | 292.10 | ||||
June 1 | 61 | 6.10 | 372.10 | ||||
September 1 | 56 | 6.60 | 369.60 | ||||
Total | 214 | $ | 1,395.90 | ||||
Cost of goods sold | Ending inventory | |
FIFO | $ | $ |
LIFO | $ | $ |
Average cost | $ | $ |
The answer has been presented in the supporting sheet. All the parts has been solved with detailed explanation and format. For detailed answer refer to the supporting sheet.
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods X FILE 5.a. HOME % Calibri INSERT PAGE LAYOUT Inventory costing methods - Excel FORMULAS DATA REVIEW ? x VIEW - 6 Sign In Paste B IU - -A- Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard D66 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: of Units...
Calculate the cost of ending inventory and the cost of goods sold under the (a) FIFO b) LIFO, and (c) weighted average cost methods. (Do not round your intermediate calculations. Round "Weighted Average Cost" to 2 decimal places.) Spotter Corporation reporteu le IUIUWING TUI JUIC E Date Description Units Unit Cost June 1 Beginning 24 $11.20 11 Purchase 40 12.20 24 Purchase 36 14.20 30 Ending Total Cost $268.80 488.00 511.20 Required: 1. Calculate the cost of ending inventory and...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that Gode Company reports the following initial balance and subsequent purchase of inventory: Beginning inventory, 2017 1,000 units @ $100 each $100,000 Inventory purchased in 2017 2.000 units $150 each 300,000 Cost of goods available for sale in 2017 3.000 units $400,000 Assume that 1,600 units are sold during 2017. Compute the cost of goods sold for 2017 and the balance reported as ending inventory...
E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost $5 1,830 Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year 6,130 4,130 2,810 2 Required: Compute ending...
E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Unit Units Cost Inventory, December 31, prior 1,980 $8 year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current 6,090 4,150 7 2,840 year Required: Compute ending...
E7-5 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost $5 1,930 Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year 7 5,080 2,830 4,040 Required: Compute ending...
M7-10 Calculating Cost of Goods Available for Sale, Cost of Goods Sold, and Ending Inventory under FIFO, LIFO, and Weighted Average Cost (Periodic Inventory) (LO 7-3] Aircard Corporation tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period as if it uses a periodic inventory system. The following are the transactions for the month of July. Unit Cost $20 July 1 July 5 July 13 July...
Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 600 units from beginning inventory, 380 from the February 10 purchase, 120 from the March 13 purchase, 130 from the August 21 purchase, and 205 from the September 5 purchase. (Round your average cost per unit to 2 decimal places.) Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases...
1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system 5. Calculate January's ending inventory and cost of goods sold for...
Check my work E7-6 Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost L07-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: 0.62 points Units Unit Cost $5 1,850 eBook Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year 4. Print...