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 12 answered question(s)
More questions like this
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.

Submitted by geniusy_2006 on Wed, 2013-07-24 11:23
teacher rated 404 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 4 times
price: $10.00


body preview (0 words)

file1.xlsx preview (58 words)

xxxxxx time xxxxxxxxxx

xxxx Prob. repair xxxxxxxxxxxxxxx simulated xxxx xxxxxxx
x xxxx x0.24366721125313728
0.22 xxxx
xxxx 3xxxx
xxx4 xxx

breakdown xxxxxxxx xxxxxxxxxx

xxxxxxxxx xxxx uniform
33 0.59976839684338934

sales loss xxx day

xxxx xxxx xxxx xxxx
xxxxx xxxxxxxxxxx

xxxxxxxxxx for 1 xxxx

xxxxxxxxx interval(simulated)xxxxxxxxx at day no.Total number xx xxxxxxxxxxxxxxxx xxxxxxxxxxxx xxxxxx xxxxsales xxxxxxx $) cum. xxxxx xxxxxx xxxx
day x day 2 day x xxx 4
26xx 12 x 2 508.70000000000005 xxxxxxxxxxxxxxxxxxx00 1
xxxx44 xxxxx645.30000000000007xxxxx 601.6xxx 2
41107 2 xxxxxx 562.9 0 x0.65 3
xx xxxxx xxxxxxxxxxxxxxxxxxxxxx x 0.94
10 141 x 2532.4 xxxxx x 0
xxxxx xxxxxx 0x
38xxx33243.70000000000002xxxxxxxxxxxxxxxxxx 739.2x
xxxxx 3x 303xxxxx451.6 0
37275x2 xxxxx 763.10 0
xx 313 xx xxxxxxxxxxxxxxxxxx 629.40000000000009x 0
20xxx 44xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
30363 xx 798.90000000000009376.8 00
Estimated total loss

file2.docx preview (567 words)

1,2,3,4. See the xxxxxxxx xxxxx xxxxx

xx xxxxxxxxxx xxx xxxxxx of xxxx xx repair xx xxx first xxxxxxxx xx is a discrete probability distribution. xxx xx xxxxxxxxx xxxxxx xxxxxxx xxxx xx xx the xxxxxxxxx xxxx We first xxxxxxxxxx xxxxxxxxx type xxxxxxxxxx xxxxxxxxxxxxx xxx xxxx we xxxxxxxxx one uniform (0,1) random xxxxxxxx xxxxx rand().If the xxxxxxxxx uniform no. is xx xxxxxx we return xx xx it is xx [.2,.65) then we return x and so on. Thus xx generated xxx number xx xxxx to xxxxxxx


xxxx xxxxx

repair time














For simulating the xxxxxxxx xxxxxxx xxxxxxxxxx breakdowns xxx xxxxxx xx x for x in [0,6]. The xxxxxxxxxxxx xxxxxxxx is xxx x in xxxxxx

We xxxxxxxx the distribution xx generating xxx xxxxxxx (0,1) and xxxxxxx xx in xxx inverse xx xxx xxxxxxxxxxxx function.

xxx inverse function is .

Finally we round off xxx xxxxxxxxx xxx of weeks xx nearest xxx of days. xxx this a continuous distribution xxx xx

- - - 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