Inventory Valuation - Perpetual Method
This assignment will provide you with some practice calculating Cost of Goods Sold, Ending Inventory, and Gross Profit using the First In First Out (FIFO), Last In First Out (LIFO), and Weighted Average Cost methods when a company uses the perpetual inventory approach. For practice sets using the periodic inventory approach, see the appropriate section. Be sure to follow the instructions, and use Excel formulas as requested in order to get full credit for this assignment.
Relevant Excel Functions
This assignment will require you to be able to use some or all of the following Excel functions. Click on the hyperlinked section number next to the relevant Excel skill to be directed to a page showing how to perform the assigned task in Excel:
Want to try our built-in assessments?
Use the Request Full Access button to gain access to this assessment.