What does the colour formatting in columns F and G indicate?

1. What does the colour formatting in columns F and G indicate?

2. Using Solver, what is the ideal solution it the target gross margin is 24%, if at least 500 units are sold?

3. How does the colour scheme in question 1 relate to your response to question 2?

4. Under which circumstances would gross profit be set at a specific limit rather than optimized for maximum profit?

5. What is the maximum profit that this store could earn if the constraint was that they can sell no more than 850 items (and there was no constraint on profit margin percentage)?

6. Under the solution to question #5, what is the average gross profit margin?