948235 Solve by hand or using excel A product has the Time P…
948235 Solve by hand or using excel A product has the Time Phased Net Net Requirement Below. Assume the setup cost is $200/order and holding cost is $0.3/week. Week 1 2 3 4 5 Time phased Net Requirements 74 85 84 95 57 What is Lambda? /week (round up to next integer, use this rounded up number in your EOQ calculation. For example, if Lambda is 31.23, use 32) What is the EOQ? units Place a ‘X’ in the cells below for the weeks in which you would release an order based on the EOQ Lot Sizing Rule. If nothing is release enter the number zero ‘0’. I am doing this so that you can get partial credit if the above calculations are incorrect. Week 1 2 3 4 5 Planned Order Release