Answered step by step
Verified Expert Solution
Question
1 Approved Answer
43 Use cells A2 to M12 from the given information to complete this question.) 44 45 46 47 Cost of Goods Available for Sale .
43 Use cells A2 to M12 from the given information to complete this question.) 44 45 46 47 Cost of Goods Available for Sale . # of units 185 Cost per unit $11.00 100 270 555 $10.00 $9.50 48 eginning inventory 49 urchases: 50 Jan. 20 51 Jan. 30 52 otal 53 54 Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. 55 56 Use cells A2 to M12 from the given information to complete this question.) 57 58 59 Periodic FIFO Cost of Goods Available # of units for Sale sota $2,035 1,000 2,565 $5,600 Cost of Goods Available for Sale 185 Cost of Goods Sold 95 5 285 Cost per unit * ####### $9.50 Periodic LIFO Cost of Goods Sold 2,035.00 950.00 47.50 Cost of Goods Sold # of units in ending inventory 0 5 265 270 Ending Inventory Cost per unit $11.00 $10.00 $9.50 Ending Inventory 0 Ending Inventon 50.00 2,517.50 ########## 0 (-) Leg x ( nee WOI Ise cells A2 to M12 from the given information to complete this question.) Determine the cost assigned to ending inventory and to cost of goods soid us Use cells A2 to M12 from the given information to complete this question.) IE Exercise 5-3 (Algo): Periodic: Inventory costing methods LO P1 Laker Company reported the following January purchases and sales data for its only product. The Company uses a periodic inventory system. For specific identification, ending inventory consists of 285 units, where 270 are from the January 30 purchase, 5 are from the January 20 purchase, and 10 are from beginning inventory. Required: 1. Determine the cost assigned to ending inventory and to cost of goods sold using specific identification. 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. 3. Determine the cost assigned to ending inventory and to cost of goods sold using Fifo 4. Determine the cost assigned to ending inventary and to cost of poods sold using LifO Navigation: 1) Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect
43 Use cells A2 to M12 from the given information to complete this question.) 44 45 46 47 Cost of Goods Available for Sale . # of units 185 Cost per unit $11.00 100 270 555 $10.00 $9.50 48 eginning inventory 49 urchases: 50 Jan. 20 51 Jan. 30 52 otal 53 54 Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. 55 56 Use cells A2 to M12 from the given information to complete this question.) 57 58 59 Periodic FIFO Cost of Goods Available # of units for Sale sota $2,035 1,000 2,565 $5,600 Cost of Goods Available for Sale 185 Cost of Goods Sold 95 5 285 Cost per unit * ####### $9.50 Periodic LIFO Cost of Goods Sold 2,035.00 950.00 47.50 Cost of Goods Sold # of units in ending inventory 0 5 265 270 Ending Inventory Cost per unit $11.00 $10.00 $9.50 Ending Inventory 0 Ending Inventon 50.00 2,517.50 ########## 0 (-) Leg x ( nee WOI
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started