1) IMPORTANT NOTE!!!!! Flashcards
When doing the constraints charts, the OFC has a coeffecicients at the top- do you drag them down to all the cells below??
NO!!!! only put coefficients in ur constraints if they come from something else sweetie
when doing lp graphing, how to note the constraints?
hash lines baby!! in the correct direction for every consrtaint besidse non negativity
IN LP graph corner point method! dont forget to what??
note the otpimal solution on the graph and also in the box!!!
HIGHLIGHT THE FEASIBLE REGION
YES
LABEL ALL CONSTRAINTS
PURR
how do you do integer constraint
ISO PROFIT LINE SHOULD BE A DASHED LINE
!!
IMPORTANT NOTE about the table in corner point method
not given to you in exam! so remember the format is
Co-ordinates Profit
in excel solver sensitivty, if there is an allowable increase/decrease to infintity.. what does this mean
you can increase or decrease up to an infinite amount and it will not impact the model!
if there is a complex ratio constraint:
<35% of total investment should be in xyz, what do I reference in my RHS constraint?
Reference the variable cells!!!!!
x y z <= 0.35*(uvwxyz)
excel solver, what does every cell in the constraints table need to be linked to?
(on the LHS of the constraint)
a decision variable that is going to change
how to calculate profit
((unit profit- unit cost)*quantity)
NOT SALES-COST
How to formulate the ofc
The line of the top with the variables and their coeffs (#2 A1)
JUST subtract price-cost for each individual element shawty!! And then put it in (don’t try to mathematically reason too hard it is illogical)
IMPORTANT REMINDER ABOTUT those a1 q2 table questions: what are the two things you write?
1) Maximize or minimize in the top left corner by the ofc!!
2) subject to: in the corner!
how to clean up a sensitivitty report?
2 decimals and 1e30+
how do you say if the solution is feasible
because all constraints satisfied
how do you say if solutions are not feasible
because all constraints are unsatisfied
how do you do the write ups in excel for allowable and non allowable decrease (compare the terms?)
ex: 1 is not in the allowable decrease of 0.75
(1>0.75)
how do you write up the write ups for the “All or none constraints”
NEVER re-solve w excel and say new profit
-just compare the money you earn from the all or none deal and the costs associated w all or none deal
($181.50 revenue > $150 costs)