JET Copier Case Analysis In the case study for Jet copies three students are contemplating the benefits of opening a copy business in their town. They are also trying to decide whether or not it would be a good investment to purchase a second copier‚ in case their main copy machine breaks down. The students have already purchased an $18000 copier to start their copy business. They are trying to determine if they should get a loan to purchase a smaller $8000 copier as back-up. The students estimated
Premium Mathematics Cumulative distribution function Random variable
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: 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 distribution shown. In Excel‚ use a
Premium Simulation Microsoft Excel Logic
Assignment 1: JET Copies Case Problem Rose Leahy Strayer University Quantitative Methods-MAT540 Dr. Patricia DeJarnett July 21‚ 2013 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: 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
Premium Airline Management Aircraft
Jet Copies Case Problem Shelandria Jones Strayer University MAT 540-Quantitative Methods Dr. Raymond Ottinot February 5‚ 2013 Introduction Jet Copies 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 often for a few days. So the three guys are looking into possibly getting
Premium
JET Copies Problem The simulation of Jet Copies 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 4. .10 -----
Premium Random variable Cumulative distribution function
Jet Copies 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 together to simulate the lost revenue
Premium Cumulative distribution function Real number Randomness
JET Copies 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 it and copy‚ if necessary. I used
Premium
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
Premium Time Manufacturing Scientific method
the simulation I have the breakdown column which is column B which displays 13 days. The second column which is column C displays the random numbers. The random numbers will be used to calculate the time between breakdowns. The random numbers are determined by entering the formula =RAND(). Once we have the random numbers now I have the ability to determine the time between breakdowns. Weeks between Breakdowns The time between breakdowns allows you to estimate the time between the breakdowns of the
Premium Randomness Cumulative distribution function Mathematics
Jet Copies DAYS TO REPAIR The days to repair component was calculated by using the probability distribution of repair times given. This was used along with a set of random numbers based on 100 breakdowns a year. Then‚ a vlookup was used and the probability distribution per day to come up with the days to repair‚ which varies based on the random number that excel generates. The random number represents the probability of how many days it would take to repair the copier. TIME BETWEEN BREAKDOWNS
Premium Spreadsheet Cumulative distribution function Mathematics