MonarchsMatter is planning its next informational campaign and has identified a variety of locations to which it can send speakers and informational material.  These locations vary in the cost it would take to reach them and the expected number of people they would reach at each event. Due to constraints on staffing, and goals to allocate minimum donor dollars to this project so that more can go to research budgets, they have identified two alternative plans in which they attend 15 events..

Plan 1 sends volunteers to the 15 highest turn-out events available for their staffing schedule. It will yield 370,540 in population reached but would cost $46,000 to implement.

Plan 2 sends volunteers to the 15 cheapest locations as available with their staffing schedule. It will yield only 152,134 in population reached, but would also only cost $30,500 to implement.

They set a Minimax problem as shown below with objective value cell “M” (E5).

Assume we get a calculated resulting actual budget of TestBudget and calculated resulting actual Exposure of TestExp in cells B2 and B3.  Complete the minimax formulation below by writing out the formulas that would go in cells C2:D3 and related constraints.  

Use the information and notation above to fill in the numbers or formulas for the white spaces of the table below. You can write your results using the names of cells (e.g. TestExp) or the cell reference (e.g. B2)   

C2:

C3:

D2:

D3:

2.  

    Write the required minimax constraints using the above table .

Answer rating: 100% (QA)

Required solution Answer C2 46000305002 Value 38250 C3 3705401521342 Value 261337 D2 460003... View the full answer