Premium Essay

Jet Copies Case Study

In: Business and Management

Submitted By jk52calvin
Words 920
Pages 4
Running head: Jet Copies Case Study 1

JET COPIES CASE STUDY
James C. Kessler
Strayer University
Introduction to Management Science
Math 540
Dr. Yaw Kyei
January 3, 2013

Jet Copies Case Study 2
Days-to-Repair
I typed the name jet copies into the A1 slot. Then I made the letters bold and used the cells section to increase the row height and the column width. I also increased the font size. I then typed in the probability of weekly demand section. Increasing the font size and making it bold. I set up three columns, P(x), cumulative, and repair time. This was taken from the table that was given. Because we need 52 weeks of information I set numbers for 60 weeks, starting with column E6. I then went to G6 and typed in =RAND() to start a random number sequence and hit enter. I then clicked on G6 and right clicked and held down to set up 60 random numbers. I then went to the clipboard section and clicked copy. Then we clicked on F6, then right clicked, then clicked on past special, then clicked on values, then clicked ok to set the values we would use. Then I left clicked on G6, then clicked on delete, then clicked entire column to remove. To develop the probability of breakdowns I had to assume values for P(y). We were given six operating times and given .33 as the highest probability, we then assumed the others with the total equaling 1.00. I then set up the cumulative column, and the operating time to breakdown column. Now I can do the calculation to get the times between breakdowns in weeks. This I set up in column G starting at G6 for the sixty weeks. In G6 I typed the formula, =Vlookup(F6,B20:C25,2). I then left clicked on G6 and scrolled down to get the values. I then started a column H, beginning with H6, to come up with the 52 weeks for one year. In H6 we interred the value for the first

Similar Documents

Premium Essay

Mat 540: Jet Copies Case Study

...JET Copies: The Decision to Purchase a Backup Copier Businesses are continually faced with difficult and challenging decisions, especially those regarding revenue and whether or not to spend money on situations that may or may not occur, based on speculation or perception. There may be several techniques a business can employ to analyze if perceived investments will produce a desired return and subsequently, profit. Simulation is an analytical process that supports business planning objectives. By utilizing models to support this process, business leaders and managers can forecast potential expenditures and better prepare for roadblocks that can serve as organizational disadvantages. JET Copies is a company facing a dilemma of whether or not it would be cost effective to purchase a second copier in case repair times concerning the original one would result in a loss of revenue. To further analyze their case, I will model the number of days to repair the original copier, the number of weeks between breakdowns, and lost revenue due to breakdowns for a period of 1 year. Additionally, by combining all the modeling components, I will provide a detailed summary to support their decision of whether to invest in the additional copier, and do so with a high level of confidence. I will begin by modeling the number of days to repair. To begin the simulation technique chosen for this case, I first utilized the information communicated by Terri speculating that it will take...

Words: 1203 - Pages: 5

Free Essay

Mat 540 - Assignment 2

...In this case the results were based on the use of one copy machine, intervals of breakdown, requiring 1-4 days for repair at a loss, at $0.10 cents a copy. Day 1: 20%, Day 2: 45%, Day 3: 25%, Day 4: 10% a total probability of 100%. The point of this case study is to simulate the break-down and repair process for one year to obtain an average annual loss of revenue. In addition the amount of time between breakdowns increases the probability of needing more costly repairs. Should the anticipated lost revenue exceeds $12,000.00 annually a backup copier will be purchased. We must keep in mind the most important factors of customer satisfaction and convenience, which is what, prompted the owners of JET to start their business in the first place. The first part of creating the probability of breakdowns relied upon information supplied by Jet Copies and their estimated probability of distribution. The nearby college staff had prior knowledge of the service provider’s timelines for repair because they had the same copier in the campus office. JET used their own estimated repair time to recreate a random repair time probability table using a range of days. As a result the average repair time was 3 days at a cost of $691 per day in potential profit loss due to the machine being out of service. The second part was to generate the intervals between successive amounts of breakdowns to the primary copier machine only. Using random numbers and the number of possible copies that could...

Words: 677 - Pages: 3

Free Essay

Mat540 Jet Copies

...Assignment #1: JET Copies Case Problem Strayer University MAT540: Quantitative Methods October 29, 2013 JET Copies is a company designed to alleviate a longer commute and longer wait time, and possibly have a more cost efficient method for the college students to make copies. The three students James, Ernie, and Terri decided to go into business together with a copying business initiative. Considering what was ahead of the new business, for example, possible machine downtime and days to repair the copier, they had to determine the average number of days that it would take for them to acquire a repair team to fix the machine in the event that it broke down. As discovered, the average time for repair was between one and four days. In order to calculate the average, a probability distribution was developed using Microsoft Excel. From there, the cumulative probability was obtained by adding the probability, P(x), from the previously itemized probabilities where the cumulative summation of a probability is always equal to one (1) or 100%. A random number formula, =RAND(), was plugged into the Microsoft Excel desired cell, in this situation, (H4), which generated a random range of numbers that are greater than or equal to zero and less than one. The interim time between breakdowns were achieved simply by soliciting the experience several staff members in the college of business who were familiar with frequency of the copier’s inconsistent behavior. It was estimated that the...

