Problems – Chapter 21



# Problem Worksheet Combined Description
B-21.01 pdf pdf excel Understanding key terminology relating to budgets
B-21.02 pdf pdf excel Scheduling anticipated cash collections
B-21.03 pdf pdf excel Planning for production
B-21.04 pdf pdf excel Planning for materials purchases
B-21.05 pdf pdf excel Scheduling anticipated cash payments
B-21.06 pdf pdf excel Direct labor and factory overhead budgeting
B-21.07 pdf pdf excel Budgeting of finished goods
B-21.08 pdf pdf excel Budgeting for SG&A and volume fluctuation
B-21.09 pdf pdf excel Cash budgeting and decision making



# Problem Worksheet Combined Description
I-21.01 pdf pdf excel In-depth cash budgeting
I-21.02 pdf pdf excel Comprehensive budget
I-21.03 pdf pdf excel Team-based approach to budgeting
I-21.04 pdf pdf excel Budget decisions and financial statement results



Description Problem                              
Budget Characteristics excel                              
Budget Processes excel                              
Budget Components excel                              
Sales Budget excel                              
Materials Budget excel                              
Labor and Overhead Budget excel                              
Cash Budget excel                              
Budget Periods 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.