Read the both the entire Case Study (New England Foundry) & the chapters application program that explains how to use the Using Excel Modules for Queuing Model Computations.
Then Use Excel TreePlan and Excel Solver and APA style Word document to answer the Case Questions by providing detailed answers.
1. How much time would the new layout save?
2. If maintenance personnel were paid $9.50 per hour and molding personnel were paid $11.75 per hour, how much could be saved per hour with the new factory layout?