The purpose of this assignment is to use analytics techniques to analyze a case problem. Part 1 Read Case Study Case 15.2 “Ebony Bath Soap” from the textbook, and then complete the following items. For Questions 1 and 2 of the case, use the Palisade De
Michelle_Michy
20190130233239mis_665_rs_topic_3_case_study_template.xlsxHome>Business & Finance homework help>Marketing homework help>The purpose of this assignment is to use analytics techniques to analyze a case problem. Part 1 Read Case Study Case 15.2 “Ebony Bath Soap” from the textbook, and then complete the following items. For Questions 1 and 2 of the case, use the Palisade De
Sheet1
| Ebony Bath Soap Simulation | |||||||
| Inputs | Production policy: | ||||||
| Average demand | 120 | If inventory < | 30 | then produce | 130 | ||
| Stdev of demand | 15 | If inventory > | 80 | then produce | 110 | ||
| Unit holding cost | $30 | Otherwise, don't change production level. | |||||
| Prod change cost | $3,000 | ||||||
| Initial inventory | 60 | ||||||
| Current prod level | 120 | Annual cost | |||||
| Simulation of 52 weeks | Next week | ||||||
| Week | Normal | Demand Author: Make sure demand is an integer and not negative | Inventory | Production | Holding cost | Change cost | Weekly cost |
