Scm 16: Supply Chain Modeling & Optimization Session Linear Programming – II hw debrief February 1, 2023 Announcements

Download 89.67 Kb. Date 04.04.2023 Size 89.67 Kb. #61036

Navigate this page:

• Individual exercise
• Each acre planted with corn yields $3000 profit, needs 2 workers, 4 tons of fertilizer
• Workers needed/acre 3 2 Fertilizer needed/acre 2
• Decision variables: Constraints: Total number of workers used ≤ 1000
• Maximize total profit from farming wheat + corn Farming Wheat Corn (cont.) Resource Availability
• Profit/acre, $ 2000 3000 Objective: DV: Constraints
• = number of acres of corn planted Resource Availability Workers
• Wheat Corn Workers needed/acre 3 2
• Session Outline Summary Key Takeaways Algebraic formulation of an LP
• Chapter 3, WA: read p.87-90 and p.97-101

SCM 416: Supply Chain Modeling & Optimization Session 5 Linear Programming – II HW 1 Debrief February 1, 2023 Announcements HW 1 due now One-week turn around time for grading HW 2 posted Due February 8, 9:30 AM Individual exercise LP Example: Farming HW 1 Debrief Summary Session Outline Farmer, owns 450 acres of land, wants to plant each acre with wheat or corn Each acre planted with wheat yields $2000 profit, needs 3 workers, 2 tons of fertilizer Each acre planted with corn yields $3000 profit, needs 2 workers, 4 tons of fertilizer Example: Farming Wheat & Corn What is the best farming strategy of the farmer? Resource Availability Workers 1000 Fertilizer (tons) 1200 Acreage 450 Availability 1000 workers 1200 tons of fertilizers Wheat Corn Workers needed/acre 3 2 Fertilizer needed/acre 2 4 Profit/acre, $ 2000 3000 Objective: Decision variables: Constraints: Total number of workers used ≤ 1000 Total amount of fertilizer used (tons) ≤ 1200 (3) Total acreage planted ≤ 450 (4) DVs are non-negative (1) How many acres of wheat to plant (2) How many acres of corn to plant Wheat__Corn_(cont.)__Resource__Availability'>Maximize total profit from farming wheat + corn Farming Wheat & Corn (cont.) Resource Availability Workers 1000 Fertilizer (tons) 1200 Acreage 450 Wheat Corn Workers needed/acre 3 2 Fertilizer needed/acre 2 4 Profit/acre, $ 2000 3000 Objective: DV: Constraints: (2) (3) Maximize Farming: Algebraic Formulation = number of acres of wheat planted = number of acres of corn planted Resource Availability Workers 1000 Fertilizer (tons) 1200 Acreage 450 Wheat Corn Workers needed/acre 3 2 Fertilizer needed/acre 2 4 Profit/acre, $ 2000 3000 Let us look at Excel solution LP Example: Farming HW 1 Debrief Summary Session Outline Let us look at Excel solution LP Example: Farming HW 1 Debrief Summary Session Outline Summary & Key Takeaways Algebraic formulation of an LP Excel Solver solution Next Class: LP 3: Sensitivity Analysis Review Excel solution of the STC and farming examples Readings (see “Reading(s) by Date” folder on Canvas) Chapter 3, WA: read p.87-90 and p.97-101 Access to Excel will be needed Download 89.67 Kb. Share with your friends: