Hospital Resource Allocation Optimization Model

Develop a complex Excel spreadsheet that uses linear programming techniques and scenario analysis to optimize hospital resource allocation during pandemic scenarios. The model should incorporate dynamic staffing requirements, equipment inventory, patient flow predictions, and cost optimization algorithms. Include Monte Carlo simulation capabilities to model multiple potential outbreak scenarios with probabilistic risk assessment.