solve questions for case c only. Please use Excel and show the functions for it. Make sure to use the solver to get an answer. Need it ASAP! Rest of work is for reference

Case A BlueSky flies three airplanes between Houston and three cities, Chicago, Miami, and Phoenix. These three cities are the spokes connected by the Houston hub. A few times each day the three airplanes fly from the spoke cities to Houston. They arrive simultaneously at Houston; connecting passengers change aircraft during a 45-minute layover, and the three airplanes depart for the spokes. One set of six flights (three inbound to Houston and three outbound) is called a bank. Each bank can serve passengers flying on 12 different routes: three inbound direct routes (Chicago-Houston or C-H, Miami-Houston or For example, on the C-H flight, the total demand is MH, and Phoenix-Houston or P-H), three outbound the sum of demands for three passenger routes, C-H, direct routes (H-C, H-M, and H-P), and six routes C-M, and C-P, totaling 130+98+88=316 passengers requiring two flights each (C-M, C-P, M-C, M-P, P-C, (this is the sum of the second row of Table 2). Because and P-M). BlueSky charges a single fee for a one-way coach- least 76 passengers must be turned away. class ticket on each passenger route. Table 1 shows When the total demand for a particular flight the prices charged by BlueSky. The marginal cost of may be larger than the available capacity, an airline flying a passenger on each route is virtually zero. can decide whether to accept or reject an offer to Each of the three airplanes currently has 240 coach buy a ticket for a particular route. Controlling sales seats. Table 2 shows demand for the routes in a bank; in this way to maximize revenue is called revenue assume in this case that demand is known, with no management. For example, BlueSky may decide that uncertainty. From Table 2 we can see that passen- it is optimal to sell large numbers of tickets for the ger demand exceeds airplane capacity on every flight. CH and C-M routes, but might severely restrict the number of C-P tickets sold. Given the data above, BlueSky might sell tickets for 130CH routes, 98 C-M routes, and only 12 C-P routes, thus filling all 240 seats on the CH flight. Build a model to determine the number of tickets to sell for each route. The objective is to maximize revenues over a single bank. The tables above are available in BlueSky Network Data.xls. 1 1 This Excel spreadsheet file can be found and downloaded from \begin{tabular}{|l|r|r|r|r|r|r|} \hline table one & price & \multicolumn{4}{|l|}{ destination } \\ \hline \begin{tabular}{l|r|r|r|r|r|} \hline \end{tabular} & & & & & \\ \hline origin & houston & chicago & miami & phoenix & \\ \hline houston & 0 & 197 & 110 & 125 & \\ \hline chicago & 190 & 0 & 282 & 195 & \\ \hline miami & 108 & 292 & 0 & 238 & \\ \hline phoenix & 110 & 192 & 230 & 0 & \\ \hline & & & & & \\ \hline table 2 & demand & & & & hub \\ \hline origin & houston & chicago & miami & phoenix & \\ \hline houston & 0 & 123 & 80 & 110 & \\ \hline chicago & 130 & 0 & 98 & 88 & 316 \\ \hline miami & 72 & 105 & 0 & 68 & 245 \\ \hline phoenix & 115 & 90 & 66 & 0 & 271 \\ \hline spoke & & 318 & 244 & 266 & \\ \hline \end{tabular} number of tickets to sell \begin{tabular}{|l|r|r|r|r|r|r|} \hline origin & houston & chicago & miami & phoenix & & \\ \hline houston & 0 & 123 & 80 & 110 & & \\ \hline chicago & 84 & 0 & 94 & 62 & 240