INCLUDE EXCEL Step by Step:

Blueberries can be harvested using either a "wet" method or a "dry" method. Dry-harvested blueberries can be sold at a premium, while wet-harvested blueberries are used mainly for blueberry juice and bring in less revenue. Pearl Blueberry Cooperative must decide how much of its blueberry crop should be harvested wet and how much should be dry harvested.

Pearl Cooperative has 10,000 barrels of blueberries that can be harvested using either the wet or dry method. Dry blueberries are sold for $34.50 per barrel and wet blueberries are sold for $19.50 per barrel.

Once harvested, blueberries must be processed through several operations before they can be sold. Both wet and dry blueberries must go through dechaffing and cleaning operations. The dechaffing and the cleaning operations can each be run continuously for the whole season (with a total of 2,000 hours available for dechaffing and 3000 hours available for cleaning). Each barrel of dry blueberries requires 0.18 hours in the dechaffing operation and 0.32 hours in the cleaning operation.

Wet blueberries require 0.04 hours in the dechaffing operation and 0.10 hours in the cleaning operation. Wet blueberries must also go through a drying process. The drying process can also be operated continuously for the whole season (with a total of 2,000 hours available), and each barrel of wet blueberries must be dried for 0.22 hours.

1. Julian, a new intern at Pearl Blueberry who works under your supervision, has been tasked with converting the above statement into a linear programming model to determine the optimal number of barrels of blueberries to dry harvest and wet harvest such that sales are maximized. After hours of hard work over the past week, Julian has come up with the following formulation.

Minimize	34.5D	+19.5W
Subject to
	1D	+ 1W		10,000	Total Harvest
	0.18D	+ 0.04W		2000	Dechaffing
	0.32D	+ 0.10W		3000	Cleaning
		0.22W		2000	Drying
	D	, W		0

Double check the above linear programming formulation for accuracy and identify three areas where modifications are required. Re-write the modified linear programming formulation below.

1. Use Excel Solver to find a solution for the modified linear programming model in part (a).

How many barrels of blueberries should be dry harvested? (Round your answers to the nearest integer.)

How many barrels of blueberries should be wet harvested? (Round your answers to the nearest integer.)

What is the optimal value of the objective function?

1. Based on your answers in part (b), which constraints are binding, and which are non-binding in the modified linear programming model? Why? Explain.

1. Suppose that Pearl Cooperative is considering an increase in its cleaning capacity by hiring a third-party contractor. The contractor's quote for completing this task is $50 per hour. Should Pearl Cooperative proceed forward with this plan? Why or why not? Explain.

1. Pearl Cooperative is also considering an increase in its dechaffing capacity by hiring a different third-party contractor. The contractor's quote for completing this task is $50 per hour. Should Pearl Cooperative proceed forward with this plan? Why or why not? Explain.

1. Add an additional constraint to the modified linear programming formulation in part (a), requiring that the optimal decision variables take integer values only. Use Excel Solver to find a solution to this linear programming model.

How many barrels of blueberries should be dry harvested?

How many barrels of blueberries should be wet harvested?

What is the optimal value of the objective function?

Are your answers different compared to part (b)? Why? Explain.