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:

Process Of Development

The sequence of physical, psychological, and social changes that occur in human beings from birth to the end of life, involving growth and decline.

Sensitive Periods

Specific times in an individual's development when the brain is particularly receptive to learning certain skills or knowledge, leading to optimum development in those areas.

Beliefs About Children

The assumptions, values, or opinions that individuals or societies hold regarding children and childhood.

Confidentiality

The ethical and legal duty to protect private information from unauthorized access or disclosure.