The JET Copies assignment is similar to the Bigelow Manufacturing Company machine breakdown example in the textbook. Hence the example was used as a guide. Days to Repair Simulation Process
In simulating the number of days to repair, first a table was created based on the information given in the Repair time and Probability information table as found in the case. The created table was defined as “Lookup” in the array information for VLookup function in Microsoft Excel. Next, based on the probability information provided, a Cumulative Probability column was generated by adding the probability numbers given (each with the number above it) and distributing the probability to the number of possible repair days from 1-4. For example, a .20 probability corresponds to 2 repair days. Next, simulating the repair times, random numbers were generated in Microsoft Excel, with the VLookup function referencing the “Lookup” table; and based on the range of the random number generated returns the associated number of repair day(s). Interval Between Successive Breakdowns Simulation Process

According to the continuous distribution information provided, interval between successive breakdowns is 0-6 weeks. Based on the Bigelow Manufacturing example, the formula for continuous probability function for the time between breakdowns is f(x) =x/18, 0 < x < 6 weeks. To simulate the interval successive breakdowns, random numbers were generated and the result multiplied by 6 and Square root. This gives the number of weeks between machine breakdowns. Cumulative Time was also generated adding the result of the generated square root and stopping just a bit above 52 weeks for the one year simulation requirement. Lost Revenue Simulation Process

An actual loss number was not provided according to the case. It only gave a range from 2000-8000 copies that they expect to sell per day at 10 cents each. It also indicates using a uniform probability in the same range. Based on this, a random...

...JetCopies Case Study
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...

...JETCopies Problem
The simulation of JetCopies can be done by generating random numbers from given probability distributions. The different steps of this simulation and assumption made are explained below.
1. Simulation for the repair time.
It is given that the repair time follows
Repair Time (days) Probability
1. .20
2. .45
3. .25...

...Read the "JETCopies" 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:
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.
In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous...

...JETCopies Case Problem
Assignment 1
Professor
Dr. Elena Klimova
MAT 540 – Quantitative Methods
Janeiro 28, 2013
5.
Model number of days to repair
In regard to the first part of the Case Problem (The average number of days needed to repair the copier), I worked on the Excel to find the number of the days required to repair the copier (Repair Time (days). In Excel, I wrote down the table information given from the case study to make it easier to find...

...
Assignment 3: Long-Term Investment Decisions
March 9, 2014
Managerial Economics and Globalization ECO 550
Capital Budgeting Decisions
Introduction
A low calorie food or a healthy option of food is a new concept, which has gained a lot of interest in the recent times. In the previous assignment, we had discussed the background and the introduction of the company, which wants to cater to this segment. This paper will discuss the long-term capital budgeting...

...JetCopies Case Problem
Shelandria Jones
Strayer University
MAT 540-Quantitative Methods
Dr. Raymond Ottinot
February 5, 2013
Introduction
JetCopies is a business venture of a couple of young men who had the insight to open up a copy business. James Ernie and Terri received a loan from Terri’s parents of $18,000. Due to information they have received the large copier they purchased has a history of breakdowns...

...Running Head: JETCOPIES CASE
JETCopies Case
Math 540
Winter 2013
JETCopies Case
Introduction
Before starting the case, it is important to know how this case will be evaluated through excel, the functions and their application, and how they quantifiably accentuate on the variables and known possibilities of the case. The major functions that are used in this particular case...

...Assignment #1: JETCopies Case Problem
Read the “JETCopies” 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...