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?