Filimonov Inc. has the following information related to purchases and sales of one of its inventory items: Date Description Units Purchased at Cost Units Sold at Retail June 1 Beginning inventory 180 units e $10 - $1,800 Purchase 1 200 units e $14 - $2,800 14 Sale 1 290 units o $25 22 Purchase 2 250 units o $17 - 54,250 29 Sale 2 225 units e s25 Refer to the information for Filmonov Inc. and assume that the company uses a perpetual inventory system. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet; perform the required analysis, and input your answers in the question below. Open spreadsheet Required: Calculate the cost of goods sold and the cost of ending inventory using the LIFO inventory costing method. Cost of goods sold 6,540 X Cost of ending inventory

Filimonov Inc. has the following information related to purchases and sales of one of its inventory items: Date Description Units Purchased at Cost Units Sold at Retail June 1 Beginning inventory 180 units e $10 - $1,800 Purchase 1 200 units e $14 - $2,800 14 Sale 1 290 units o $25 22 Purchase 2 250 units o $17 - 54,250 29 Sale 2 225 units e s25 Refer to the information for Filmonov Inc. and assume that the company uses a perpetual inventory system. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet; perform the required analysis, and input your answers in the question below. Open spreadsheet Required: Calculate the cost of goods sold and the cost of ending inventory using the LIFO inventory costing method. Cost of goods sold 6,540 X Cost of ending inventory

Name: Costing: LIFOFilimonov Inc. has the following information related to
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Costing: LIFOFilimonov Inc. has the following information related to purchases and sales of one of its inventory items:DateDescriptionUnits Purchased at CostUnits Sold at Retail180 units e $10 - $1,800200 units e s14 - $2,800June 1Beginning inventor

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter6: Cost Of Goods Sold And Inventory

Section: Chapter Questions

Problem 50E: Inventory Costing Methods Crandall Distributors uses a perpetual inventory system and has the...

See similar textbooks

Similar questions

Calculate the cost of goods sold dollar value for B74 Company for the sale on November 20, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average (AVG).
Inventory Costing Methods On June 1, Welding Products Company had a beginning inventory of 210 cases of welding rods that had been purchased for S88 per case. Welding Products purchased 1,150 cases at a cost of $95 per case on June 3. On June 19, the company purchased another 950 cases at a cost of $112 per case. Sales data for the welding rods are: Welding Products uses a perpetual inventory system, and the sales price of the welding rods was $130 per case. Required: 1. Compute the cost of ending inventory and cost of goods sold using the FIFO method. 2. Compute the cost of ending inventory and cost of goods sold using the LIFO method. 3. Compute the cost of ending inventory and cost of goods sold using the average cost method. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.) 4. CONCEPTUAL CONNECTION Assume that operating expenses are $21,600 and Welding Products has a 30% tax rate. How much will the cash paid for income taxes differ among the three inventory methods? 5. CONCEPTUAL CONNECTION Compute Welding Products' gross profit ratio (rounded to two decimal places) and inventory turnover ratio (rounded to three decimal places) under each of the three inventory costing methods. How would the choice of inventory costing method affect these ratios?
Calculate the cost of goods sold dollar value for A74 Company for the sale on March 11, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average (AVG).
Inventory Costing Methods Crandall Distributors uses a perpetual inventory system and has the following data available for inventory, purchases, and sales for a recent year. Required: 1. Compute the cost of ending inventory and the cost of goods sold using the specific identification method. Assume the ending inventory is made up of 40 units from beginning inventory, 30 units from Purchase 1, 80 units from Purchase 2, and 40 units from Purchase 3. 2. Compute the cost of ending inventory and cost of goods sold using the FIFO inventory costing method. 3. Compute the cost of ending inventory and cost of goods sold using the LIFO inventory costing method. 4. Compute the cost of ending inventory and cost of goods sold using the average cost inventory costing method. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.) 5. CONCEPTUAL CONNECTION Compare the ending inventory and cost of goods sold computed under all four methods. What can you conclude about the effects of the inventory costing methods on the balance sheet and the income statement?
Inventory Costing Methods VanderMeer Inc. reported the following information for the month of February: During February, VanderMeer sold 140 units. The company uses a periodic inventory system. Required What is the value of ending inventory and cost of goods sold for February under the following assumptions: Of the 140 units sold, 55 cost $20, 35 cost $22, 45 cost $23, and 5 cost $24. FIFO LIFO Weighted average
On January 1 of Year 1, Dorso Company adopted the dollar-value LIFO method of inventory costing. Dorsos December 31 ending inventory records are as follows: Year 1: Current cost, 20,000; Index, 100 Year 2: Current cost, 33,600; Index, 120 Using the dollar-value LIFO method, compute Dorsos December 31 ending inventory for Year 2.
Calculate the cost of goods sold dollar value for B67 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for weighted average (AVG).
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).
Use the following information to compute cost of goods sold under the FIFO and LIFO inventory methods. The firm sold 200 units.
Inventory Costing Methods Andersons Department Store has the following data for inventory, purchases, and sales of merchandise for December. Andersons uses a perpetual inventory system. All purchases and sales were for cash. Required: 1. Compute cost of goods sold and the cost of ending inventory using FIFO. 2. Compute cost of goods sold and the cost of ending inventory using LIFO. 3. Compute cost of goods sold and the cost of ending inventory using the average cost method. ( Note: Use four decimal places for per-unit calculations.) 4. Prepare the journal entries to record these transactions assuming Anderson chooses to use the FIFO method. 5. CONCEPTUAL CONNECTION Which method would result in the lowest amount paid for taxes?
Inventory Write-Down Stiles Corporation uses the FIFO cost flow assumption and is in the process of applying the LCNRV rule for each of two products in its ending inventory. A profit margin of 30% on the selling price is considered normal for each product. Specific data for each product are as follows: Inventory Write-Down Use the information in E8-1. Assume that Stiles uses the LIFO cost flow assumption and is applying the LCM rule. Required: 1. What is the correct inventory value for each product? 2. Next Level With regard to requirement 1, what effect does the imposition of the constraints on market value have on the inventory valuations?
Kulsrud Company would like to estimate the current inventory level. Using the gross profit method and the following information, estimate the current inventory level for Kulsrud Company. Goods available for sale 100,000 Net sales 150,000 Normal gross profit as a percent of sales 40%