Here is the background for the questions:Data from the customer e-mail survey have begun to trickle in. Walker wants to develop a prototype model based on the current survey results. So far, 53 surveys have been returned. To keep the prototype model manageable, Walker wants to proceed with model development using the data from the 53 returned surveys and using only the first 10 news sites in the questionnaire. The costs of ads per week for the 10 web sites are given in the following table, and the budget is $10,000 per week. For each of the 53 responses received, the 10 web sites visited regularly are shown below.

For a given customerweb site pair, a one indicates that the customer regularly visits that web site and a zero indicates that the customer does not regularly visit that site.

Please walk me through how to solve these questions on the excel spreadsheet.

1. 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.
2. Solve the model. What is the maximum number of customers reached for the $10,000 budget?
3. Perform a sensitivity analysis on the budget for values from $5,000 to $48,000 in increments of $4,000. 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.

Applecore Website 12345678910Cost/Wk ($000)$5.0$8.0$3.5$5.5$7.0$4.5$6.0$5.0$3.0$2.2 Website Customer12345678910100000000012100100000031000000000400001100005000010000060000000001701000000108000010010091000100001100001010101110000010000120010000000130000100000140100010000150000000100160000010000170001100000180000001000190000110000200100000100210000001010220000010000230010010001240000000000250000100100260010000001270100000100280001001000290000010000300011100001310001000000320000000100331010000001340001100000351000110000361010000000370010100100380010000000390100001000400100001000410000001000420001110000430000000000440000100001451100000000460000001000471000100001480010000000491011000000500000000000510100010000520000000000530100100111