A B D E F G H 1 j K L M N Exercise: A company has 3 factories. It has developed the profit model below, but it isn't sure of the values in 2 the gray cells. The values shown here for the "base case" are best guesses, but the company wants to test two 3 other scenarios: (1) the high cost case, where the values in the gray cells are replaced by the values in rows 30- 4 31, and (2) the low cost case, where the values in the gray cells are replaced by the values in rows 34-35. Create 5 three named scenarios called Base Case, High Cost Case, and Low Cost Case. 6 7 8 9 10 Sales price $125 11 12 12 Factory 1 Factory 2 Factory 3 13 Base units produced per worker 10 10 10 14 Training effectiveness factor 150 150 150 15 Training investment per worker $100 $200 $300 16 Labor cost per worker $800 $900 $1,200 17 Number of workers 500 250 100 18 Base production capacity 5,000 2,500 1,000 19 Efficiency factor 0.67 1.33 2.00 20 Units produced 3,333 3,333 2,000 21 Profit per plant ($33,333) $141,667 $100,000 22 23 Total profit $208,333 24 25 High cost case values (15% above) 26 Training investment per worker $115 $230 $345 27 Labor cost per worker $920 $1,035 $1,380 28 29 Low cost case values (15% below) 30 Training investment per worker $85 $170 $255 31 Labor cost per worker $680 $765 $1,020 32 33 34 35 36 37 38 39 40 41 42 A B D E F G H 1 j K L M N Exercise: A company has 3 factories. It has developed the profit model below, but it isn't sure of the values in 2 the gray cells. The values shown here for the "base case" are best guesses, but the company wants to test two 3 other scenarios: (1) the high cost case, where the values in the gray cells are replaced by the values in rows 30- 4 31, and (2) the low cost case, where the values in the gray cells are replaced by the values in rows 34-35. Create 5 three named scenarios called Base Case, High Cost Case, and Low Cost Case. 6 7 8 9 10 Sales price $125 11 12 12 Factory 1 Factory 2 Factory 3 13 Base units produced per worker 10 10 10 14 Training effectiveness factor 150 150 150 15 Training investment per worker $100 $200 $300 16 Labor cost per worker $800 $900 $1,200 17 Number of workers 500 250 100 18 Base production capacity 5,000 2,500 1,000 19 Efficiency factor 0.67 1.33 2.00 20 Units produced 3,333 3,333 2,000 21 Profit per plant ($33,333) $141,667 $100,000 22 23 Total profit $208,333 24 25 High cost case values (15% above) 26 Training investment per worker $115 $230 $345 27 Labor cost per worker $920 $1,035 $1,380 28 29 Low cost case values (15% below) 30 Training investment per worker $85 $170 $255 31 Labor cost per worker $680 $765 $1,020 32 33 34 35 36 37 38 39 40 41 42