758654 Solve by hand or using excel A product has the Time P…
758654 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 75 89 89 60 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 an ‘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