You Have Been Given the Following Linear Programming Model and Excel

question 85

Essay

You have been given the following linear programming model and Excel spreadsheet to solve this problem. What formulas should be entered into cells E5 and D8:D10 to implement this model?
MIN: $\quad 8 X _ { 1 } + 3 X _ { 2 }$
Subject to: $\quad X _ { 2 } \geq 8$
$\begin{array} { l } 8 \mathrm { X } _ { 1 } + 5 \mathrm { X } _ { 2 } \geq 80 \\3 \mathrm { X } _ { 1 } + 5 \mathrm { X } _ { 2 } \geq 60 \\\mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } \geq 0\end{array}$ $$\begin{array} { | c | c | c | c | c | c | } \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\\hline 1 & & & & & \\\hline 2 & & & & & \\\hline 3 & & \mathrm { X } _ { 1 } & \mathrm { X } _ { 2 } & & \\\hline 4 & \text { Number to make: } & & & & \text { OBJ. FN. VALUE } \\\hline 5 & \text { Unit profit: } & 8 & 3 & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & & 1 & & 8 \\\hline 9 & 2 & 8 & 5 & & 80 \\\hline 10 & 3 & 3 & 5 & & 60 \\\hline\end{array}$$

Understand detector controls and their role in identifying fraudulent activities.

Understand the treatment and impact of NSF cheques and bank service charges on accounting records.

Comprehend the purpose and components of a bank reconciliation process.

Identify items that require adjustment in a bank reconciliation and their effects on the balance per books and balance per bank.

---

Definitions:

Financial Break-Even

The point at which total revenues and total costs are equal, meaning a project or business is neither making a profit nor a loss.

Sensitivity Analysis

An approach to assess how different values of an independent variable affect a particular dependent variable under a given set of assumptions.

Financial Break-Even

The point where total revenues equal total costs, leading to neither a profit nor a loss.

Accounting Break-Even

The point at which total costs and total revenue are equal, resulting in neither profit nor loss.