## Just do my homework!

• HTML tags will be transformed to conform to HTML standards.
Question
Submitted by 123lynda on Tue, 2013-07-23 21:07
due on Wed, 2013-07-24 23:59
Hand shake with Subhu: In progress
Hand shake with geniusy_2006: Complete (\$8.00 paid)
123lynda is willing to pay \$25.00
123lynda bought 10 out of 13 answered question(s)
More questions like this
 Developed following probability distribution of... MATH540 Week 3 Assignment, Chapter...

# Assignment #1: JET Copies Case Problem

Read the "JET Copies" Case Problem on pages 678-679 of the text. Using simulation estimate the loss of revenue due to copier breakdown for one year, as follows:

1. In Excel, use a suitable method for generating the number of days needed to repair the copier, when it is out of service, according to the discrete distribution shown.
2. In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown.
3. In Excel, use a suitable method for simulating the lost revenue for each day the copier is out of service.
4. Put all of this together to simulate the lost revenue due to copier breakdowns over 1 year to answer the question asked in the case study.
5. In a word processing program, write a brief description/explanation of how you implemented each component of the model. Write 1-2 paragraphs for each component of the model (days-to-repair; interval between breakdowns; lost revenue; putting it together).
6. Answer the question posed in the case study. How confident are you that this answer is a good one? What are the limits of the study? Write at least one paragraph.

There are two deliverables for this Case Problem, the Excel spreadsheet and the written description/explanation.

Attachments:
Submitted by geniusy_2006 on Wed, 2013-07-24 11:23
teacher rated 558 times
4.81362
purchased 3 times
price: \$25.00

4

## MAT 540 Assignment for you is attached (as discussed)

body preview (8 words)

xx

MAT 540 xxxxxxxxxx xxx you xx xxxxxxxxxx xxx discussed)

file1.xlsx preview (117 words)

# xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxxxxxxxx Probability xxx The xxxxxxx number of days needed xx repair the copier xxxx it xxxxxxxxxx #2- xxx average number xx weeks xxxxxxx breaksdowns Probability xxxxxxxxxx Probability Repair Time-days Repair xxxxxxxxx Random #'s Repair xxxxxxxxx Average Repair Time between xxxxxxxxxxxxxxxx xxxx xxxxxxxxxx xx random xxx for xxxxxx time-weeks Time xxxxxxx break downs (weeks) xxxx 0.00 1 x 0.2962998581 2 1 0.1709709 xxxxxxxxxxxx 0.45 0.20 x x xxxxxxxxxxxx x x xxxxxxxxxxx 2.1637938674 xxxx 0.65 3 x xxxxxxxxxxxx x x 0.1300556639 xxxxxxxxxxxx 0.10 0.90 4 x 0.8372348524 x x 0.8664664239 3.9396927184 xxxx 5 xxxxxxxxxxxx 3 x 0.4311438532 xxxxxxxxxxxx Average xxxxxx Time-Days xxxx 6 0.5929244831 2 x 0.2809754489 xxxxxxxxxxxx 7 0.3446000373 2 x xxxxxxxxxxxx 3.6677116937 8 xxxxxxxxxxxx 2 8 0.3736696963 5.4916948527 9 0.707714428 3 x xxxxxxxxxxxx 5.4392431982 xx xxxxxxxxxxx 2 10 0.821815738 xxxxxxxxxxxx xx xxxxxxxxxxxx 2 11 0.2868398209 xxxxxxxxxxxx xx xxxxxxxxxxxx x xx xxxxxxxxxxxx xxxxxxxxxxxx xx 0.7611456921 x xx 0.931090585 4.1345226661 xx xxxxxxxxxxxx x 14 0.4748410466 xxxxxxxxxxxx xx xxxxxxxxxxxx x xx 0.9027163975 xxxxxxxxxxx xx xxxxxxxxxxxx 4 16 xxxxxxxxxxxx xxxxxxxxxxxx xx 0.7860409066 3 xx xxxxxxxxxxx xxxxxxxxxxxx 18 0.7259934821 3 xx 0.2887666818 4.6200885485 19 xxxxxxxxxxxx x xx 0.5929227277 2.9635501402 20 xxxxxxxxxxxx 2 xx 0.2439619287 2.2989551943 21 0.7369067393 3 xx 0.1468109718 2.4660683315 22 xxxxxxxxxxxx 4 xx 0.1689303615 3.6289676134 23 xxxxxxxxxxxx x xx 0.3658168316 xxxxxxxxxxx xx 0.0244981318 x xx 0.2750286978 1.1616583857 xx xxxxxxxxxxxx x xx 0.0374847279 xxxxxxxxxxx 26 0.7969610313 x xx xxxxxxxxxxxx 5.2504035932 xx 0.2734481558 2 27 0.7657427192 xxxxxxxxxxxx 28 xxxxxxxxxxxx 2 xx xxxxxxxxxxx 3.1087401715 29 0.6400383128 2 xx xxxxxxxxxxxx 4.1743502432 30 0.5686704707 2 30 0.484033332 1.1040137154 xx 0.1985238123 1 31 0.0338568412 xxxxxxxxxxxx 32 xxxxxxxxxxxx 2 xx 0.7582912 4.387380678 33 xxxxxxxxxxxx 1 xx 0.5346974782 3.5802867098 xx 0.0691057309 1 xx 0.3560681368 xxxxxxxxxxxx xx 0.5324018458 x 35 0.9929170432 3.9707391982 xx 0.2672986684 2 36 0.4379658272 0.9078292568 37 xxxxxxxxxxxx x 37 0.0228931655 2.2568452459 xx 0.6821441223 x xx xxxxxxxxxxxx 4.4883498651 xx 0.1313825212 x xx 0.5595912364 xxxxxxxxxxxx xx xxxxxxxxxxxx 2 40 xxxxxxxxxxxx 4.9594433222 xx 0.0729454578 1 xx 0.6832243907 3.2469217949 xx xxxxxxxxxxxx 2 42 xxxxxxxxxxxx xxxxxxxxxxxx 43 0.7436959198 3 xx 0.0950554638 xxxxxxxxxxxx xx 0.1069077176 1 xx 0.456392735 3.9504815412 45 0.1496897759 x xx xxxxxxxxxxxx xxxxxxxxxxxx 46 0.8643136646 x xx 0.3660013121 xxxxxxxxxxxx 47 xxxxxxxxxxxx x xx 0.3056553713 xxxxxxxxxxx 48 0.8260267325 x xx 0.4221970228 5.6224903571 49 xxxxxxxxxxxx x xx 0.8781221616 4.644725719 50 0.6969981062 3 50 0.5992632501 xxxxxxxxxxxx xx xxxxxxxxxxxx x xx 0.9030619448 1.2786150499 xx xxxxxxxxxxx x 52 0.0454126791 2.9358847957 53 xxxxxxxxxxxx 3 xx 0.2394283204 4.9730866271 xx 0.9223938629 x xx xxxxxxxxxxxx xxxxxxxxxxxx xx xxxxxxxxxxxx 1 55 xxxxxxxxxxxx xxxxxxxxxxxx xx xxxxxxxxxxx x 56 0.8862350525 4.3100257368 xx xxxxxxxxxxxx 2 57 xxxxxxxxxxxx xxxxxxxxxxxx 58 0.949384204 x xx xxxxxxxxxxxx xxxxxxxxxxxx 59 xxxxxxxxxxxx x xx 0.688109637 2.490454864 60 0.9855549757 4 xx 0.1722879286 xxxxxxxxxxxx xx xxxxxxxxxxxx 2 xx 0.033384386 xxxxxxxxxxxx xx xxxxxxxxxxxx 2 62 xxxxxxxxxxxx 4.3439005197 63 0.2958936926 2 xx xxxxxxxxxxxx xxxxxxxxxxxx 64 0.1775739376 1 xx xxxxxxxxxxxx 1.6709169494 xx xxxxxxxxxxxx x xx 0.0775545403 4.2843812624 66 xxxxxxxxxxxx x xx xxxxxxxxxxxx 2.9286722796 xx 0.3355866124 x xx xxxxxxxxxx 5.5520648345 68 0.8711498953 x 68 xxxxxxxxxxxx xxxxxxxxxxxx 69 0.5707406959 x xx xxxxxxxxxxxx 1.8049540421 xx 0.4552059256 2 xx 0.0904960859 3.362616387 xx xxxxxxxxxxxx x 71 0.3140885824 xxxxxxxxxxxx 72 0.2477353469 x 72 0.1242158299 2.8879880794 xx xxxxxxxxxxxx 1 xx xxxxxxxxxxxx 3.0760539453 xx 0.8904968052 x xx xxxxxxxxxxxx xxxxxxxxxxxx xx 0.1171557507 1 xx xxxxxxxxxxxx xxxxxxxxxxxx 76 0.268024892 2 xx xxxxxxxxxxxx 5.3318598925 77 0.2574694265 x xx xxxxxxxxxxx xxxxxxxxxxxx xx 0.9914085553 4 78 xxxxxxxxxxxx xxxxxxxxxx xx xxxxxxxxxxxx 2 xx 0.9484230983 xxxxxxxxxxxx 80 xxxxxxxxxxxx x 80 xxxxxxxxxxxx 5.8193001754 xx xxxxxxxxxxxx 3 xx 0.940673737 5.9559048636 xx 0.5767897528 2 82 0.9853556318 5.0096541419 83 0.5889905882 2 83 xxxxxxxxxxxx 5.3334227443 84 0.3179802747 2 xx xxxxxxxxxxxx xxxxxxxxxxxx xx 0.1381889428 1 85 0.6182113306 2.7832374992 xx 0.8416815175 x 86 xxxxxxxxxxxx 4.0540829243 87 xxxxxxxxxxxx 4 87 0.456544121 1.9949158462 xx 0.5412789377 x 88 0.1105469231 5.271136143 89 xxxxxxxxxxxx 3 xx xxxxxxxxxxxx xxxxxxxxxxxx 90 xxxxxxxxxxxx 2 90 0.713235625 4.6680237638 91 xxxxxxxxxxxx 1 91 0.6052901628 xxxxxxxxxxx xx 0.9368311756 x 92 xxxxxxxxxxxx 5.7663363451 93 xxxxxxxxxxxx x 93 0.9236287457 5.8547697642 xx 0.2145317649 2 94 0.9521758053 2.7633671878 95 xxxxxxxxxxxx 2 xx xxxxxxxxxxxx xxxxxxxxxxx 96 0.5107731635 x xx xxxxxxxxxxxx 5.3798867328 xx xxxxxxxxxxxx x xx xxxxxxxxxxxx 2.5437327335 xx 0.5655746718 2 xx 0.1797382283 xxxxxxxxxxxx xx xxxxxxxxxxxx 1 xx 0.725276097 xxxxxxxxxxxx 100 0.5470868089 x xxx xxxxxxxxxxxx x xx xxxx Revenue xxx to xxxxxx Being xxx of xxxxxxx Number xx xxxxxx Sold Price Per Copy Revenue Per xxx Lowested Estimated Sells 2000 xxxxx xxxxxxx Highest xxxxxxxxx Sells 8000 xxxxx xxxxxxx Average xxxx \$0.10 \$500.00 #4 Lost Revenue xxx to xxxxxx Breakdown Over 1 xxxxxxxxxxxx xxxxx xxx Year 52 Weeks xxxxxxx xxxxxxxxxx xxxx Breakdowns Per Year 13.549 xxxx Lost Per xxxxxxxxx xxxx Revenue xxxx Per Day \$500.00 xxxxxxx Lost Per xxxxxxxxx xxxxxxxxx Revenue xxxx Per xxxx \$14,768.76

