If you like a particular idea that someone has suggested, you can respond with that phrase. Of course, you can use another word instead of great to express approval or enthusiasm. For example, “fantastic”, “excellent”, “awesome” or “perfect”.
A: My mom is baking biscuits this afternoon. We could go to our house and eat some. How does that sound?
B: That sounds perfect!