Show me the steps to solve step by step using Excel solver:

The Flair Furniture Company produces inexpensive tables and chairs. Processes are similar in that both require a certain number of hours of carpentry work and in the painting and varnishing department. Each table takes $4$ hours of carpentry and $2$ hours of painting and varnishing. Each chair requires $3$ of carpentry and $1$ hour of painting and varnishing. There are $240$ hours of carpentry time available and $100$ hours of painting and varnishing Each table yields a profit of $$70$ and each chair a profit of $$50.$ Find the number of tables and chairs that Flair Furniture Company could produce to maximize their profit using excel solver.