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) 9. Customers arrive at Rich Dunn's Styling Shop at a rate of 3 per hour, distributed in a Poisson fashion. Rich can perform haircuts at a rate of 5 per hour, distributed exponentially. a) Find the average number of customers waiting for haircuts b) Find the average number of customers in the shop. c) Find the average time a customer waits until it is his or her turn. d) Find the average time a customer spends in the shop e) Find the percentage of time that Rich is busy 10. Phantom Controls monitors and repairs control circuit boxes on elevators installed in multistory buildings in downtown Chicago. The company has a 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.)
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)
9. Customers arrive at Rich Dunn's Styling Shop at a rate of 3 per hour, distributed in a Poisson fashion. Rich can perform haircuts at a rate of 5 per hour, distributed exponentially.
a) Find the average number of customers waiting for haircuts
b) Find the average number of customers in the shop.
c) Find the average time a customer waits until it is his or her turn.
d) Find the average time a customer spends in the shop
e) Find the percentage of time that Rich is busy
10. Phantom Controls monitors and repairs control circuit boxes on elevators installed in multistory buildings in downtown Chicago. The company has a 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.)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
