It should include: 1. Spreadsheet Model with Solver setup 2%. 2. User Interface (be sure to set Object Properties as appropriate. 2% 3. VBA Code to link Model and Interface 2% 4. VBA Code for Formatting 2% 5. VBA Code for Error Trapping 2% Cranberries can be harvested using either a "wet" method or "dry" method. Dry-harvested cranberries can be sold at a premium, while wet harvested cranberries are used mainly for cranberry juice and bring in less revenue. Fresh Made Cranberry Cooperative must decide how much of its cranberry crop should be harvested wet and how much should be dry harvested. Fresh Made has 5000 barrels of cranberries that can be harvested using either the wet or dry method. Dry cranberries are sold for $32.50 per barrel and wet cranberries are sold for $17.50 per barrel. Once harvested, cranberries must go through dechaffing and cleaning operations. The deshaffing and the cleaning operations can each be run 24 hours per day for the 6-week seasons (for a total of 1,008 hours). Each barrel of dry cranberries requires 0.18 hours in the deshaffing operation and 0.32 hours in the cleaning operation. Wet cranberries require 0.04 hours in the dechaffing operation and 0.10 hours in the cleaning operation. Wet cranberries must also go through a dry process. The drying process can also be operated 24 hours per day for the 6-week season, and each barrel of wet cranberries must be dried for 0.22 hours. Let W = barrels of cranberries harvested using wet method Let D = barrels of cranberries harvested using dry method Max 17.5 W + 32.5 D Siti 1 W + 1D