This scenario gives the background for all of the problems in this Assignment.
You are the manager of Cornucopia, a small organic snack company. You are planning production for
the next year, but the available quantity of one of the resources required, corn, is uncertain, due to
crop disease. You will use a combination of linear programming and simulation to estimate the mean
and standard deviation of your profit.
Cornucopia produces three kinds of snack: Lirazels, Wolf Bites, and UFOs. The resources required are
cheese powder, corn, and rice. The following table shows, for each product, the amount required of
each resource, and the profit, per unit. It also shows the amounts of cheese powder and rice
available
When you are moving a workbook to another computer, use the Remove Buttons command. This
simplifies opening the workbook on the other computer. Buttons are removed from all worksheets.
Linear Programming Models
Your Excel document should have seven worksheets: the linear program (any one of the four
versions
solved), the four sensitivity reports, the piecewise-linear function implementation for Problem 3,
and the
overall simulation for Problem 4. Each worksheet should have a sensible name, and be referred to in
the
main report. The main report should contain all of your final answers (even where this repeats
material
visible in the Excel file).
Use the attached copies as you do the amends,The editor has split ed the excel file from the word
file and that is how it should be done,
Your Excel document should have seven worksheets: the linear program (any one of the four
versions
solved), the four sensitivity reports, the piecewise-linear function implementation for Problem 3,
and the
overall simulation for Problem 4. Each worksheet should have a sensible name, and be referred to in
the
main report. The main report should contain all of your final answers (even where this repeats
material
visible in the Excel file).
Your Excel document should have seven worksheets: the linear program (any one of the four
versions
solved), the four sensitivity reports, the piecewise-linear function implementation for Problem 3,
and the
overall simulation for Problem 4. Each worksheet should have a sensible name, and be referred to in
the
main report. The main report should contain all of your final answers (even where this repeats
material
