24

answer questions and do nkt use excel for this one. on paper with formulas .

Note: if a worker works in multiple resources, the worker distributes his/her work time on those resources. In that case, the worker counts for the resources can be decimal numbers. On the supply side, we know how many workers are in charge of each resource and the processing time in minutes per unit for each product at each resource. Zero processing time means the product of interest does not go through the corresponding resource at all. Besides, A process is composed of five resources working on products A,B, and C for eight hours a day. The table below summarizes the situation. You would need to choose a minute of work as the common flow unit for all products and resources. In addition, you need to explain and show your calculations steps. Some cells are prefilled for your reference. Use 2 decimal places. \begin{tabular}{|c|c|c|c|c|c|} \hline Resource \& Process & R1 & R2 & R3 & R4 & R5 \\ \hline Number of workers & 4 & 3 & 4 & 4 & 6 \\ \hline Processing time for A (minutes/unit/worker) & 2 & 5 & 0 & 4 & 8 \\ \hline Processing time for B (minutes/unit/worker) & 5 & 4 & 8 & 0 & 6 \\ \hline Processing time for C (minutes/unit/worker) & 4 & 0 & 3 & 8 & 5 \\ \hline \multicolumn{6}{|l|}{ Capacity } \\ \hline \multicolumn{6}{|l|}{ Capacity (minutes/hour) } \\ \hline \multicolumn{6}{|l|}{ Capacity (minutes/day) ( 8 hours/day) } \\ \hline \multicolumn{6}{|l|}{ Demand, Workload, \& Implied Utilization } \\ \hline \multicolumn{6}{|l|}{ Demand for A (units/day) } \\ \hline \multicolumn{6}{|l|}{ Demand for B (units/day) } \\ \hline \multicolumn{6}{|l|}{ Demand for C (units/day) } \\ \hline \multicolumn{6}{|l|}{ Workload on A (minutes/day) } \\ \hline \multicolumn{6}{|l|}{ Workload on B (minutes/day) } \\ \hline \multicolumn{6}{|l|}{ Workload on C (minutes/day) } \\ \hline Total workload (minutes/day) & & & 2070 & & \\ \hline \multicolumn{6}{|l|}{ Implied utilization ( %,2 decimals) } \\ \hline \multicolumn{6}{|l|}{ Flow Rate \& Utilization } \\ \hline \multicolumn{6}{|l|}{ Flow rate of A (units/day) } \\ \hline \multicolumn{6}{|l|}{ Flow rate of B (units/day). } \\ \hline \multicolumn{6}{|l|}{ Flow rate of C (units/day) } \\ \hline Effective workload on A (minutes/day) & & 2 & & & \\ \hline \multicolumn{6}{|l|}{ Effective workload on B (minutes/day) } \\ \hline \multicolumn{6}{|l|}{ Effective workload on C (minutes/day) } \\ \hline \multicolumn{6}{|l|}{ Total effective workload (minutes/day) } \\ \hline Effective IU (%,2 decimals ) & & 86.81% & . & & \\ \hline Utilization ( %,2 decimals) & & & & & \\ \hline \end{tabular} assume that inputs are always sufficient. On the demand side, we know demands for products A,B, and C per day as follows: demand for A is 156 units per day; demand for B is 180 units per day; and demand for C is 210 units per day. We assume a fixed product mix of A:B:C. (a)[2] Draw a process flow diagram of the process, assuming that there are buffers between resources. Make sure to have process boundaries. (b)[1] Find two measures of capacity for each resource as in the table. (c)[1] Find total workload on each resource. (d)[1] Find implied utilizations of individual resources. Draw the implied utilization profile. (e) [1] Find the bottleneck and the demand-acceptance ratio (if IU[BN] >1 then DAR =1/IU[BN] ). (f) [1] Based on the demand-acceptance ratio, find the effective flow rates of A,B, and C. Explain. (g)[1] Find total effective workload and effective IU on each resource. (h)[1] Find utilizations of individual resources. Draw the utilization profile. (i)[1] Process analysis is for designing and improving business processes! By looking at the implied utilization and utilization profiles, propose one way to reallocate workers among the resources so as to increase the flow rates of products A, B, and C. For this part, you should try to implement the table in Excel and reallocate workers in your Excel template (optional). Note: if a worker works in multiple resources, the worker distributes his/her work time on those resources. In that case, the worker counts for the resources can be decimal numbers. On the supply side, we know how many workers are in charge of each resource and the processing time in minutes per unit for each product at each resource. Zero processing time means the product of interest does not go through the corresponding resource at all. Besides, A process is composed of five resources working on products A,B, and C for eight hours a day. The table below summarizes the situation. You would need to choose a minute of work as the common flow unit for all products and resources. In addition, you need to explain and show your calculations steps. Some cells are prefilled for your reference. Use 2 decimal places. \begin{tabular}{|c|c|c|c|c|c|} \hline Resource \& Process & R1 & R2 & R3 & R4 & R5 \\ \hline Number of workers & 4 & 3 & 4 & 4 & 6 \\ \hline Processing time for A (minutes/unit/worker) & 2 & 5 & 0 & 4 & 8 \\ \hline Processing time for B (minutes/unit/worker) & 5 & 4 & 8 & 0 & 6 \\ \hline Processing time for C (minutes/unit/worker) & 4 & 0 & 3 & 8 & 5 \\ \hline \multicolumn{6}{|l|}{ Capacity } \\ \hline \multicolumn{6}{|l|}{ Capacity (minutes/hour) } \\ \hline \multicolumn{6}{|l|}{ Capacity (minutes/day) ( 8 hours/day) } \\ \hline \multicolumn{6}{|l|}{ Demand, Workload, \& Implied Utilization } \\ \hline \multicolumn{6}{|l|}{ Demand for A (units/day) } \\ \hline \multicolumn{6}{|l|}{ Demand for B (units/day) } \\ \hline \multicolumn{6}{|l|}{ Demand for C (units/day) } \\ \hline \multicolumn{6}{|l|}{ Workload on A (minutes/day) } \\ \hline \multicolumn{6}{|l|}{ Workload on B (minutes/day) } \\ \hline \multicolumn{6}{|l|}{ Workload on C (minutes/day) } \\ \hline Total workload (minutes/day) & & & 2070 & & \\ \hline \multicolumn{6}{|l|}{ Implied utilization ( %,2 decimals) } \\ \hline \multicolumn{6}{|l|}{ Flow Rate \& Utilization } \\ \hline \multicolumn{6}{|l|}{ Flow rate of A (units/day) } \\ \hline \multicolumn{6}{|l|}{ Flow rate of B (units/day). } \\ \hline \multicolumn{6}{|l|}{ Flow rate of C (units/day) } \\ \hline Effective workload on A (minutes/day) & & 2 & & & \\ \hline \multicolumn{6}{|l|}{ Effective workload on B (minutes/day) } \\ \hline \multicolumn{6}{|l|}{ Effective workload on C (minutes/day) } \\ \hline \multicolumn{6}{|l|}{ Total effective workload (minutes/day) } \\ \hline Effective IU (%,2 decimals ) & & 86.81% & . & & \\ \hline Utilization ( %,2 decimals) & & & & & \\ \hline \end{tabular} assume that inputs are always sufficient. On the demand side, we know demands for products A,B, and C per day as follows: demand for A is 156 units per day; demand for B is 180 units per day; and demand for C is 210 units per day. We assume a fixed product mix of A:B:C. (a)[2] Draw a process flow diagram of the process, assuming that there are buffers between resources. Make sure to have process boundaries. (b)[1] Find two measures of capacity for each resource as in the table. (c)[1] Find total workload on each resource. (d)[1] Find implied utilizations of individual resources. Draw the implied utilization profile. (e) [1] Find the bottleneck and the demand-acceptance ratio (if IU[BN] >1 then DAR =1/IU[BN] ). (f) [1] Based on the demand-acceptance ratio, find the effective flow rates of A,B, and C. Explain. (g)[1] Find total effective workload and effective IU on each resource. (h)[1] Find utilizations of individual resources. Draw the utilization profile. (i)[1] Process analysis is for designing and improving business processes! By looking at the implied utilization and utilization profiles, propose one way to reallocate workers among the resources so as to increase the flow rates of products A, B, and C. For this part, you should try to implement the table in Excel and reallocate workers in your Excel template (optional)