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
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
Number of Days In 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
Premium Randomness Cumulative distribution function Mathematics
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
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 decisions that such a company
Premium Government Food Capitalism
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 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
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 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