*** 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

profileMichelle_Michy
attachment_1.xlsx

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