Limited Dependent Variable Models

Solving LP problems graphically is possible when there are more than two decision variable. T/F

True

Tropicyun produces melons with 2 large fields (A and B) and has 2 processing centers (C and D). The field A and field B can supply 500 and 800 melons, respectively. The capacity of processing centers C and D is 650 melons and 750 melon, respectively. Tropicyun wants to determine how many melons to ship from each field to each processing center in order to process all melons while maximizing the total travel distances. Assuming the distance between each field and each processing center is identical. Please define the decision variables an the constraints.

AC, AD, BC, BD # of melons shipped xAC + xAD=500 xBC + xBD=800 xAC + xBC <=650 xBD + xAD <=750 AC,AD,BC,BD >=0

Which function is equivalent to =SumProduct(A1:A3,B1:B3)? A. =Sum(product((A1:A3,B1:B3)) B. =Product(Sum((A1:A3,B1:B3)) C. =Product(A1+B1,A2+B2,A3+B3)) D. =A1*B1+A2*B2+A3*B3

D. =A1*B1+A2*B2+A3*B3

The variable cells in the spreadsheet represent the _____________ variables in an LP problem

Decision

Electro is a leading maker of slip-rings. The company now receives an order including 3000 units of model 1 and 2000 units of model 2. The company cannot fill the order by itself given the capacity constraints. The company can subcontyract any portion of this order ti its partner. The unit costs of producing each model in-house and buying them from its partner aew summarized below. Electro wants to determine the number of slip rings to make and buy at the least possible cost. Define the decision variables an the objective function.

M1= How many to make for model 1 M2= how many to make for model 2 B1= How many to buy for model 1 B2= How many to buy for model 2 Min COst= 70M1 + 160M2 + 90B1 + 157B2