Suppose a manufacturer of copiers has concluded that a 70 percent learning curve applies to the time a new service technician takes to install copy machines. Use the Learning Curve Excel template in MindTap to answer the following questions: a. If the time required to install the first copy machine is estimated to be three hours, what is an estimate of the time required by a new technician to install the third and fourth copiers? Round your answers to one decimal place. For x = 3 it takes hours For x = 4 it takes hours b. If the learning rate changes to 60 or 90 percent, what is an estimate of the time required by a new technician to install the third and fourth copiers? Round your answers to one decimal place. For x = 3 and a 60% LC, it takes For x = 4 and a 60% LC, it takes For x = 3 and a 90% LC, it takes For x = 4 and a 90% LC, it takes hours hours hours hours
Suppose a manufacturer of copiers has concluded that a 70 percent learning curve applies to the time a new service technician takes to install copy machines. Use the Learning Curve Excel template in MindTap to answer the following questions: a. If the time required to install the first copy machine is estimated to be three hours, what is an estimate of the time required by a new technician to install the third and fourth copiers? Round your answers to one decimal place. For x = 3 it takes hours For x = 4 it takes hours b. If the learning rate changes to 60 or 90 percent, what is an estimate of the time required by a new technician to install the third and fourth copiers? Round your answers to one decimal place. For x = 3 and a 60% LC, it takes For x = 4 and a 60% LC, it takes For x = 3 and a 90% LC, it takes For x = 4 and a 90% LC, it takes hours hours hours hours
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
![Enter the data only in the yellow cells. This template is designed to compute the production time for the first 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
90%
% learning cur
b
0.1520
Unit Time Cumulative Tim Cum. Avg. Time
1
3500
3500
3500.0
2
3150.0
6650.0
3325.0
3 2961.7
3203.9
4 2835.0
3111.7
5 2740.5
3037.4
6 2665.5
7 2603.8
2975.5
2922.4
2876.0
2834.9
8 2551.5
9 2506.2
10 2466.4
11 2430.9
12 2399.0
13 2370.0
14 2343.4
15 2319.0
16 2296.4
2275.3
2255.6
19 2237.1
17
18
20 2219.8
21 2203.4
22 2187.8
23 2173.1
24
2159.1
25
2145.7
9611.7
12446.7
15187.2
17852.7
20456.5
23008.0
25514.3
27980.7
30411.6
32810.6
35180.6
37524.0
39843.0
42139 4
44414.6
46670.2
48907.4
51127.2
53330.5
55518.4
57691.5
59850.6
61996.3
2798.1
2764.7
2734.2
2706.2
2680.3
2656.2
2633.7
2612.6
2592.8
2574.1
2556.4
25.39.5
2523.6
2508.3
2493.8
2479.9
Unit
31 2076.7
32 2066.7
33 2057.1
34 2047.8
35 2038.8
36 2030.0
37 2021.6
Time Cumulative Tim Jum. Avg. Time Unit
Unit Time Cumulative Timi Cum. Avg. Time Unit Time
26 2133.0
64129.3
2466.5 51 1925.4 114422.2
2243.6 76 1812.1
27 2120.8 66250.1
2453.7 52 1919.7 116341.9
2237.3 77 1808.5
28 2109.1
68359.2
2441.4 53 1914.1 118256.0
2231.2 78 1804.9
29 2097.9 70457.0
2429.6 54 1908.7 120164.7
2225.3 79 1801.5
30 2087.1 72544.1
2418.1 55 1903.4 122068.1
2219.4 80 1798.0
74620.8
2407.1 56 1898.2 123966.3
2213.7 81 1794.6
76687.6
2396.5 57 1893.1 125859.4
2208.1 82 1791.3
78744.6
2386.2 58 1888.1 127747.5
2202.5 83 1788.0
80792.4
2376.2 59 1883.2 129630.7
2197.1 84 1784.7
82831.1
2366.6 60 1878.4 131509.0
2191.8 85 1781.5
84861.2
2357.3
61 1873.7 133382.7
2186.6 86 1778.4
86882.8
2348.2 62 1869.0 135251.7
2181.5 87 1775.2
88896.2
2339.4 63 1864.5 137116.2
2176.4 88 1772.2
90901.7
2330.8 64 1860.0 138976.3
2171.5 89 1769.1
92899.5
2322.5 65 1855.7 140832.0
2166.6 90 1766.1
94889.8
2314.4 66 1851.4 142683.3
2161.9 91 1763.1
96872.8
2306.5 67 1847.1 144530.5
2157.2 92 1760.2
98848.8
2298.8 68 1843.0 146373.4
2152.6 93 1757.3
100817.8
2291.3 69 1838.9
148212.3
2148.0 94 1754.5
102780.2
2284.0 70 1834.9 150047.2
2143.5 95 1751.7
104736.0
2276.9 71 1830.9
151878.1
2139.1 96 1748.9
106685.4
2269.9 72 1827.0 153705.2
2134.8 97 1746.1
108628.6
2263.1 73 1823.2 155528.4
2130.5
110565.7
2256.4 74 1819.4 157347.8
2126.3
112496.8
2249.9 75 1815.7 159163.6
98 1743.4
99 1740.7
2122.2
100 1738.0
38 2013.4
39 2005.5
40 1997.8
41 1990.3
42 1983.0
43 1975.9
44 1969.1
45 1962.3
46 1955.8
47 1949.4
48 1943.2
49 1937.1
50 1931.2
umulative Timium. Avg. Tim
2118.1
2114.1
160975.7
162784.1
164589.1
166390.5
168188.6
169983.2
171774.5
173562.4
175347.2
177128.7
178907.0
180682.3
182454.4
184223.5
185989.6
187752.8
189513.0
191270.3
193024.8
194776.4
196525.3
198271.4
200014.8
201755.5
203493.6
2110.1
2106.2
2102.4
2098.6
2094.8
2091.1
2087.5
2083.9
2080.3
2076.8
2073.3
2069.9
2066.6
2063.2
2059.9
2056.7
2053.5
2050.3
2047.1
2044.0
2041.0
2037.9
2034.9
3,200
2,400
1,600
800
0
Learning Curve
10
30
50
70
90
= Time
Cum. Avg.
Time](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc00f41a8-3019-411c-9841-b4d3b90602dd%2F506eea02-a1e0-403a-bfc0-a95da88c1262%2Fupsr5ax_processed.png&w=3840&q=75)
Transcribed Image Text:Enter the data only in the yellow cells. This template is designed to compute the production time for the first 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
90%
% learning cur
b
0.1520
Unit Time Cumulative Tim Cum. Avg. Time
1
3500
3500
3500.0
2
3150.0
6650.0
3325.0
3 2961.7
3203.9
4 2835.0
3111.7
5 2740.5
3037.4
6 2665.5
7 2603.8
2975.5
2922.4
2876.0
2834.9
8 2551.5
9 2506.2
10 2466.4
11 2430.9
12 2399.0
13 2370.0
14 2343.4
15 2319.0
16 2296.4
2275.3
2255.6
19 2237.1
17
18
20 2219.8
21 2203.4
22 2187.8
23 2173.1
24
2159.1
25
2145.7
9611.7
12446.7
15187.2
17852.7
20456.5
23008.0
25514.3
27980.7
30411.6
32810.6
35180.6
37524.0
39843.0
42139 4
44414.6
46670.2
48907.4
51127.2
53330.5
55518.4
57691.5
59850.6
61996.3
2798.1
2764.7
2734.2
2706.2
2680.3
2656.2
2633.7
2612.6
2592.8
2574.1
2556.4
25.39.5
2523.6
2508.3
2493.8
2479.9
Unit
31 2076.7
32 2066.7
33 2057.1
34 2047.8
35 2038.8
36 2030.0
37 2021.6
Time Cumulative Tim Jum. Avg. Time Unit
Unit Time Cumulative Timi Cum. Avg. Time Unit Time
26 2133.0
64129.3
2466.5 51 1925.4 114422.2
2243.6 76 1812.1
27 2120.8 66250.1
2453.7 52 1919.7 116341.9
2237.3 77 1808.5
28 2109.1
68359.2
2441.4 53 1914.1 118256.0
2231.2 78 1804.9
29 2097.9 70457.0
2429.6 54 1908.7 120164.7
2225.3 79 1801.5
30 2087.1 72544.1
2418.1 55 1903.4 122068.1
2219.4 80 1798.0
74620.8
2407.1 56 1898.2 123966.3
2213.7 81 1794.6
76687.6
2396.5 57 1893.1 125859.4
2208.1 82 1791.3
78744.6
2386.2 58 1888.1 127747.5
2202.5 83 1788.0
80792.4
2376.2 59 1883.2 129630.7
2197.1 84 1784.7
82831.1
2366.6 60 1878.4 131509.0
2191.8 85 1781.5
84861.2
2357.3
61 1873.7 133382.7
2186.6 86 1778.4
86882.8
2348.2 62 1869.0 135251.7
2181.5 87 1775.2
88896.2
2339.4 63 1864.5 137116.2
2176.4 88 1772.2
90901.7
2330.8 64 1860.0 138976.3
2171.5 89 1769.1
92899.5
2322.5 65 1855.7 140832.0
2166.6 90 1766.1
94889.8
2314.4 66 1851.4 142683.3
2161.9 91 1763.1
96872.8
2306.5 67 1847.1 144530.5
2157.2 92 1760.2
98848.8
2298.8 68 1843.0 146373.4
2152.6 93 1757.3
100817.8
2291.3 69 1838.9
148212.3
2148.0 94 1754.5
102780.2
2284.0 70 1834.9 150047.2
2143.5 95 1751.7
104736.0
2276.9 71 1830.9
151878.1
2139.1 96 1748.9
106685.4
2269.9 72 1827.0 153705.2
2134.8 97 1746.1
108628.6
2263.1 73 1823.2 155528.4
2130.5
110565.7
2256.4 74 1819.4 157347.8
2126.3
112496.8
2249.9 75 1815.7 159163.6
98 1743.4
99 1740.7
2122.2
100 1738.0
38 2013.4
39 2005.5
40 1997.8
41 1990.3
42 1983.0
43 1975.9
44 1969.1
45 1962.3
46 1955.8
47 1949.4
48 1943.2
49 1937.1
50 1931.2
umulative Timium. Avg. Tim
2118.1
2114.1
160975.7
162784.1
164589.1
166390.5
168188.6
169983.2
171774.5
173562.4
175347.2
177128.7
178907.0
180682.3
182454.4
184223.5
185989.6
187752.8
189513.0
191270.3
193024.8
194776.4
196525.3
198271.4
200014.8
201755.5
203493.6
2110.1
2106.2
2102.4
2098.6
2094.8
2091.1
2087.5
2083.9
2080.3
2076.8
2073.3
2069.9
2066.6
2063.2
2059.9
2056.7
2053.5
2050.3
2047.1
2044.0
2041.0
2037.9
2034.9
3,200
2,400
1,600
800
0
Learning Curve
10
30
50
70
90
= Time
Cum. Avg.
Time
![Suppose a manufacturer of copiers has concluded that a 70 percent learning curve applies to the time a new service technician takes to install copy
machines. Use the Learning Curve Excel template in MindTap to answer the following questions:
a. If the time required to install the first copy machine is estimated to be three hours, what is an estimate of the time required by a new technician
to install the third and fourth copiers? Round your answers to one decimal place.
For x = 3 it takes
hours
For x = 4 it takes
hours
b. If the learning rate changes to 60 or 90 percent, what is an estimate of the time required by a new technician to install the third and fourth
copiers? Round your answers to one decimal place.
For x = 3 and a 60% LC, it takes
For x = 4 and a 60% LC, it takes
For x = 3 and a 90% LC, it takes
For x = 4 and a 90% LC, it takes
hours
hours
hours
hours](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc00f41a8-3019-411c-9841-b4d3b90602dd%2F506eea02-a1e0-403a-bfc0-a95da88c1262%2Fnvco2k_processed.png&w=3840&q=75)
Transcribed Image Text:Suppose a manufacturer of copiers has concluded that a 70 percent learning curve applies to the time a new service technician takes to install copy
machines. Use the Learning Curve Excel template in MindTap to answer the following questions:
a. If the time required to install the first copy machine is estimated to be three hours, what is an estimate of the time required by a new technician
to install the third and fourth copiers? Round your answers to one decimal place.
For x = 3 it takes
hours
For x = 4 it takes
hours
b. If the learning rate changes to 60 or 90 percent, what is an estimate of the time required by a new technician to install the third and fourth
copiers? Round your answers to one decimal place.
For x = 3 and a 60% LC, it takes
For x = 4 and a 60% LC, it takes
For x = 3 and a 90% LC, it takes
For x = 4 and a 90% LC, it takes
hours
hours
hours
hours
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.