(NEED HELP WITH EXCEL TABLE. ALL RELEVANT INFORMATION BELOW)

Formulas Share File Home Insert Draw Page Layout Data Review View Help Comments Insert Calibri 12 - A A 25 Wrap Text Accounting E - AY O Delete E $ ~ % " Cell Sort & Find & BIUT YAv Merge & Center Conditional Format as Analyze Sensitivity Paste E Formatting * Table Styles * Format Filter * Select Data Alignment Number Cells Analysis Sensitivity Font Styles Editing Clipboard X V A B C D E F G H J K L NAME: Scenario 2 Scenario 5 3 Scenario 1 Scenario 3 Scenario 4 Work with Contracting suppliers to Unit Cost Per Current with Premium correct Finding new Cost Element No. Units Frame Situation Steel problem Your Choice suppliers Example Materials (Raw Frames) 1150 $ 500.00 10 Materials (Finished Good Frames) 1000 $ 1,000.00 11 12 Machining (Labor & Overhead) $ 300.00 13 14 Production Disruption S 100.00 15 Supplier Problem Support 20.00 16 Lost Sales $ 50.00 17 Safety/Buffer Stock (15%) 100.00 18 Machinery Investment $ 150,000.00 19 20 Total Costs: 21 Savings: 22