3.1 Setting up the To compare the deterministic, inflexible and fixed design options, I set up the projects in an excel worksheet with cash flow as shown in the scenario in Figure 3. The main differences between the deterministic and inflexible system is the incorporation of uncertainty. The inputs for the deterministic case are the average values as shown below: Table 2: Deterministic Values Deterministic Inputs Average corn price $116/MT Average demand 1558 MT/ha Average flow 4805 MCM Average corn production 1.4 MT/ha Since the deterministic model uses the same average every year, it does not incorporate the possibility of water shortages, smaller crop yields or fluctuating demands and prices. In the inflexible design, the seasonal water flow level, the demand for corn, the price of corn and the production of corn become random values determined from the distributions described before.
3.1 Setting up the To compare the deterministic, inflexible and fixed design options, I set up the projects in an excel worksheet with cash flow as shown in the scenario in Figure 3. The main differences between the deterministic and inflexible system is the incorporation of uncertainty. The inputs for the deterministic case are the average values as shown below: Table 2: Deterministic Values Deterministic Inputs Average corn price $116/MT Average demand 1558 MT/ha Average flow 4805 MCM Average corn production 1.4 MT/ha Since the deterministic model uses the same average every year, it does not incorporate the possibility of water shortages, smaller crop yields or fluctuating demands and prices. In the inflexible design, the seasonal water flow level, the demand for corn, the price of corn and the production of corn become random values determined from the distributions described before.