Use Excel worksheet Q40-41, also shown below. It is demand for apples at Big Apple Farms. Demand (1000s) Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 1 14.2 7.5 5.9 16.7 44.3 2 16.4 9.7 7 17.8 50.9 3 16.9 10.3 7.8 18.8 53.8 Total 47.5 27.5 20.7 53.3 149 Use the following data for problems 43-45 (all times are in days) Activity Optimistic Most likely pessimistic A 5 7 12 B 4 9 10 C 2 3 4 D 6 12 20 Use the following data for problems 46-48. Crusty's pizza management has been recording data regarding the time it takes to make a pepperoni pizza and bread sticks (see table) Activity Predecessor Time (seconds) s 1. Weigh dough 145 2. Make carry out box 15 3. Weight Cheese 35 4. Measure 15oz of secret sauce 48 5. Roll out bread sticks 1 215 6. Spin dough to proper size 1 180 7. Shape dough on pizza pan 6 64 8. Spread the secret sauce 4, 7 23 9. Place 35 pepperonis 8 65 10. Sprinkle cheese on pizza 3, 9 43 11. Add 15 pepperonis 10 24 12. Place pizza in oven & cook 11 900 13. Place breadsticks in oven & cook 5 330 14. Slice pizza 12 23 15. Place in carry out box 13, 14 14 Use the following data for problems 49 and 50 (all times are days) Activit y 1 2 Activity time 5 4 Crash time 2 1 Normal Cost 25 30 Crash Cost 35 40 Predecessor 1 Predecessor 2 Predecessor 3 3 4 5 6 7 8 9 10 11 12 12 6 15 9 14 16 21 8 35 6 9 4 10 6 12 8 14 6 25 4 45 15 21 16 32 64 14 25 30 10 60 45 28 20 41 80 28 30 42 16 1 1 1 3 3 6 7 8 9 10 2 2 2 5 4 9 5 Name Laudus Rosenberg U.S. Large Cap Growth Fund Inst. Shrs JPMorgan Disciplined Equity Sel Laudus U.S. MarketMasters Fund Investor Shares William Blair Growth N Schwab S and P 500 Index Fund Investor Shares Laudus Rosenberg U.S. Large Cap Fund Inst. Shrs SSgA Disciplined Equity Schwab Core Equity Fund Dreyfus S and P 500 Index FMI Large Cap Schwab LargeCap Growth Fund Select Shares Neuberger Berman Socially Resp Inv Buffalo USA Global Sit Large Cap Growth American Beacon Lg Cap Value Plan Transamerica Premier Equity Inv Gabelli Equity Income AAA 1st Source Monogram Income Equity Janus Research Schwab Dividend Equity Fund Select Shares Manning and Napier Equity Allianz NFJ Large Cap Value D Excelsior Value and Restructuring TCW Small Cap Growth N Schwab SmallCap Index Fund Investor Shares Dreyfus Small Cap Stock Index Excelsior Small Cap Tamarack Micro Cap Value S JPMorgan Dynamic Small Cap Growth A Loomis Sayles Small Cap Value Ret Perritt Micro Cap Opportunities Northern Small Cap Value Janus Enterprise Neuberger Berman Millennium Inv Glenmede Small Cap Equity Adv American Century Mid Cap Value Inv JPMorgan Small Cap Value A Sit Mid Cap Growth Value Line Emerging Opportunities Gabelli Asset AAA Gabelli Small Cap Growth AAA Hennessy Focus 30 Janus Mid Cap Value Investor Dreman Contrarian Small Cap Value R Nationwide Worldwide Leaders A Dreyfus Intl Stock Index Wells Fargo Advantage Asia Pacific Class Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Large Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap Small Mid Cap International International International SSgA International Stock Selection Schwab International Index Fund Investor Shares Nationwide International Growth A GE Global Equity A Glenmede Philadelphia International Lazard Emerging Markets Open Guinness Atkinson China and Hong Kong Laudus International MarketMasters Fund Investor Shares Manning and Napier World Opportunities A SPARX Japan Investor Artisan International Inv JPMorgan Intrepid European A American Century Intl Discovery Inv Matthews China Laudus Rosenberg Intl Discovery Fund Inst. Shrs Harbor International Inv Metzler Payden European Emerging Markets International International International International International International International International International International International International International International International International International 3 Month Return 3.82 0.83 0.71 2.79 0.91 0.58 -0.95 1.95 0.86 0.7 3.43 1.88 0.73 4.57 -0.83 6.61 2.93 2.96 5.96 1.83 -0.05 -1.21 1.24 4.13 -2.67 -4.38 -2.52 -7.02 -3.86 -2.15 -4.39 -4.3 6.27 7.47 -1.54 -4.45 -10.62 3.57 1.04 1.94 -1.1 -7.37 1.18 -1.54 1.78 5.83 15.32 3.42 6.76 6.07 1.56 2.25 12.01 18.44 4.97 5.63 -2.72 11.94 -1.79 6.57 17.84 2.74 11.16 12.07 Day Cars sold 1 13 2 9 3 7 4 15 5 11 6 9 7 12 8 16 9 12 10 11 11 15 12 2 13 6 14 21 15 4 16 7 17 11 18 13 19 15 20 15 test 1 67 52 98 97 75 78 90 76 48 75 89 83 64 69 58 test 2 184 127 192 150 143 180 150 140 150 180 112 141 175 170 150 Amount Frequency $500 or more 12 $250-$499 32 $100-$249 64 Less than $100 3 Age Group Warranty No Warranty Less than 30 12 16 30 or Older 15 22 Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Late 0 2 3 1 0 2 7 1 0 3 2 0 4 1 2 0 2 3 1 4 1 0 0 3 0 0 2 2 1 3 Day Negative Cards 1 0 2 2 3 3 4 1 5 4 6 0 7 1 8 6 9 2 10 4 11 0 12 1 13 0 14 3 Hour 1 2 3 4 5 6 7 8 mean 15.07 15.09 14.98 15.02 14.91 15.07 15.11 14.93 Range 0.21 0.23 0.35 0.13 0.19 0.22 0.39 0.14 Age Completion Time 22 18 25 19 31 16 42 31 45 22 Height (inches) Weight (lbs) 37 74 39 79 40 82 40 82 42 88 43 97 44 103 50 111 50 114 50 116 52 117 53 120 54 122 55 124 56 125 57 127 57 128 58 132 61 134 63 134 Month Jan. Feb. March April May June July Aug. Sep. Oct. Orders Delivered 120 90 100 75 110 50 75 130 111 94 Demand (1000s) Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 1 14.2 7.5 5.9 16.7 44.3 2 16.4 9.7 7 17.8 50.9 3 16.9 10.3 7.8 18.8 53.8 Total 47.5 27.5 20.7 53.3 149