Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Complete the inventory costing schedules documenting details in the calculation of ending inventory and cost of goods sold for each of the THREE costing methods.
Complete the inventory costing schedules documenting details in the calculation of ending inventory and cost of goods sold for each of the THREE costing methods. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO and Weighted Average Cost methods. Make use of Excel/Sheets capabilities by using as many formulas and functions as possible. BBC2, Inc. uses a periodic inventory system and has the following information available: REQ. A MASTER INVENTORY RECORD Description (Shelves) # of Units Cost per unit Total cost Beginning inventory Jan 15 purchase 20 $ 20.00 25 $ 25.00 35 $ 33.00 Jan 20 purchase Total Inventory January Sales Ending Inventory 42 answer will be on each schedule below REOB INVENTORY COSTING SCHEDULES Link or reference back to the description, units and cost on the master reco Calculate the Ending Inventory and cost of Goods Sold using Periodic FIFO FIFO Ending Inventory # of Units Cost per unit Total cost Description Jan 15 purchase Jan 20 purchase Total FIFO Cost of Goods Sold # of Units Cost per unit Description Total cost Calculate the Ending Inventory and Cost of Goods Sold using Periodic LIFO LIFO Ending Inventory # of Units Cost per unit Description Total cost LIFO Cost of Goods Sold # of Units Cost per unit Description Total cost Calculate the Ending Inventory and cost of Goods Sold using Periodic LIFO Description LIFO Ending Inventory # of Units Cost per unit Total cost LIFO Cost of Goods Sold # of Units Cost per unit Description Total cost Calculate the Ending Inventory and cost of Goods Sold using Periodic Weighted Average WEIGHTED AVERAGE Ending Inventory WEIGHTED AVERAGE Cost of Goods Sold + Sheet1
Complete the inventory costing schedules documenting details in the calculation of ending inventory and cost of goods sold for each of the THREE costing methods.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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