Msis 3223 Final Exam Review With Correct Answers And Explanation

Optimization models: {Ans: Have been used extensively in operations and supply chains, finance, marketing, and other disciplines.}(T/F) Spreadsheets need to be accurate, understandable, and user friendly. {Ans: True}Integer Tolerance: {Ans: The parameter that specifies when the Solver algorithm will terminate an optimization process with integer constraints.}Variable cost = {Ans: Unit Variable Cost * Quantity Produced}The set of feasible solution is often called: {Ans: the feasible region}Profit= {Ans: Revenue - Variable Cost - Fixed Cost}Constraints generally fall into one of these categories: {Ans: -Simple Bounds constrain the value of a single variable. -Limitations usually involve the allocation of scarce resources. -Requirements involve the specification of minimum levels of performance. -Proportional Relationships are often found in problems involving mixtures or blends of materials or strategies. -Balance Constrains essentially state that input=output and ensure that the flow of material or money is accounted for at locations or between time periods.}In predictive modeling, verification refers to how well a model represents reality. {Ans: False}Data validation feature allows you to: {Ans: Define acceptable input values in a spreadsheet and provides an error alert if an invalid entry is made. This can help you avoid inadvertent user