MSIS 3223 Final Exam question with answers
Total Cost - -=Fixed Cost + Variable Cost * Quantity Produced
-Influence Diagram - -A visual representation of a descriptive model that shows how
the elements of the model influence, or relate to, others.
-Revenue - -= Price * Quantity Sold
-Gross Profit - -= Sales - Cost of Goods Sold
-Operating Expenses - -= Admin Expenses + Selling Expenses + Depreciation
Expenses
-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 ____________ .
Total Cost - -=Fixed Cost + Variable Cost * Quantity Produced
-Influence Diagram - -A visual representation of a descriptive model that shows how
the elements of the model influence, or relate to, others.
-Revenue - -= Price * Quantity Sold
-Gross Profit - -= Sales - Cost of Goods Sold
-Operating Expenses - -= Admin Expenses + Selling Expenses + Depreciation
Expenses
-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 ____________ .
