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 isout 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 youimplemented 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.
Here is the case study:
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. I hate wasting time like this.” “I know what you mean,” said Robin. “And look who’s here. A lot of these students are from Southgate Apartments or one of the other apartments near us. It seems as though it would be more logical if Klecko’s would move its operation over to us, instead of all of us coming over here.”
James looked around and noticed what Robin was talking about. Robin and he were students at State University, and most of the customers at Klecko’s were also students. As Robin suggested, a lot of the people waiting were State students who lived at Southgate Apartments, where James also lived with Ernie Moore. This gave James an idea, which he shared with Ernie and their friend Terri Jones when he got home later that evening. “Look, you guys, I’ve got an idea to make some money,” James started. “Let’s open a copy business! All we have to do is buy a copier, put it in Terri’s duplex next door, and sell copies. I know we can get customers because I’ve just seen them all at Klecko’s. If we provide a copy service right here in the Southgate complex, we’ll make a killing.” Terri and Ernie liked the idea, so the three decided to go into the copying business. They would call it JET Copies, named for James, Ernie, and Terri. Their first step was to purchase a copier. They bought one like the one used in the college of business office at State for $ 18,000. (Terri’s parents provided a loan.) The company that sold them the copier touted the copier’s reliability, but after they bought it, Ernie talked with someone in the dean’s office at State, who told him that the University’s copier broke down frequently and when it did, it often took between 1 and 4 days to get it repaired. When Ernie told this to Terri and James, they became worried. If the copier broke down frequently and was not in use for long periods while they waited for a repair person to come fix it, they could lose a lot of revenue. As a result, James, Ernie, and Terri thought they might need to purchase a smaller backup copier for $ 8,000 to use when the main copier broke down. However, before they approached Terri’s parents for another loan, they wanted to have an estimate of just how much money they might lose if they did not have a backup copier. To get this estimate, they decided to develop a simulation model because they were studying simulation in one of their classes at State. To develop a simulation model, they first needed to know how frequently the copier might break down— specifically, the time between breakdowns. No one could provide them with an exact probability distribution, but from talking to staff members in the college of business, 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. Thus, the probability distribution of breakdowns generally looked like the following:
0 6 x, weeks
*** There is a diagonal line from 0 going up to .33 at 6 weeks. ***
Next, they needed to know how long it would take to get the copier repaired when it broke down. They had a service contract with the dealer that “guaranteed” prompt repair service. However, Terri gathered some data from the college of business from which she developed the following probability distribution of repair times:
Repair Time (days) Probability
Finally, they needed to estimate how much business they would lose while the copier was waiting for repair. The three of them had only a vague idea of how much business they would do but finally estimated that they would sell between 2,000 and 8,000 copies per day at $ 0.10 per copy. However, they had no idea about what kind of probability distribution to use for this range of values. Therefore, they decided to use a uniform probability distribution between 2,000 and 8,000 copies to estimate the number of copies they would sell per day. James, Ernie, and Terri decided that if their loss of revenue due to machine downtime during 1 year was $ 12,000 or more, they should purchase a backup copier. Thus, they needed to simulate the break-down and repair process for a number of years to obtain an average annual loss of revenue. However, before programming the simulation model, they decided to conduct a manual simulation of this process for 1 year to see if the model was working correctly. Perform this manual simulation for JET Copies and determine the loss of revenue for 1 year.
Why Choose Us
We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.
Professional Academic Writers
Over the years, MyEssay.Help has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.
Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.
We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.
At MyEssay.help, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.
Customer Support 24/7
Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: firstname.lastname@example.org.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
MyEssay.help has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.
At MyEssay.help, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.
Admission and Business Papers
Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.
Editing and Proofreading
Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.
We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.