Scribd Logo
Upload

Welcome to Scribd!

  • 290 views

    Adm 2302 Assignment 2 !!!

    Uploaded by

    FreddyChow
    The solver found an optimal solution that maximized total revenue within the given constraints. It took 14 iterations over 0.015 seconds. The objective cell for total revenue was originally $548,588 but was optimized to $1,272,000. Several variable cells representing numbers of bottles changed values from their original to final optimized values. All constraints were satisfied with their bounds.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Adm 2302 Assignment 2 !!!

    Uploaded by

    FreddyChow
    290 views9 pages
    The solver found an optimal solution that maximized total revenue within the given constraints. It took 14 iterations over 0.015 seconds. The objective cell for total revenue was originally $548,588 but was optimized to $1,272,000. Several variable cells representing numbers of bottles changed values from their original to final optimized values. All constraints were satisfied with their bounds.

    Original Description:

    Adm 2302 Assignment 2

    Original Title

    Copy of Adm 2302 Assignment 2 !!!

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The solver found an optimal solution that maximized total revenue within the given constraints. It took 14 iterations over 0.015 seconds. The objective cell for total revenue was originally $548,588 but was optimized to $1,272,000. Several variable cells representing numbers of bottles changed values from their original to final optimized values. All constraints were satisfied with their bounds.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    290 views9 pages

    Adm 2302 Assignment 2 !!!

    Uploaded by

    FreddyChow
    The solver found an optimal solution that maximized total revenue within the given constraints. It took 14 iterations over 0.015 seconds. The objective cell for total revenue was originally $548,588 but was optimized to $1,272,000. Several variable cells representing numbers of bottles changed values from their original to final optimized values. All constraints were satisfied with their bounds.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 9

    Microsoft Excel 14.

    0 Answer Report
    Worksheet: [adm 2302 Assignment 2.xlsx]Sheet1
    Report Created: 29/10/2014 9:24:07 PM
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
    Engine: Simplex LP
    Solution Time: 0.015 Seconds.
    Iterations: 14 Subproblems: 0
    Solver Options
    Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
    Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegati

    Objective Cell (Max)


    Cell
    Name
    $M$4 Revenue Total Revenue

    Original Value
    548588.235294

    Final Value
    1272000

    Variable Cells
    Cell
    $B$3 Number
    $C$3 Number
    $D$3 Number
    $E$3 Number
    $F$3 Number
    $G$3 Number
    $H$3 Number
    $I$3
    Number
    $J$3
    Number
    $K$3 Number

    Original Value
    5000
    5000
    4000
    86598.0392157
    1000
    625
    666.666666667
    8659.80392157
    11875
    0

    Final Value
    12307.6923077
    12307.6923077
    96000
    96000
    2461.53846154
    1538.46153846
    16000
    9600
    0
    0

    of
    of
    of
    of
    of
    of
    of
    of
    of
    of

    bottle
    bottle
    bottle
    bottle
    bottle
    bottle
    bottle
    bottle
    bottle
    bottle

    Name
    X1
    X2
    X3
    X4
    A1
    A2
    A3
    A4
    M1
    M2

    Constraints
    Cell
    Name
    $L$13 Production First Year LHS
    $L$14 Production Second Year LHS
    $L$15 Chinon Production first year LHS
    $L$16 Chardonnay Production First Year LHS
    $L$17 Chinon Production Second year LHS
    $L$18 Chardonnay Production Second Year LHS
    $L$6 First Year Total used
    $L$7 Second Year Total used
    $L$9 Marketing Cost 1 LHS
    $L$10 Marketing Cost 2 LHS
    $L$11 Marketing Cost 3 LHS

    Cell Value

    Formula
    0 $L$13=$N$13
    0 $L$14=$N$14
    12307.6923077 $L$15>=$N$15
    12307.6923077 $L$16>=$N$16
    96000 $L$17>=$N$17
    96000 $L$18>=$N$18
    20000 $L$6=$N$6
    -2.546585E-011 $L$7=$N$7
    -1.818989E-012 $L$9<=$N$9
    0 $L$10<=$N$10
    -1.455192E-011 $L$11<=$N$11

    $L$12 Marketing Cost 4 LHS

    -2.910383E-011 $L$12<=$N$12

    s are satisfied.

    Assume NonNegative

    Integer
    Contin
    Contin
    Contin
    Contin
    Contin
    Contin
    Contin
    Contin
    Contin
    Contin

    Status
    Binding
    Binding
    Not Binding
    Not Binding
    Not Binding
    Not Binding
    Binding
    Binding
    Binding
    Binding
    Binding

    Slack
    0
    0
    8307.6923077
    7307.6923077
    92000
    91000
    0
    0
    0
    0
    0

    Binding

    Microsoft Excel 14.0 Sensitivity Report


    Worksheet: [adm 2302 Assignment 2.xlsx]Sheet1
    Report Created: 29/10/2014 9:24:08 PM

    Variable Cells
    Cell
    $B$3
    $C$3
    $D$3
    $E$3
    $F$3
    $G$3
    $H$3
    $I$3
    $J$3
    $K$3

    Number
    Number
    Number
    Number
    Number
    Number
    Number
    Number
    Number
    Number

    of
    of
    of
    of
    of
    of
    of
    of
    of
    of

    bottle
    bottle
    bottle
    bottle
    bottle
    bottle
    bottle
    bottle
    bottle
    bottle

    Name
    X1
    X2
    X3
    X4
    A1
    A2
    A3
    A4
    M1
    M2

    Final
    Reduced
    Value
    Cost
    12307.692308
    0
    12307.692308
    0
    96000
    0
    96000
    0
    2461.5384615
    0
    1538.4615385
    0
    16000
    0
    9600
    0
    0
    -55.65
    0
    -6.95

    Constraints
    Cell
    $L$13
    $L$14
    $L$15
    $L$16
    $L$17
    $L$18
    $L$6
    $L$7
    $L$9
    $L$10
    $L$11
    $L$12

    Name
    Production First Year LHS
    Production Second Year LHS
    Chinon Production first year LHS
    Chardonnay Production First Year LHS
    Chinon Production Second year LHS
    Chardonnay Production Second Year LHS
    First Year Total used
    Second Year Total used
    Marketing Cost 1 LHS
    Marketing Cost 2 LHS
    Marketing Cost 3 LHS
    Marketing Cost 4 LHS

    Final
    Value
    0
    0
    12307.692308
    12307.692308
    96000
    96000
    20000
    -2.54659E-011
    -1.81899E-012
    0
    -1.45519E-011
    -2.91038E-011

    Shadow
    Price
    -1.59
    0.7575
    0
    0
    0
    0
    63.6
    7.95
    12.72
    7.95
    1.325
    0.795

    Objective
    Allowable
    Allowable
    Coefficient
    Increase
    Decrease
    0 1.00000E+030
    90.43125
    0 1.00000E+030
    90.43125
    7.25 1.00000E+030 11.583333333
    6 1.00000E+030 11.583333333
    0 72.526315789
    452.15625
    0
    68.9
    723.45
    0 8.8333333333
    69.5
    0 8.4574468085 115.83333333
    0
    55.65 1.00000E+030
    1
    6.95 1.00000E+030

    Constraint
    Allowable
    Allowable
    R.H. Side
    Increase
    Decrease
    0 13194.444444 18620.689655
    0 185714.28571 180392.15686
    4000 8307.6923077 1.00000E+030
    5000 7307.6923077 1.00000E+030
    4000
    92000 1.00000E+030
    5000
    91000 1.00000E+030
    20000 1.00000E+030
    11875
    0 1.00000E+030 151666.66667
    0 14035.087719
    59375
    0 13333.333333
    95000
    0 106666.66667
    910000
    0 102127.65957 1516666.6667

    Number of bottle
    Revenue
    First Year
    Second Year
    Marketing Cost 1
    Marketing Cost 2
    Marketing Cost 3
    Marketing Cost 4
    Production First Year
    Production Second Year
    Chinon Production first year
    Chardonnay Production First Year
    Chinon Production Second year
    Chardonnay Production Second Year

    First Year Chinon First Year Chardonn


    X1
    X2
    5000
    5000
    0
    0
    0.7
    -7

    0.6
    -6

    1
    0
    0
    0
    1
    0
    1
    0
    0
    0

    0
    1
    0
    0
    -1
    0
    0
    1
    0
    0

    Second Year Second Year Marketing CostMarketing Cost


    Marketing CoMarketing Cost
    X3
    X4
    A1
    A2
    A3
    A4
    39000
    39000
    1000
    625
    6500
    3900
    7.25
    6
    0
    0
    0
    0
    0
    0.65

    0
    0.75

    1
    0

    1
    0

    0
    1

    0
    1

    0
    0
    1
    0
    0
    1
    0
    0
    1
    0

    0
    0
    0
    1
    0
    -1
    0
    0
    0
    1

    -5
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    -8
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    -6
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    -10
    0
    0
    0
    0
    0
    0

    Money left Money


    i
    left in Second yearTotal Revenue
    M1
    M2
    11875
    0
    0
    1
    516750
    Total used
    1
    0
    20000
    20000
    -1
    1
    -11875
    =
    0
    LHS
    0
    0
    0
    <=
    0
    0
    0
    0
    <=
    0
    0
    0
    0
    <=
    0
    0
    0
    0
    <=
    0
    0
    0
    0
    =
    0
    0
    0
    0
    =
    0
    0
    0
    5000
    =>
    4000
    0
    0
    5000
    =>
    5000
    0
    0
    39000
    =>
    4000
    0
    0
    39000
    =>
    5000

    You might also like