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. You must make 4 chairs for every table. Your answer will be the revenue generated by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs must be a whole number.) Scenario 1 Large wood per table 3 Small wood per table 2 Large wood per chair 1 Small wood per chair 4 Revenue per table $35 Revenue per chair $29 Large wood inventory 300 Small wood inventory 500
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. You must make 4 chairs for every table.
Your answer will be the revenue generated by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs must be a whole number.)
| Scenario 1 | |
| Large wood per table | 3 |
| Small wood per table | 2 |
| Large wood per chair | 1 |
| Small wood per chair | 4 |
| Revenue per table | $35 |
| Revenue per chair | $29 |
| Large wood inventory | 300 |
| Small wood inventory | 500 |
Let us assume x1 is the no of tables to be made
and x2 as the number of chairs to be made
Now, Arrange the given data into excel as shown below:
Enter the following parameters into SOLVER dialog box:
Final answer will be as follows:
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
