quantatative stat assignment – Essay Writers

Click the link above to submit your assignment.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:There are two deliverables for this Case Problem, the Excel spreadsheet and the written description/explanation. Please submit both of them electronically via the dropbox.The assignment will be graded using the associated rubric.JET CopiesJames Banks was standing in line next to Robin Cole at Klecko’sCopy Center, waiting to use one of the copy machines. “Gee,Robin, I hate this,” he said. “We have to drive all the way over herefrom 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. Alot of these students are from Southgate Apartments or one of theother apartments near us. It seems as though it would be morelogical if Klecko’s would move its operation over to us, instead ofall of us coming over here.”James looked around and noticed what Robin was talkingabout. Robin and he were students at State University, and mostof the customers at Klecko’s were also students. As Robinsuggested, a lot of the people waiting were State students wholived at Southgate Apartments, where James also lived with ErnieMoore. This gave James an idea, which he shared with Ernie andtheir friend Terri Jones when he got home later that evening.“Look, you guys, I’ve got an idea to make some money,” Jamesstarted. “Let’s open a copy business! All we have to do is buy acopier, put it in Terri’s duplex next door, and sell copies. I knowwe 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 intothe copying business. They would call it JET Copies, named forJames, Ernie, and Terri. Their first step was to purchase a copier.They bought one like the one used in the college of business officeat State for $18,000. (Terri’s parents provided a loan.) The companythat sold them the copier touted the copier’s reliability, butafter they bought it, Ernie talked with someone in the dean’s officeat State, who told him that the University’s copier broke down frequentlyand when it did, it often took between 1 and 4 days to getit repaired.When Ernie told this to Terri and James, they becameworried. If the copier broke down frequently and was not in usefor long periods while they waited for a repair person to come fixit, they could lose a lot of revenue. As a result, James, Ernie, andTerri thought they might need to purchase a smaller backupcopier 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 theymight lose if they did not have a backup copier. To get this estimate,they decided to develop a simulation model because theywere studying simulation in one of their classes at State.To develop a simulation model, they first needed to know howfrequently the copier might break down—specifically, the timebetween breakdowns. No one could provide them with an exactprobability distribution, but from talking to staff members in thecollege of business, James estimated that the time between breakdownswas probably between 0 and 6 weeks, with the probabilityincreasing the longer the copier went without breaking down.Thus, the probability distribution of breakdowns generally lookedlike the following:Next, they needed to know how long it would take to get thecopier repaired when it broke down. They had a service contractwith the dealer that “guaranteed” prompt repair service. However,Terri gathered some data from the college of business from whichshe developed the following probability distribution of repair times:Repair Time (days) Probability1 .202 .453 .254 .101.00Finally, they needed to estimate how much business they wouldlose while the copier was waiting for repair. The three of them hadonly a vague idea of how much business they would do but finallyestimated that they would sell between 2,000 and 8,000 copies per dayat $0.10 per copy. However, they had no idea about what kind ofprobability distribution to use for this range of values. Therefore, theydecided to use a uniform probability distribution between 2,000 and8,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 tomachine downtime during 1 year was $12,000 or more, they shouldpurchase a backup copier. Thus, they needed to simulate the breakdownand repair process for a number of years to obtain an averageannual loss of revenue. However, before programming the simulationmodel, they decided to conduct a manual simulation of this process for1 year to see if the model was working correctly. Perform this manualsimulation for JET Copies and determine the loss of revenue for 1 year.