Show me how to post my homework

Just do my homework!

  • HTML tags will be transformed to conform to HTML standards.
  • Add rel="nofollow" to external links
Submitted by 123lynda on Tue, 2013-07-23 21:07
due on Wed, 2013-07-24 23:59
answered 3 time(s)
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)

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.

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

Answer rating (rated one time)


MAT 540 Assignment for you is attached (as discussed)

body preview (10 words)


MAT 540 Assignment xxx xxx is attached  xxx discussed)

file1.xlsx preview (474 words)


Continuous Probability
#1- xxx average number of xxxx needed to repair the xxxxxx when xx xxxxxxxxxx #2- The average xxxxxx xx weeks between xxxxxxxxxxx
ProbabilityCumulative ProbabilityRepair Time-days Repair Time-days Random #'s xxxxxx Time-daysAverage xxxxxx Time xxxxxxx xxxxxxxxxxxxxxxx3.84 xxxxxxxxxxxx xxxxxx xxx xxx xxxxxx xxxxxxxxxx Time xxxxxxx break downs xxxxxxx
xxxx xxxxx1 xxxxxxxxxxxxx xxxxxxxxxx xxxxxxxxxxxx
0.450.202 2 xxxxxxxxxxxx 2 20.118795422xxxxxxxxxxxx
0.25 xxxx 3 xxxxxxxxxxxxx x3 0.1300556639 xxxxxxxxxxxx
0.10xxxxxx xxxxxxxxxxxx3 xxxxxxxxxxxxxxxxxxxxxxxxx
xxxxx0.7023251249 x xxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxx xxxxxx

- - - more text follows - - -

file2.doc preview (472 words)

Assignment #1: JET xxxxxx Case Problem

Do xxx xxxxxx xxxx work as your xxxx xxxxxx to xxxxxx xxxxxxxxxxx


The xxxxxxx xxxxxx xx days xxxxxx xx xxxxxx the xxxxxxx Continuous xxxxxxxxxxx Distributions

I did xxx xxxxxxxxxx probability for the four xxxxxx xxxx xxxxx xxxx I named the xxxxxxxxxx probability xxx repair time xxxx’ xxxxxxx x decided xx expand my xxxxxx time days xx xxx to xxx a xxxxxx xxxxxxx xxx I used the xxxxxxx =rand() to xxx my random numbers. I froze my random xxxxxxxx xx convert xx random xxxxxxx to xxxxxx time days, I used xxx xxxxxxx =vlookup(F6,vlookup,2) and average the xxx repair xxxx – xxxxx

Equals= xxxxx

The average xxxxxx xx xxxxx between xxxxxxxxxxx

I xxxx xxx repair time xxxxx then x xxxxx () to get xx random xxxxxxxx The random xxxxxxx xxxx xxxxxxx xx xxx my time xxxxxxx xxxxxxxxxx x used the formula =6*sqrt(m7) xxx continuous xxxxxxxxxxx xxxxxxxx and xxxxxxxx x

Equals= xxxx

Lost xxxxxxx Due to xxxxxx xxxxx Out of xxxxxxxx

The xxxxxxx estimated

- - - more text follows - - -

Buy this answer

Try it before you buy it
Check plagiarism for $2.00

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


body preview (0 words)

file1.xlsx preview (58 words)

repair xxxx simulation

cum. Prob. repair time probability simulated xxxxuniform
x xxxx 2 xxxxxxxxxxxxxxxxxxx
xxx 20.45
xxxxx 0.25
0.9 4xxx

xxxxxxxxx interval xxxxxxxxxx

simulated xxxxuniform
33 xxxxxxxxxxxxxxxxxxx

xxxxx loss xxx xxx

rate xxxx sold loss
$0.10 5734$573.40

simulation for 1 year

