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 5 Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Large wood per Table 1 Small wood per Table 3 Large wood per Chair 1 Small wood per Chair 4 Revenue per Table $27 Revenue per Chair $17 Large wood inventory 85 Small wood inventory 80 2 3₂ 2 4 $23 $16 90 50 223 3 $29 $19 100 50 333 4 $18 $21 80 130 552 1 6 $48 $43 200 190
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 5 Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Large wood per Table 1 Small wood per Table 3 Large wood per Chair 1 Small wood per Chair 4 Revenue per Table $27 Revenue per Chair $17 Large wood inventory 85 Small wood inventory 80 2 3₂ 2 4 $23 $16 90 50 223 3 $29 $19 100 50 333 4 $18 $21 80 130 552 1 6 $48 $43 200 190
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 40P
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 5 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,