Filatoi Riuniti

Read the case Filatoi Riuniti provided on pages $3-8($the tables in the case are available electronically on Canvas$).$ Then,

answer the following questions.

Questions

$1.$ What is the optimal supply strategy for the month of March? What is the optimal cost?

a$.$ Formulate $($in math$)$ a linear program model for this problem. That is$,$ specify the decision variables, the

objective function, and the constraints of the model in the summary report. $($Legible$,$ hand$-$written math

formulation is acceptable. Mathematical shorthand is acceptable. That is$,$ expressions like $$#$,..,,$

$$#$,...,$

are

acceptable, and a definition of what parameter $$ represents should be provided.$)$

b$.$ Construct a spreadsheet model of your formulation and solve it using Excel$$s Solver. Please make sure that

i$.$ Simplex LP is the solution method for the problem

ii$.$ No integer constraints should be added to the formulation $($Solver will not provide a sensitivity

report if an integer constraint is added$).$

c$.$ Present the optimal supply strategy in a table format.