This spreadsheet Supports Student analysis Of the case, "Deutsche Brauerei" (UVA *-1355 v. 1.2). please note: I) This is a working model. Assumptions I Inputs presented Can be changed to Vary the results. 2) This model intentionally incorporates a circular reference in its logit. In Order to resolve this Circularity, please instruct Excel to "iterate" 20 or so times in recalculating the model. This may be done by Clicking on Tools"OptiongJCalculation, and then on Iteration. 3) AS long as default spreadsheet calculation is Set as "automatic" impact Of Changing assumptions Will be tasmputed in real time. Alternatively FS function key may need to be invoked to recalculate results. TO Set numerical calculation settings to automatic 100k under tools. options, calculations menu. Revised. December 14. 2001. Copyright (C) 2001 by the the university Mrginia Darden School Foundation.