please show using excel splver feature simplex lp

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 amount of small wood pieces used by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs must be a whole number) Use Scenario 3 Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Large wood per Table 1 2 5 Small wood per Table 3 2 Large wood per Chair 1 3 3 1 Small wood per Chair 4 16 Revenue per Table $27 $23 $29 $18 $48 Revenue per Chair $17 $16 $21 Large wood inventory 85 90 100 B0 200 Small wood inventory 80 50 130 190 3 NN 13 3 2 4 3 4 $19 $43 50