Excel File Edit View Insert Format Tools Data Window Q 2 # Sat Nov 20 10:01 AM Help 2. #13 Decision Trees & Cost Effectiveness-Student - AutoSave OFF MB G. a SP Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments 14 Footlight MT .A AA = O sy & Wrap Text General IXE y O v Peste B TV OA = = = - + $ % % Insert Merge & Center Conditional Format Cell Formatting as Table Styles Delete Format Sort Filter Find & Select Analyze Data W31 X B C D E E F 6 H 1 K L M N N 0 Q R 5 T U 1 2 39% Which program was the most cost effective? $26,834 $ 24% Progrin A increased productivity from 125 purts per day to 190 parts per day. The program costs $13, 045. $19,546 A A 13 20% C $13,009 TOTAL COST Program B incrcased productivily from 125 parts per day lo 208 paris per day. The program costs $13,399. D 17% $10.099 3 . 4. 5 6 6 7 8 9 10 11 12 13 14 = 15 16 17 ODUCT SHOULD THE 18 Frogrin Cincreased productivity from 125 parts per day to 237 purts per day. The progrin costs $19,376 20 points 15 points 19 ANY CONTINUE? 13% $11,221 20% $15,930 Which project below should be selected if the dollars represent net incomc? (dollars arc in millic II G 22% Averige Net Income $17,089 20 21 22 23 = = 24 25 26 27 28 29 30 TOTAL COST Project A Project B Project C 1455 Northeast Midwest Southeast Northwest Southwest 20% 35% 28% 10% 10% $5 $7 $4 S3 S2 $4 $8 $3 S2 S2 $7 $4 $4 $3 E * 45% $29,110 % 10 point Sheet1 + Ready + 100% Thur Excel File Edit View Insert Format Tools Data Window Q8 + Sat Nov 20 10:02 AM Help 2 #13 Decision Trees & Cost Effectiveness-Student AutoSave OFF MB G. a SP Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments . Or Peste Footlight MI v 14 . A AA = O 9. Wao Text General LYHH v B TV 11 OA = == +E Merge & Centar $ % % Conditional Format Cell Insert Delete Format Sort Find & Analyze Formatting as Table Styles Filter Select Data W31 Xfx x A B C D F G H 1 ! K M N 0 0 R S 16 20 points 17 WHICH PRODUCT SHOULD THE 18 COMPANY CONTINUE? 15 points 19 13% $11,221 20 21 20% $15,930 Which project below should be selected if the dollars represenl net incomcy (do 22 H 23 Product Y Cost = G Northeast Midwest Southcast Northwest Southwest A 24 22% S17,089 20% 95% 25% 10% 10% Net 25 F Project A 35 $7 S3 TOTAL COST $2 26 Projects $1 $8 3 $3 SZ $2 27 E Project C $7 $4 $6 S4 $3 28 $ 29 30 31 32 Big Boss Sue has two options of which she can only choose one. She can hire a sales executive for $60,000. This executive will generate stines 13 that much in net income per year for her firm. Or, she could pay $175,000 for a machine that will save her firm $515,000 per year. 34 Lising COST/BENEFIT analysis, which choice should she make? Show your work. 5 points 35 COST BENEFIT C/B Analysis 36 SALES EXEC 37 MACHINE 38 39 40 41 45% 28,110 42 43 44 45 46 Sheet1 + Ready + 100% Thur Excel File Edit View Insert Format Tools Data Window Q 2 # Sat Nov 20 10:01 AM Help 2. #13 Decision Trees & Cost Effectiveness-Student - AutoSave OFF MB G. a SP Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments 14 Footlight MT .A AA = O sy & Wrap Text General IXE y O v Peste B TV OA = = = - + $ % % Insert Merge & Center Conditional Format Cell Formatting as Table Styles Delete Format Sort Filter Find & Select Analyze Data W31 X B C D E E F 6 H 1 K L M N N 0 Q R 5 T U 1 2 39% Which program was the most cost effective? $26,834 $ 24% Progrin A increased productivity from 125 purts per day to 190 parts per day. The program costs $13, 045. $19,546 A A 13 20% C $13,009 TOTAL COST Program B incrcased productivily from 125 parts per day lo 208 paris per day. The program costs $13,399. D 17% $10.099 3 . 4. 5 6 6 7 8 9 10 11 12 13 14 = 15 16 17 ODUCT SHOULD THE 18 Frogrin Cincreased productivity from 125 parts per day to 237 purts per day. The progrin costs $19,376 20 points 15 points 19 ANY CONTINUE? 13% $11,221 20% $15,930 Which project below should be selected if the dollars represent net incomc? (dollars arc in millic II G 22% Averige Net Income $17,089 20 21 22 23 = = 24 25 26 27 28 29 30 TOTAL COST Project A Project B Project C 1455 Northeast Midwest Southeast Northwest Southwest 20% 35% 28% 10% 10% $5 $7 $4 S3 S2 $4 $8 $3 S2 S2 $7 $4 $4 $3 E * 45% $29,110 % 10 point Sheet1 + Ready + 100% Thur Excel File Edit View Insert Format Tools Data Window Q8 + Sat Nov 20 10:02 AM Help 2 #13 Decision Trees & Cost Effectiveness-Student AutoSave OFF MB G. a SP Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments . Or Peste Footlight MI v 14 . A AA = O 9. Wao Text General LYHH v B TV 11 OA = == +E Merge & Centar $ % % Conditional Format Cell Insert Delete Format Sort Find & Analyze Formatting as Table Styles Filter Select Data W31 Xfx x A B C D F G H 1 ! K M N 0 0 R S 16 20 points 17 WHICH PRODUCT SHOULD THE 18 COMPANY CONTINUE? 15 points 19 13% $11,221 20 21 20% $15,930 Which project below should be selected if the dollars represenl net incomcy (do 22 H 23 Product Y Cost = G Northeast Midwest Southcast Northwest Southwest A 24 22% S17,089 20% 95% 25% 10% 10% Net 25 F Project A 35 $7 S3 TOTAL COST $2 26 Projects $1 $8 3 $3 SZ $2 27 E Project C $7 $4 $6 S4 $3 28 $ 29 30 31 32 Big Boss Sue has two options of which she can only choose one. She can hire a sales executive for $60,000. This executive will generate stines 13 that much in net income per year for her firm. Or, she could pay $175,000 for a machine that will save her firm $515,000 per year. 34 Lising COST/BENEFIT analysis, which choice should she make? Show your work. 5 points 35 COST BENEFIT C/B Analysis 36 SALES EXEC 37 MACHINE 38 39 40 41 45% 28,110 42 43 44 45 46 Sheet1 + Ready + 100% Thur