Develop a Appendix $7\mathrm{.}1$ Excel Solution of Integer Linear Programs

$331$

Managerial Report:

Develop a model that will allow Applecore to maximize the number of customers reached for a budget of $$10,000$ for one week of promotion.

Solve the model. What is the maximum number of customers reached for the $$10,000$ budget?

Perform a sensitivity analysis on the budget for values from $$5000$ to $$35,000$ in increments of $$5000.$ Construct a graph of percentage reach versus budget. Is the additional increase in percentage reach monotonically decreasing as the budget allocation increases? Why or why not? What is your recommended budget? Explain.