Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Modelling

    Uploaded by

    nguyenlanquynh985
    The document presents information about maximizing profit from a farm with constraints on land, labor, and fertilizer. It provides crop options of oats, wheat, and corn with details on resources required and expected profit per acre. The optimal solution is shown to plant 80 acres of oats and 40 acres of wheat to maximize profit of $64,000 within the constraints.

    Copyright:

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

    Modelling

    Uploaded by

    nguyenlanquynh985
    8 views2 pages
    The document presents information about maximizing profit from a farm with constraints on land, labor, and fertilizer. It provides crop options of oats, wheat, and corn with details on resources required and expected profit per acre. The optimal solution is shown to plant 80 acres of oats and 40 acres of wheat to maximize profit of $64,000 within the constraints.

    Original Title

    modelling (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document presents information about maximizing profit from a farm with constraints on land, labor, and fertilizer. It provides crop options of oats, wheat, and corn with details on resources required and expected profit per acre. The optimal solution is shown to plant 80 acres of oats and 40 acres of wheat to maximize profit of $64,000 within the constraints.

    Copyright:

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

    Modelling

    Uploaded by

    nguyenlanquynh985
    The document presents information about maximizing profit from a farm with constraints on land, labor, and fertilizer. It provides crop options of oats, wheat, and corn with details on resources required and expected profit per acre. The optimal solution is shown to plant 80 acres of oats and 40 acres of wheat to maximize profit of $64,000 within the constraints.

    Copyright:

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

    x oats

    y wheat
    z corn
    120 = 120
    constraint 6400 <= 6500
    200 <= 200
    labor required fertilizer required expected profit number of crops
    z 50 1.5 500 80
    y 60 2 600 40
    z 105 4 950 0

    number of crops 80
    40 profit 64000
    0

    Variable Cells
    Final Reduced Objective
    Cell Name Value Cost Coefficient
    $B$12 acres planted oats 80 0 500
    $B$13 acres planted resources used per acre40 0 600
    $B$14 acres planted corn 0 -50 950

    Constraints
    Final Shadow Constraint
    Cell Name Value Price R.H. Side
    $C$4 land (acres) used 120 200 120
    $C$5 labour (hours) used 6400 0 6500
    $C$6 fertilizer (tons) used 200 200 200
    Allowable Allowable
    Increase Decrease The farm can maximize the profit by:
    12.5 1E+30 increase the fertilizer can maximize profit by: $ 1,000.00
    1E+30 10 increase the land used can maximize profit by: $ 1,000.00
    50 1E+30

    Allowable Allowable
    Increase Decrease
    5 20
    1E+30 100
    5 20

    You might also like