Question: Please provide work in excel. DO NOT round any number, and please keep at least 2 decimal places for the answers. Problems #2 need to

Please provide work in excel.

DO NOT round any number, and please keep at least 2 decimal places for the answers. Problems #2 need to be solved by the graphical method, not the corner point method. Excel wont generate graphs for you, you need to create the lines on Excel spreadsheet. Do NOT use QM for Windows.

The seasonal yield of olives in a Piraeus, Greece, and vineyard is greatly influenced by a process of branch pruning. If olive trees are pruned every two weeks, output is increased. The pruning process , however, requires considerably more labor then permitting the olives to grow on their own and results in a smaller size olive. It also, though, permits olive trees to be spaced closer together. The yield of 1 barrel of olives by pruning requires 6 hours of labor and 3 acres of land. The production of a barrel of olives by the normal process requires only 5 labor hours but takes 10 acres of land. An olive grower has 410 hours of labor available and a total of 330 acres for growing. Because of the olive size difference, a barrel of olives produced on pruned trees sells for $32, whereas a barrel of regular olives has a market price of $30. The grower has determined that because of uncertain demand, no more than 40 barrels of pruned olives should be produced. Use the graphical method to find

(a) The maximum possible profit. (b) The best combination of barrels of pruned and regular olives. (c) The number of acres that the olive grower should devote to each growing process.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!