Please help !!!! And send me the excel spreadsheet pls!!!!!

You are the CEO of a space mining company. Your company has a fleet of six vessels, which you are going to send out on a two-year mission. Each vessel can be sent to one of the four quadrants of the asteroid belt. Every year, each vessel has a certain probability of capturing an asteroid. Once an asteroid has been captured, its raw materials can be extracted and marketed by the end of that year. The income from any asteroid is a uniformly-distributed random variable lying in the range given by the table below. Each vessel can capture at most one asteroid per year captures, a bottleneck in transportation prevents you from However many asteroids your fleet extracting and marketing the materials from more than a certain number of asteroids per year. If, for example, your fleet captures six asteroids in the Alpha quadrant in a given year, you can extract and market the materials from three of them in that year, but the next three will have to wait till the following year At the end of two years, the fleet comes home, abandoning any asteroids that it may have captured but not mined The annual costs for each vessel are paid at the end of each year, and are the same whether it's searching for asteroids, extracting material from a captured asteroid, or sitting on a captured asteroid and waiting. Even we're sure that we won't need a vessel again for example, if it's the beginning of the second year and we've already captured all the asteroids that we can process in that year it still stays with the fleet Alpha Beta Gamma Delta Quadrant Quadrant Quadrant Ouadrant Annual CostsAvessel (SB) Annual Probability of Capture 0.6 0.3 0.1 0.0 Range of Value (SB) 7-11 5-9 15 Max, extractionslyear Your company's MARR is 15% What is the expected PW of sending one vessel to the Alpha quadrant? (5 pts) What is the expected PW of sending six vessels to the Alpha quadrant? (20 pts) What is the expected PW of sending one vessel to the Beta quadrant? (5 pts) What is the expected PW of sending six vessels to the Beta quadrant? (20 pts) What is the expected PW of sending one vessel to the Gamma quadrant? (5 pts) What is the expected PW of sending six vessels to the Gamma quadrant? (20 pts) What is the expected PW of sending one vessel to the Delta quadrant? (5 pts) What is the expected PW of sending six vessels to the Delta quadrant? (20 pts)