Words: 679 - Pages: 3

Premium Essay

Jet Copy

...Jet Copy Simulation Prepared by Joe Miller Prepared for February 7th 2013 TABLE OF CONTENTS INTRODUCTION SUMMARY JET COPY SIMILATION CONCLUSION AND RECOMMENDATIONS APPENDIX INTRODUCTION The purpose of this report is to examine the feasibility to for Jet Copy to purchase a second copy machine. Based on copies produced and lost with only the use of one copier. In this report I will use data from a simulation to assist in the determination of an additional copier for Jet Copy. As a reminder that this is a random simulation and the information in the simulation will only assist between when the test stop and 52 week will not have great affect on the outcome of the in the decision making. The simulation that was run was base on a 52 week scenario. The actual results are based on 51 week trial. The difference between the 51 week test and the actual 52 weeks will not have any great impact on the recommendation. ------------------------------------------------- SUMMARY This report creates a simulation that shows one possible outcome for Jet Copier when there one copier is out for repair for up to 4 days. It will also aid in the decision to ad d or not to add a second copier. This report will answer the following questions: 1. Using Excel to generate the number of days needed to repair the copier. 2. Using Excel to generate the interval between successive breakdowns according to continuous distribution. 3. Using Excel, use a suitable method to...

Words: 968 - Pages: 4

Free Essay

Math 540

...JET Copies Case Problem page 1 Assignment #1: JET Copies Case Problem By: Jenna Kiragis Quantitative Methods 540 7/29/2012 JET Copies Case Problem page 2 Case Problem JET Copies is a copy business opened by James, Ernie, and Terri, three students who wanted to make it more convenient for other students in their apartment complex to get copies in a timely manner. After obtaining a copy machine for the business with a loan from Terri’s mother, the students soon began discussing the frequent breakdowns that may occur. It was then that the three decided they needed a backup copier. However, the students wanted to first have an estimate of how much money they would be losing if they did not have a backup copier (Taylor, 2010). This paper will discuss methods that simulate the number of days needed to repair the copier, the intervals between successive breakdowns, and the lost revenue for each day the copier is out of service. All of these methods together will simulate the lost revenue due to copier breakdowns over 1 year. JET Copies Case Problem page 3 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. Lost revenue of Jet Copies due to breakdown can be done by generating random numbers from different probability...

Words: 655 - Pages: 3

Free Essay

Jet Copies

...JET Copies Case Problem In analyzing the case, JET Copies Case Problem, the following categories will be addressed: Model number of days to repair 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. JET copies needs to know the number of days they need to repair, when the copy machine is out of service. Using the given table, there are three columns of probability, repair time and cumulative. I used the figures given in case problem for probability and repair time days but for the cumulative column we started at 0.00 cumulative, then added the 0.20 to that to get the cumulative for day 2. For each probability subsequent to the previous we added, so for the 0.45 probability we added the 0.20 to get 0.65. Then repeating the same for the rest of probabilities, after 0.65 the cumulative resulted in 0.90. Then we used the table with ten columns. In the first column starting at A5, the formula entered was the =RAND() function to create random number for the first cell. That function formula was then dragged down to the below cells and locked to have the values be fixed. In the next column, I use the numbers copied from my first column. Then in the G5 column, we entered the function VLOOKUP to find the number of days needed to repair =VLOOKUP(F5,Lookup,2) and dragged the cell to have the same formula for the below cells in the column. Look up, in the...

Words: 892 - Pages: 4

Premium Essay

Capital Structure

...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 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 due to copier breakdowns over 1 year to answer the question asked in the case study.  5. In a word processing program, write a brief description/explanation of how you implemented each component of the model.  Write 1-2 paragraphs for each component of the model (days-to-repair; interval between breakdowns; lost revenue; putting it together).  6. Answer the question posed in the case study.  How confident are you that this answer is a good one?  What are the limits of the study?  Write at least one paragraph. Case Problem James Banks was standing in line next to Robin Cole at Klecko’s Copy Center, waiting to use one of the copy machines. “ Gee, Robin, I hate this,” he said. “We have to drive all the way over here from Southgate and then wait in line to use these copy machines...

Words: 1060 - Pages: 5

Free Essay

Mat540 Jet Copies

