A image of what the excel would look like would be very helpful.

M55 A truck with the capacity to load 4,000 cubic feet of cargo is available to transport items selected from the. following table. ITEM VALUE $2,500 $1,400 $1,600 $900 $1,600 51,100 51,500 commander VOLUME (cu. ft.) 950 350 100 550 900 600 850 If selected, an item must be shipped in its entirety [i.e.no partial shipments or multiple shipments}. of items A, C, and G at least two of these items must be selected. If item C is selected, the E cannot be selected. The shipment must include at least five of these Items. Which of these items should be selected to maximize the value of the shipment? SOLUTION: The optimal solution, the value of the shipment, should be 53,100. All decision variables should be 0 or 1. Be sure to use standard LP template and Include the formulation In your Excel le. LEW Formulate this problem bv dening decision variables, obiective function, and constraints In standard format as specifiedj'demonstrated In videos. Questions a] Which items should be Included In the shipment? bi If the value of Item D increased to $1500 does this change the value of the shipment and the Items are included in the shipment? Explain