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.
-
Why is evaluating training an important part of strategic training?
-
An economic downturn throws millions of people out of work. In some industries, workers who remain employed, or insiders, continue to develop their skills, enabling them to push wages above the level...
-
The composite bar consists of a 20-mm-diameter A-36 steel segment AB and 50-mm-diameter red brass C83400 end segments DA and CB. Determine the average normal stress in each segment due to the applied...
-
In December 2010, Gomez Companys manager estimated next years total direct labor cost assuming 50 persons working an average of 2,000 hours each at an average wage rate of $15 per hour. The manager...
-
5. [10 points] Consider the following graph: 2 5 3 6 a) Starting at vertex 1 and resolving ties by vertex d number, traverse the graph by depth- first search and construct the corresponding...
-
A stock is worth $10 today and will be worth either $14 or $8 two years from today. It pays no dividend. r=6%. Using a one-period binomial model. a. How many shares (and indicate whether you are long...
-
Write a Java program which takes as input the name of a file in the current directory. The first line of the file will contain an integer n, giving the number of posts along the river. The remaining...
-
Calculate the ROE using the DuPont analysis, which is return on equity is equal to the profit margin multiplied by asset turnover multiplied by financial leverage. Given information: Net Income =...
-
Chordall Authors Company circulates a monthly magazine, charging $36 to subscribers for a 12-month subscription. Subscribers are required to forward the entire $36 yearly subscription fee before...
-
2. In the following code, suppose that f is an instance of Foo. Answer Question 2. a. b. C. class Foo { d. } static int x; static int s; Which of the following statements is incorrect? f.smethod ();...
-
Austin (2018) states that beyond the dynamics of organizational and technological change, one of the greatest challenges facing social work managers is not the old adage of doing more with less, but...
-
Suppose that another portfolio, portfolio E, is well diversified with a beta of 6 and expected return of 8%. Would an arbitrage opportunity exist? If so, what would be the arbitrage strategy? Assume...
-
A group of network designers at the communications company CluNet find themselves facing the following problem. They have a connected graph G = (V. E), in which the nodes represent sites that want to...
-
Which of the following streaming TV devices does not involve use of a remote controller? A) Google Chromecast B) Apple TV C) Amazon Fire TV D) Roku
-
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...
-
For the system shown in Figure P1.10, the angular displacement of the thin disk is given by \(\theta(t)=0.03 \sin \left(30 t+\frac{\pi}{4} ight)\) rad. The disk rolls without slipping on the surface....
-
The helicopter of Figure P1.9 has a horizontal speed of \(110 \mathrm{ft} / \mathrm{s}\) and a horizontal acceleration of \(3.1 \mathrm{ft} / \mathrm{s}^{2}\). The main blades rotate at a constant...
-
Figure P1.14 shows a schematic diagram of a one-cylinder reciprocating onecylinder engine. If at the instant of time shown the piston has a velocity \(v\) and an acceleration \(a\), determine (a) the...
Study smarter with the SolutionInn App