Optimizing Study Hours for Higher GPA: Scenarios Explained
School
KL University**We aren't endorsed by this school
Course
EEE 12
Subject
Industrial Engineering
Date
Dec 10, 2024
Pages
7
Uploaded by CoachBookMonkey77
Product 1Product 2Product 3Technician A23Technician B2.53Technician C4Technician D3.5Profit per unit6710ResultsTechnicianProduct 1Product 2Product 3Total HoursA3020120B480120C030120D034.285714119.999999Total Units7834.28571450Product Profit468239.999998500Total Profit1207.999998
Data Solver ConstraintsTechnician A's Hours:2×A_prod1+3×A_prod3≤120Technician B's Hours2.5×B_prod1+3×B_prod2≤120Technician C's Hours4×C_prod3≤120Technician D's Hours3.5×D_prod2≤120Product 1 UnitsA_prod1+B_prod1≤80Product 2 UnitsB_prod2+D_prod2≤50Product 3 UnitsA_prod3+C_prod3≤50
Question 2b: Water DistribWater Demand (billion gallons)RegionDemandNorthern100Central100Southern100Shipping Costs (thousands of dollars per billion gallons)OriginDestinationCostNorthernCentral7NorthernSouthern10CentralNorthern7CentralSouthern6SouthernNorthern10SouthernCentral5Initial Surpluses and DeficitsRegionAmount (billion gallons)Northern Surplus20Central Surplus20Southern Deficit60Optimal Shipping AmountsShipping RouteAmount (billion gallons)CostNorthern to Central0Northern to Southern0Central to Northern40280Central to Southern120720Southern to Northern0Southern to Central120600
butionWater Supply (billion gallons)RegionSupplyNorthern120Central120Southern40Shortage Costs (thousands of dollars per billion gallons)RegionCostNorthern6Central5Southern9Initial Shortage CostsRegionCost (thousands of dollars)Northern120000Central100000Southern540000Total Cost$1600000Cost (thousands of dollars) 1600
Hours Calculus Chemistry Physics EconomicsSubject1-575766585Calculus6-1084878192Chemistry11-1593949197PhysicsEconomicsConstraints(Same applied in solver)Total HoursTotal Hours <= 35Physics >= 2 * EconomicsCalculus between Physics and EconomicsScenariSubjectCalculusChemistryPhysicsEconomics
HoursGPARange Using VLOOKUP1593931767615919148585)35Overall GPA186.2511io -2 HoursGPARange Using VLOOKUP6.2584841087876.25818112.59797Overall GPA87.25ConclusionIn Scenario 1, the student allocates significant timCalculus and Physics, achieving an overall GPA oIn Scenario 2, the student adopts a more balancedwith fractional study hours, resulting in a higher oGPA of 87.25.Both scenarios show strong GPA outcomes, with 2 offering a marginally better GPA due to a more distributed study schedule and higher GPA valuesEconomics. However, Scenario 2's fractional hours are valid ohalf-hour increments are permitted. Scenario 1 hithe benefit of concentrating study time on high-Gsubjects to achieve a strong overall performance.
me to of 86.25. d approach overall Scenario evenly s in only if ighlights GPA .