# Problem Worksheet Combined Description
B-8.01 pdf pdf excel Inventory categories, shipping, and costs to include in inventory
B-8.02 pdf pdf excel Consigned inventory
B-8.03 pdf pdf excel Basic inventory cost flow concepts
B-8.04 pdf pdf excel Basic “periodic” calculations for inventory, FIFO, LIFO, average cost
B-8.05 pdf pdf excel Basic “perpetual” calculations for inventory, FIFO, LIFO, average cost
B-8.06 pdf pdf excel Inventory journal entries – periodic and perpetual
B-8.07 pdf pdf excel Specific identification method
B-8.08 pdf pdf excel Lower of cost or net realizable value
B-8.09 pdf pdf excel Gross profit estimation technique
B-8.10 pdf pdf excel Retail inventory techniques
B-8.11 pdf pdf excel Inventory ratio analysis
B-8.12 pdf pdf excel Inventory errors



# Problem Worksheet Combined Description
I-8.01 pdf pdf excel Inventory accounting concepts
I-8.02 pdf pdf excel Periodic inventory – application of methods
I-8.03 pdf pdf excel Perpetual inventory – application of methods
I-8.04 pdf pdf excel Team-based study of inventory methods and analysis
I-8.05 pdf pdf excel Inventory estimates, errors, and adjustments



  Problem Description
1 excel Self-Grading Problem



Description Problem                              
Items to Include in Inventory excel                              
Periodic Inventory Costing Methods excel                              
Perpetual FIFO excel                              
Perpetual LIFO excel                              
Moving Average excel                              
Gross Profit Method excel                              
Retail Method excel                              
Inventory Turnover Ratio excel                              


The preceding table includes links to “Basic” and “Involved” problems. Each excel link will download the file containing a spreadsheet for the problem and a template worksheet on which you can prepare the solution electronically. If you see a light bulb icon on a worksheet, just mouse over above the icon and a comment box will appear. The comments include useful suggestions for improving your spreadsheet skills.

You may not post or redistribute, electronically or otherwise, any solution material. Violation of this policy constitutes a copyright violation.

Alternative problems, with solutions, may be found at our partner website Bookboon. Video solutions to selected problems are available to students enrolling in the online course. The pdf version of the solutions manual also includes links to the video solutions. You can purchase the solutions manual in the bookstore.