A company began January with 6,000 units of its principal product. The cost of each nit...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company began January with 6,000 units of its principal product. The cost of each nit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Sales Units Date of Sale January 5 January 12 January 20 Total 5,000 6,000 11,000 * Includes purchase price and cost of freight. Purchases Unit Cost $9 10 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $ 105,000 Dok Int ences Problem 8-5 (Static) Part 1 Required: 1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. FIFO Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale $ 48,000 Number Cost per of units unit 6,000 $8.00 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic FIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic FIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory Problem 8-5 (Static) Part 2 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. LIFO Beginning Inventory Purchases: January 10 January 18- Total Cost of Goods Available for Sale Cost of Goods Available for Sale 6,000 $8.00 S 48,000 Number Cost per of units unit 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic LIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic LIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory I ces Problem 8-5 (Static) Part 3 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Perpetual FIFO: Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 $ Number of units 5,000 9.00 6,000 10.00 17,000 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold-January 5 Number of units sold Cost per unit $ 8.00 9.00 10.00 Cost of Goods Sold Cost of Goods Sold-January 12 Number of units sold Cost per unit $ 8.00 9,00 10.00 Cost of Goods Sold 0 0 Cost of Goods Sold-January 20 Number of units sold Cost per 5 8.00 9.00 10.00 Cost of Goods Sold O 1 ok mt 0 ences Problem 8-5 (Static) Part 4 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Cost of Goods Average Cost per Unit Average Cost Beginning Inventory Purchases: January 10 January 18 Total Number Unit of units Cost Available for Sale 6,000 $8.00 $ 48,000 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Number of units sold Cost of Goods Sold Number of units in ending inventory Ending Inventory-Average Cost Average Cost per unit Ending Inventory S Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Perpetual Average Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase-January 18 Subtotal Average Cost Sale January 20 Total Inventory on hand Number Cost per of units unit Inventory Value Number of units sold Cost of Goods Sold Average Cost per unit Cost of Goods Sold A company began January with 6,000 units of its principal product. The cost of each nit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Sales Units Date of Sale January 5 January 12 January 20 Total 5,000 6,000 11,000 * Includes purchase price and cost of freight. Purchases Unit Cost $9 10 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $ 105,000 Dok Int ences Problem 8-5 (Static) Part 1 Required: 1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. FIFO Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale $ 48,000 Number Cost per of units unit 6,000 $8.00 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic FIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic FIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory Problem 8-5 (Static) Part 2 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. LIFO Beginning Inventory Purchases: January 10 January 18- Total Cost of Goods Available for Sale Cost of Goods Available for Sale 6,000 $8.00 S 48,000 Number Cost per of units unit 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic LIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic LIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory I ces Problem 8-5 (Static) Part 3 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Perpetual FIFO: Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 $ Number of units 5,000 9.00 6,000 10.00 17,000 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold-January 5 Number of units sold Cost per unit $ 8.00 9.00 10.00 Cost of Goods Sold Cost of Goods Sold-January 12 Number of units sold Cost per unit $ 8.00 9,00 10.00 Cost of Goods Sold 0 0 Cost of Goods Sold-January 20 Number of units sold Cost per 5 8.00 9.00 10.00 Cost of Goods Sold O 1 ok mt 0 ences Problem 8-5 (Static) Part 4 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Cost of Goods Average Cost per Unit Average Cost Beginning Inventory Purchases: January 10 January 18 Total Number Unit of units Cost Available for Sale 6,000 $8.00 $ 48,000 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Number of units sold Cost of Goods Sold Number of units in ending inventory Ending Inventory-Average Cost Average Cost per unit Ending Inventory S Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Perpetual Average Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase-January 18 Subtotal Average Cost Sale January 20 Total Inventory on hand Number Cost per of units unit Inventory Value Number of units sold Cost of Goods Sold Average Cost per unit Cost of Goods Sold A company began January with 6,000 units of its principal product. The cost of each nit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Sales Units Date of Sale January 5 January 12 January 20 Total 5,000 6,000 11,000 * Includes purchase price and cost of freight. Purchases Unit Cost $9 10 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $ 105,000 Dok Int ences Problem 8-5 (Static) Part 1 Required: 1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. FIFO Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale $ 48,000 Number Cost per of units unit 6,000 $8.00 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic FIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic FIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory Problem 8-5 (Static) Part 2 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. LIFO Beginning Inventory Purchases: January 10 January 18- Total Cost of Goods Available for Sale Cost of Goods Available for Sale 6,000 $8.00 S 48,000 Number Cost per of units unit 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic LIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic LIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory I ces Problem 8-5 (Static) Part 3 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Perpetual FIFO: Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 $ Number of units 5,000 9.00 6,000 10.00 17,000 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold-January 5 Number of units sold Cost per unit $ 8.00 9.00 10.00 Cost of Goods Sold Cost of Goods Sold-January 12 Number of units sold Cost per unit $ 8.00 9,00 10.00 Cost of Goods Sold 0 0 Cost of Goods Sold-January 20 Number of units sold Cost per 5 8.00 9.00 10.00 Cost of Goods Sold O 1 ok mt 0 ences Problem 8-5 (Static) Part 4 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Cost of Goods Average Cost per Unit Average Cost Beginning Inventory Purchases: January 10 January 18 Total Number Unit of units Cost Available for Sale 6,000 $8.00 $ 48,000 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Number of units sold Cost of Goods Sold Number of units in ending inventory Ending Inventory-Average Cost Average Cost per unit Ending Inventory S Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Perpetual Average Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase-January 18 Subtotal Average Cost Sale January 20 Total Inventory on hand Number Cost per of units unit Inventory Value Number of units sold Cost of Goods Sold Average Cost per unit Cost of Goods Sold A company began January with 6,000 units of its principal product. The cost of each nit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Sales Units Date of Sale January 5 January 12 January 20 Total 5,000 6,000 11,000 * Includes purchase price and cost of freight. Purchases Unit Cost $9 10 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $ 105,000 Dok Int ences Problem 8-5 (Static) Part 1 Required: 1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. FIFO Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale $ 48,000 Number Cost per of units unit 6,000 $8.00 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic FIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic FIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory Problem 8-5 (Static) Part 2 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. LIFO Beginning Inventory Purchases: January 10 January 18- Total Cost of Goods Available for Sale Cost of Goods Available for Sale 6,000 $8.00 S 48,000 Number Cost per of units unit 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic LIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic LIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory I ces Problem 8-5 (Static) Part 3 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Perpetual FIFO: Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 $ Number of units 5,000 9.00 6,000 10.00 17,000 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold-January 5 Number of units sold Cost per unit $ 8.00 9.00 10.00 Cost of Goods Sold Cost of Goods Sold-January 12 Number of units sold Cost per unit $ 8.00 9,00 10.00 Cost of Goods Sold 0 0 Cost of Goods Sold-January 20 Number of units sold Cost per 5 8.00 9.00 10.00 Cost of Goods Sold O 1 ok mt 0 ences Problem 8-5 (Static) Part 4 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Cost of Goods Average Cost per Unit Average Cost Beginning Inventory Purchases: January 10 January 18 Total Number Unit of units Cost Available for Sale 6,000 $8.00 $ 48,000 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Number of units sold Cost of Goods Sold Number of units in ending inventory Ending Inventory-Average Cost Average Cost per unit Ending Inventory S Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Perpetual Average Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase-January 18 Subtotal Average Cost Sale January 20 Total Inventory on hand Number Cost per of units unit Inventory Value Number of units sold Cost of Goods Sold Average Cost per unit Cost of Goods Sold A company began January with 6,000 units of its principal product. The cost of each nit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Sales Units Date of Sale January 5 January 12 January 20 Total 5,000 6,000 11,000 * Includes purchase price and cost of freight. Purchases Unit Cost $9 10 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $ 105,000 Dok Int ences Problem 8-5 (Static) Part 1 Required: 1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. FIFO Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale $ 48,000 Number Cost per of units unit 6,000 $8.00 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic FIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic FIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory Problem 8-5 (Static) Part 2 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. LIFO Beginning Inventory Purchases: January 10 January 18- Total Cost of Goods Available for Sale Cost of Goods Available for Sale 6,000 $8.00 S 48,000 Number Cost per of units unit 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic LIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic LIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory I ces Problem 8-5 (Static) Part 3 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Perpetual FIFO: Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 $ Number of units 5,000 9.00 6,000 10.00 17,000 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold-January 5 Number of units sold Cost per unit $ 8.00 9.00 10.00 Cost of Goods Sold Cost of Goods Sold-January 12 Number of units sold Cost per unit $ 8.00 9,00 10.00 Cost of Goods Sold 0 0 Cost of Goods Sold-January 20 Number of units sold Cost per 5 8.00 9.00 10.00 Cost of Goods Sold O 1 ok mt 0 ences Problem 8-5 (Static) Part 4 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Cost of Goods Average Cost per Unit Average Cost Beginning Inventory Purchases: January 10 January 18 Total Number Unit of units Cost Available for Sale 6,000 $8.00 $ 48,000 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Number of units sold Cost of Goods Sold Number of units in ending inventory Ending Inventory-Average Cost Average Cost per unit Ending Inventory S Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Perpetual Average Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase-January 18 Subtotal Average Cost Sale January 20 Total Inventory on hand Number Cost per of units unit Inventory Value Number of units sold Cost of Goods Sold Average Cost per unit Cost of Goods Sold A company began January with 6,000 units of its principal product. The cost of each nit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Sales Units Date of Sale January 5 January 12 January 20 Total 5,000 6,000 11,000 * Includes purchase price and cost of freight. Purchases Unit Cost $9 10 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $ 105,000 Dok Int ences Problem 8-5 (Static) Part 1 Required: 1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. FIFO Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale $ 48,000 Number Cost per of units unit 6,000 $8.00 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic FIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic FIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory Problem 8-5 (Static) Part 2 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. LIFO Beginning Inventory Purchases: January 10 January 18- Total Cost of Goods Available for Sale Cost of Goods Available for Sale 6,000 $8.00 S 48,000 Number Cost per of units unit 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic LIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic LIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory I ces Problem 8-5 (Static) Part 3 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Perpetual FIFO: Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 $ Number of units 5,000 9.00 6,000 10.00 17,000 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold-January 5 Number of units sold Cost per unit $ 8.00 9.00 10.00 Cost of Goods Sold Cost of Goods Sold-January 12 Number of units sold Cost per unit $ 8.00 9,00 10.00 Cost of Goods Sold 0 0 Cost of Goods Sold-January 20 Number of units sold Cost per 5 8.00 9.00 10.00 Cost of Goods Sold O 1 ok mt 0 ences Problem 8-5 (Static) Part 4 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Cost of Goods Average Cost per Unit Average Cost Beginning Inventory Purchases: January 10 January 18 Total Number Unit of units Cost Available for Sale 6,000 $8.00 $ 48,000 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Number of units sold Cost of Goods Sold Number of units in ending inventory Ending Inventory-Average Cost Average Cost per unit Ending Inventory S Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Perpetual Average Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase-January 18 Subtotal Average Cost Sale January 20 Total Inventory on hand Number Cost per of units unit Inventory Value Number of units sold Cost of Goods Sold Average Cost per unit Cost of Goods Sold A company began January with 6,000 units of its principal product. The cost of each nit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Sales Units Date of Sale January 5 January 12 January 20 Total 5,000 6,000 11,000 * Includes purchase price and cost of freight. Purchases Unit Cost $9 10 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $ 105,000 Dok Int ences Problem 8-5 (Static) Part 1 Required: 1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. FIFO Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale $ 48,000 Number Cost per of units unit 6,000 $8.00 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic FIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic FIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory Problem 8-5 (Static) Part 2 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. LIFO Beginning Inventory Purchases: January 10 January 18- Total Cost of Goods Available for Sale Cost of Goods Available for Sale 6,000 $8.00 S 48,000 Number Cost per of units unit 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic LIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic LIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory I ces Problem 8-5 (Static) Part 3 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Perpetual FIFO: Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 $ Number of units 5,000 9.00 6,000 10.00 17,000 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold-January 5 Number of units sold Cost per unit $ 8.00 9.00 10.00 Cost of Goods Sold Cost of Goods Sold-January 12 Number of units sold Cost per unit $ 8.00 9,00 10.00 Cost of Goods Sold 0 0 Cost of Goods Sold-January 20 Number of units sold Cost per 5 8.00 9.00 10.00 Cost of Goods Sold O 1 ok mt 0 ences Problem 8-5 (Static) Part 4 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Cost of Goods Average Cost per Unit Average Cost Beginning Inventory Purchases: January 10 January 18 Total Number Unit of units Cost Available for Sale 6,000 $8.00 $ 48,000 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Number of units sold Cost of Goods Sold Number of units in ending inventory Ending Inventory-Average Cost Average Cost per unit Ending Inventory S Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Perpetual Average Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase-January 18 Subtotal Average Cost Sale January 20 Total Inventory on hand Number Cost per of units unit Inventory Value Number of units sold Cost of Goods Sold Average Cost per unit Cost of Goods Sold A company began January with 6,000 units of its principal product. The cost of each nit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Sales Units Date of Sale January 5 January 12 January 20 Total 5,000 6,000 11,000 * Includes purchase price and cost of freight. Purchases Unit Cost $9 10 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $ 105,000 Dok Int ences Problem 8-5 (Static) Part 1 Required: 1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. FIFO Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale $ 48,000 Number Cost per of units unit 6,000 $8.00 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic FIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic FIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory Problem 8-5 (Static) Part 2 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. LIFO Beginning Inventory Purchases: January 10 January 18- Total Cost of Goods Available for Sale Cost of Goods Available for Sale 6,000 $8.00 S 48,000 Number Cost per of units unit 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic LIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic LIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory I ces Problem 8-5 (Static) Part 3 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Perpetual FIFO: Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 $ Number of units 5,000 9.00 6,000 10.00 17,000 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold-January 5 Number of units sold Cost per unit $ 8.00 9.00 10.00 Cost of Goods Sold Cost of Goods Sold-January 12 Number of units sold Cost per unit $ 8.00 9,00 10.00 Cost of Goods Sold 0 0 Cost of Goods Sold-January 20 Number of units sold Cost per 5 8.00 9.00 10.00 Cost of Goods Sold O 1 ok mt 0 ences Problem 8-5 (Static) Part 4 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Cost of Goods Average Cost per Unit Average Cost Beginning Inventory Purchases: January 10 January 18 Total Number Unit of units Cost Available for Sale 6,000 $8.00 $ 48,000 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Number of units sold Cost of Goods Sold Number of units in ending inventory Ending Inventory-Average Cost Average Cost per unit Ending Inventory S Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Perpetual Average Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase-January 18 Subtotal Average Cost Sale January 20 Total Inventory on hand Number Cost per of units unit Inventory Value Number of units sold Cost of Goods Sold Average Cost per unit Cost of Goods Sold A company began January with 6,000 units of its principal product. The cost of each nit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Sales Units Date of Sale January 5 January 12 January 20 Total 5,000 6,000 11,000 * Includes purchase price and cost of freight. Purchases Unit Cost $9 10 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $ 105,000 Dok Int ences Problem 8-5 (Static) Part 1 Required: 1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. FIFO Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale $ 48,000 Number Cost per of units unit 6,000 $8.00 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic FIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic FIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory Problem 8-5 (Static) Part 2 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. LIFO Beginning Inventory Purchases: January 10 January 18- Total Cost of Goods Available for Sale Cost of Goods Available for Sale 6,000 $8.00 S 48,000 Number Cost per of units unit 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic LIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic LIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory I ces Problem 8-5 (Static) Part 3 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Perpetual FIFO: Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 $ Number of units 5,000 9.00 6,000 10.00 17,000 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold-January 5 Number of units sold Cost per unit $ 8.00 9.00 10.00 Cost of Goods Sold Cost of Goods Sold-January 12 Number of units sold Cost per unit $ 8.00 9,00 10.00 Cost of Goods Sold 0 0 Cost of Goods Sold-January 20 Number of units sold Cost per 5 8.00 9.00 10.00 Cost of Goods Sold O 1 ok mt 0 ences Problem 8-5 (Static) Part 4 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Cost of Goods Average Cost per Unit Average Cost Beginning Inventory Purchases: January 10 January 18 Total Number Unit of units Cost Available for Sale 6,000 $8.00 $ 48,000 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Number of units sold Cost of Goods Sold Number of units in ending inventory Ending Inventory-Average Cost Average Cost per unit Ending Inventory S Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Perpetual Average Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase-January 18 Subtotal Average Cost Sale January 20 Total Inventory on hand Number Cost per of units unit Inventory Value Number of units sold Cost of Goods Sold Average Cost per unit Cost of Goods Sold A company began January with 6,000 units of its principal product. The cost of each nit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Sales Units Date of Sale January 5 January 12 January 20 Total 5,000 6,000 11,000 * Includes purchase price and cost of freight. Purchases Unit Cost $9 10 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. Total Cost $ 45,000 60,000 $ 105,000 Dok Int ences Problem 8-5 (Static) Part 1 Required: 1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. FIFO Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale $ 48,000 Number Cost per of units unit 6,000 $8.00 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic FIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic FIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory Problem 8-5 (Static) Part 2 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. LIFO Beginning Inventory Purchases: January 10 January 18- Total Cost of Goods Available for Sale Cost of Goods Available for Sale 6,000 $8.00 S 48,000 Number Cost per of units unit 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Cost of Goods Sold - Periodic LIFO Number of units sold Cost per unit $ $ $ 8.00 9.00 10.00 Cost of Goods Sold Ending Inventory - Periodic LIFO Number of units in ending inventory Cost per unit $ 8.00 $ 9.00 $ 10.00 Ending Inventory I ces Problem 8-5 (Static) Part 3 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Perpetual FIFO: Beginning Inventory Purchases: January 10 January 18 Total Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 $ Number of units 5,000 9.00 6,000 10.00 17,000 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold-January 5 Number of units sold Cost per unit $ 8.00 9.00 10.00 Cost of Goods Sold Cost of Goods Sold-January 12 Number of units sold Cost per unit $ 8.00 9,00 10.00 Cost of Goods Sold 0 0 Cost of Goods Sold-January 20 Number of units sold Cost per 5 8.00 9.00 10.00 Cost of Goods Sold O 1 ok mt 0 ences Problem 8-5 (Static) Part 4 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Cost of Goods Average Cost per Unit Average Cost Beginning Inventory Purchases: January 10 January 18 Total Number Unit of units Cost Available for Sale 6,000 $8.00 $ 48,000 5,000 $9.00 6,000 $10.00 17,000 45,000 60,000 $ 153,000 Number of units sold Cost of Goods Sold Number of units in ending inventory Ending Inventory-Average Cost Average Cost per unit Ending Inventory S Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Perpetual Average Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase-January 18 Subtotal Average Cost Sale January 20 Total Inventory on hand Number Cost per of units unit Inventory Value Number of units sold Cost of Goods Sold Average Cost per unit Cost of Goods Sold
Expert Answer:
Answer rating: 100% (QA)
To calculate the ending inventory and cost of goods sold for the month of January using different inventory costing methods we can follow the given in... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-1260481952
10th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas
Posted Date:
Students also viewed these accounting questions
-
Ferris Company began January with 6,000 units of its principal product. The cost of each unit is $8. Merchandise transactions for the month of January are as follows:
-
what is the diameter of the rivet if the length of the snap headrivet is 100 mm and the thickness is 50mm A. 43.64mm B.40.26mm C.53.76mm D.41.67mm
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study of Ritz Carlton Company USA and discuss why and how you would transfer some of their methods to the operation of a non-accommodation component in an integrated resort complex.
-
The information that follows is available from the general ledger and the bank statement of the Gentry Corporation for the month of August 2007: 1. Bank statement balance, August 31 $1,342.50 2. Note...
-
What is a magnetic reversal, and how are magnetic reversals recorded in rock?
-
What are units for \(C_{1}\) in Eq. (15.10)? Confirm that the units agree on both sides. F = 4 (15.10)
-
Starbucks is hoping to make use of its excess restaurant capacity in the evenings by experimenting with selling beer and wine. It speculates that the only additional costs are hiring more of the same...
-
The Belfast router will perform NAT. Configure the Belfast router as follows: Define the NAT pool. The pool consists of public network address 200.10.10.64/26. Exclude first 10 addresses from this...
-
Vessels A and B contain water under pressures of 276 kPa and 138 kPa, respectively. What is the deflection height of the mercury, h, in the differential manometer gauge in Figure 5?
-
Why is it necessary to study the diffusion of molecules in biological systems?
-
How do cultural practices and symbolic systems contribute to the construction of collective identities and the negotiation of power relations within heterogeneous societies?
-
The White House emphasizes federal-state-local cooperation in enforcing U.S. immigration laws and takes a step to enhance the homeland security mission space by integrating certain public safety...
-
You are a chief of a large city agency. Your department is working with the Federal government through the Secure Communities program. Your city has been declared a sanctuary city and has developed a...
-
You'll be arguing against this new energy bar. How do you find your supporting evidence for your argument? A. Visit online medical journals with studies related to energy supplements and the...
-
A corporation has a stock option plan it awards to its executives. On January 1, Year 6, the board of directors granted 20,000 stock options, each of which permits the purchase of one share of stock...
-
MetLife expects to receive $150,000 at the end of each month, for the next 30 years. The nominal interest rate is 4.25%. (a) use the Annuity Discount Formula to compute the present value of these...
-
Data on weekday exercise time for 20 females, consistent with summary quantities given in the paper An Ecological Momentary Assessment of the Physical Activity and Sedentary Behaviour Patterns of...
-
At January 1, 2021, Brant Cargo acquired equipment by issuing a five-year, $150,000 (payable at maturity), 4% note. The market rate of interest for notes of similar risk is 10%. Required: 1. Prepare...
-
Data analytics is the process of examining data sets in order to draw conclusions about the information they contain. If you have not completed any of the prior data analytics cases, follow the...
-
The following relate to an operating lease agreement: a. The lease term is 3 years, beginning January 1, 2021. b. The leased asset cost the lessor $800,000 and had a useful life of eight years with...
-
Prove that \(B(x ; n, p)=1-B(n-x-1 ; n, 1-p)\).
-
Prove that \(b(x ; n, p)=b(n-x ; n, 1-p)\).
-
With reference to Exercise 4.5, find an expression for the distribution function \(F(x)\) of the random variable. Data From Exercise 4.5 k 4.5 Given that f(x): = is a probability distribution for 2x...
Study smarter with the SolutionInn App