I need assistance in developing a algebraic optimization formula using an excel spreadsheet. Problem description paragraph: Include a general description of the objective to be optimized. What are the cost coefficients? What are the variables that can be listed? Format outline for remaining write up. Each item must be addressed. Declared variables in x or y terms with definitions. OR if you more comfortable you can use the declared variable “cells” in the spreadsheet.
Variable index (subscript) use and range ( number expected) use three variables
Given data to support- user defined
Objective equation
Constraint equations
An estimate (guess ) at the solution in conclusion
An attachment of an Excel spreadsheet “set up”
