Note: This Problem Requires the Use of a Linear Programming $$x _ { j } = \left\{ \begin{array} { l } 1 , \text { if crew } j \text { is selected } \\0 , \text { otherwise }\end{array} \right.$$

question 2

Multiple Choice

Note: This problem requires the use of a linear programming application such as Solver or Analytic Solver.
The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost and is qualified to clean only certain buildings. There are eight possible crews to choose from in this case. The goal is to minimize costs while making sure that each building is cleaned. The management science department formulated the following linear programming model to help with the selection process.
Min 200x1 + 250x2 + 225x3 + 190x4 +215x5 + 245x6 + 235x7 + 220x8
s.t. x1 + x2 + x5 + x7 ? 1 {Building A constraint}
X1 + x2 + x3 ? 1 {Building B constraint}
X6 + x8 ? 1 {Building C constraint}
X1 + x4 + x7 ? 1 {Building D constraint}
X2 + x7 ? 1 {Building E constraint}
X3 + x8 ? 1 {Building F constraint}
X2 + x5 + x7 ? 1 {Building G constraint}
X1 + x4 + x6 ? 1 {Building H constraint}
X1 + x6 + x8 ? 1 {Building I constraint}
X1 + x2 + x7 ? 1 {Building J constraint} $$x _ { j } = \left\{ \begin{array} { l } 1 , \text { if crew } j \text { is selected } \\0 , \text { otherwise }\end{array} \right.$$
Set up the problem in Excel and find the optimal solution. Which crews are selected?

• A) Crews 1, 2, and 3
• B) Crews 1, 5, and 6
• C) Crews 1, 7, and 8
• D) Crews 2, 3, and 5
• E) Crews 3, 4, and 5.

Analyze the impact of mergers and acquisitions on the value per share of the acquiring and acquired firms.

Understand the concept of merger premium per share and how it is calculated.

Discern the decision-making process involved in choosing cash or stock payments in acquisitions.

Learn the methods to calculate the synergy value in mergers and acquisitions.

---

Definitions:

Macy's

An American department store chain known for its diverse range of products, including clothing, accessories, home furnishings, and more.

Kohl's

An American department store retail chain, offering a wide selection of clothing, footwear, bedding, furniture, jewelry, beauty products, and housewares.

Conventional Supermarkets

Traditional brick-and-mortar grocery stores that offer a wide range of food and household products, often including a bakery, dairy, meat, and produce sections.

Competitive Reality

The actual market conditions in which businesses compete for customers, including the level of competition, market share distribution, and current consumer preferences.