Spreadsheet eBook Check My Work In the Chandler blending model, suppose there is a chemical ingredient called C1 that both gasoline and heating oil need. At least 3% of every barrel of gasoline must be C1, and at least 5% of every barrel of heating oil must be C1. Suppose that 4% of all crude oil 1 is C1 and 6% of all crude oil 2 is C1. Given file P14_10.xlsx, modify the model to incorporate the constraints on C1, and then optimize. Don't forget to clear denominators. Has the optimal solution changed from the original blending model? Select + Explain. The previous solution Select because it Select the new constraints on chemical C1. Check My Work Properties of outputs Selling price per barrel Required quality level Oil blending model Properties of crude oil inputs Value per barrel Quality level Crude oil 1 $65 10 Crude oil 2 $50 5 Gasoline $75 8 Heating oil $60 6 Blending plan (barrels of crude in each output) Gasoline Heating oil Used Available Crude oil 1 Crude oil 2 Barrels sold Quality constraints with cleared denominators Quality obtained Quality required Objective to maximize Total revenue Gasoline Heating oil 5000 10000 Leftover