linear programming solve using Excel solver

7-42 Outdoor Inn (see Problem 7-41) expanded its tent-making operations later in the year. While still making the Double Inn tent, it is also making a larger tent, the Family Rolls, which has four rooms. The company can produce up to a combined total of 280 tents per month. The following table provides the demand that must be met and the production costs for the next three months. Note that the costs will increase in month 2. The holding cost for keeping a tent in inventory at the end of the month for use in the next month is estimated to be $6 per tent for the Double Inn and $8 per tent for the Family Rolls. Develop a linear program to minimize the total cost. Solve it using any computer software. MONTH DEMAND FOR DOUBLE COST TO PRODUCE DOUBLE DEMAND FOR FAMILY COST TO PRODUCE FAMILY INN INN ROLLS ROLLS 1 185 $120 60 $150 2. . 205 $ 130 70 $160 3 225 $130 65 $160