New Exercise Bank Content Qu$.07-02$

$10$ The Pine Furniture Company makes fine country furniture. The company's polnts

current product lines consist of end tables, coffee tables, and dining room tables. The production of each of these tables requires $8,15,$ and $80$ pounds of pine wood, respectively: The tables are handmade and require one hour, two hours, and four hours, respectively. Each table sold generates $\backslash (\backslash$$ $50.\backslash$$ $100\backslash ),$ and $\backslash (\backslash$$ $220\backslash )$ profit, respectively. The company has $2,900$ pounds of pine wood and $180$ hours of labor available for the coming week's production. The chief operating officer $($COO$)$ has asked you to do some spreadsheet modeling with these data to analyze what the product mix should be for the coming week and make a recommendation.

Click here for the Excel Data File

Buld a spreadsheet model and then solve it$.$

a$.$ What should be the product mix for the coming week?

b$.$ Determine the total profit.

Complete this question by entering your answers in the tabs below.

G