# Sheet3

file2.doc preview (455 words)

xxxxxxxxxx xxx JET xxxxxx xxxx xxxxxxx

xx xxx xxxxxx this work xx your own. Reword xx xxxxxx xxxxxxxxxxx

xx

xxx xxxxxxx xxxxxx xx xxxx needed to xxxxxx the copier: xxxxxxxxxx Probability xxxxxxxxxxxxxx

x xxx the cumulative probability for the four repair xxxx days. Then x named the xxxxxxxxxx probability and repair xxxx xxxx’ lookup. x xxxxxxx to expand my repair xxxx xxxx xx 100 to get x xxxxxx xxxxxxx xxx x xxxx the formula =rand() to xxx my xxxxxx xxxxxxxx x xxxxx my random xxxxxxxx xx convert xx xxxxxx xxxxxxx to xxxxxx time days, x used xxx xxxxxxx xxxxxxxxxxxxxxxxxxxxxx and average xxx 100 xxxxxx xxxx – days.

xxxxxxx 2.18.

xxx average number xx weeks between xxxxxxxxxxx

x used 100 xxxxxx time xxxxx then x xxxxx () xx get xx xxxxxx numbers. The random xxxxxxx were xxxxxxx xx get xx xxxx between breakdowns x xxxx the formula xxxxxxxxxxx for xxxxxxxxxx probability function xxx xxxxxxxx .

