MaxTotal Revenue Max $45 B $120 P +$89 V Software Engineer (SE) 20 B+5P 40 V QC Manager: Demand f...
MaxTotal Revenue= Max $45 B + $120 P +$89 V Software Engineer (SE) 20 B+5 P + 40 V QC Manager: Demand for B: Demand for P: = 1400 minutes < 4000 minutes <- 60 units <-100 units 15 B 30 P 35 V Objective Cell (Max) Cell Name Original Value Final Value SF$3 Objective 254 14025 Variable Cells Cell $C$3 # Produced Basic $D$3 # Produced Premium SE$3 |# Produced Video Name Original Value Final Value 45 100 0...
Q.1: “Marginal Cost” for B is: a) $45 b) $0 c) -$1 d) none of these Q.2: “Marginal Cost for V is: a) -$1 b) $1 c) $0 d) none of these Q.3: If you were asked to produce V, the lowest price for V that is acceptable to you: a) $46 b) $91 c)$88 d) $87 Q.4: Suppose the SE is available for only 1000 min. Then Objective Function Value, OFV = $13125 a) True b)False Q.5: Suppose the...
Decision Variables: B= # of Basic models to be produced, profits$45/unit P= # of Premium models to be produced, profit-$120/unit Objective: MaxTotal Profit Max $45 B $120 P Constraints: Software Engineer (SE): 20 B5 P QC Manager: Demand for B: Demand for P: Preferred product is: a)B b)P c)QC Manager d) SE e)none of these <= 2400 minutes 15 B+30 P 2400 minutes <=100 units <= 50 units Decision Variables: B= # of Basic models to be produced, profits$45/unit P=...
Decision Variables: B= # of Basic models to be produced, profit=$45/unit P= # of Premium models to be produced, profit=$120/unit Objective: MaxTotal Profit= Max $45 B + $120 P Constraints: Software Engineer (SE): 20 B + 5 P <= 2400 minutes QC Manager: 15 B + 30 P <= 2400 minutes Demand for B: B <= 100 units Demand for P: P <= 50 units. Optimal production quantities are: a) B=100 & P=50 b) B=50 & P=60 c)B=60 & P=50...
Decision Variables: B= # of external modems to be produced, profit=$40/unit P= # of internal modems to be produced, profit=$120/unit Objective: MaxTotal Profit= Max $40 B + $120 P Constraints: Software Engineer (SE): 20 B + 5 P <= 2400 minutes QC Manager: 15 B + 30 P <= 2400 minutes Demand for B: B <= 100 units Demand for P: P <= 50 units QC is the Bottleneck. P is the preferred product since $120/30 > $40/15 Optimal production quantities: B=60, P=50. Questions: 1. True/False - Allowable...
If you could sell 50 oz. of stabilizer at $2.25/oz, how would this affect profit? Adjustable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease Cell $B$5 Variable C $C$5 Variable P Name 100 350 0 1E+30 2 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 200 500 50 Cell Name $D$11 Fragrance LHS 1600 $D$12 Intensifier LHS 1300 $D$13 Stabilizer LHS 350 1600 166.6666667 1E+30 50 1.5 1800 350 2 Adjustable Cells Final...
Q1: Decision Variables: B= # of Basic models to be produced, profit=$45/unit P= # of Premium models to be produced, profit=$120/unit Objective: MaxTotal Profit= Max $45 B + $120 P Constraints: Software Engineer (SE): 20 B + 5 P <= 2400 minutes QC Manager: 15 B + 30 P <= 2400 minutes Demand for B: B <= 100 units Demand for P: P <= 50 units QUESTION 5 Refer to the data given in Q1. Shadow Price for “Demand for...
(8 points) M&D Chemicals produces two products that are sold as raw materials to companies manufacturing bath soaps and laundry detergents. Let A=number of gallons of product A B=number of gallons of product B M&D’s objective is to satisfy all requirements at a minimum total cost. Production costs are $2 per gallon for product A and $3 per gallon for product B. The objective function together with the constraints is given below: Objective function: Min 2A+3B Subject to (s.t) 1A...
HERE IS THE SENSITIVITY REPORT!!!!!!!!! PLEASE SHOW ALL WORK A B C D E F G H J K M N O 1 Transportation Model (Basic) Use Solver on Data Ribbon to solve 2 3 Input Matrix: Destinations C D A 4 1 4 7 7 1 100 5 SUPPLY 8 8 2 12 3 200 6 5 3 10 16 150 7 90 80 120 160 8 Demand Required 10 Do not change or delete unshaded cells. 11 12...