The seasonal yield of olives in a Piraeus, Greece, vineyard is greatly influenced by a process of branch pruning. If olive trees are pruned every two weeks, the output is increased. The pruning process, however, requires considerably more labor than permitting the olives to grow on their own and results in a smaller size olive. It also permits olive trees to be spaced closer together. The yield of 1 barrel of olives by pruning requires 5 hours of labor and 1 acre of land. The production of a barrel of olives by the normal process requires only 2 labor hours but takes 2 acres of land. An olive grower has 240 hours of labor available and a total of 150 acres for growing. Because of the olive size difference, a barrel of olives produced on pruned trees sells for $20, whereas a barrel of regular olives has a market price of $35. The grower has determined that because of uncertain demand, no more than 40 barrels of pruned olives should be produced. Use LP to find the maximum possible profit. the best combination of barrels of pruned and regular olives. the number of acres that the olive grower should devote to each growing process. Can you show me how to solve this using excel
The seasonal yield of olives in a Piraeus, Greece, vineyard is greatly influenced by a process of branch pruning. If olive trees are pruned every two weeks, the output is increased. The pruning process, however, requires considerably more labor than permitting the olives to grow on their own and results in a smaller size olive. It also permits olive trees to be spaced closer together. The yield of 1 barrel of olives by pruning requires 5 hours of labor and 1 acre of land. The production of a barrel of olives by the normal process requires only 2 labor hours but takes 2 acres of land. An olive grower has 240 hours of labor available and a total of 150 acres for growing. Because of the olive size difference, a barrel of olives produced on pruned trees sells for $20, whereas a barrel of regular olives has a market price of $35. The grower has determined that because of uncertain demand, no more than 40 barrels of pruned olives should be produced. Use LP to find
- the maximum possible profit.
- the best combination of barrels of pruned and regular olives.
- the number of acres that the olive grower should devote to each growing process.
Can you show me how to solve this using excel
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 11 images
