You Have Been Given the Following Linear Programming Model and Excel

question 79

Essay

You have been given the following linear programming model and Excel spreadsheet to solve this problem. What numbers should be entered into cells B5:C5 and B8:C10 to implement this model?
$$\begin{array} { l l } \text { MAX: } & 4 X _ { 1 } + 3 X _ { 2 } \\\text { Subject to: } & 6 X _ { 1 } + 7 X _ { 2 } \leq 84 \\& X _ { 1 } \leq 10 \\& X _ { 2 } \leq 8 \\& X _ { 1 } , 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 & & X _ { 1 } & \mathrm { X } _ { 2 } & & \\\hline 4 & \text { Number to make: } & & & & \text { OBJ. FN. VALUE } \\\hline 5 & \text { Unit profit: } & & & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & & & & 84 \\\hline 9 & 2 & & & & 10 \\\hline 10 & 3 & & & & 8 \\\hline\end{array}$$

---

Definitions:

Functional Areas

Distinct categories within an organization, each focused on a particular aspect of the business, such as marketing, finance, or human resources.

Specialization

A focus or concentration on a particular area of expertise, leading to increased efficiency and skill in that area.

Total Cost of Ownership

The comprehensive assessment of the direct and indirect costs associated with the purchase and operation of a product or system over its entire lifespan.

Centralization

A process where decision-making authority is concentrated at a single point in the organization, often at the top management level.