A furniture company manufactures tables and chairs. A table requires 45 board-feet of wood, and a chair requires 20 board-feet of wood. Wood can be purchased at a cost of $1.90 per board-foot, and 25,000 board-feet of wood are available for purchase. It takes 2.5 hours of skilled labor to manufacture an unfinished table or an unfinished chair. Then 3 more hours of skilled labor will turn an unfinished table into a finished table, and 1.5 more hours of skilled labor will turn an unfinished chair into a finished chair. A total of 4500 hours of skilled labor is available (and have already been paid for). All furniture produced can be sold at the following unit prices: an unfinished table, $180; a finished table, $330; an unfinished chair, $130; and a finished chair, $200. a. Determine how to maximize the company's profit from manufacturing tables and chairs. using Excel solver
A furniture company manufactures tables and chairs.
A table requires
45 board-feet of wood, and a chair requires
20 board-feet of wood. Wood can be
purchased at a cost of $1.90 per board-foot, and 25,000
board-feet of wood are available for purchase. It takes
2.5 hours of skilled labor to manufacture an unfinished
table or an unfinished chair. Then 3 more hours of
skilled labor will turn an unfinished table into a finished
table, and 1.5 more hours of skilled labor will
turn an unfinished chair into a finished chair. A total of 4500 hours of skilled labor is available (and have already
been paid for). All furniture
produced can be sold
at the following
unit prices: an unfinished table, $180;
a finished
table, $330; an unfinished chair, $130; and a
finished
chair, $200.
a. Determine how to maximize the company's profit
from manufacturing tables and chairs.
using Excel solver
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)