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
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 copy machine. The time between breakdown allows you to also understand how the long the copy machines will work and how long they will last before they breakdown again. In column D row 16 is where I input the formula to find the time between breakdown =6*SQRT(Random r1). I used =6*SQRT(0.862) to
Premium Randomness Cumulative distribution function Mathematics
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
Introduction to Management Science‚ 11e (Taylor) Chapter 1 Management Science 1) Management science involves the philosophy of approaching a problem in a subjective manner. Answer: FALSE Diff: 1 Page Ref: 2 Section Heading: The Management Science Approach to Problem Solving Keywords: scientific approach AACSB: Analytic skills 2) Management science techniques can be applied only to business and military organizations. Answer: FALSE Diff: 1 Page Ref: 2 Section Heading:
Premium Decision theory Costs Variable cost
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
MAT540 Quantitative Analysis Quiz 3 TRUE/FALSE – clearly indicate your response. 1. Sensitivity analysis is the analysis of the effect of parameter changes on the optimal solution. T . 2. The sensitivity range for an objective function coefficient is the range of values over which the current optimal solution (product mix) will remain optimal. T . 3. The sensitivity range for a right-hand-side value in a constraint is the range
Premium Linear programming Optimization Operations research
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