Present your answers in an Excel file, or in a Word or PDF file if problems are worked out by hand. (No photos, please.) Clearly mark your work with the question number. If using an Excel workbook, submit each question in a separate worksheet with the question number as the name of the worksheet. 1. [15 points] A manufacturing process has 12 workers and 6 stations. The process is completed in the order given below. Where there are multiple workers within a station, each worker works independently on his/her own unit. Assume inventory buffers are allowed between each station. Station Processing time (hours per unit per worker) Staffing A 2 2.20 B 1 1.25 C 3 2.00 D 2 2.60 E 3 3.00 0.75 F What is the maximum number of units per hour that can be produced? Assume they start the day with inventory at each station to work on. 2. [15 points] A process requires 6 tasks that must be performed in order. Currently there are 4 employees that are equally skilled at each task. Employee 1 is assigned tasks 1 and 2, employee 2 is assigned task 3, employee 3 is assigned task 4, and employee 4 is assigned to tasks 5 and 6. The task times (all in seconds) are given in the process diagram below. For example, task 1 requires 29 seconds. 1-2-3-4-5-6- 29 27 62 46 21 32 Suppose the system started without any work in process inventory (i.e., an empty system). How long would this process take to produce 22 units (in seconds)? 3. Suppose a company has an inventory of $732,507.93 and had 7.8 turns. a. [10 points] What are the cost of goods sold (COGS)? b. [10 points] Suppose in a given year, the company has a gross margin of 29%. What were the sales for the company that year? c. [10 points] In the next year, the company experiences a 16% sales growth. What are the sales for the next year? d. [10 points] Suppose the annual holding cost is 32% and the COGS of item X is $12. What is the total amount of inventory holding costs for one unit of item X for one year? 4. [15 points] A process requires 10 tasks that must be performed in order. Currently there are 4 employees that are equally skilled at each task. Employee A is assigned tasks 1 and 2, employee B is assigned tasks 3, 4 and 5, employee C is assigned tasks 6, 7 and 8, and employee D is assigned tasks 9 and 10. The task times (all in seconds) are given in the table. Tasks | Activity time (seconds) 1 56 2 3 42 39 32 5 61 6 28 7 35 8 47 9 10 41 65 Suppose the system started without any work in process inventory (i.e., an empty system). How long would this process take to produce 25 units (in seconds)? 5. [15 points] Bakery ABC has 13 ovens. Each oven can hold a single cake at a time and each cake takes 35 minutes to bake. How many cakes per hour can be baked at Bakery ABC?