A rock company uses five types of rocks to fill six orders. The phosphate content, availability of each type of rock, and the production cost per pound for each rock are listed in the file P04_76.xlsx, as well as the size of each order and the minimum and maximum phosphate percentage in each order. What is the minimum total cost? $ 1225 What is the cheapest way to fill the orders? The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank Rock orders Rock type 1 2 Cost/1b $1.00 $5.00 $5.50 $2.00 $1.20 % phosphate 2.0% 5.0% 4.5% 3.0% 6.0% Amount (lbs) 8000 6000 7000 4000 3 4 5 4500 6 Order Size (lbs) Min % phosphate Max % phosphate 1 5000 3.5% 5 5500 2 6000 3.8% 4.6% 3 5000 4.0% 4.7% 4 3500 3.6% 4.8% 3.3% 3500 3.7% 4.8% 4.4% 4.7% A rock company uses five types of rocks to fill six orders. The phosphate content, availability of each type of rock, and the production cost per pound for each rock are listed in the file P04_76.xlsx, as well as the size of each order and the minimum and maximum phosphate percentage in each order. What is the minimum total cost? $ 1225 What is the cheapest way to fill the orders? The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank Rock orders Rock type 1 2 Cost/1b $1.00 $5.00 $5.50 $2.00 $1.20 % phosphate 2.0% 5.0% 4.5% 3.0% 6.0% Amount (lbs) 8000 6000 7000 4000 3 4 5 4500 6 Order Size (lbs) Min % phosphate Max % phosphate 1 5000 3.5% 5 5500 2 6000 3.8% 4.6% 3 5000 4.0% 4.7% 4 3500 3.6% 4.8% 3.3% 3500 3.7% 4.8% 4.4% 4.7%