Question is attached

OPRE315

Problem Statement

A dietitian would like to design a diet that provides minimum or maximum requirements for the following diet at minimum cost. Each of the decision variables are defined in the following statement. Formulate and solve a linear program that gives the amount of each in ingredient to minimize total cost. Please post the Excel and QM files on Sakai site of our class under assignment 3. Please type in the amount of each ingredient and total cost below and post this word file on Sakai as well.

X1=

X2=

X3=

X4=

X4=

X5=

X6=

X7=

X8=

X9=

X10=

Total cost =