Jet Copier Essay

Submitted By SileenWright1

Words: 383

Pages: 2

Open Document

I used the =RAND formula to find the r1 of random numbers. Which is also depicted in column r2. Then I used formula that was used to obtain the time between breakdowns is (6x sqrt x r1). This information is depicted in the column labeled Time between Breakdowns. To find the repair time for the copier used the VLOOKUP formula. The formula looks at r2 RAND number and the P(x) and Cumulative number (=VLOOKUP(E20,Lookup,2). This gives me the number of days that it would take to repair the copier. Now that we know the number of days that it will take to repair the copier, we can calculate the average time it would take per week. We do this by using the =Average(), so the average breakdown per week is 3.99 Now for each repair there is at least one day and a maximum of 4 days when the business is closed and loosing copies. For day one we calculate a number of copies lost based on the information we have that the shop usually makes between 2000 and 8000 copies, so number of copies is 2000+rand()*6000. For the second, third, and fourth days we check the number of days spent on the repair in that period and calculate losses (copies) if the repair was longer than one, two, or three days respectively. Once we know the number of copies lost per day we calculate monetary loss by multiplying number of copies by $0.1. Losses from all periods are added and logical test is performed, if the total losses are less than $12000 the second copier is not needed, otherwise the second copier is

Analysis Of Jet Copier Simulation

JET Copier Simulation Explanation The simulation is divided into periods, each period begins with a working copier and ends once the copier is repaired. Period one begins on the first business day of the JET Copier, eventually the copier breaks down and gets repaired, this ends the first period. Second period begins and events repeat. And so on. After each period the total elapsed time is calculate. The total elapsed time calculates the time between breakdowns and once the total elapsed time reaches…

Words 337 - Pages 2

Nothing: Random Variable and Jet Copies Essay

JET Copies – Case Description University students James, Ernie and Terri are opening a new copy center business called JET Copies. They borrowed $18,000 from Terrie’s parents to purchase their main copy machine. After the copy machine was purchased Ernie found out from a friend that the copy machine had frequent breakdowns; a breakdown between 1 and 6 weeks and often took 1 – 4 days for repair. In order to keep the business running between repairs the business owners are evaluating whether to purchase…

Words 822 - Pages 4

Jet Copies Case Problem Essay

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: 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…

Words 1074 - Pages 5

How to start Consulting Essay examples

How to Get Started as an Independent Consultant By Jerry Grohovsky Copyright 2008. JPG & Associates, Inc. Here is an employment scenario for you: You have been employed with a company for the past 5 years as a technical communicator, and suddenly given notice that there is a lay-off…and you are on the list. You are now faced with the options of seeking other fulltime direct positions, or you can consider a new path: going out on your own as an independent consultant. For those who have…

Words 759 - Pages 4

Telecommunications: Microsoft Office Essay

including yourself, there will be four other users on this network. This information will be taken into consideration when purchasing your equipment, licenses, and calculating data rates. You have also established that you wish to go with a networked laser jet printer. I have chosen a Konica Minolta for its exceptional quality. I understand that your company maintains no local server. This limits your sharing and storage capabilities, but I can set you up with a cloud based server to free up space and…

Words 1294 - Pages 6

Untitled Document Essay

Course Project Ursula M. Burns Course Project Ursula M. Burns COLL 148 February, 22 2015 Devry University Course Project Ursula M. Burns Introduction “Dreams do come true, but not without the help of others, a good education, strong work ethic, and the courage to lean in.” Words spoken by an innovator and leader in corporate America Mrs. Ursula M. Burns. During the course of this paper my intentions are to highlight her career accomplishments…

Words 2149 - Pages 9

Exam Review Essay

Long line One long line with a lot of hooks Seine Net held by two people in a river bottom has weights top has bobbers Trawling Catches everything Causes Habitat destruction Rollers plow through anything in its way Gigantic net that can fit 33 jumbo jets Leaves tracks that can be seen from space Line-caught Traditional charter fishing Other methods Dynamite Giving the fish such a bad concussion they die and float to the top Poison Gillnet Once fish swim into the net there gills get stuck Commercial…

Words 2441 - Pages 10

Tyre Industry Profile

INDUSTRY PROFILE INTRODUCTION 70% of world rubber consumption goes into the tyre industry. The growth in world tyre production has been in response to the growth in the automotive industry. Consequently, tyre production has been a driving force behind growth in the world elastomer industry. At the same time, the improvement in quality and variety of elastomers has enabled the tyre industry to achieve its goals of providing grip, control, safety, comfort and other important features of tyres. The…

Words 10191 - Pages 41