Using Excel, formulate the following problem as a linear programming problem to maximize profit.

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 below. 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 800 kg.

	Grade	Grade	Grade	Available
	A	B	C	Resources
Labor hours	4	4	5	80 hr
Raw material #1	200	300	300	6,000 kg
Raw material #2	600	400	500	5,000 kg

Hint: The profits of $40, $50, and $60 are profits per kilogram, not per batch. The figures 800kg, 700kg, and 800kg are kilograms yielded from each batch. The required labor and materials are also for each batch. The maximized profit should be $480,000.