Chapter 2
Problems 1-26
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 6
Problems 1-78
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 3
Problems 1-30
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 4
Problems 1-33
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 5
Problems 1-20
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 7
Problems 1-35
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 8
Problems 1-24
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 9
Problems 1-28
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 10
Problems 1-36
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 12
Problems 1-24
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 11
Problems 1-32
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 13
Problems 1-28
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 15
Problems 1-15
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
Chapter 16
Problems 1-22
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
Chapter 19
Problems 1-12, Appendix 1-10
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be install
Chapter 17
Problems 1-16
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
Chapter 20
Question 16
Input Area:
Sales
Cost per unit
Probablity of default
Initial charge to subscribe
Cost of each credit report
500
$490
4%
$450
$5.00
Output Area:
Cost of subscription
Savings from credit reports
$2,950.00
$9,800.00
Net savings
$6,850
Chapter 18
Problems 1-18
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
Chapter 24
Problems 1-22
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
Chapter 25
Problems 1-30
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
Chapter 21
Problems 1-18
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
Chapter 23
Problems 1-8
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
Chapter 27
Problems 1-12
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
CHAPTER 14
COST ALLOCATION, CUSTOMER-PROFITABILITY
ANALYSIS, AND SALES-VARIANCE ANALYSIS
TRUE/FALSE
1.
Indirect costs are costs that cannot be traced to cost objects in an economically
feasible way.
Answer:
Terms to Learn:
2.
1
Objective:
1
To motivate en
CHAPTER 6 MASTER BUDGET AND RESPONSIBILITY ACCOUNTING
TRUE/FALSE 1. Few businesses plan to fail, but many of those that dont succeed have failed to plan. Answer: True Difficulty: Terms to Learn: master budget 2. 1 Objective: 1
The master budget reflects t
CHAPTER 8
FLEXIBLE BUDGETS, OVERHEAD COSTS,
VARIANCES, AND MANAGEMENT CONTROL
TRUE/FALSE
1.
Overhead costs are a major part of costs for most companies more than 50% of
all costs for some companies.
Answer:
Terms to Learn:
2.
True
Difficulty:
total-overhe