Basic

# Problem Worksheet Combined Description
B-5.01 pdf pdf excel Sales, returns and allowances
B-5.02 pdf pdf excel Sales discounts
B-5.03 pdf pdf excel Purchase transactions, business papers, net vs. gross
B-5.04 pdf pdf excel Sales and freight cost
B-5.05 pdf pdf excel Purchases and freight cost
B-5.06 pdf pdf excel Calculating values for a merchandising income statement
B-5.07 pdf pdf excel Preparing a merchandising income statement
B-5.08 pdf pdf excel Closing entries
B-5.09 pdf pdf excel Perpetual inventory
B-5.10 pdf pdf excel Single-step and multiple-step income statements
B-5.11 pdf pdf excel Profit margin analysis
B-5.12 pdf pdf excel Control structure

 

Involved

# Problem Worksheet Combined Description
I-5.01 pdf pdf excel Comprehensive merchandising entries
I-5.02 pdf pdf excel Gross vs. net recording of purchases, entries and reporting
I-5.03 pdf pdf excel Merchandising income statement and closing
I-5.04 pdf pdf excel Perpetual inventory vs. periodic inventory
I-5.05 pdf pdf excel Single-step and multiple-step income statements, profit margins
I-5.06 pdf pdf excel Team-based study of controls

 

Self-Grading

  Problem Description
1 excel Self-Grading Problem

 

MyExceLab

Description Problem                              
Sales Terminology and Concepts excel                              
Gross v. Net Entries and Impact excel                              
Buyer and Seller Entries excel                              
Calculating Cost of Goods Sold excel                              
Detailed Income Statement excel                              
Closing Accounts with Debits and Credits excel                              
Comparing Periodic and Perpetual Systems excel                              
Analysis of Profit Margins excel                              
Control Strengths and Weaknesses 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.