tugas manajemen sains - simulasi monte carlo

Upload: ichann

Post on 10-Oct-2015

39 views

Category:

Documents


0 download

DESCRIPTION

Tugas ke III mata kuliah Manajemen Sains (Simulasi)

TRANSCRIPT

Sheet2PCs Demand per WeekFrequency on DemandProbability of Demandfrequency probabilityCumulative Frequency050.02221100.04462150.066123200.088204200.088285250.110386300.1212507400.1616668350.1414809300.12129210200.088100TOTAL2501100Demand, xfrequency probabilityRandom Ns Range, r020-1142-5266-113812-194820-2751028-3761238-4971650-6581466-7991280-9110892-99

WeekRNDemand, xRevenue $17483440024262580034562580042541720058093870069286007244172008537301009819387001051730100111001230521500135173010014768344001536521500164062580017224172001890938700191128600201028600218793870022607301002351730100245673010025274172002682860027496258002821417200291231290030567301003138625800328793870033000341531290035909387003651730100377283440038274172003945625800405073010041204172004295104300043928600443143004520417200462141720047928600487983440049355215005022417200514462580052100535773010054829387005536521500564562580057163129005874834400598093870060748344006157730100626286006348625800641331290065748344006682860067567301006834521500694762580070788344007138625800724562580073244172007432521500751931290076335215007722417200785073010079951043000806683440081153129008253730100837383440084123129008518312900863452150087183129008826417200896473010090768344009136521500924762580093647301009474834400951028600966286009750730100985143009921430010060730100101708344001027283440010356730100104517301001051331290010678834400107112860010825417200109426258001104562580011192860011278834400113153129001144862580011524417200116829387001173452150011883938700119517301001209710430001216573010012222417200123446258001248793870012567834400126647301001278993870012813312900129436258001306573010013157730100132668344001332952150013439625800135627301001368286001378693870013881938700139507301001404562580014183938700142748344001434062580014474834400145718344001465173010014762730100148708344001494143001507183440015120417200152446258001534862580015416312900155285215001565773010015787938700158486258001591931290016033521500161315215001621931290016317312900164274172001653752150016693104300016722417200168587301001697583440017058730100171456258001725273010017392104300017492104300017586938700176274172001773862580017871834400179486258001808093870018162860018211286001834762580018425417200185396258001861731290018741430018833521500189961043000190314300191849387001929510430001934862580019489938700195819387001969910430001974462580019812312900199335215002008286002015573010020256730100203597301002048793870020539625800206728600207718344002089510430002093352150021025417200211496258002121331290021392104300021469834400215819387002165143002174162580021823417200219829387002204262580022132521500222899387002234762580022478834400225315215002269910430002274762580022848625800229396258002305473010023136521500232325215002337283440023462730100235738344002362641720023732521500238476258002396273010024096104300024194104300024210286002435273010024490938700245224172002461128600247123129002485273010024956730100250414300Total Demand selama 250 minggu1469Demand rata-rata5.876Total Revenue6316700Rata-rata Revenue25266.8Expected Value6.06error sampling0.184

Sheet3