Keyboard Navigation Help Spreadsheet Suppose a manufacturer of copiers has concluded that a 75 percent learning...

Transcribed Image Text:

Keyboard Navigation Help Spreadsheet 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: a. 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 For x = 5 it takes hours hours b. If the learning rate changes to 65 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 65% LC, it takes hours For x = 5 and a 65% LC, it takes hours For x = 4 and a 95% LC, it takes hours For x = 5 and a 95% LC, it takes hours Spreadsheet A hotel hosts banquets for conferences in a large ballroom with tables of eight. Servers must get the meals from the kitchen, bring them out to the tables, and then place the meals on the tables. It takes four minutes to get the meals, bring them out to the tables, and then 15 seconds to serve each guest. Use the Service Capacity Excel template to answer the following questions. a. If 24 servers are available, how many tables can be served in 24 minutes? Do not round intermediate calculations. Round your answer to two decimal places. tables b. The hotel wants to be able to serve 160 tables in 24 minutes. How many servers are needed? Do not round intermediate calculations. Round your answer to the nearest whole number. servers We know the following data for Albert's fabricating production area: Not Answered Number of machines = 6 Number of working days in year = 335 Processing time per unit = 25 minutes a. What is the annual capacity with a single eight-hour shift? Round your answer down to the nearest whole number. units/year b. What is the annual capacity with two shifts? Round your answer down to the nearest whole number. units/year N Not Answered ns, Inc. has the following claims it must complete in the next week (40 hours). The jobs are as follows: Claim Type Cancer treatment Spinal injury Hip replacement Number of Claims to Process (Work Order Quantity) 18 12 10 Setup (Changeover) Time per Claim Type (hours) Processing Time per Claim (hours) 2.9 1.0 1.4 0.8 1.1 1.9 All claims of the same type are processed together. Is 40 hours enough capacity? (Hint: use Equation 10.3.) Round your answers to one decimal place. CT Claims Workload: SI Claims Workload: HR Claims Workload: hours hours hours Total workload is hours. hours while capacity is 40 hours. The work -Select- be completed using regular time The roller coaster at Treasure Island Amusement Park consists of 20 cars, each of which can carry up to two passengers. According to a time study, each run takes 2.0 minutes, and the time to unload and load riders is 3.0 minutes. What is the the theoretical capacity of the system in number of passengers per hour? Round your answer down to the nearest whole number. passengers per hour Keyboard Navigation Help Spreadsheet 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: a. 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 For x = 5 it takes hours hours b. If the learning rate changes to 65 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 65% LC, it takes hours For x = 5 and a 65% LC, it takes hours For x = 4 and a 95% LC, it takes hours For x = 5 and a 95% LC, it takes hours Spreadsheet A hotel hosts banquets for conferences in a large ballroom with tables of eight. Servers must get the meals from the kitchen, bring them out to the tables, and then place the meals on the tables. It takes four minutes to get the meals, bring them out to the tables, and then 15 seconds to serve each guest. Use the Service Capacity Excel template to answer the following questions. a. If 24 servers are available, how many tables can be served in 24 minutes? Do not round intermediate calculations. Round your answer to two decimal places. tables b. The hotel wants to be able to serve 160 tables in 24 minutes. How many servers are needed? Do not round intermediate calculations. Round your answer to the nearest whole number. servers We know the following data for Albert's fabricating production area: Not Answered Number of machines = 6 Number of working days in year = 335 Processing time per unit = 25 minutes a. What is the annual capacity with a single eight-hour shift? Round your answer down to the nearest whole number. units/year b. What is the annual capacity with two shifts? Round your answer down to the nearest whole number. units/year N Not Answered ns, Inc. has the following claims it must complete in the next week (40 hours). The jobs are as follows: Claim Type Cancer treatment Spinal injury Hip replacement Number of Claims to Process (Work Order Quantity) 18 12 10 Setup (Changeover) Time per Claim Type (hours) Processing Time per Claim (hours) 2.9 1.0 1.4 0.8 1.1 1.9 All claims of the same type are processed together. Is 40 hours enough capacity? (Hint: use Equation 10.3.) Round your answers to one decimal place. CT Claims Workload: SI Claims Workload: HR Claims Workload: hours hours hours Total workload is hours. hours while capacity is 40 hours. The work -Select- be completed using regular time The roller coaster at Treasure Island Amusement Park consists of 20 cars, each of which can carry up to two passengers. According to a time study, each run takes 2.0 minutes, and the time to unload and load riders is 3.0 minutes. What is the the theoretical capacity of the system in number of passengers per hour? Round your answer down to the nearest whole number. passengers per hour