Celine Company provided the following data relating to an inventory item. Total cost 1,000,000 1,250,000 Units Unit cost Beginning balance 10 Purchase 15 Sale 16 Sale return 30 Purchase 31 Purchase return 5,000 5,000 7,000 1,000 16,000 2,000 200 250 Jan. 1 2,400,000 300,000 150 150 1. Under the perpetual system, what is the moving average unit cost on January 31? 2. What is the FIFO. 3. What is the Weighted Average Periodic.

Celine Company provided the following data relating to an inventory item. Total cost 1,000,000 1,250,000 Units Unit cost Beginning balance 10 Purchase 15 Sale 16 Sale return 30 Purchase 31 Purchase return 5,000 5,000 7,000 1,000 16,000 2,000 200 250 Jan. 1 2,400,000 300,000 150 150 1. Under the perpetual system, what is the moving average unit cost on January 31? 2. What is the FIFO. 3. What is the Weighted Average Periodic.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

he following data are available for Sellco for the fiscal year ended on January 31, 2020: Sales 1,600 units Beginning inventory 500 units @ $ 4 Purchases, in chronological order 600 units @ $ 5 800 units @ $ 6 500 units @ $ 8 Required:a. Calculate cost of goods sold and ending inventory under the cost flow assumptions, FIFO, LIFO and weighted average (using a periodic inventory system): (Round unit cost to 2 decimal places.) b. Assume that net income using the weighted-average cost flow assumption is $80,000. Calculate net income under FIFO and LIFO. (Round unit cost to 2 decimal places.)
Phillips Company had the following information for the year ending December 31: Units Unit Cost Beginning inventory 320 $36 Purchase: April 6 580 39 Sale: May 4 450 Purchase: July 19 400 40 Sale: September 9 500 Purchase: October 10 230 44 Phillips uses the perpetual inventory system and the LIFO method. Required: Using LIFO (a) Compute the cost of ending inventory. (b) Compute the cost of goods sold for the year. Cost of ending inventory Cost of goods sold
Akira Company had the following transactions for the month. Number of units Cost per Unit Beginning inventory 150 $ 10 Purchased Mar. 31 160 12 Purchased Oct. 15 130 15 Ending inventory 50 ? Calculate the ending inventory dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. first-in, first-out (FIFO) last-in, first-out (LIFO) weighted average (AVG)
The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 4,000 units at $40 Apr. 19 Sale 2,500 units June 30 Purchase 4,500 units at $44 Sept. 2 Sale 5,000 units Nov. 15 Purchase 2,000 units at $46 The firm uses the weighted average cost method with a perpetual inventory system. Deteremine the cost of goods sold for each sale and the inventory balance after each sale. Present the data in the form illustrated in Exhibit 5.
Wildhorse Company uses a periodic inventory system and reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 130 $4 $520 12 Purchase 520 6 3,120 23 Purchase 325 8 2,600 30 Inventory 305 (a) Compute the cost of the ending inventory and the cost of goods sold under (1) FIFO, (2) LIFO, and (3) average-cost. (For calculation purposes, round average cost per unit to 2 decimal places, e.g. 5.25. Round answers to O decimal places, eg. 125.) FIFO Cost of the ending inventory $ Cost of goods sold $ $ $ LIFO Average-Cost $ $
Sandhill Company uses a perpetual inventory system and reports the following for the month of June. Date June 1 (a1) 12 23 30 June 1 June 12 June 15 Explanation Units Inventory June 23 Purchase Purchase Inventory $ $ $ LA 120 380 210 265 Unit Cost Calculate the weighted-average cost per unit, using a perpetual inventory system. Assume a sale of 400 units occurred on June 15 for a selling price of $8 and a sale of 45 units on June 27 for $9. (Round intermediate calculations to O decimal places, e.g. 152 and final answers to 3 decimal places, e.g. 5.125.) $5 6 7 Total Cost $600 2,280 1,470
Kingbird, Inc. uses a periodic inventory system and reports the following for the month of June. Date June 1 12 23 30 (a) Explanation Units Inventory Purchase Purchase Inventory 130 330 Cost of goods sold 200 203 Cost of the ending inventory Unit Cost $ $5 6 7 Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round per unit cost to 3 decimal places, e.g. 15.647 and final answers to 0 decimal places, e.g. 5,125.) Total Cost FIFO $650 1,980 1,400 LA LIFO LA LA Average-cost
You have the following information for Tamarisk, Inc. for the month ended October 31, 2022. Tamarisk uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 60 24 Oct. 9 Purchase 115 26 Oct. 11 Sale 95 45 Oct. 17 Purchase 95 27 Oct. 22 Sale 60 50 Oct. 25 Purchase 70 29 Oct. 29 Sale 105 50 A(3) Calculate gross profit rate under each of the following: 1.LIFO 2.FIFO 3. Average-cost. Gross profit rate - LIFO% - FIFO% AND AVERAGE-COST %
The following units of a particular item were available for sale during the calendar year: Jan. 1 Apr. 19 Inventory Sale 4,000 units at $50 2,500 units June 30 Purchase 4,500 units at $54 Sept. 2 Sale 5,000 units Purchase 2,000 units at $56 Nov. 15 The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale. Present the data in the form illustrated in Exhibit 5. Date Purchases Quantity Purchases Unit Cost Purchases Total Cost Quantity Weighted Average Cost Flow Method Cost of Goods Sold Cost of Goods Sold Unit Cost Cost of Goods Sold Total Cost Jan. 1 Apr. 19 June 30 Sept. 2 Nov. 15 ☐ ☐ ☐ ☐ ☐ ☐ Dec. 31 Balances
The following are the transactions for the month of July. Units Unit Cost Unit Selling Price July 1 Beginning Inventory 55 $ 10 July 13 Purchase 275 11 July 25 Sold (100 ) $ 14 July 31 Ending Inventory 230 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under FIFO. Assume a periodic inventory system is used. How would i creat a FIFO periodic table?
ossom Company uses a perpetual inventory system and reports the following for the month of June. Date une 1 12 23 30 Explanation Units Unit Cost Inventory $5 Purchase Purchase Inventory June 1 June 12 June 15 June 23 June 27 $ $ 112 Calculate the weighted-average cost per unit, using a perpetual inventory system. Assume a sale of 388 units occurred on June 15 for a selling price of $8 and a sale of 50 units on June 27 for $9. (Round intermediate calculations to 0 decimal places, e.g. 152 and final answers to 3 decimal places, e.g. 5.125.) $ 336 190 200 6 Total Cost $560 2,016 1,330
Calculate the cost of goods sold dollar value for A65 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO). Number of units Unit cost Sales Beginning inventory 800 $ 50 purchased 600 52 Sold 400 $ 80 Sold 350 90 Ending inventory 650 Use this chart: FIFO (perpetual) Inventory Cost of Goods Purchased Cost of Goods Sold Cost of Inventory Remaining Number of Units Unit Cost Total Cost Number of Units Unit Cost Total Cost Number of Units Unit Cost Total Cost Beginning Purchase Sale…