DESIGN A SPREADSHEET THAT CAN BE USED TO EVALUATE AGGREGATE PLANS. THE SPREADSHEET SHOULD ENABLE THE EVALUATION OF: L. PURE STRATEGY BASED ON LEVELING PRODUCTION, 2 PURE STRATEGY BASED ON MINIMIZING INVENTORY BY L.AYING OFFHIRING AS NEFDED, 3. A MIX OF THE ABOVE TWO. THE SPREADSHEET SHOULD HAVE THE FOLLOWING HEADINGS: ALL BUT COLUMNS 1, 2, AND 4 SHOULD BE COMPUTED USING CELL. FORMULAS. COLUMN 5 SHOULD ALLOW FOR USING CELL. FORMULAS IN THE CASE OF LEVEL PRODUCTION OR DIRECT INPUT FOR MIXED PLANS, THE COST OF ANY PLAN, IN TOHAL AND FOR EACH COST COMPONENT, SHOLLD BE COMPUTED WTHOUT ADDITONAL FFORT. ASSUME AN 8.MONTH HORIZON AND USE THE FOLLOWNG DATA TO TEST YOUR SPREADSHEET: Previous Next