MGM 315 4-19-16 Classwork - SA 15 Houston 20 random numbers...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Trade number random number price change stock price price change elative frequenc 1 21 -1/8 22.875 -3/8 0.08 2 84 +1/8 23.125 1/4 0.04 3 7 -3/8 22.625 -1/8 0.16 4 30 0 23 0 0.4 5 94 +3/8 23.375 +1/8 0.2 6 57 0 23 +1/4 0.06 7 57 0 23 +3/8 0.04 8 19 -1/8 22.875 +1/2 0.02 9 84 +1/8 23.125 10 84 +1/8 23.125 0.1308266176 13 Trade number random number price change stock price 1 30 0 2 84 8 3 84 12 4 57 28 5 30 68 6 7 88 7 21 94 8 84 98 9 30 10 21
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
random numbers 00-07 08-11 12-27 28-67 68-87 88-93 94-97 98-99 =rounddown(100,cell,0) Starting price random number action 1 98 0.5 -0.125 2 24 -0.125 -0.25 3 60 0 -0.125 4 57 0 0 5 99 0.5 0.125 6 45 0 0.25 7 51 0 0.375 8 48 0 0.5 9 51 0 10 64 0 Average
Image of page 2
23 final price 23.5 22.875 23 23 23.5 23 23 23 23 23 23.0875
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
this day location next day loation austin San antonio Houston austin 0.6 0.15 0.25 san antonio 0.2 0.75 0.05 houston 0.15 0.05 0.8 current austin current san antonio current houston next day random numbers next day random numbers next day austin 00-59 austin 00-19 austin SA 60-74 SA 20-94 SA Houston 75-99 Houston 95-99 Houston start in houston day random number days location 1 51 #N/A 2 57 #N/A 3 53 #N/A 4 95 #N/A 5 27 #N/A 6 61 #N/A 7 3 #N/A 8 83 #N/A 9 26 #N/A 10 61 #N/A 11 81 #N/A 12 9 #N/A 13 31 #N/A 14 93 #N/A 15 66 #N/A 16 49 #N/A Austin
Image of page 4
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SA 15 Houston 20 random numbers 00-14 15-19 20-99 start in ausTn start in SA day random number days locaTon day 1 79 1 2 76 2 3 99 3 4 96 4 5 27 5 6 46 6 7 47 7 8 91 8 9 58 9 10 64 10 11 56 11 12 88 12 13 94 13 14 57 14 15 69 15 16 24 16 AusTn AusTn SA 60 SA Houston 75 Houston random number days locaton 48 82 61 92 99 27 56 56 9 42 31 76 91 18 100 51 20 95 current order 100 unsold cost $15 stockout cost $30 demand average 100 demand st.dev 20 iteraTon demand gross proft holding cost stockout cost total proft Average 1 133.6611 5000 0 1009.8338714 6009.83387 5524.181 2 89.23633 4461.816296 161.4551111 0 4623.27141 3 88.10692 4405.346188 178.3961436 0 4583.74233 4 99.01442 4950.720815 14.78375557 0 4965.50457 5 101.2852 5000 0 2438.5551309 7438.55513...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern