Math540 week 3 assignment, chapter 14, jet copies, set up

This is an unformatted preview. Please download the decided instrument for the pristine format.

MATH540 Week 3 Assignment, Chapter 14, Jet Copies, Set up

Provided by Professor Aungst, Supplemental Instruction

Information from Jet Copies Case Study:

- Students bought an $18,000 copier to rouse their own representation occupation.

- Wanted to dissipation a smaller copier for $8,000 as back-up

- Created a mannerism to affect the aggregate of income that would be past if they did not keep a


- Span betwixt breakdowns is 0 weeks to 6 weeks (see appearance office on page 679, and

provided succeeding in this set up

- Exposed subjoined appearance arrangement of relit spans:

Repair Span (days)










- Estimated they would vend betwixt 2,000 and 8,000 copies per day at 10 cents (0.10) per representation

- Used a even appearance arrangement betwixt 2,000 and 8,000 to affect how manifold copies

they would vend per day

- If waste of income due to record downspan during 1 year is superior than or resembling to $12,000,

then they should dissipation the back-up copier

- Decided to direct a manual mannerism of this course for 1 year to see if the example was

working correctly

- Our assignment is to discharge this manual mannerism for JET copies and state the

waste of income for 1 year.

Here’s some preparatory Set Up information:

The appearance office for span betwixt relits, f(x), is,

f(x) = x/18, 0 <= x <= 6

and, r = x^2/36

x2 = 36r

x = 6*sqrt of r (use this formula in the support you state as span betwixt relits)

You could clear the cumulative arrangement and wild enumerate ranges for the arrangement of

relit spans for relation if you would enjoy that for relation.

Repair Time

Repair Time

y (days)










RN Ranges



The appearance office for daily claim is cleared by determining the rectirectilinear office

for the even arrangement, which is,

f(z) = 1 / b – a which resemblings 1/6

Letting F(z) = r in the Integrated Function, and solving for z we get: z = 6r + 2 (this is the

formula for copies past)

There are multitudinous ways to set up the Monte Carlo mannerism in Excel using the formulas we

learned in Chapter 14 … namely Wild Enumerate Generation (which is =RAND) and

VLOOKUP which allows us to “purpose back” to a appearance consultation and infuse a appearance based

on that Wild Enumerate and the Appearance associated after a while it in the consultation.

Most students rouse after a while clearing the appearance consultation for Relit span to succeeding be used as the

VLOOKUP Consultation for Relit Span appearance.





The Mannerism itself would be for 52 weeks (which would be when the cumulative “time

betwixt breakdowns” reached 52 weeks). You could initiate after a while a Wild Enumerate (r1) which

would be various by support 2, the Span Betwixt Breakdown (in weeks) formula of 6*square

root of r1

You could then sum those variables in a cumulative inventory in support 3 (so you could enumerate when the

mannerism reached 52 weeks).

In support 4 you could produce another wild enumerate (say, r2) to weigh the support 5

Repair span in y days.

That r2 could be used in a support 5 for Relit Span in y days which could be weighd by

using the =VLOOKUP office which would describe that r2 to probabilities in the Relit Time

appearance consultation pristinely set up.

You authority then set up some wild enumerate supports and consequence supports for relits initiative 1 day,

2 days, 3 days and 4 days.

At some purpose, you would need to delineation out how to weigh copies past in a day in thousands

and that would probably embody the formula z = 6r + 2

Finally, you would omission to equate the enumerate of copies past to the income past at 10 cents

per representation and then cumulate that for all 52 weeks to furnish the annual past income.