Please use excel and Solver

Exhibit 2: Sample color ratings Exhibit 3: Sample acid values Exhibit 4: Sample Brix/Acid ratios Exhibit 5: Sample astringency of taste The analyst is aware of an agreement that PepLa signed with the state of Florida, which requires PepLa to buy at least 40% of its juice from its Florida supplier (namely Supplier 3) each month. This agreement allows PepLa to receive tax incentives and should not be violated under any circumstances. You need to help the analyst find a minimum cost procurement plan for the next three months. Hint: Before building the model, it is useful to compute the following quantities. 1. Compute the average quality parameters for juice from each of the 11 suppliers. 2. The demand of January is 900,000 gallons. If 900,000/11 gallons (approximately 81,819 ) are procured from each of the 11 suppliers, and are then blended together, what are the average quality parameters of the blended juice? Does it satisfy the quality requirement of Pepla? Problem 2 (3 points). Pepla Juice Blending An analyst at PepLa has been asked to prepare a plan for the procurement of orange juice from its suppliers to meet the demand of January, February, and March of the coming year. The forecasted demand is provided below. Quantities and quality of oranges vary from year to year. In order to produce consistently delicious orange juice, PepLa procures its juice from 11 suppliers worldwide located in the US, Brazil, India, China, Spain, Mexcio, Egypt and Italy. The juices are shipped from the suppliers to the blending facility of PepLa in Florida. (Juices shipped from different suppliers are blended at the blending facility.) Exhibit 1 below includes the list of all suppliers and for each supplier, the type of oranges, the country of origin, the total quantity available for purchase for January, February, and March of this coming year (three months combined), the price, and the shipping cost from the supplier to the blending facility of PepLa in Florida