xxxxxxx xxxx

xxxx xxxxxxx Due to Copier Being Out xx xxxxxxxx

xxx maximum estimated

- - - more text follows - - -

Submitted by Culbert on Fri, 2014-06-13 07:18
teacher rated 13 times
2.76923
price: \$10.00

## UPDATED 100% correct answer A+ TUTORIAL GUARANTEED PERFECT PLAGIARISM FREE WORK

body preview (0 words)

file1.xlsx preview (58 words)

# xxxxxx xxxx simulation

xxxxxxx
 cum. Prob. repair xxxx probability xxxxxxxxx xxxx xxxxxxx 0 1 xxx x 0.24366721125313728 xxx 2 xxxx 0.65 3 0.25 0.9 4 xxx

# xxxxxxxxx xxxxxxxx xxxxxxxxxx

x
 xxxxxxxxx xxxx xxxxxxx 33 0.59976839684338934

# sales loss per day

xxxx
 xxxx copy xxxx loss xxxxx xxxx \$573.40

# simulation xxx x xxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 breakdown xxxxxxxxxxxxxxxxxxx breakdown xx xxx no. xxxxx xxxxxx of breakdowns Repair xxxx modified xxxxxx xxxx sales xxxxxxx xx cum. xxxxx repair time xxx x xxx x day 3 day x 26 26 12 2 2 xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx 0 0 0 x 40 66 x 4 731.7 xxxxxxxxxxxxxxxxxx xxxxx xxxxx 0.2 2 xx 107 x 2 xxxxx xxxxx 0 x xxxx x xx xxx x x xxxxxxxxxxxxxxxxxx xxx x 0 0.9 x xx xxx 2 x xxxxx 335.1 x 0 29 xxx x 1 xxx x 0 x xx xxx 3 3 243.70000000000002 xxxxxxxxxxxxxxxxxx 739.2 x 30 238 x x xxx 533.9 xxxxx x 37 275 x 2 xxxxx 763.1 x x 38 xxx 2 x xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx x 0 20 xxx x x 418.3 xxxxxxxxxxxxxxxxxx 249.70000000000002 510.8 30 xxx x x xxxxxxxxxxxxxxxxxx 376.8 0 x 25 388 Estimated xxxxx xxxx 15780.3

file2.docx preview (567 words)

xxxxxxxx xxx the attached excel xxxxx

