Note: This Problem Requires the Use of a Linear Programming $$y _ { i } = \left\{ \begin{array} { l } 1 , \text { if product } j \text { is produced } \\0 , \text { ot herwise }\end{array} \right.$$

question 34

Multiple Choice

Note: This problem requires the use of a linear programming application such as Solver or Analytic Solver.
A bakery produces both pies and cakes. Both products use the same materials (flour, sugar and eggs) and both have a setup cost ($100 for cakes, $200 for pies) . The baker earns a profit of $10 per cake and $12 per pie and can sell as many of each as it can produce. The daily supply of flour, sugar and eggs is limited. To manage the decision-making process, an analyst has formulated the following linear programming model (assume that it is possible to produce fractional pies and cakes for this example) :
Max 10x1 + 12x2 - 100y1 - 200y2
s.t. 5x1 + 10x2 ? 1000 {Constraint 1}
2x1 + 5x2 ? 2500 {Constraint 2}
2x1 + 1x2 ? 300 {Constraint 3}
My1 ? x1 {Constraint 4}
My2 ? x2 {Constraint 5} $$y _ { i } = \left\{ \begin{array} { l } 1 , \text { if product } j \text { is produced } \\0 , \text { ot herwise }\end{array} \right.$$
Set up the problem in Excel and find the optimal solution. What is the maximum profit possible?

• A) $1,233.33
• B) $1,333.33
• C) $1,433.33
• D) $1,533.33
• E) $1,633.33

---

Definitions:

Townsend's Political Appeal

Refers to the efforts by Francis Townsend to mobilize public and political support in the 1930s for his proposal of a government-funded pension for the elderly.

Social Security Act

A 1935 United States law that established a system of old-age benefits, unemployment insurance, and welfare programs.

Mail Fraud

A criminal act involving the use of postal services to carry out schemes designed to fraudulently obtain money or valuables.

Anti-Semitic

Hostile or prejudiced against Jewish people.