The pine furniture company makes fine country furniture. The companys current product lines consist of end, tables, coffee, tables, and dining room tables. The production of each of these tables requires eight, 15, and 80 pounds of Pinewood, respectively. The tables are handmade and require one hour, two hours, and four hours, respectively. Each table sold generates $50, $100, and $220 profit, respectively. The company has 31,000 pounds of pinewood and 220 hours of labor available for the coming weeks 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.

Build a spreadsheet, model, and then solve it.

a. What should be the product mix for the coming week? End Tables? Coffee Tables? Dining Room Tables?

b. Determine the total profit.