Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Upload one excel file for your submission.

1. Delights Company is designing a production layout for a new product. They plan to use this production line 10 hours a day in order to meet forecasted demand of 80,000 units per day. For output to equal forecasted demand, what should the actual cycle time be for this production?

2. A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be $.25 per load per meter moved. An analyst has prepared the following distances and flow matrices:

Distance (meters) Flows (loads per week)

From/To I II III From/To X Y Z

I - 20 30 X - 400 280

II - 50 Y 180 - 320

III - Z 280 300 -

In what areas, I, II, and III, should departments X, Y, and Z be located that minimize the total cost of moving loads over the distance? (Identify assignments and total cost)

3. A job had an observed time of two min., a performance rating of 80 percent, and an allowance factor of 20 percent of job time. Thirty cycles were timed.
   1. Normal time for the job in min. is: (5 pts)
   2. Standard time for the job in minutes is:

4. 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. A B C

Labor Cost .2 60 70 80

Transportation Cost .3 80 90 70

Market Access .1 70 70 60

Utility Cost .3 60 80 80

Raw Materials Cost .1 90 80 60

What is the composite score for location C?

5. Determine the center of gravity for the following destinations and shipping quantities:

Destination (x,y) Quantity

A (2,6) 700

B (1,5) 400

C (3,4) 500

D (4,8) 700

6. The manager for sales contractors wants to construct a control chart for determining whether the 10 contractors are under control with regard to the number of sales made. Accordingly, the manager sampled 100 days from last year for each contractor, with the following results:

Contractor Number of Sales

A 95

B 90

C 70

D 80

E 102

F 68

G 105

H 79

I 69

J 98

Analyze these data using a control chart that would provide for a 95% confidence interval, identifying the control limits and contractors, if any, that are outside the control limits