PLEASE SHOW WORK IN EXCEL AND SHOW FORMULA'S IN IN SCREENSHOT ALSO THANKS

PLEASE SHOW WORK IN EXCEL AND SHOW FORMULA'S IN IN SCREENSHOT ALSO THANKS

4.* Abbott Manufacturing produces plastic cases for solar photovoltaic panels and has decided to combine orders from customers to increase work order size, and thereby make one large production run per model type. Plastic injection molding machines are used to make these parts, and it is time consuming to clean the machines and set them up again between production runs. Each molding machine and operator works one 9-hour shift with a one-hour lunch break and one-half hour for operator breaks. Setup (Changeover) Processing Time per Time per Consolidated Work Order Work Order Panel Work Orders Quantity (Minutes) (Seconds) Model XVT-5 9,500 90 2.05 Case panels Model UYT-3 7,500 75 1.78 Case Model KLY-6 10,800 150 4.31 Case What is the total workload (demand) in hours for this work order mix? How many machines will it take to do this work in 1, 2, or 3 days? How might this process be improved