In the "Input Analysis" section of the spreadsheet model, calculate a sales forecast for each type of product if expected attendance at the future event is 18000 people. Reference cell I13 (the attendance forecast) for your calculations. In the "Input Analysis" section of the spreadsheet model, calculate the upper limit for your sales forecast for each type of product if expected attendance at the future event is 18000 people. Reference the confidence interval you created for your calculation. In the "Input Analysis" section of the spreadsheet model, calculate the lower limit for your sales forecast for eath type of product if expected attendance at the future event is 18000 people. Reference the confidence interval you created for your calculation. \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Event & Crowd Size & Attendance & Programs & Food & Merchandise & Type & \\ \hline 1123 & Fair & 11055 & $28,190 & $76,722 & $146,037 & Sporting Event & \\ \hline 1125 & Good & 19689 & $168,538 & $113,409 & $499,116 & Sporting Event & \\ \hline 1214 & Good & 16657 & $74,457 & $239,861 & $351,629 & Sporting Event & \\ \hline 1217 & Fair & 11383 & $32,100 & $181,217 & $271,826 & Sporting Event & \\ \hline 1322 & Good & 15334 & $102,584 & $98,598 & $618,267 & Concert & \\ \hline 1416 & Fair & 12081 & $70,191 & $68,620 & $407,975 & Sporting Event & \\ \hline 1419 & Excellent & 20082 & $106,836 & $246,808 & $561,292 & Sporting Event & \\ \hline 1621 & Fair & 10643 & $39,486 & $139,210 & $448,070 & Concert & \\ \hline 1713 & Good & 18421 & $128,947 & $223,078 & $615,814 & Sporting Event & \\ \hline 1716 & Good & 18485 & $63,219 & $187,992 & $251,396 & Sporting Event & \\ \hline 1723 & Good & 17012 & $35,045 & $204,484 & $137,967 & Other Event & \\ \hline 1919 & Good & 16884 & $29,040 & $128,318 & $695,621 & Concert & \\ \hline 2119 & Fair & 14350 & $35,014 & $72,181 & $569,552 & Concert & \\ \hline 2317 & Good & 15901 & $34,187 & $221,183 & $244,557 & Sporting Event & \\ \hline 2321 & Poor & 8789 & $63,544 & $131,659 & $103,798 & Other Event & \\ \hline 2322 & Fair & 13629 & $59,968 & $211,250 & $457,253 & Sporting Event & \\ \hline 2416 & Fair & 13331 & $95,583 & $161,172 & $419,527 & Sporting Event & \\ \hline 2418 & Poor & 8569 & $35,047 & $106,084 & $117,310 & Sporting Event & \\ \hline 2419 & Excellent & 21016 & $56,323 & $305,362 & $774,860 & Concert & \\ \hline 2523 & Fair & 13281 & $23,109 & $113,951 & $454,210 & Sporting Event & \\ \hline 2524 & Excellent & 21538 & $119,536 & $129,228 & $987,087 & Concert & \\ \hline 2527 & Fair & 12465 & $79,153 & $142,101 & $121,160 & Other Event & \\ \hline 2615 & Excellent & 20611 & $176,430 & $166,125 & $581,642 & Sporting Event & \\ \hline 2620 & Excellent & 20145 & $58,018 & $234,689 & $283,843 & Sporting Event & \\ \hline 2621 & Poor & 8800 & $30,096 & $87,032 & $292,336 & Sporting Event & \\ \hline 2919 & Excellent & 20999 & $97,645 & $223,639 & $893,927 & Concert & \\ \hline 2921 & Good & 15443 & $123,390 & $237,822 & $177,749 & Other Event & \\ \hline 2924 & Fair & 10848 & $67,149 & $172,483 & $72,356 & Other Event & \\ \hline 3121 & Good & 19953 & $91,983 & $265,774 & $906,265 & Concert & \\ \hline 3216 & Good & 18903 & $147,632 & $157,840 & $504,710 & Sporting Event & \\ \hline 3920 & Poor & 9074 & $34,390 & $123,769 & $288,281 & Sporting Event & \\ \hline 3922 & Excellent & 20498 & $53,705 & $304,190 & $565,335 & Sporting Event & \\ \hline 4122 & Fair & 11573 & $87,608 & $63,420 & $213,175 & Sporting Event & \\ \hline 4416 & Excellent - & 21249 & $170,417 & $320,010 & $127,919 & Other Event & \\ \hline 4422 & Fair & 11257 & $99,624 & $150,394 & $413,132 & Sporting Event & \\ \hline 4520 & Good & 19235 & $25,006 & $181,194 & $483,760 & Sporting Event & \\ \hline 4719 & Fair & 13275 & $19,382 & $96,775 & $300,679 & Sporting Event & \\ \hline 4819 & Fair & 13378 & $13,512 & $206,423 & $526,424 & Concert & \\ \hline 4820 & Good & 18449 & $44.093 & $216.407 & $126.007 & Other : & \\ \hline \end{tabular}