- Net Operating Income - -= Gross Profit - Operating Expenses
- Earnings Before Taxes - -= Net Operating Income - Interest Expense
- Net Income - -= Earnings Before Taxes - Taxes
- Spreadsheet Engineering - -The process of building spreadsheet models
- Verification - -The process of ensuring that a model is accurate and free
from logical errors.
- Data Validation - -An Excel tool that allows you to define acceptable input
values in a spreadsheet and provides and error alert if an invalid entry is
made
-Data > Data Tools
-Select the cell range, click Data Validation
-Specify the criteria that Excel will use to flag invalid data.
- Single-Period Purchase Decisions - -One-Time purchase decisions often
must be made in the face of uncertain demand.
- Predictive Models - -Theses kind of models focus on understanding the
future.
- Cash Budgeting - -The process of projecting and summarizing a company's
cash inflows and outflows expected during a planning horizon, usually 6 to
12 months.
, - Project Management - -Concerned with scheduling the activities of a
project involving interrelated activities.
- Critical Path - -The longest path through the network defines the minimum
project completion time is called the...
- Optimization Models - -Predictive models are often called ____________ .
-Specifies a set of decision variables, numerical quantities that represent the
decision options from which to choose.
-Specifies an objective function and constraints.
- What-If Analysis - -Spreadsheet models that allow you to easily evaluate
what-if questions by changing input values and recalculating model outputs.
- Data Tables - -_______ _________ summarize the impact of one or two inputs
on a specified output.
- One-Way Data Table - -Evaluates an output variable over a range of
values for a single input variable.
- Two-Way Data Tables - -Evaluate an output variable over a range of
values for two different input variables.
- Scenario Manager - -Allows the creation of scenarios. Sets of values that
are saved and can be substituted in worksheets.
- Optimization - -The process of selecting values of decision variables that
minimize or maximize some quantity of interest.
- What are the 2 basic properties of Linear Optimization Models? - -1. The
objective function and all constraints are linear functions of the decision
variables.
2. All variables are continuous.
- Integer Linear Optimization Model - -Some of or all the variables are
restricted to being whole numbers.
- A special type of integer problem is one in which variables can be only 0 or
1.
-More difficult to solve, but have important applications in scheduling and
supply chains.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Nursephil2023. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.49. You're not tied to anything after your purchase.