HW 1 Part 2- Please complete all work in excel. Use excel to make the calculations and be sure to identify your answer, including units.

1. Given the following sales data:

Quarter	Year 1	Year 2
1	360	440
2	580	610
3	600	680
4	370	420

Compute the seasonal index for each quarter and forecast quarterly demand for year 3 with a projected annual demand of 2400. (10 pts)

2. The efficiency of a production unit is 80 percent. The unit produces an average of 500 products per day. Determine the effective capacity of the unit. (5 pts)

3. The utilization of a machine is 70 percent. The machine has a design capacity of 240 units per hour and an effective capacity of 200 units per hour. Find the efficiency of the machine.