Solve in excel

1) The management feels that it is important to produce at least some Florida Mix. If the firm produced 10 jars of Florida Mix, the firm's profits would change as follows. (Answer the question using the report provided above.)

a) the profit would stay the same

b) it would drop by 10

c) It would drop by 20

d) It is impossible to answer without re-solving the problem in Excel because the reduced cost information is missing.

2) A company makes two products in a single plant. It runs this plant for 100 hours each week. Each unit of product A that the company produces consumes two hours of plant capacity, earns the company a contribution of $1000, and causes, as undesirable side effects, the emission of 4 ounces of particulates. Each unit of product B that the company produces consumes one hour of capacity earns the company a contribution of $2000, and causes, as undesirable side effects, the emission of 3 ounces of particulates and 1 ounce of chemicals. The EPA (Environmental Protection Agency) requires the company to limit the particulate emission to at most 240 ounces per week and chemical emission to at most 60 ounces per week.

Solve the problem in Excel and answer the following.

The management wants to reduce the number of hours that the plant operates by 10 hours per week. By how much will the plant's profit drop if the management's decision is adopted?

a) It will stay the same

b) 500

c) 850

d) 1250

3)

What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the LHS of constraint 1? Choose a formula that can subsequently be copied from the cell D8 and pasted to cells D9 and D10?

a) = SUMPRODUCT(B8:C8, B4:C4)

b) = SUMPRODUCT(B8:C8,$B$4:$C$4)

c) =SUM(B5:C5)

d) =SUM(E8:E10)

4) A company makes two products in a single plant. It runs this plant for 100 hours each week. Each unit of product A that the company produces consumes two hours of plant capacity, earns the company a contribution of $1000, and causes, as undesirable side effects, the emission of 4 ounces of particulates. Each unit of product B that the company produces consumes one hour of capacity earns the company a contribution of $2000, and causes, as undesirable side effects, the emission of 3 ounces of particulates and 1 ounce of chemicals. The EPA (Environmental Protection Agency) requires the company to limit the particulate emission to at most 240 ounces per week and chemical emission to at most 60 ounces per week.

The government wants to limit the plant's operations to 75 hours per week. The policy will have the following effect:

a) The release of particulates will drop by 30 ounces per week; the release of chemicals will remain the same.

b) The release of chemicals will drop by 10 ounces per week; the release of particulates will remain the same

c) The release of both chemicals and particulates will stay the same

d) None of the above

A firm produces jars of chilled fruit that are sold to restaurants. Three varieties of fruit are sold: California mix (x1), Florida mix (x2), and Hawaiian (x3). Each of the three fruit mixes are made by mixing oranges, grapefruit, and pineapple. A linear programming model for the process is Max 4 X1 + 3 x2 + 6 x3 s.t. Oranges: 3 X1 + 2 X2 + 1 X3 = 0 A B C D 1. 2 3 X1 X2 Objective 25 4 Number to make: 5 Unit profit: 61 7 Constraints: 8 Constraint 1 9 Constraint 2 | 10 | Constraint 3 LHS 6 4 RHS 1500 2700 800