Linear Programming Final Exam Spring 2010

Begin each essay on a separate page.

Write an integrated, holistic essay that explains the overall business meaning of columns G, H, I, and J of the "Warehouse location" tab of the "Toxic Waste Cleanup" spreadsheet from March 15. Use sentences and paragraphs. Do not use bullet points or tables. Do not try to explain the cells one-by-one; their meaning comes from the interrelationships among them. Consideration of the constraints that tie these cells together is essential to the essay.

Assume the reader is already thoroughly familiar with the other tabs of the spreadsheet; in other words, don't include any detailed discussion of columns A through F.

Write an integrated, holistic essay that compares and contrasts the answer & sensitivity reports of the "Home Theaters" spreadsheet from March 29 without supplementary variables versus the answer & sensitivity reports of the Home Theaters spreadsheet with supplementary variables. Do not just summarize each report separately. Explain all jargon in terms the manager of an electronics store could easily understand. Use sentences and paragraphs. Do not use bullet points or tables.

Assume the reader is thoroughly familiar with the business of installing home theaters, including all the resources and constraints, but is completely ignorant of LP jargon.

Write an integrated, holistic essay that compares and contrasts the possible reasons why the persons who manage the company modeled in the spreadsheet "WidgetGoal.xls" from April 19 might be motivated to consider each of the models represented by the various tabs of that spreadsheet.

Note: It makes no sense to try to use LP or goal programming jargon to talk about the reasons why persons might be motivated to do something! Don't confuse "why" with "how."

Do not just summarize each model separately. Use sentences and paragraphs. Do not use bullet points or tables.