Question
On January 1, 2010, ABC Co. had inventory of 200 units @ 18.00 a unit. It purchased 400 more units @ $20.00 a piece on
On January 1, 2010, ABC Co. had inventory of 200 units @ 18.00 a unit. It purchased 400 more units @ $20.00 a piece on Feb. 19th. On May 12th, it bought 300 more units @ $22.00 each. On Oct. 3rd, it bought an additional 100 units for $24.00 a unit. On Dec. 31st, an inventory count showed only 206 units that had not been sold. Prepare an Excel worksheet that shows the Ending Inventory Balance and the Cost of Goods Sold for the year using each of the three inventory valuation methods, LIFO, FIFO, and Average Cost. You will be graded on how well your worksheet data flows. For example, if I open your worksheet and change the ending inventory number, then I expect your worksheet to also change based on the new information. Be sure to link as many cells as possible and use formulas for every calculation.
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