...Introduction This paper will answer the question whether or not JET Copies, a new copier company established by three friends, should purchase a smaller copier as a backup for the primary copier when the primary copier is not in service. The owners of the company have purchased a primary copier similar to the one in the dean’s school of business. During making their decision to purchase, the owners received positive information from the seller regarding the copier reliability. The price of the primary copier is $12,000. Terri, one of the owners of JET Copier, received a loan for her family to purchase the copier. After talking to someone from the dean’s office of business, JET Copies discovered that the copier is not as reliable as they thought. To prevent loss of revenue, JET Copies uses several simulations in an attempt to estimate the loss of revenue—repair days, time between breakdowns, and number of copies per day. The price of the second copier is $8,000. If revenue lost for a year is greater than or equal to $8000, then JET should purchase. Below are my calculation after setting up and running simulations based on the information provided within the 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. The owners of JET Copies decided to purchase a copier similar to the one used in the college of business at State. The company they purchased...

Words: 674 - Pages: 3

Free Essay

Jet Copies Case Problem

...JET Copies Case Problem Assignment #1 MAT540, Strayer University Assignment#1: JET Copies Case Problem According to the discrete distrubution, the number of days (y) needed to repair the copier is as follows (where “R2” is a random value in the excel sheet between and 0 and 1): 0 < R2 < .2, then it takes 1 day .2 < R2 < .65, then it takes 2 days .65 < R2 < .9, then it takes 3 days .9 < R2 < 1, then it takes 4 days James estimated that the time between break-downs was probably between 0 and 6 weeks, with the probability increasing the longer the copier went without breaking down. For simulating the interval between successive breakdowns: f(x) = x/18, 0 ≤ x ≤ 6 weeks where x= weeks between break-downs f(x) = x²/36, 0 ≤ x ≤ 6 weeks where x= weeks between break-downs f(x) = random number1 (R1) = x²/36 x = 6*sqrt(R1) 3. For simulating the lost revenue every day that the copier is out of service, select a random number (R3) between 2000 and 8000, since it is estimated that they would see between 2000 and 8000 copies a day. They will charge $0.10 per copy. Therefore, the lost revenue for each day the copier is out of service is equal to R3*.1*repair time. The amound of revunue lost is approxiamtely $12,934.80. Please see the attached excel sheet. In order to estimate the revenue lost for the one year of operations the simulation has been performed. The estimates indicated that the copies sales were between 2000 to 8000 pieces...

Words: 522 - Pages: 3

Premium Essay

Mat 540

...how to grade is within the Instructor Center. Click the link above to submit your assignment. 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 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 due to copier breakdowns over 1 year to answer the question asked in the case study. 5. In a word processing program, write a brief description/explanation of how you implemented each component of the model. Write 1-2 paragraphs for each component of the model (days-to-repair; interval between breakdowns; lost revenue; putting it together). 6. Answer the question posed in the case study. How confident are you that this answer is a good one? What are the limits of the study? Write at least one paragraph. There are two deliverables for this Case Problem, the Excel spreadsheet and the written description/explanation. Please submit both of them electronically...

Words: 673 - Pages: 3

Free Essay

Jey Copies

...JET Copies Patrick Prophet Quantitative Methods – MAT 540 Dr. LaTasha Thompson 10/22/10 1. Write a brief description of how you implemented days-to-repair. When looking at the days it took to repair the copier, all that the JET Company had to go by was the average number of days that it took for the company to repair the copier if it broke down. The average was between 1 and 4 days to have the machine repaired. For this data, a probability distribution table was developed and programmed into excel. Once the probability table is loaded into excel, they are averaged into a random number range that generates numbers from 0.00 to 1.0. The system then generated an average number days it would take to repair the machine base to the random number generated. 2. Write a brief description of how you implemented the intervals between break downs. When the company looked at the number of intervals between breakdowns, there was no exact numbers to go by to create a probability distribution. What they did instead was to talk to the college who already owned one and go by their data. It was then determined that the average repair days would be between 0 and 6 days. This time the formula took the maximum number of and averaged it with the square root of the random numbers generated again from 0.00 to 1.0. Excel would then come up with the average number of days it would be between machine break down based on these numbers. 3. Write a brief description of how you...

Words: 633 - Pages: 3

Premium Essay

Mat 540 Entire Course Latest Strayer

