Question: solve and explain steps to run the simulation in excel We consider the Butler Internet Company, which distributes a wireless router. Each router costs Butler

solve and explain steps to run the simulation in excel  solve and explain steps to run the simulation in excel We
consider the Butler Internet Company, which distributes a wireless router. Each router

We consider the Butler Internet Company, which distributes a wireless router. Each router costs Butler $75 and sells for $125. Thus Butler realizes a gross profit of $125$75=$50 for each router sold. Monthly demand for the router is described by a normal probability distribution with a mean of 100 units and a standard deviation of 20 units. - Butler receives monthly deliveries from its supplier and replenishes its inventory to a level of Q=100 at the beginning of each month. This beginning inventory level is referred to as the replenishment level. - If monthly demand is less than the replenishment level, an inventory holding cost of $15 is charged for each unit that is not sold. - If monthly demand is greater than the replenishment level, a stock-out occurs and a shortage cost of $30 for each unit is incurred. HW4 Case 1: DQ Gross profit =$50D Holding cost =$15(QD) Net profit = Gross profit - Holding cost =$50D$15(QD) Case 2: D>Q Gross profit =$50Q Shortage cost =$30(DQ) Net profit = Gross profit - Shortage cost =$50Q$30(DQ) Run the simulation for 100 months

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!