Scribd Logo
Upload

Welcome to Scribd!

  • 9 views

    5435778e8f136 Cepcom

    Uploaded by

    yiğit tirkeş
    The document summarizes the results of an optimization problem solved using Excel Solver. The objective was to minimize total cost, which was achieved at a value of $449460. The optimal solution involved producing 3000 units of product C303 and 777 units of C309 within integer constraints. All capacity constraints were satisfied with slack remaining. The solver found an integer solution in 1 iteration and 0.016 seconds.

    Copyright:

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

    5435778e8f136 Cepcom

    Uploaded by

    yiğit tirkeş
    9 views2 pages
    The document summarizes the results of an optimization problem solved using Excel Solver. The objective was to minimize total cost, which was achieved at a value of $449460. The optimal solution involved producing 3000 units of product C303 and 777 units of C309 within integer constraints. All capacity constraints were satisfied with slack remaining. The solver found an integer solution in 1 iteration and 0.016 seconds.

    Original Title

    5435778e8f136-Cepcom.xlsx

    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 document summarizes the results of an optimization problem solved using Excel Solver. The objective was to minimize total cost, which was achieved at a value of $449460. The optimal solution involved producing 3000 units of product C303 and 777 units of C309 within integer constraints. All capacity constraints were satisfied with slack remaining. The solver found an integer solution in 1 iteration and 0.016 seconds.

    Copyright:

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

    5435778e8f136 Cepcom

    Uploaded by

    yiğit tirkeş
    The document summarizes the results of an optimization problem solved using Excel Solver. The objective was to minimize total cost, which was achieved at a value of $449460. The optimal solution involved producing 3000 units of product C303 and 777 units of C309 within integer constraints. All capacity constraints were satisfied with slack remaining. The solver found an integer solution in 1 iteration and 0.016 seconds.

    Copyright:

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

    Microsoft Excel 14.

    0 Answer Report
    Worksheet: [New Microsoft Excel Worksheet.xlsx]Sheet1
    Report Created: 08.10.2014 19:10:15
    Result: Solver found an integer solution within tolerance. All Constraints are satisfied.
    Solver Engine
    Engine: Simplex LP
    Solution Time: 0,016 Seconds.
    Iterations: 1 Subproblems: 2
    Solver Options
    Max Time Unlimited, Iterations Unlimited, Precision 0,000001
    Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

    Objective Cell (Min)


    Cell Name Original Value Final Value
    $B$11 Toplam Maliyet C303 449460 449460

    Variable Cells
    Cell Name Original Value Final Value Integer
    $B$4 Üret C303 3000 3000 Integer
    $C$4 Üret C309 777 777 Integer
    $B$5 Satın al C303 0 0 Integer
    $C$5 Satın al C309 723 723 Integer

    Constraints
    Cell Name Cell Value Formula Status Slack
    $B$13 Toplam üret&satınal C303 3000 $B$13=$B$15 Binding 0
    $C$13 Toplam üret&satınal C309 1500 $C$13=$C$15 Binding 0
    $D$18 Üretim 1099.65 $D$18<=$F$18 Not Binding 0.35
    $D$19 Montaj 1177.35 $D$19<=$F$19 Not Binding 422.65
    $D$20 Paketleme 527.7 $D$20<=$F$20 Not Binding 372.3
    $B$4:$C$5=Integer
    Cepcom

    C303 C309
    Üret 3000 777
    Satın al 0 723

    C303 C309
    Üretim M. 80 130
    Satınalma M. 100 150

    Toplam Maliyet 449460

    Toplam üret&satınal 3000 1500


    = =
    3000 1500

    Kapasite kısıtları
    Üretim 0.25 0.45 1099.65 <= 1100
    Montaj 0.25 0.55 1177.35 <= 1600
    Paketleme 0.15 0.1 527.7 <= 900

    You might also like