Posted: November 19th, 2022

BUAD306 Assignment 5

BUAD306 Assignment 5
Due Date: Friday November 18, 11:59 PM, Canvas Submission
The assignment must be completed in groups of two unless otherwise is permitted by the instructor. You must
hand-write your answers for parts (b) to (f) and submit a scanned version (scanning/taking pictures with phone
is ok) to Canvas. You must combine those several pages of scans/pictures of your handwritten answers into
one Word or PDF file only (do not submit the scans/pictures separately). You must submit your Excel file for
part (a) as well. The assignment should be submitted to Canvas by one of the group members only (write the
names of all team members on the assignment). Handwriting on iPad, Surface, etc. is accepted, but typing is not
allowed. You are responsible for making sure the handwriting is neat to read and the scanned copy/picture is of
high-quality. No late assignments will be accepted for any reasons, and zero grade will be assigned. Surface, for example, is acceptable, but typing is not. You must ensure that the handwriting is legible and that the scanned copy/picture is of high quality. There will be no late assignments accepted for any reason, and a zero grade will be assigned.
Remember to include units, etc., wherever necessary in your model. If you do not include units correctly, you will lose points. Your Excel model should adhere to the same coloring rules and structure that we use in class.
Do not forget to include units in your model, etc., wherever required. You will lose marks if you do not
include units properly. Your Excel model should follow the coloring rules and structure we follow in class.
The Fruits&Nuts Blending Problem
Fruits&Nuts produces Yummix, a snack that is a mixture of dried fruits, nuts and cereal. The following table
includes the information about the calories, fat and cost of every item in the mix:
Dried Fruit Nuts Cereal
Calories (per ounce) 150 300 50
Trans Fat (grams per ounce) 2 8 1
Cost (per ounce) $0.65 $0.60 $0.35
Each Yummix pack must weigh exactly 10 ounces. The mix cannot contain more than 1500 calories, and cannot
contain more than 30 grams of trans fat. Dried fruit must be at least 25% of the weight of the mix. Cereals must
be no more than 40% of the weight of the mix.
a) Formulate and solve an LP model in Excel that would tell Fruits&Nuts how many ounces of each item to
include in each pack of Yummix, minimizing the cost of the mix.
b) What is the optimal solution? What is the optimal objective value?
c) How many decisions does the model have? State them clearly.
d) How many constraints does the model have in total? Describe each in a sentence or two.
e) Which constraints are binding? Which constraints are non-binding?
f) Write down the LP mathematical formulation of the problem. Clearly state every component of the
formulation and label all constraints.