1/

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 (Ibs) 1 S 22,500 7500 2 S 24,000 7500 3 S 8,000 3000 4 S 9,500 3500 5 S 11,500 4000 6 S 9,750 3500LP Model Formulation Steps 1. Define the decision variables 2. Define the objective function 3. Define the constraintsVariables Objective Table Decision Variables + Objective Function Constraints Table Cell Reference Constraint LHS RHS Constraint Sign Slack (-) or Constraint Variables Technical Coefficients (units used) (constraint) Surplus (+)Results Questions to interpret the results of the regression analysis Type answer in the box 1. What is the maximum value of the cargo? 2. Which item # is the 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 #s have a surplus? 8. Which item #s have a slack