The objective was to develop Excel-based models to optimize project selection and resource allocation for Ewing Natural Gas and Shelby Shelving. Implemented linear programming, sensitivity analysis, ...