Case Solutions Data Analysis, Optimization, and Simulation Modeling, International Edition, 4th Edition

C01_01.xlsx


Sheet: Solution




C02_01.xlsx


Sheet: Solution
Numbers of six-packs purchased
Beer B Beer C Any Customer Beer A Beer B
9.296296296296296 9.545454545454545 8.766666666666667 1 4 0
2 1 1
3 4 0
4 5 1
5 5 1
6 2 1
7 3 1
8 4 1
9 3 0
10 6 0
11 5 1
12 1 0
13 1 1
14 4 0
15 4 1
16 3 0
17 2 1
18 4 0
19 3 0
20 5 0
21 1 1
22 1 0
23 2 0
24 2 1
25 3 0

, 26 5 0
27 0 4
28 3 0
29 6 0
30 5 1




C02_02.xlsx


Sheet: Source

Sheet: Data
Month Closing Value Percentage Change
1950-01-01 00:00:00 201.79
1950-02-01 00:00:00 203.44 0.008176817483522503
1950-03-01 00:00:00 206.05 0.012829335430593855
1950-04-01 00:00:00 213.56 0.03644746420771653
1950-05-01 00:00:00 223.42 0.046169694699381834
1950-06-01 00:00:00 209.11 -0.06404977173037317
1950-07-01 00:00:00 209.4 0.001386829898139697
1950-08-01 00:00:00 216.87 0.03567335243553008
1950-09-01 00:00:00 226.36 0.04375893392354871
1950-10-01 00:00:00 225.01 -0.005963951228132279
1950-11-01 00:00:00 227.6 0.011510599528909841
1950-12-01 00:00:00 235.42 0.03435852372583477
1951-01-01 00:00:00 248.83 0.056962025316455805
1951-02-01 00:00:00 252.05 0.012940561829361406
1951-03-01 00:00:00 248.53 -0.013965483039079588
1951-04-01 00:00:00 259.13 0.042650786625357075
1951-05-01 00:00:00 249.65 -0.03658395399992278
1951-06-01 00:00:00 242.64 -0.028079311035449705
1951-07-01 00:00:00 257.86 0.062726673260798
1951-08-01 00:00:00 270.25 0.04804932909330639
1951-09-01 00:00:00 271.16 0.0033672525439408883
1951-10-01 00:00:00 262.35 -0.032490042779170974
1951-11-01 00:00:00 261.27 -0.004116638078902385
1951-12-01 00:00:00 269.23 0.030466567152753997

,1952-01-01 00:00:00 270.69 0.005422872636778886
1952-02-01 00:00:00 260.08 -0.03919612841257532
1952-03-01 00:00:00 269.46 0.036065825899723146
1952-04-01 00:00:00 257.63 -0.04390262005492461
1952-05-01 00:00:00 262.94 0.020610953693281073
1952-06-01 00:00:00 274.26 0.04305164676352017
1952-07-01 00:00:00 279.56 0.019324728359950454
1952-08-01 00:00:00 275.04 -0.01616826441551002
1952-09-01 00:00:00 270.61 -0.016106748109365934
1952-10-01 00:00:00 269.23 -0.005099589815601772
1952-11-01 00:00:00 283.66 0.05359729599227429
1952-12-01 00:00:00 291.9 0.029048861312839142
1953-01-01 00:00:00 289.77 -0.00729701952723534
1953-02-01 00:00:00 284.27 -0.018980570797529076
1953-03-01 00:00:00 279.87 -0.015478242515917886
1953-04-01 00:00:00 274.75 -0.01829420802515455
1953-05-01 00:00:00 272.28 -0.008989990900819025
1953-06-01 00:00:00 268.26 -0.014764213309828052
1953-07-01 00:00:00 275.38 0.026541415045105512
1953-08-01 00:00:00 261.22 -0.05141985619870713
1953-09-01 00:00:00 264.04 0.010795498047622667
1953-10-01 00:00:00 275.81 0.04457657930616566
1953-11-01 00:00:00 281.37 0.020158804974438935
1953-12-01 00:00:00 280.9 -0.0016703984077905507
1954-01-01 00:00:00 292.39 0.0409042363830545
1954-02-01 00:00:00 294.54 0.007353192653647643
1954-03-01 00:00:00 303.51 0.030454267671623445
1954-04-01 00:00:00 319.33 0.052123488517676494
1954-05-01 00:00:00 327.49 0.025553502646165488
1954-06-01 00:00:00 333.53 0.01844331124614481
1954-07-01 00:00:00 347.92 0.04314454471861615
1954-08-01 00:00:00 335.8 -0.03483559438951484
1954-09-01 00:00:00 360.46 0.07343656938653952
1954-10-01 00:00:00 352.14 -0.02308161793264161
1954-11-01 00:00:00 386.77 0.09834156869426931
1954-12-01 00:00:00 404.39 0.04555679085761565
1955-01-01 00:00:00 408.83 0.010979499987635692
1955-02-01 00:00:00 411.87 0.0074358535332534805

, 1955-03-01 00:00:00 409.7 -0.005268652730230451
1955-04-01 00:00:00 425.65 0.03893092506712226
1955-05-01 00:00:00 424.86 -0.0018559849641723567
1955-06-01 00:00:00 451.38 0.06242056206750454
1955-07-01 00:00:00 465.85 0.03205724666578055
1955-08-01 00:00:00 468.18 0.005001609960287612
1955-09-01 00:00:00 466.62 -0.0033320517749583544
1955-10-01 00:00:00 454.87 -0.02518108953752518
1955-11-01 00:00:00 483.26 0.0624134368061204
1955-12-01 00:00:00 488.4 0.010636096511194773
1956-01-01 00:00:00 470.74 -0.03615888615888609
1956-02-01 00:00:00 483.65 0.027424905467986507
1956-03-01 00:00:00 511.79 0.0581825700403185
1956-04-01 00:00:00 516.12 0.008460501377518092
1956-05-01 00:00:00 478.05 -0.07376191583352708
1956-06-01 00:00:00 492.78 0.03081267649827416
1956-07-01 00:00:00 517.81 0.050793457526685286
1956-08-01 00:00:00 502.04 -0.03045518626523228
1956-09-01 00:00:00 475.25 -0.05336228188988929
1956-10-01 00:00:00 479.85 0.009679116254602889
1956-11-01 00:00:00 472.78 -0.014733770970094925
1956-12-01 00:00:00 499.47 0.0564533186683025
1957-01-01 00:00:00 479.16 -0.04066310288906241
1957-02-01 00:00:00 464.62 -0.030344770014191544
1957-03-01 00:00:00 474.81 0.021931901338728417
1957-04-01 00:00:00 494.36 0.04117436448263518
1957-05-01 00:00:00 504.93 0.021381179707096028
1957-06-01 00:00:00 503.29 -0.003247974966827058
1957-07-01 00:00:00 508.52 0.01039162311987117
1957-08-01 00:00:00 484.35 -0.04753008731220003
1957-09-01 00:00:00 456.3 -0.05791266646020442
1957-10-01 00:00:00 441.04 -0.03344291036598727
1957-11-01 00:00:00 449.87 0.02002085978596042
1957-12-01 00:00:00 435.69 -0.0315202169515638
1958-01-01 00:00:00 450.02 0.032890357823222895
1958-02-01 00:00:00 439.92 -0.022443446957912908
1958-03-01 00:00:00 446.76 0.015548281505728257
1958-04-01 00:00:00 455.86 0.020368878144865304