Consider the Last Several Conversations You Have Had

question 18

Essay

Consider the last several conversations you have had.Identify which personal space zones you were in for each of the conversations.Were any of the conversations held in inappropriate zones? Explain.

Formulate and solve linear programming models using Solver in Excel for optimization problems.

Apply binary variable utilization in decision-making for optimal solutions.

Calculate optimal shipping quantities to minimize transportation costs.

Understand and apply the concept of material balance equations in production planning.

---

Definitions:

Changing Cell

In spreadsheet applications, a cell whose value is altered based on changes in a formula or as part of a scenario analysis.

Objective Cell

In optimization and spreadsheet software, the cell that contains the formula that is to be maximized or minimized.

Goal Seek

A function in spreadsheet software that finds the input value needed to achieve a specific goal or result in a formula.

What-If Analysis

A process or feature in spreadsheet and analytical software that allows users to predict the outcome of a particular action or scenario by changing variables.