This excel picture is all that was given

Can you please answer the following in an EXCEL SPREADSHEET and show the formulas

(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 firms two warehouse outlets, one at Carlyle(C) and the other at Damiansville(D). Current costs per bushel at the two plants are:

A

B

Corn

10

14

Wheat

12

11

Transportation costs per bushel between the plants and warehouses are:

Fast-Gro

To

C

D

From

A

1

2

B

3

0.75

Quik-Gro

To

C

D

From

A

3

3.5

B

4

1.9

The firm must satisfy the following demands in bushels at the warehouse outlets:

Product

Warehouse

Fast-Gro

Quik-Gro

C

1,000

3,000

D

4,000

6,000

Formulate an LP useful in determining the purchasing, blending, and shipping decisions.

(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: Corn 10 14 Wheat | 12 | 11 Transportation costs per bushel between the plants and warehouses are: Fast-Gro From AL 1 2 B | 3 | 0.75 Quik-Gro To A From 3 4 3.5 1.9 B The firm must satisfy the following demands in bushels at the warehouse outlets: Product Warehouse Fast-Gro | Quik-Gro C 1 ,000 3,000 D 4,000 6,000 Formulate an LP useful in determining the purchasing, blending, and shipping decisions. (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: Corn 10 14 Wheat | 12 | 11 Transportation costs per bushel between the plants and warehouses are: Fast-Gro From AL 1 2 B | 3 | 0.75 Quik-Gro To A From 3 4 3.5 1.9 B The firm must satisfy the following demands in bushels at the warehouse outlets: Product Warehouse Fast-Gro | Quik-Gro C 1 ,000 3,000 D 4,000 6,000 Formulate an LP useful in determining the purchasing, blending, and shipping decisions