MSIS 3223 Final Exam Oklahoma State
Total Cost - correct answer =Fixed Cost + Variable Cost * Quantity Produced
Influence Diagram - correct answer A visual representation of a descriptive model
that shows how the elements of the model influence, or relate to, others.
Revenue - correct answer = Price * Quantity Sold
Gross Profit - correct answer = Sales - Cost of Goods Sold
Operating Expenses - correct answer = Admin Expenses + Selling Expenses +
Depreciation Expenses
Net Operating Income - correct answer = Gross Profit - Operating Expenses
Earnings Before Taxes - correct answer = Net Operating Income - Interest
Expense
Net Income - correct answer = Earnings Before Taxes - Taxes
, Spreadsheet Engineering - correct answer The process of building spreadsheet
models
Verification - correct answer The process of ensuring that a model is accurate
and free from logical errors.
Data Validation - correct answer 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 - correct answer One-Time purchase decisions
often must be made in the face of uncertain demand.
Predictive Models - correct answer Theses kind of models focus on
understanding the future.
Cash Budgeting - correct answer The process of projecting and summarizing a
company's cash inflows and outflows expected during a planning horizon,
usually 6 to 12 months.
Total Cost - correct answer =Fixed Cost + Variable Cost * Quantity Produced
Influence Diagram - correct answer A visual representation of a descriptive model
that shows how the elements of the model influence, or relate to, others.
Revenue - correct answer = Price * Quantity Sold
Gross Profit - correct answer = Sales - Cost of Goods Sold
Operating Expenses - correct answer = Admin Expenses + Selling Expenses +
Depreciation Expenses
Net Operating Income - correct answer = Gross Profit - Operating Expenses
Earnings Before Taxes - correct answer = Net Operating Income - Interest
Expense
Net Income - correct answer = Earnings Before Taxes - Taxes
, Spreadsheet Engineering - correct answer The process of building spreadsheet
models
Verification - correct answer The process of ensuring that a model is accurate
and free from logical errors.
Data Validation - correct answer 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 - correct answer One-Time purchase decisions
often must be made in the face of uncertain demand.
Predictive Models - correct answer Theses kind of models focus on
understanding the future.
Cash Budgeting - correct answer The process of projecting and summarizing a
company's cash inflows and outflows expected during a planning horizon,
usually 6 to 12 months.
