Please answer #8 in excel format with the formulas showing. Screenshots work perfectly!

9:51 Cancel Text - operati...nd-edition.pdf following production schedule for the next 4 weeks for three of its furniture products: Week 4 2 70 3 120 Product Dresser Dining Table Chair 50 20 90 30 100 90 65 60 140 The two critical work centers for manufacturing these products are sanding and painting. The sanding work center has efficiency and utilization rates of 96% and 92%, respectively. Similarly, the painting work center has efficiency and utilization rates of 92% and 96%, respectively. The time required in hours) for each furniture product at each work center is given in the following table: Work Center Chair Sanding Painting Dresser 0.75 1.0 Dining Table 0.5 0.75 0.3 0.5 Assuming each work center is available for 40 hours a week, determine the capacity and load profile for each work center for each week. 8. A work center has two machines and two operators. The work center operates on two shifts, and each operator works one shift at 8 hours per shift. The efficiency and utilization rates of the two machines and operators at this work center are 95% and 90%, respectively. The following table presents the work order to be completed in this work center on Friday of this week along with the information on the number of units to be produced, setup time, and the run time for each work order. Is there sufficient capacity available in this work center to complete all work orders? If not, what options would you suggest to mitigate the capacity overload? Setup Time (in minutes) of Units 300 8 Work Ordere 702 520 650 830 Run Time (in minutes per unit) 0.15 0.10 0.30 0.20 15 700 3.500 7,500 7 20 9. Given the following product structure tree, master production schedule, and routing and work standards information: III Q (3) R (2) S (4) T (2) 0 comments Activity Page 1405 @ Type a comment 1 9:51 Cancel Text - operati...nd-edition.pdf following production schedule for the next 4 weeks for three of its furniture products: Week 4 2 70 3 120 Product Dresser Dining Table Chair 50 20 90 30 100 90 65 60 140 The two critical work centers for manufacturing these products are sanding and painting. The sanding work center has efficiency and utilization rates of 96% and 92%, respectively. Similarly, the painting work center has efficiency and utilization rates of 92% and 96%, respectively. The time required in hours) for each furniture product at each work center is given in the following table: Work Center Chair Sanding Painting Dresser 0.75 1.0 Dining Table 0.5 0.75 0.3 0.5 Assuming each work center is available for 40 hours a week, determine the capacity and load profile for each work center for each week. 8. A work center has two machines and two operators. The work center operates on two shifts, and each operator works one shift at 8 hours per shift. The efficiency and utilization rates of the two machines and operators at this work center are 95% and 90%, respectively. The following table presents the work order to be completed in this work center on Friday of this week along with the information on the number of units to be produced, setup time, and the run time for each work order. Is there sufficient capacity available in this work center to complete all work orders? If not, what options would you suggest to mitigate the capacity overload? Setup Time (in minutes) of Units 300 8 Work Ordere 702 520 650 830 Run Time (in minutes per unit) 0.15 0.10 0.30 0.20 15 700 3.500 7,500 7 20 9. Given the following product structure tree, master production schedule, and routing and work standards information: III Q (3) R (2) S (4) T (2) 0 comments Activity Page 1405 @ Type a comment 1