if you gonna copy and past the same answer please tell me the formula for R18,R19 etc......... note I need the answer to every question and it has to be done in excel please state every formula being used.

Using Solver to Find the optimal Stock Portfolio Five investors plan to pool the fund and create a stock portfolio together. Based on their unique expertise and analysis, their investing preferences are as follows: Adam has a total amount of $50,000 and is only willing to invest in Google, Facebook and Amazon; Bill has a total amount of $80,000, and is willing to purchase at least 50 shares of Disney, and the rest of the fund can be allocated to AT&T, T-Mobile and Netflix: Cindy has a total amount of $65,000, and is only willing to allocate the fund to Google and Amazon: Dianna has a total amount of S90,000, and is open to invest in any companies; Elaine has a total amount of $60,000, and is willing to invest in Google, Facebook, Amazon, AT&T, T-Mobile, Netflix and Tesla. The purchase price (per share) of each stock is shown in the table below: Google Facebook Netflix T-Mobile AT&T Disney Tesla $1,400 $2,400 $213 $440 $811 Amazon $97 $29 S108 The expected profit for each stock (per share) is: Google Amazon Facebook Netflix $52 $30 $19 $21 T-Mobile S8 AT&T $5 Disney $20 Tesla $29 Please use Solver to determine the best fund allocation for each investor (i.e. for every investor, how many shares to purchase for each stock) to optimize their stock portfolio. (Note: fraction partial share can be purchased, and integer constraint does not need to be imposed)