We are supposed to use linear programming and the Solver tool in Excel to come to the answer. The format above is the example of the setup in Excel, but I don't understand how to input and organize the data.

Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory, selling price, and Bill of Materials (recipe, or construction requirements). You are to determine the number of Tables and Chairs to be built to maximize revenue. Your answer will be the revenue generated by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs may not be a whole number, which is acceptable in this chapter.)