Can you please answer the following in an EXCEL SPREADSHEET and show the formulas (this is all that's given)

(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.