Scribd Logo
Upload

Welcome to Scribd!

  • 10 views

    Decision Making - Solver

    Uploaded by

    Shubham Prabhat
    The document contains tables showing employee hours worked for different projects (P1, P2, P4, P5) and a warehouse assignment optimization problem. The employee hours table tracks hours worked by employees A, B, C, and D on various projects for a week. The warehouse tables show unit costs for customers (Cust 1, Cust 2, etc.) at each warehouse (WH1, WH2, etc.) and customer requirements that must be met through warehouse assignments.

    Copyright:

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

    Decision Making - Solver

    Uploaded by

    Shubham Prabhat
    10 views2 pages
    The document contains tables showing employee hours worked for different projects (P1, P2, P4, P5) and a warehouse assignment optimization problem. The employee hours table tracks hours worked by employees A, B, C, and D on various projects for a week. The warehouse tables show unit costs for customers (Cust 1, Cust 2, etc.) at each warehouse (WH1, WH2, etc.) and customer requirements that must be met through warehouse assignments.

    Original Description:

    Decision making example with Solver formula.

    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 contains tables showing employee hours worked for different projects (P1, P2, P4, P5) and a warehouse assignment optimization problem. The employee hours table tracks hours worked by employees A, B, C, and D on various projects for a week. The warehouse tables show unit costs for customers (Cust 1, Cust 2, etc.) at each warehouse (WH1, WH2, etc.) and customer requirements that must be met through warehouse assignments.

    Copyright:

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

    Decision Making - Solver

    Uploaded by

    Shubham Prabhat
    The document contains tables showing employee hours worked for different projects (P1, P2, P4, P5) and a warehouse assignment optimization problem. The employee hours table tracks hours worked by employees A, B, C, and D on various projects for a week. The warehouse tables show unit costs for customers (Cust 1, Cust 2, etc.) at each warehouse (WH1, WH2, etc.) and customer requirements that must be met through warehouse assignments.

    Copyright:

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

    Hours P1 P2 P4 P5

    A 26 25 9 20
    B 15 20 7 11
    C 17 14 5 25
    D 21 29 27 8

    Assign P1 P2 P4 P5
    A 0
    B 0
    D 0
    E 0
    0 0 0 0

    Total Cost 0
    Unit Cost Cust 1 Cust 2 Cust 3 Cust 5 Capacity
    WH 1 35 15 30 5 1000
    WH 2 45 50 35 15 400
    WH 3 40 5 40 5 300
    WH 5 15 45 5 45 500
    Requirement 600 600 200 200

    Assignment Cust 1 Cust 2 Cust 3 Cust 5 Capacity


    WH 1 0
    WH 2 0
    WH 3 0
    WH 5 0
    Rquirement 0 0 0 0 0

    You might also like