Bus309: Excel

8. Rienzi Farms grows sugar cane and soybeans on its 500 acres of land. An acre of soybeans brings a $1000 contribution to overhead and profit; an acre of sugar cane has a contribution of $2000. Because of a government program no more than 200 acres may be planted in soybeans. During the planting season 1200 hours of planting time will be available. Each acre of soybeans requires 2 hours, while each acre of sugar cane requires 5 hours. The company seeks maximum contribution (profit) from its planting decision.

a. State the objective functions and constraints

b. What combination of sugar cane and soybeans will maximize contribution? (You may use Excel Solver or a graphical method)

Phantom Controls monitors and repairs control circuit boxes on elevators installed in multistory buildings in downtown Chicago. The company has the contract for 108 buildings. When a box malfunctions, Phantom installs a new one and rebuilds the failed unit in its repair facility in Gary, Indiana. The date for failed boxes over the last 2 years is shown in the following table: Simulate 2 years (24 months) of operation for Phantom and determine the average number of failed boxes per month from the simulation. Was it common to have fewer than 7 failures over 3 months of operation? (Start your simulation at the top of the 10th column of Table F.4 on page 795,RN=37, and go down in the table.) Phantom Controls monitors and repairs control circuit boxes on elevators installed in multistory buildings in downtown Chicago. The company has the contract for 108 buildings. When a box malfunctions, Phantom installs a new one and rebuilds the failed unit in its repair facility in Gary, Indiana. The date for failed boxes over the last 2 years is shown in the following table: Simulate 2 years (24 months) of operation for Phantom and determine the average number of failed boxes per month from the simulation. Was it common to have fewer than 7 failures over 3 months of operation? (Start your simulation at the top of the 10th column of Table F.4 on page 795,RN=37, and go down in the table.)