Here is the "Delta Products" case for Graduate Operations. You require showing the number of hours for Mike's and Nikki's plan. To do this you require computing the number of hours needed for every option. You also should check Nikki's calculations for EOQ. When you have calculated the hours and checked the calculations for EOQ you require submitting a memo to your manager outlining your findings. Submit this memo along with a single page Excel spreadsheet that shows your calculations for Mike and Nikki's hours in addition to Nikki's EOQ calculations. Keep in mind, the memo should be no more than one page long (preferably one-half page).
1. Are Nikki's EOQ computations correct?
2. Whose proposal should be accepted?
3. Are there any other possibilities to decrease costs?
4. Finally, in your last sentence, tell your supervisor what you learned in the analysis.
I have also given an Excel template to help you organize your calculations. Though, this time formulas are not included.