logo image

BUS 150 Part 2

At the break-even point, revenue equals expenses. T or F
The item marked 1 in the accompanying figure indicates the profit.
As in traditional what-if analysis, Goal Seek starts with the end result and determines what value you should use to reach a desired answer. T or F
To open the Goal Seek dialog box, first click the What-If Analysis button in the Data Tools group. T or F
If your input values are in a column, you will use the Column input cell option when you use the Data Table command. T or F
Two-variable data tables are often used to explore the impact of changing two values on a single result. T or F
You cannot merge scenarios in situations involving multiple workbooks. T or F
Solver is an add-in, a program that adds customized commands and features to Microsoft Office programs such as Excel. T or F
The sensitivity report is most often used in science and engineering environments. T or F
A limits report allows you to quantify the reliability of a solution produced by Solver.T or F
_____expenses change in proportion to the company’s sales volume.
CVP analysis is sometimes called ______ analysis.
break even
In traditional what-if analysis, you change _____ values in worksheet cells.
The ____ cells are the cells containing the values you want to examine.
An array _____ performs multiple calculations on one or more sets of values and then returns either a single value or multiple values.
The items marked 1 in the accompanying figure are the ____ cells.
_____ is a program that searches for the optimal solution of a problem involving several variables.
A(n) ____ cell is a cell that Excel changes to produce the desired result in the target cell.
variable, changing
_________ constraints always show a slack of 0.
A(n) ____ expense is an expense that is part variable and part fixed.
________ analysis is an important business decision-making tool because it predicts the effect of cutting overhead or raising prices on net income.
_____ analysis expresses the relationship between a company’s expenses, its volume of business, and the resulting profit.
Which of the following expense types can be used in a CVP analysis?
b. variable
A business must pay insurance and rent; these are examples of _______ expenses.
All three expense types can be classified as _______.
variable, fixed, and mixed
Goal Seek uses a different approach from traditional _______ analysis.
With Goal Seek, you specify the _______ values you want.
If you orient a one-variable table so that the input values are in the first row, you would use the _______ input cell option.
In two-variable tables, you must always place a reference to the result cell in the _______ corner of the table at the intersection of the row values and the column values.
{=SUM(B1:B10*C1:C10)} is an example of a(n) _______.
array formula
Once you enter an array formula, Excel will enclose the formula in a set of _______.
curly braces
To calculate multiple cell values, select the range and type the array formula, then press the _______ keys to enter the formula.
Before using Scenario Manager, you should assign _______ to all the input and result cells you intend to use in your scenarios.
To perform a what-if analysis with more than two input cells, you _______.
create scenarios
The items marked 1 in the accompanying figure are _______ cells.
To select nonadjacent changing cells, press and hold the _______ key as you click each cell.
You can switch from one scenario to another by clicking the _______ button in the Scenario Manager dialog box.
A scenario summary report’s _______ layout makes it simpler to compare the results of each scenario, and the automatic formatting makes it useful for reports and meetings.
_______ is a program that searches for the optimal solution of a problem involving several variables.
The three items that you must specify when using Solver are _______.
variable cell, objective cell, and constraints
In Solver, changing cells are sometimes referred to as _______ cells.
Aside from Solver, other Excel _______ provide the ability to perform statistical analyses, generate business reports, and retrieve financial data from the Internet.
To activate Solver, click Solver Add-In in the _______.
add-ins dialog box
A(n) _______ is a limit that is placed on a Solver problem’s solution.
_______ are important because they ensure a realistic solution to your problem
After trying out solutions for a short time, Solver displays the _______ dialog box, which displays the message that indicates Solver has found a solution that satisfies the constraints.
solver results
A(n) _______ procedure means that Solver starts with an initial solution and uses that as a basis to calculate a series of solutions.
If Solver is taking too long to find a solution, you can halt the program at any time by pressing the _______ key.
The default length of time that Solver will spend on the iterative process is _______ seconds.
The default convergence value in Solver is _______.
You can include an analysis of the constraints and conditions by which Solver arrived at its solution by creating a(n) _______ report.
Solver can create the following three different reports: _______.
answer, limits, sensitivity
The _______ report summarizes the results of a successful solution by displaying information about the target cell, changing cells, and constraints.
The answer report is divided into _______ sections.
The slack is the difference between the value in the cell and the value at the limit of the _______
Binding constraints always show a slack of _______
Cells that display the value _______ indicate that all of the values in the worksheet satisfy the Solver constraints.
If a value in the worksheet violates one of the constraints, the Solver parameter cells will display the value _______.
To set up a(n) ____________________ table, you first insert references to the input and result cells.
When creating a(n) ____________________ data table, you must identify the row input cell and the column input cell.
The ____________________ input cell is the cell on which values placed in the first column of the data table are based.
Click the Scenario PivotTable ____________________ option button to create a PivotTable describing the scenarios.
A(n) ____________________ is a customized program that adds commands and features to Microsoft Office programs.
add in
In Solver, a(n) ____________________ cell is a cell that you want to maximize, minimize, or change to a specific value.
The Scenario Manager refers to ____________________ cells as changing cells because these worksheet cells contain values that are changed under the scenario
The ____________________ is the difference between the value in a cell and the value at the limit of the constraint.
___________________ constraints always show a slack of 0.
____ changes one cell in order to force another to show a specific value
Goal Seek
____ places limits on a problem’s solution, in Solver
Summarizes the results of a successful Solver solution
answer report
____ adds commands and features to Excel
add ins
____ cannot be used when a problem contains integer constraints
limits reports
Cells whose values you will change within each scenario
Cells that contain the calculated values you want to examine
_____ means that a constraint was not a limiting factor in a Solver solution
Searches for the optimal solution of a problem involving several variables
The difference between the value in a cell and the value at the limit of the constraint

Need essay sample on "BUS 150 Part 2"? We will write a custom essay sample specifically for you for only $ 13.90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
Complete Buyer Protection
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy

We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy