Problems: Chapter Twenty-One

Budgeting and Decision Making  Problem Workbook

 
 
Obtain the entire Budgeting/Decision Making Workbook via the linked image at left. Our high volume production process makes this an economical option as compared to printing these files on your own printer!

 

       
               
Basic
 
Problem
Worksheet
Combined
  Objective
               
  B-21.01   pdf link
pdf link
Excel link
  Understanding key terminology relating to budgets
               
  B-21.02  
pdf link
pdf link
Excel link
  Scheduling anticipated cash collections
               
  B-21.03  
pdf link
pdf link
Excel with light bulb icon
  Planning for production
               
  B-21.04  
pdf link
pdf link
Excel link
  Planning for materials purchases
               
  B-21.05  
pdf link
pdf link
Excel link
  Scheduling anticipated cash payments
               
  B-21.06  
pdf link
pdf link
Excel link
  Direct labor and factory overhead budgeting
               
  B-21.07  
pdf link
pdf link
Excel link
  Budgeting of finished goods
               
  B-21.08  
pdf link
pdf link
Excel link
  Budgeting for SG&A and volume fluctuation
     
   
  B-21.09  
pdf link
pdf link
Excel link
  Cash budgeting and decision making
               
               
               
Involved
 
Problem
Worksheet
Combined
  Objective
               
  I-21.01  
pdf link
pdf link
Excel link
  In-depth cash budgeting
               
  I-21.02  
pdf link
pdf link
Excel link
  Comprehensive budget
               
  I-21.03  
pdf link
pdf link
Excel link
  Team-based approach to budgeting
               
  I-21.04  
pdf link
pdf link
Excel link
  Budget decisions and financial statement results

 

The preceding table includes links to "Basic" and "Involved" problems. Each Excel icon 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.

Solutions to these problems may be obtained from your instructor, however you may not post or redistribute, electronically or otherwise, any such solution material. Solution material may be provided to you for your sole use only, at the discretion of your individual instructor. Violation of this policy constitutes a copyright violation. Alternative problems, with solutions, may be found under the "Exercises" tab within each chapter. Video solutions to selected problems are available to students enrolling in the online course.