xxxxxxxxx xxxxxxxxxxxxxxxxxxxbreakdown xx day xxxxxxxx number of xxxxxxxxxx xxxxxx timemodified repair xxxxsales lost(in xxxxxx xxxxx xxxxxx time
xxx xday 2day x day 4
2626 12 2 x508.70000000000005xxxxxxxxxxxxxxxxxxxx0 1
xx xxx 4 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxx
xx xxx 2 x xxxxx562.9 00 xxxx 3
xx xxxxxxxxxxxxxxxxxxxxxxxxxx x0 0.9 4
10 xxx 2x 532.4 335.1 0 x
29xxx11 xxx0x 0
xx 2083 3 243.70000000000002xxxxxxxxxxxxxxxxxx xxxxx0
30 238 3 x303xxxxxxxxxx x
37 xxx 2x 381.6 xxxxx x 0
38313xx632.40000000000009 xxxxxxxxxxxxxxxxxx 00
xxxxx x xxxxxx 652.70000000000005 249.70000000000002 510.8
xxxxx3 x798.90000000000009376.80 0
Estimated total xxxx

file2.docx preview (567 words)

1,2,3,4. xxx the xxxxxxxx xxxxx file.

5. xxxxxxxxxx xxx number xx xxxx to xxxxxx xx the first problem. xx is a discrete probability distribution. xxx xx generated xxxxxx xxxxxxx xxxx it xx the following xxxx xx xxxxx xxxxxxxxxx xxxxxxxxx type cumulative probabilities xxx then xx generated xxx xxxxxxx xxxxx random variable xxxxx xxxxxxxxx xxx generated uniform xxx is in [0,.2) xx return 1, if xx xx in [.2,.65) xxxx xx xxxxxx x xxx so on. Thus xx xxxxxxxxx the number of xxxx to xxxxxxx


cum. Prob.

xxxxxx time














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

We simulate xxx distribution xx generating one uniform xxxxx xxx xxxxxxx xx xx the inverse xx xxx xxxxxxxxxxxx function.

The inverse function is x

xxxxxxx we round xxx the xxxxxxxxx no. of xxxxx to xxxxxxx xxx xx xxxxx (as xxxx x xxxxxxxxxx distribution no. of

- - - more text follows - - -

Buy this answer

Try it before you buy it
Check plagiarism for $2.00

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

Jet Copies solution

body preview (0 words) preview (748 words)

xxx xxxxxx xxxxxxxxxx solution.xlsx

xxxxxx xxxx xxxxxxxxxx

cum. xxxxxrepair xxxxxxxxxxxxxxxsimulated xxxx xxxxxxx
xxxxx x0.24366721125313728
0.94 0.1

xxxxxxxxx xxxxxxxx xxxxxxxxxx

simulated xxxxuniform
33 xxxxxxxxxxxxxxxxxxx

sales xxxx per xxx

rate xxxx xxxx xxxx

xxxxxxxxxx xxx 1 year

breakdown xxxxxxxxxxxxxxxxxxx breakdown xx day no.xxxxx number xx breakdowns Repair timexxxxxxxx repair xxxxxxxxx lost(in $) cum. Prob. xxxxxx time
day x xxx xday 3xxx x
26 26 xx 22 508.70000000000005323.20000000000005 x001
xx 66x x xxxxx645.30000000000007 786.7 601.60.2 x
xxxxx 2 2xxxxxxxxxx xx 0.65 x
24 131 2 x572.70000000000005 678 00xxx 4
xx xxxx2532.4xxxxx 0 x
29 170x x482x 0x
xx2083 x243.70000000000002xxxxxxxxxxxxxxxxxx xxxxx0
xx xxxxx xxx 533.9451.6 0
xx 275 x xxxxxx763.100
xxxxx2 xxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx0 0
20 333 4 x xxxxx 652.70000000000005249.70000000000002 xxxxx
30xxx3 xxxxxxxxxxxxxxxxxxx xxxxx0x
xx xxx
Estimated total loss

jet copies xxxxxxxxxxxx

xxxxxxxx See xxx attached excel xxxxx

xx xxxxxxxxxx the xxxxxx of days to xxxxxx is the xxxxx problem. xx is a discrete xxxxxxxxxxx distribution. xxx xx generated random numbers xxxx xx xx the following way. xx first calculated less-than type cumulative

- - - more text follows - - -

Buy this answer

Try it before you buy it
Check plagiarism for $2.00