I’m working on a supply chain multi-part question and need an explanation to help me understand better. About 20 maths problems on the following: Must be solved in excel sheet and explain all steps I will provide examples of the maths problems upon matching.
Chapter 1 – multi – and single-factor productivity
Chapter 2 – weighted scoring matrix
Chapter 3 – network diagrams, the critical path forward and backward passes, crashing, PERT estimates (a + 4m +b)/6
Chapter 4 – moving average, weighted moving average, exponential smoothing, exponential smoothing with the trend, least-squares trend, linear regression, MAD, MSE, MAPE,, seasonal index
Chapter 5: Decision Trees
Chapter 7: Crossover Charts
Chapter 8: Crossover Charts, Weighted Scoring Matrix
Chapter 9: Process Oriented Layouts (distance moved calculation), Assembly Line Balancing
Chapter 11: Three measures of supply chain performance (% assets, inventory turnover, weeks of supply)
Chapter 12: ABC Analysis, EOQ, Annual holding cost, Annual setup/ordering cost, reorder point
Chapter 15: Assignment method, sequencing jobs, Johnsons Rule. There may be questions on any of these topics. A simplified format may be used for some problem classes.