Please submit using an excel spreadsheet with formulas and detailed instructions.

(Supply Chain Decisions) The Albers Milling Company buys corn and wheat and then grinds and blends them into two final products Fast-Gro and Quik-Gro. Fast-Gro is required to have at least 2.5% protein while Quik-Gro must have at least 3.2 % protein. Corn contains 1.9% protein while wheat contains 3.8% protein. The firm can do the buying and blending at either the Albers(A) plant or the Bartelso(B) plant. The blended products must then be shipped to the firm's two warehouse outlets, one at Carlyle(C) and the other at Damiansville(D). Current costs per bushel at the two plants are: A B 10 14 Corn Wheat 12 11 Transportation costs per bushel between the plants and warehouses are: Fast-Gro To C D A 1 From 2 0.75 B 3 Quik-Gro C D 3 From 3.5 1.9 B 4 The firm must satisfy the following demands in bushels at the warehouse outlets: Warehouse D Product Fast-Gro Quik-Gro 1,000 3,000 4,000 6,000 Formulate an LP useful in determining the purchasing, blending, and shipping decisions