Problem 10-46 Algo (Learning Curves and Capacity Requirements)

Suppose a manufacturer of copiers has concluded that a 75 percent learning curve applies to the time a beginning service technician takes to install copy machines. Use the Learning Curve Excel template to answer the following questions:

If the time required to install the first copy machine is estimated to be five hours, what is an estimate of the time required by a new technician to install the fourth and fifth copiers? Round your answers to one decimal place.

For x = 4 it takes hours

For x = 5 it takes hours

If the learning rate changes to 60 or 95 percent, what is an estimate of the time required by a new technician to install the fourth and fifth copiers? Round your answers to one decimal place.

For x = 4 and a 60% LC, it takes hours

For x = 5 and a 60% LC, it takes hours

For x = 4 and a 95% LC, it takes hours

For x = 5 and a 95% LC, it takes hours

. . . AutoSave . OFF AH ? CE ... learning_curve Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments & Cut AA g Wrap Text v IIX AutoSum v [ Copy Fill Paste Format BI UV V MV Av Merge & Center v $ v % " Conditional Format Insert Delete Format Sort & Find & Analyze Sensitivity Formatting as Table Clear v Filter Select Data B6 fx 3500 B D G M N OP Q R S U V W Z AA AB Learning Curve Cengage Learning Enter the data only in the yellow cells. This template is designed to compute the production time for the first 100 units. Not for commercial use. A chart of the unit time and cumulative average time is given to the right of the tables. Enter the % learning curve as a whole number, e.g., 80 or 90. First unit 3500 % learning curve 90% b 0.1520 10 11 Unit Time Cumulative Time Cum. Avg. Time Unit Time Cumulative Time Cum. Avg. Time Unit Time Cumulative Time | Cum. Avg. Time Unit Time Cumulative Time Cum. Avg. Time 3500 3500 3500.0 26 2133.0 64129.3 2466.5 51 1925.4 114422.2 2243.6 76 1812.1 160975.7 2118.1 Learning Curve 3150.0 6650.0 3325.0 2120.8 56250.1 2453.7 52 1919.7 116341.9 2237.3 77 1808.5 162784.1 2114.1 4000 2961.7 9611.7 3203.9 2109.1 58359.2 2441.4 53 1914. 118256.0 231.2 78 1804.9 164589.1 2110.1 2835.0 2446. 3111.7 29 2097.9 70457.0 2429.6 54 1908.7 120164.7 2225.3 79 1801.5 166390.5 2106.2 3500 2740.5 15187. 3037.4 30 2087.1 72544.1 418.1 55 1903. 122068.1 2219.4 80 1798.0 168188.6 2102.4 6 6 DO VMI VIA W N H 2665.5 17852.7 2975.5 31 2076. 74620.8 407.1 56 1898. 23966.3 213.7 81 1794.6 169983.2 2098.6 3000 2603.8 10456.5 2922.4 32 2066.7 76687.6 2396.5 57 1893.1 125859.4 2208.1 1791.3 171774.5 2094.8 2551.5 23008.0 2876.0 33 2057.1 78744.6 2386.2 58 1888.1 127747.5 2202.5 1788.0 173562.4 2091.1 2500 2506.2 25514.3 2834.9 34 2047.8 80792.4 376.2 59 1883.2 129630.7 2197.1 1784.7 175347.2 2087.5 2466.4 27980.7 2798.1 35 2038.8 82831.1 2366.6 60 1878.4 131509.0 191.8 1781.5 177128.7 2083.9 2000 11 2430.9 30411.6 2764.7 36 2030.0 84861.2 2357.3 61 1873.7 133382.7 2186.6 1778.4 178907.0 2080.3 12 2399. 32810.6 2734.2 37 2021.6 86882.8 348.2 1869.0 135251.7 2181.5 87 1775.2 180682.3 2076.8 1500 13 2370.0 35180.6 2706.2 38 2013.4 88896.2 2339.4 1864. 137116.2 2176.4 88 1772.2 182454.4 2073.3 14 2343.4 37524.0 2680.3 39 2005.5 90901.7 330.8 1860.0 138976.3 2171.5 1769.1 184223.5 2069.9 1000 989890 15 2319.0 39843. 2656.2 40 1997.8 92899.5 322.5 1855.7 140832.0 2166.6 90 1766.1 185989.6 2066.6 16 2296.4 42139.4 2633.7 1990.3 94889.8 314.4 1851.4 142683.3 2161.9 91 1763.1 187752.8 2063.2 17 500 2275.3 44414.6 2612.6 CRE 1983.0 96872.8 2306.5 1847.1 44530.5 2157.2 92 1760.2 189513.0 2059.9 18 2255.6 46670.2 2592.8 43 1975.9 8848.8 2298.8 1843.0 46373.4 2152.6 93 1757.3 191270.3 2056.7 19 2237.1 48907.4 2574.1 44 1969.1 100817.8 291.3 69 1838.9 148212.3 148.0 94 1754.5 193024.8 2053.5 20 2219.8 51127.2 2556.4 45 1962.3 102780.2 2284.0 70 1834.9 150047.2 2143.5 95 1751.7 194776.4 2050.3 21 2203.4 53330. 2539.5 46 1955.8 104736.0 2276.9 71 Unit Number 1830.9 151878.1 2139.1 1748.9 196525.3 2047.1 22 2187.8 5518.4 2523.6 1949.4 106685.4 2269.9 72 1827.0 153705.2 2134.8 1746.1 198271.4 2044.0 -Time -Cum. Avg. Time 23 2173.1 57691.5 2508.3 1943.2 108628.6 2263.1 73 1823.2 155528.4 2130.5 1743.4 200014.8 2041.0 24 2159.1 59850.6 2493.8 1937.1 110565.7 2256.4 74 1819.4 157347.8 2126.3 99 1740.7 201755.5 2037.9 25 2145.7 61996.3 2479.9 50 1931.2 112496.8 2249.9 75 1815.7 159163.6 2122.2 100 1738.0 203493.6 2034.9 Learning Curve + Ready & Accessibility: Investigate 100%