xx xxxxxxxxxx the xxxxxx xx days to xxxxxx xx the xxxxx xxxxxxxx xx is x discrete probability xxxxxxxxxxxxx xxx we generated xxxxxx numbers xxxx it xx the xxxxxxxxx way. We first xxxxxxxxxx xxxxxxxxx type xxxxxxxxxx probabilities xxx xxxx xx xxxxxxxxx one xxxxxxx (0,1) random variable xxxxx rand().If the xxxxxxxxx uniform xxx is in xxxxxx xx return xx xx xx is in [.2,.65) xxxx xx return 2 and so on. Thus xx generated the number xx days to xxxxxxx

xxxxxxxxx
 cum. xxxxx repair xxxx xxxxxxxxxxx 0 x xxx xxx x 0.45 0.65 x 0.25 xxx 4 0.1

For xxxxxxxxxx xxx interval xxxxxxx xxxxxxxxxx xxxxxxxxxx xxx p.d.f. xx x xxx x xx xxxxxx The xxxxxxxxxxxx xxxxxxxx is for x in [0,6].

xx xxxxxxxx the xxxxxxxxxxxx xx generating xxx uniform xxxxx xxx xxxxxxx xx in xxx xxxxxxx of the distribution xxxxxxxxx

The xxxxxxx xxxxxxxx xx x

Finally we round xxx the xxxxxxxxx xxx of weeks to xxxxxxx no. xx days. xxx this x xxxxxxxxxx xxxxxxxxxxxx no. of

- - - more text follows - - -

Submitted by moneybackguar... on Tue, 2013-07-23 23:10
teacher rated 4 times
2.25
price: \$15.00

## Jet Copies solution

body preview (0 words)

file1.zip preview (634 words)

# repair xxxx simulation

xxxxxxxxxxxxxxxxxxxxxx
 cum. xxxxx xxxxxx xxxx xxxxxxxxxxx simulated xxxx uniform 0 x xxx 2 xxxxxxxxxxxxxxxxxxx 0.2 2 0.45 xxxx x 0.25 0.9 x xxx

# breakdown xxxxxxxx simulation

xxxxxx
 xxxxxxxxx xxxx xxxxxxx xx xxxxxxxxxxxxxxxxxxx

# sales xxxx xxx xxx

xxxxxxxx
 rate copy sold xxxx \$0.10 xxxx xxxxxxx

# xxxxxxxxxx xxx 1 year

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxxxxxxx interval(simulated) breakdown xx day xxx Total number of xxxxxxxxxx Repair time modified repair time xxxxx xxxxxxx \$) cum. xxxxx xxxxxx xxxx xxx x day x xxx 3 xxx x 26 xx 12 x 2 508.70000000000005 323.20000000000005 0 x 0 x xx 66 x x 731.7 xxxxxxxxxxxxxxxxxx xxxxx 601.6 xxx 2 41 xxx 2 x 648.6 562.9 0 x 0.65 3 24 xxx 2 x 572.70000000000005 xxx 0 0 0.9 x 10 xxx 2 x xxxxx xxxxx 0 0 xx 170 x 1 xxx x 0 0 xx 208 x 3 xxxxxxxxxxxxxxxxxx 686.30000000000007 739.2 x 30 238 3 3 xxx xxxxx xxxxx 0 xx xxx x 2 xxxxx xxxxx 0 x xx 313 2 2 xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx x x xx xxx x x xxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx xxxxx 30 363 x 2 xxxxxxxxxxxxxxxxxx 376.8 0 x 25 xxx xxxxxxxxx xxxxx loss xxxxxxx

# xxx xxxxxx solution.doc

1,2,3,4. xxx xxx attached xxxxx file.

5. Generating the number of days xx repair xx xxx xxxxx problem. xx is x discrete xxxxxxxxxxx distribution. And we generated random xxxxxxx xxxx xx in xxx following way. We xxxxx xxxxxxxxxx less-than xxxx xxxxxxxxxx

- - - more text follows - - -