please show spreadsheet

USE THE FIRST 7 LETTERS (OR LESS FOR SHORTER NAMES) OF YOUR LAST NAME FOLLOWED BY THE HOMEWORK NUMBER TO NAME THE FILE (FOR EXAMPLE KHOUJA2) AND SUBMIT THE HOMEWORK ON CANVAS. DESIGN A SPREADSHEET THAT CAN BE USED TO EVALUATE AGGREGATE PLANS. THE SPREADSHEET SHOULD ENABLE THE EVALUATION OF: 1. PURE STRATEGY BASED ON LEVELING PRODUCTION, 2. PURE STRATEGY BASED ON MINIMIZING INVENTORY BY LAYING OFF/HIRING AS NEEDED, 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 TOTAL AND FOR EACH COST COMPONENT, SHOULD BE COMPUTED WITHOUT ADDITIONAL EFFORT. ASSUME AN 8-MONTH HORIZON AND USE THE FOLLOWING DATA TO TEST YOUR SPREADSHEET: 1. PURE STRATEGY BASED ON LEVELING PRODUCTION, 2. PURE STRATEGY BASED ON MINIMIZING INVENTORY BY LAYING OFF/HIRING AS NEEDED, 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 TOTAL AND FOR EACH COST COMPONENT, SHOULD BE COMPUTED WITHOUT ADDITIONAL EFFORT. ASSUME AN 8-MONTH HORIZON AND USE THE FOLLOWING DATA TO TEST YOUR SPREADSHEET