A chair furniture manufacturer makes 21 different types of chairs, which are categorize into single-seat chairs or multiple seat chairs.

A chair furniture manufacturer makes 21 different types of chairs, which are categorize into single-seat chairs or multiple seat chairs. The manufacturer can make at most three times as many single set chairs as multiple seat chairs. There are 5000 machine hours and $15000 production budget available each month. The manufacturer has recorded data for 12 months regarding its production quantities, raw materials costs; total machine hours used, and total sales for each week for each chair. This data is stored in the Excel file named ch3_P1chairproduction and can be downloaded from the companion website at.