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 suitable
Premium Simulation Microsoft Excel Logic
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 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
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
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
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
have resulted from the use of these personal computers. A major one was the spreadsheet application‚ the very first‚ Visicalc which was developed in the year 1979. Today‚ the most popular spreadsheet can be said to be Microsoft Excel which was developed in the 1980’s. The purpose of this term-paper is to introduce at other spreadsheets other than Microsoft Excel. VISICALC This is the first electronic spreadsheet to be made available on personal computers. The idea originated from Dan Bricklin
Premium Spreadsheet
Introduction In order for end users to carry out calculations and produce reports in a ‘user friendly’ method‚ an excel spreadsheet has been created. This report explains how this spreadsheet is created‚ how the spreadsheet works and also the benefits of this spreadsheet. 1 Business Issues As instructed by AID an information system is needed to assist staff to carry out calculations and produce reports. However‚ there were some issues to be considered during planning. Issues to be considered
Premium Project management Construction