The Container Transportation Company is trying to adjust the recently design pricing and allocation model to increase even more its future revenues. The business analyst in charge with the project revised the demand forecasts and realized that the reported High demand values are 10% lower. A new report from the sales department indicates that during the high season, a price reduction of 5 cents would result in a 6 cents increase in the volume of the containers.
Based on these changes, what is the optimal pricing policy and containers allocation for the High demand season? Please show all formulas, calculations, and excel spreadsheets (including solver) used to get answers in order to receive full credit.