1) IMPORTANT NOTE!!!!! Flashcards

1
Q

When doing the constraints charts, the OFC has a coeffecicients at the top- do you drag them down to all the cells below??

A

NO!!!! only put coefficients in ur constraints if they come from something else sweetie

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

when doing lp graphing, how to note the constraints?

A

hash lines baby!! in the correct direction for every consrtaint besidse non negativity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

IN LP graph corner point method! dont forget to what??

A

note the otpimal solution on the graph and also in the box!!!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

HIGHLIGHT THE FEASIBLE REGION

A

YES

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

LABEL ALL CONSTRAINTS

A

PURR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

how do you do integer constraint

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

ISO PROFIT LINE SHOULD BE A DASHED LINE

A

!!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

IMPORTANT NOTE about the table in corner point method

A

not given to you in exam! so remember the format is

Co-ordinates Profit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

in excel solver sensitivty, if there is an allowable increase/decrease to infintity.. what does this mean

A

you can increase or decrease up to an infinite amount and it will not impact the model!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

if there is a complex ratio constraint:

<35% of total investment should be in xyz, what do I reference in my RHS constraint?

A

Reference the variable cells!!!!!

x y z <= 0.35*(uvwxyz)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

excel solver, what does every cell in the constraints table need to be linked to?

(on the LHS of the constraint)

A

a decision variable that is going to change

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

how to calculate profit

A

((unit profit- unit cost)*quantity)

NOT SALES-COST

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How to formulate the ofc

The line of the top with the variables and their coeffs (#2 A1)

A

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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

IMPORTANT REMINDER ABOTUT those a1 q2 table questions: what are the two things you write?

A

1) Maximize or minimize in the top left corner by the ofc!!
2) subject to: in the corner!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

how to clean up a sensitivitty report?

A

2 decimals and 1e30+

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

how do you say if the solution is feasible

A

because all constraints satisfied

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

how do you say if solutions are not feasible

A

because all constraints are unsatisfied

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

how do you do the write ups in excel for allowable and non allowable decrease (compare the terms?)

A

ex: 1 is not in the allowable decrease of 0.75
(1>0.75)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

how do you write up the write ups for the “All or none constraints”

A

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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

do you write binding/non-binding for ip problems or lp problems

A

only ip problems

21
Q

what colour cells do you multiply for the ofc

A

sumproduct (blue, yellow)

22
Q

should you put in the int and bin constraint no matter what?

A

ALWAYS!!! NO MATTER WHAT!!! EVEN IF USELESS IN THE ASSIGNMENT AND TRANSPORT PROBLEMS

23
Q

How to formulate ratio constraints?

A

1) Write out the constraint in words
2) Move your denominator to the RHS
-> this will be (decimal)*(sum(xx:xx)

3) The numerator is what you will be referencing for the constraints!
->Make sure that these cells meet BOTH the restrictions of the TOP AND BOTTOM

24
Q

FOR SMA and WMA do you use actual or forecasted

A

use actual

25
Q

when you square negative errors is it positive or negative

A

NEGATIVE

26
Q

for exponential smoothing do you use forecasted or actual

A

actualalpha + 1-alphaforecasted

27
Q

if error is positive:
if error is negative:

A

underestimation
overestimation

at-ft (at>ft) actual was more than forecasted; so we predicted less

at-ft(At<ft) actual was less than forecasted; so we predicted too high

28
Q

how to calcualte base?

A

THIS IS JUST THE AVERAGE DEMAND PER SEASON

(total for all terms/number of terms)

total of year/12

29
Q

How to calculate k

A

that is the number of this period!!!
-> if yearly, then k is between 1-12
-> if seasonally, then k is 1-4

30
Q

how to calculate trend?

A

trend percent% x base

31
Q

How to forecast for year 3?
1) Calculate the average monthly demand for year 2 (total for year 2/12) [this is the same as base]

2) then calculate the average for all the months (year 2+ year 1 / 2)

3) Calculate the cyclical index (average for the month / average monthly demand for year) basically divide the avg for the month by what is the average demand should be

4) Then calculate the forecast for year 3, take the (year 3 yearly demand/12) * (cyclical index)

A

How to forecast for year 3?
1) Calculate the average monthly demand for year 2 (total for year 2/12)

2) then calculate the average for all the months (year 2+ year 1 / 2)

3) Calculate the cyclical index (average for the month / average monthly demand for year) basically divide the avg for the month by what is the average demand should be

4) Then calculate the forecast for year 3, take the (year 3 yearly demand/12) * (cyclical index)

32
Q

HOW TO calculate cyclical index

A

average for this month/ average monthly demand for all the months in the year

33
Q

if they give u a constraint in cents how do you write it?

A

as it was given!! dont convert!

34
Q

how to formulate the OFC for the constraint tables?

A

price-COST!!!

AND if not given price then just put the cost

35
Q

when you choose the right forecasting technique, there is a tradeoff between

A

accuracy and cost

36
Q

what is causual forecasting

A

forecasting related factors, promotional campagins, economic conditions, and compeititors actions

37
Q

if you increase/decrease the ofc within the allowable decrease

A

the decision variables stay the same! problem does not need to be re-solved

38
Q

if there is an allowable decrease, and you are measuring impact on profit, use what ?/

A

NEGATIVE SIGN!! IN THE DECREASE

Impact on profit= (-)change in resources*(shadow price)

39
Q

what happens in transportation problem if both constraints are <=

A

you will get an answer of 0

40
Q

what happens in transportation problem if both constraints are =

A

you will not get a solution

41
Q

5 special conditions in LP problems

A

1) redundant constraints
2)alternate optimal solution
3) infeasible solution
4) non linearity
5) unbounded

42
Q

how can you get more than one optimal solution

A

more than one optimal point found by solver

43
Q

what are redundant constraints

A

non binding constraints

44
Q

why do we keep redundant constraints

A

because we dont know if they are binidng prior to solving/ they could be binding in the future

45
Q

when could you get an unbounded solution (ERROR)?

A

in investment problem with no highest amount of investment possible

46
Q

how could you get non linearity error

A

IF you accidentally have decision variables being divided

47
Q

How could you get infeasibility error

A

signs are wrong, feasible region is incorrect

48
Q
A