*** I need the excel sheet set up along with the excel solver answers. I am having trouble setting up the table to get the excel solver results.

A phosphate manufacturer produces three grades of phosphate, A, B, and C, which yield profit of $40, $50, and $60 per kilogram, respectively. The products require the labor and materials per batch that are shown in the table. Each batch of Grade A phosphate yields 800kg of phosphate; each batch of Grade B phosphate yields 700kg of phosphate; and each batch of Grade C phosphate yields 800kg of phosphate.

Grade AGrade B Grade CAvailable Resources

Labor hours44580hr

Raw material 12003003006,000 kg

Raw material 26004005005,000 kg

Formulate as an LP problem to maximize profit. What mix of products would yield maximize profit? (Use excel solver to find the optimal solution).