...Chapter 11,12 MAT 540 WK 3 Assignment 1 – JET Copies Case Problem MAT 540 WK 3 Homework Chapter 14 MAT 540 WK 4 Assignment 2 – Internet Field Trip MAT 540 WK 4 Homework Chapter 15 MAT 540 WK 5 Midterm Exam MAT 540 WK 6 Homework Chapter 2 MAT 540 WK 6 Quiz 3 Chapter 2 MAT 540 WK 7 Assignment 3 Case Problem – Julia’s Food Booth MAT 540 WK 7 Homework Chapter 3 MAT 540 WK 8 Homework Chapter 4 MAT 540 WK 8 Quiz 4 Chapter 4 MAT 540 WK 9 Homework Chapter 5 MAT 540 WK 9 Quiz 5 Chapter 9 MAT 540 WK 10 Assignment 4 Case Problem – Stateline Shipping and Transport Company MAT 540 WK 10 Homework Chapter 6 MAT 540 WK 11 Final Exam Course Home Work aims to provide quality study notes and tutorials to the students of MAT 540 Entire Course Latest Strayer in order to ace their studies. MAT 540 ENTIRE COURSE LATEST STRAYER To purchase this visit following link: https://coursehomework.com/product/mat-540-entire-course-latest-strayer/ Contact us at: HELP@COURSEHOMEWORK.COM MAT 540 ENTIRE COURSE LATEST STRAYER MAT 540 WK 1 Homework Chapter 1,11 MAT 540 WK 1 Quiz 1 Chapter 1,11 MAT 540 WK 2 Homework Chapter 12 MAT 540 WK 2 Quiz 2 Chapter 11,12 MAT 540 WK 3 Assignment 1 – JET Copies Case Problem MAT 540 WK 3 Homework Chapter 14 MAT 540 WK 4 Assignment 2 – Internet Field Trip MAT 540 WK 4 Homework Chapter 15 MAT 540 WK 5 Midterm Exam MAT 540 WK 6 Homework Chapter 2 MAT 540 WK 6 Quiz 3 Chapter 2 MAT 540 WK 7 Assignment 3 Case Problem – Julia’s Food Booth MAT 540 WK 7...

Words: 667 - Pages: 3

Free Essay

Jet Copies

...Jet Copies a Case Study Jet Copies is a small business that was started by three friends to provide copy services to students at State University. To accomplish this they borrowed from one of the partners parents to purchase a high end copy machine. But after purchasing the copy machine they found that it was not as reliable as they were led to believe. The partners wanted to find out how long and how often the copier would be out of service. They also wanted to know how much money they would lose when the copier was out of service. If the copier was out of service so long that they would lose more than 12,000 dollars they would purchase a backup unit. To accomplish this we will use Microsoft Excel to create a statistical analysis of a year of operation of the copier. Number of days to repair the copier probability days .45 1 .20 2 .25 3 .10 4 Based on the data provided above we see that the probability for a repair to the copier to take one day is 45%, two days is 20%, three days is 25%, and four days is 10%. To compute this in Excel we will use the random number feature and the lookup function. First we create a table to account for the probability of the duration of repairs based on the data provided. probability days 0 1 0.45 2 0.65 3 0.9 4 As you can see 0-.44 is a 1 day repair, .45-64 is a 2 day repair, .65-89 is a 3 day repair, and .9- 1 is a 4 day repair. We then use a random number generated by Excel by using the RAND () function. This will provide...

Words: 817 - Pages: 4

Free Essay

Jet Copies

...The purpose of this simulation was to create to determine if JET Copies needs to purchase a back up copier. To begin, information had to be gathered which was given based on research the founders of JET Copies did to determine the length of time between breakdowns, the probability of repair times, and the revenue they would take in daily. Because there is a variance amongst the days it would take to repair the copier as well as the revenue being lost, creating this simulation helps JET Copies make the best decisions considering all the possibilities through sampling and probability. While it would be more accuracy to follow the physical process to make the decision based on true, random occurrences, JET Copies wants to know the number of breakdowns and repair time for a year which calls for this simulation of random numbers. To begin this simulation the repair time table had to be computed because it would give an introduction overview of the probability of the repair time needed to fix any breakdowns; it would also be needed to fulfill some details in the next table as well. Based on this table the following information was gathered: the probability that it would take one to two days to repair a breakdown would be 65 percent whereas for it to take three days or more would be 90 percent. After this table was created it was time to focus on the main table of the simulation which would provide more detailed information from a probability basis. The first column of the second...

Words: 1146 - Pages: 5

Free Essay

Jet Copier

...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 that they would sell between 2,000 and 8,000 copies per day at 10 cents per copy. The students determined that the time between main copier breakdowns would be from 0 to 6 weeks. The students determined that if the revenue loss for a 1 year period was greater than or equal to $12000, they would purchase the backup copier. A simulation was created to estimate the amount of revenue that would be lost if they did not have a back-up copy machine. The first step in creating the simulation was to determine the time between repairs. The probability function for time between repairs is x = 6*square root (sqrt) of r, where r is the generated random number. First, a random number was generated. The next step to determine the time between repairs was to use the probability function of x=6*sqrt of r. The results of this calculation were placed in the second column of the excel worksheet. A third column was created to determine the cumulative time between the breakdowns. The same process continued:...

Words: 416 - Pages: 2