Problem Statement A regional shipping company's wants to maximize the total value of cargo loaded onto...

Transcribed Image Text:

Problem Statement A regional shipping company's wants to maximize the total value of cargo loaded onto a truck. The truck's maximum cargo capacity is 10,000 pounds. The cargo awaiting shipment is specified in Table 1. Each item represents a batch; therefore, a portion of an item can be shipped. (i.e., shipping the entire batch represents (1), shipping 30% of the batch represents (0.3). Table 1 Items Available for Shipment Item Values ($) Weight (lbs) 1 $ 22,500 7500 2 $ 24,000 7500 3 $ 8,000 3000 4 $ 9,500 3500 5 $ 11,500 4000 6 $ 9,750 3500 LP Model Formulation Steps 1. Define the decision variables 2. Define the objective function 3. Define the constraints Variables Objective Table Decision Variables Objective Function Constraints Table Constraint Variables Technical Coefficients Results Cell Reference LHS (units used) Type answer Questions to interpret the results of the regression analysis in the box 1. What is the maximum value of the cargo? 2. Which item # isthe most valuable cargo in the load? 3. What is the actual value of the second most valuable cargo in the load? 4. How many units of Item 6 were loaded? 5. How many units of Item 1 were loaded? 6. How many units of surplus are available for Item 1? 7. Which item #shave a surplus? 8. Which item #shave a slack? Constraint Sign Constraint RHS (constraint) Slack (-) or Surplus (+) Problem Statement A regional shipping company's wants to maximize the total value of cargo loaded onto a truck. The truck's maximum cargo capacity is 10,000 pounds. The cargo awaiting shipment is specified in Table 1. Each item represents a batch; therefore, a portion of an item can be shipped. (i.e., shipping the entire batch represents (1), shipping 30% of the batch represents (0.3). Table 1 Items Available for Shipment Item Values ($) Weight (lbs) 1 $ 22,500 7500 2 $ 24,000 7500 3 $ 8,000 3000 4 $ 9,500 3500 5 $ 11,500 4000 6 $ 9,750 3500 LP Model Formulation Steps 1. Define the decision variables 2. Define the objective function 3. Define the constraints Variables Objective Table Decision Variables Objective Function Constraints Table Constraint Variables Technical Coefficients Results Cell Reference LHS (units used) Type answer Questions to interpret the results of the regression analysis in the box 1. What is the maximum value of the cargo? 2. Which item # isthe most valuable cargo in the load? 3. What is the actual value of the second most valuable cargo in the load? 4. How many units of Item 6 were loaded? 5. How many units of Item 1 were loaded? 6. How many units of surplus are available for Item 1? 7. Which item #shave a surplus? 8. Which item #shave a slack? Constraint Sign Constraint RHS (constraint) Slack (-) or Surplus (+)