Use excel to show formulas
1. A job had an observed cycle time of six min., a performance rating of 80 percent, and an allowance factor of 15 percent of job time. Normal time for the job in min. is:
2. A job had an observed time of five minutes, a performance rating of .70, and an allowance factor of 20 percent of job time. Twenty cycles were timed. Standard time for the job in minutes is:
*A location analysis has been narrowed down to three locations. The critical factors, their weights, and the ratings for each location are shown below:
Location
Factor Wt. X Y Z
Labor Cost .3 70 60 75
Transportation Cost . 3 90 90 60
Market Access 1 60 80 80
Utility Cost .2 80 90 70
Raw Materials Cost .1 90 70 80
3.What is the composite score for location Y?
