You Have Been Given the Following Linear Programming Model and Excel

question 68

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?
MAX: ^{4 X}₁ ^{+ 3 X}₂
Subject to: ^{6 X}₁ ^{+ 7 X}₂ ^{≤ 84}
X₁ ≤ 10
X₂ ≤ 8 X₁,X₂ ≥ 0
$\begin{array}{|l|l|c|c|c|c|} \hline& \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} & \mathrm{E} \\\hline 1 & & & & & \\\hline 2 & & & & & \\\hline 3 & & \mathrm{x}_{1} & \mathrm{x}_{2} & & \\\hline 4 & \text { Number to make: } & & & & \begin{array}{l}\text { OBJ. FN. } \\\text { VALUE }\end{array} \\\hline 5 & \text { Unit profit: } & & & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & & & & \\\hline 9 & 2 & & & & 84 \\\hline 10 & 3 & & & & 10 \\\hline\end{array}$

---

Definitions:

Crossing The Chasm

A marketing theory that describes the challenge of transitioning from early adopters of a product or service to a broader mainstream market.

Positioning

A marketing strategy that focuses on how your customers think or talk about product and company relative to competitors.

Psychographics

The study and classification of people according to their attitudes, aspirations, and other psychological criteria, especially in market research.

Demographics

The statistical characteristics of human populations, such as age, gender, income, and education, used especially to identify markets.