MGOC10H3 Lecture Notes - Lecture 6: Susan Boyle, Microsoft Excel, Gerontology Research Group
Document Summary
The issue at hand was to determine the optimal amount of dry and wet cranberries to harvest through the development of a linear programming model. A brief summary of the key findings are noted below. In order to maximize revenue, the model indicates that the optimal amount to harvest would be. 2309 dry barrels and 2690 wet barrels of cranberries. A total of 523. 27 hours are being used for dechaffing operations from a capacity of 1008 for dry cranberries. 1008 hours are being used for drying operations for dry cranberries and a total of 1008 hours out of 1008 hours are being used for cleaning operations for dry cranberries. The cleaning hours are being used at capacity. Lastly, according to the model, revenue is being maximized at $ Please see below for further information regarding the details of our findings through the linear programming model: let wc = the number of wet cranberries that are manufactured.