Basic
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| B-8.01 | excel | Inventory categories, shipping, and costs to include in inventory | ||
| B-8.02 | excel | Consigned inventory | ||
| B-8.03 | excel | Basic inventory cost flow concepts | ||
| B-8.04 | excel | Basic “periodic” calculations for inventory, FIFO, LIFO, average cost | ||
| B-8.05 | excel | Basic “perpetual” calculations for inventory, FIFO, LIFO, average cost | ||
| B-8.06 | excel | Inventory journal entries – periodic and perpetual | ||
| B-8.07 | excel | Specific identification method | ||
| B-8.08 | excel | Lower of cost or net realizable value | ||
| B-8.09 | excel | Gross profit estimation technique | ||
| B-8.10 | excel | Retail inventory techniques | ||
| B-8.11 | excel | Inventory ratio analysis | ||
| B-8.12 | excel | Inventory errors |
Involved
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| I-8.01 | excel | Inventory accounting concepts | ||
| I-8.02 | excel | Periodic inventory – application of methods | ||
| I-8.03 | excel | Perpetual inventory – application of methods | ||
| I-8.04 | excel | Team-based study of inventory methods and analysis | ||
| I-8.05 | excel | Inventory estimates, errors, and adjustments |
Self-Grading
| Problem | Description | |
|---|---|---|
| 1 | excel | Self-Grading Problem |
MyExceLab
| 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.