ࡱ>  \p Neil Gupta Ba==h #8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) General_)                + ) , *  !    ! #   !  ! " " " (8""@ @ 8 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`i Sheet1! Amt_Stocked:Demand:Exp_Cost:F_Cost:" Demand Amt StockedCostsPer UnitTotalExpiration Cost Air Freight Overall CostHistorical DataMonthAverageCSee an interactive simulation version of this problem in chapter 45k mcc  28 .  dMbP?_*+%&A Page &P"P??U} }  } q}  } U}  2 @ h@      ~ @~ @     ~ I@G1CC CCC B ~ b@G1CC CCC B !  DD      ?$@# @ % 0B@@@$@@ @@@@@@@ @@"@@$@@&@@(@@*@@,@@.@@0@@1@@2@@3@@>~0&*gg 3*=  !"#$%&'()*+,-./01 4@@ !5@@!"6@@"#7@@#$8@@$%9@ @%&:@@&';@@'(<@@()=@@)*>@@*+?@@+,@@@,-@@@-.A@ @./A@?/0B@@0 1(T >@  7 Oh+'0HPh| Sam L. Savage Neil GuptaMicrosoft Excel@~@H^iG,       '' ' -  -""- @ !"---#- @ !"--EE#- @ !"E-cc#- @ !"c-zz#- @ !"z-#- @ !"-#- @ !"-#- @ !"-#- @ !"-- @ !-- @ !-- @ !-- @ !-  @ !"- -#- @ !#-""- @ !"-Arial-  2  1| 2 1 2| 2 N 3| 2 g 4| 2 ~ 5| 2 6| 2 7| 2 8| 2 aA| 2 B| 2 ?C|  "SystemP9-'- #-   @ !-" Arial- 2 &Demand  2  Amt Stocked   2 /a5| 2 /@5| 2 e&Costsd  2 ePer Unit  2 e^Totaln  2 |&Expiration Cost     2 |$50.00  02 |$0.000  2 & Air FreightC    2 $150.00t  02 $0.000  2 & Overall Cost   02 $0.000  - -'-- -   -"-"- @ !"--- @ !-F""- @ !F"-F- @ !F-- @ !-- @ !-"- @ !j"---- @ !--EE- @ !E-c"c- @ !jc"-z"z- @ !jz"-"- @ !j"-"- @ !j"-"- @ !j"-"- @ !j"--'- #-'- -  -- @ !-- @ !-'՜.+,0HP X`hp x  Sheet1 Amt_StockedDemand Exp_CostF_Cost  Worksheets Named Ranges Root Entry FWorkbooksSummaryInformation( DocumentSummaryInformation8