RevolutionX is a startup tech company in robotics. The management is considering three different configurations for their new model, RobX. The three configurations are Prime, Limited, and Ultimate. The data for each of the configurations (per unit) is given in the following table. RevolutionX needs to find the optimal production of each of the configurations to maximize total profit.

Configuration	Profit ($)	Funding Needed ($)	Assembly (hrs)	Material (units)
Prime	1500	4500	45	32
Limited	2100	5300	61	41
Ultimate	3200	7100	83	63

Based on the marketing data the production of the Ultimate configuration cannot exceed the production of Prime and Limited configurations combined. Furthermore, the production of Prime and Limited configurations must be equal.

The available funding could be 1, 2, 3, or 4 million dollars with the corresponding probabilities p1,p2,p3 and p4. The chance of having 1 or 2 or 3 million dollars funding are equal (i.e., p1=p2=p3). The chance of having 4 million dollars funding is double the chance of having 1 million dollars funding (i.e., p4=2p1).

Currently they are considering three potential locations for their new factory that would be used to produce the new model. The three alternatives are: Boston, Chicago, and Huston. They need to choose one of these locations. The available Assembly hours and Material units depend on the location of the factory according to the following table:

Location	Assembly (hrs)	Material (units)
Boston	35000	15000
Chicago	30000	20000
Huston	25000	25000

A final constraint is that the production of the three configurations combined must be at least equal to the expected demand for the next month (i.e., May in the following table), that should be estimated using the following demand data for the past year.

Apr	May	June	July	Aug	Sept	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May
3850	78	89	82	112	106	131	125	145	173	182	169	195	???

You need to answer the following questions based on quantitative analysis. You need to use Regression Analysis, Linear Programming, and Payoff Table Analysis to answer the following questions.

Question 1: What location should RevolutionX choose based on the expected profit for each location?

Question 2: What is the corresponding EVPI?

Question 3: Justify the value of EVPI. You need to provide a valid argument why EVPI has this particular value.

Question 4: What is the most important parameter(s) of the model to conduct sensitivity analysis on? You need to provide reasoning why you chose that parameter(s). Conduct sensitivity analysis on the parameter you believe is the most important one.

PLEASE answer this in EXCEL and show EXCEL FORMULAS!!!