File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 12 - ' '...

Transcribed Image Text:

File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 12 - ' ' Wrap Text Accounting Paste BIU Merge & Center $ % 908-08 Font F Alignment Number Clipboard F9 Conditional Format as Formatting Table Styles Styles Insert Delete Cell Format Cells +M Select Sort & Find & Filter Editing 3 A B C NAME: Scenario 1 Scenario 2 H Scenario 3 K Scenario 4 Scenario 5 4 5 6 7 Cost Element No. Units Unit Cost Per Frame Current Situation Contracting with Premium Steel Work with suppliers to correct problem Finding new Your Choice suppliers 8 Example 9 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 $ 100.00 15 Supplier Problem Support $ 20.00 16 17 18 19 20 Lost Sales Safety/Buffer Stock (15%) Machinery Investment Total Costs: $ 150,000.00 $ 50.00 $ 100.00 21 Savings: 22 Comments Share Analyze Sensitivity Data Analysis Sensitivity File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 12 - ' ' Wrap Text Accounting Paste BIU Merge & Center $ % 908-08 Font F Alignment Number Clipboard F9 Conditional Format as Formatting Table Styles Styles Insert Delete Cell Format Cells +M Select Sort & Find & Filter Editing 3 A B C NAME: Scenario 1 Scenario 2 H Scenario 3 K Scenario 4 Scenario 5 4 5 6 7 Cost Element No. Units Unit Cost Per Frame Current Situation Contracting with Premium Steel Work with suppliers to correct problem Finding new Your Choice suppliers 8 Example 9 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 $ 100.00 15 Supplier Problem Support $ 20.00 16 17 18 19 20 Lost Sales Safety/Buffer Stock (15%) Machinery Investment Total Costs: $ 150,000.00 $ 50.00 $ 100.00 21 Savings: 22 Comments Share Analyze Sensitivity Data Analysis Sensitivity