CH%2023_P3A - CH 23_P3 Chapter 23 Problem 3 Order Cost Holding cost Shortage Cost Order up to Order $500.00 Annual Mean $33.33 Annual Std dev $150.00

CH%2023_P3A - CH 23_P3 Chapter 23 Problem 3 Order Cost...

This preview shows page 1 - 4 out of 48 pages.

CH 23_P3Page 1Chapter 23 Problem 3A 16 1/3 year simulation Order Cost$500.00 Annual Mean990assuming initial inventoryHolding cost$33.33 Annual Std. dev.40Shortage Cost$150.00 Leadtime0.11Order up to #ADDIN? Review Period0.33 Average Annual costOrder #Initial InventoryOrder SizeLeadtime Demand1500#ADDIN?#ADDIN?#ADDIN?#ADDIN?2#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?3#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?4#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?5#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?6#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?7#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?8#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?9#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?10#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?11#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?12#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?13#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?14#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?15#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?16#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?17#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?18#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?19#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?20#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?21#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?22#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?23#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?24#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?25#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?26#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?27#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?28#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?29#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?30#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?31#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?32#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?33#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?34#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?35#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?36#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?37#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?38#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?39#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?40#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?41#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?42#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?43#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?44#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?45#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?Leadtime shortageNonleadtime demand
CH 23_P3Page 246#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?47#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?48#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?49#ADDIN?#ADDIN?#ADDIN?#ADDIN?#ADDIN?Workbook NameCH 23_P3A.xlsNumber of Simulati1Number of Iteration100Number of Inputs98Number of Outputs1Sampling TypeLatin HypercubeSimulation Start Tim4/22/10 11:33:24Simulation Stop Tim4/22/10 11:33:24Simulation Duration0:00:00Random Seed1649866153Total Errors0Output and Input Summary StatisticsOutput NameOutput CellSimulationMinimumMaximumAverage Annual cos$G$51$16,578 $18,191 PART BSummary InformationWorkbook NameCH 23_P3B.xlsNumber of Simulations4Number of Iterations100Number of Inputs99Number of Outputs1Sampling TypeLatin HypercubeSimulation Start Time4/22/2010 11:49Order up to 400 is best oSimulation Stop Time4/22/2010 11:49Simulation Duration00:00:00Random Seed354601706OutputStaNameCellSimMinimumMeanMaximumAverage Annual costG51$102,015 $107,131 $116,065 Average Annual costG52$22,750 $26,739 $33,454 Average Annual costG53$27,324 $28,733 $29,429 Average Annual costG54$47,118 $48,527 $49,223 Order to 480 is the best of the five policies.
CH 23_P3Page 3was runy of 500 TV's#ADDIN?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture