*** I ONLY NEED PART 2 DONE OF THIS ASSIGNMENT (500-750-word summary to company management). I HAVE ATTACHED THE ORIGINAL ASSIGNMENT THAT HAS BOTH PARTS COMPLETED BUT PART 2 WAS NOT ANSWERED CORRECTLY AND I NEED A BETTER SUMMARY FORTHE INSTRUCTOR*** The
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 |