10. B C D E Bearland Manufacturing 1 2 3 4 5 6 Pallets 7 Profit 8 9 10 Glue 11 Pressing 12 Pine chips 13 Oak chips 14 Tahoe 9.285714 $450 Panel Type Pacific Savannah Aspen 15 47,857103 0 $1,150 $800 $400 $59,714 CE Resources Required per Pallet Type 50 50 100 50 50 150 100 50 500 400 300 200 500 750 250 500 Used 6.000 7.500 25,000 27 857 Available 6,000 quarts 7,500 hours 30,000 pounds 62,500 pounds CH Write the formula to calculate F7 using *sumproduct In Solver, which cell is the objective cell? In Solver, which are the changing variable cells? In solver, how would you write all four constraints as one constraint