The bottom list is the excel file

1. (39 points) Powers Inc. produces bicycles on a conveyor belt. The company operates 7.5 hours per day and 5 days a week. Hourly wage for associates is $40. Task times are given in the excel dataset. a. (3 points) What is the total labor content (minutes per bicycle)? Assume that the tasks are partitioned among four associates as displayed in Table 1. Answer the following questions based on the assignments in Table 1. b. (3 points) What is the production capacity per day? c. (3 points) Assume that the weekly demand is 18 , and you produce to match the demand (demand constrained process). What would be the direct labor cost (in $ per bicycle) for this task-associate assignment? d. (3 points) Assume that the demand is unlimited, and you produce at your maximum capacity (capacity constrained process). What would be the direct labor cost (in $ per bicycle) for this taskassociate assignment? e. (4 points) Compute the utilization of associates 1 and 4 for the production rate in part d. f. (8 points) Re-assign tasks to maximize the capacity of the line subject to the conditions that an associate can only perform adjacent tasks and all tasks need to be done in their numerical order. What would be the direct labor cost (in \$ per bicycle) for your proposed assignment? What would be the arect Iabor cost (In > per bicycle) tor your proposed assignment? Assume that the weekly demand is 36 . Answer the following questions based on this demand value and task times in the dataset. g. (3 points) Assume that all the production will be done on a single assembly line. What should be the maximum cycle time to satisfy the weekly demand of 36 bicycles? h. (8 points) Using the minimum number of associates (or workstations), assign tasks to associates to be able to satisfy the weekly demand of 36 bicycles with single assembly line. i. (4 points) What would be the direct labor cost (in \$ per bicycle) for this task-associate assignment? Bonus (15 points) Propose an alternative production system that would result in lower labor cost. You may use multiple assembly lines. Assume that overtime cost is $60 per hour and each associate may have up to 8 hours of overtime. What would be the direct labor cost (in $ per bicycle) for your proposed task-associate assignment