Question
A warehouse serves 3 retail stores with a certain home cleaning product. The retail stores are called Fairview, Bristol, and Springfield (for the towns they
A warehouse serves 3 retail stores with a certain home cleaning product. The retail stores are called Fairview, Bristol, and Springfield (for the towns they are in). The lead time between any retail store and this warehouse is 4 working days. The lead time between the warehouse and the manufacturer is 10 working days. Daily demand for the working days in the past year is given in the Excel file for this question. Each row in the Excel file gives demand for that day. The data runs from day 1 to day 312 because the stores were only open for 312 working days in the calendar year.
The company uses a cycle service level (CSL) of 98% for this product.
AutoSave Off H Echelon Scenario Data - Excel Search shemuel gloster SG File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments B317 fx A B D E F H 1 J K L M N O P Q R S IA 1 2 Echelon Scenario Data 3 4 Working Day Fairview 5 1 89 6 2 102 Bristol 54 99 Springfield 79 110 7 3 67 95 96 4 8 9 9 88 83 102 109 55 75 5 67 102 10 6 74 11 128 93 79 12 8 70 68 107 13 9 97 102 86 14 10 74 92 93 84 15 11 84 89 16 12 81 104 101 17 13 74 99 83 72 18 14 88 90 15 71 78 96 19 20 79 16 86 102 1001 21 17 91 113 22 18 114 89 123 19 83 87 23 24 68 85 20 98 106 109 25 21 70 80 Sheet1 Ready 3 + 100% o Type here to search 3 2 . N W X 10:31 AM 10/23/2020 AutoSave Off H Echelon Scenario Data - Excel Search shemuel gloster SG File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments B317 fx A B D E F H 1 J K L M N O P Q R S IA 1 2 Echelon Scenario Data 3 4 Working Day Fairview 5 1 89 6 2 102 Bristol 54 99 Springfield 79 110 7 3 67 95 96 4 8 9 9 88 83 102 109 55 75 5 67 102 10 6 74 11 128 93 79 12 8 70 68 107 13 9 97 102 86 14 10 74 92 93 84 15 11 84 89 16 12 81 104 101 17 13 74 99 83 72 18 14 88 90 15 71 78 96 19 20 79 16 86 102 1001 21 17 91 113 22 18 114 89 123 19 83 87 23 24 68 85 20 98 106 109 25 21 70 80 Sheet1 Ready 3 + 100% o Type here to search 3 2 . N W X 10:31 AM 10/23/2020Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started