Use the FY2022-2023 info to calculate, for each port-of-call as well as the "grand total": TEUs, Revenue, Ratio of 20':40' containers, Total weight, etc. You may want to comment on whether some "proposed" constraints are violated at the port/total level. For dynamic pricing, you are going to simulate-estimate, the demand-curve" at each port-of-call as follows: a. Use the Excel command = rand() to generate a number between 0 and 1 multiply this number by -1 "label" it "Price Elasticity" E. b. Assume that in FY2022-2023, each port-of-call's price and demand resulted in every port-of-call having the price elasticity equal to E. For example, given Japan's price and output in season X, its price elasticity was E, identical to the price elasticity of the other nine port-of-calls. C. Assume each port-of-call has a linear demand curve. For example, the ith port-of-call demand curve is: P = ai biqi - Here Pi = Price $/TEU and qi = Total Demand (TEUs) for the ith port-of-call. From ECO101, recall that the point price elasticity is: dq P E = dP q