Jet Case Problem Analysis James, Ernie, and

JET Case Problem Analysis James, Ernie, and Terri decides to open a business named JET Copies after discovering that they will make nice profits from by establishing a copier business at State University. However, they discover that they have to tackle the problem of machine breakdown after raising loan of $18,000 from Terri's parent. The breakdown if not properly manage will lead to lost of revenue.

They decide to buy a smaller version of copier machine for $8,000 to be used as a back up in case of a breakdown of the original machine. Before buying a back-up machine, they decide to estimate the lost revenue if they do not have a backup machine. If the lost revenue within a year is more than $12,000, it will be of a business advantage to purchase a back-up copier machine. (Taylor, 2011).

Objective of this paper is use stimulation model to investigate the lost revenue, days-to-repair ad interval between breakdowns of Jet Copies. The method assist in revealing the lost revenue that will occur due to a breakdown of the machine for 1 year. The study also delivers the written explanation/description and Excel spreadsheet to the case problem. The attached spreadsheet provides the answers to the question 1, 2, 3, and 4. The Appendix 1 also provides the copy of the excel spreadsheet. 5.

"Description and Explanation of the model (days-to-repair, lost revenue interval between breakdowns, and putting it together)." Interval between Breakdowns Based on the continuous distribution information provided in the case study, the random distribution probability for the machine breakdowns varies between 0 and 6 weeks. The study stimulates random number to stimulate the interval between successful breakdown and the study multiple the results by square root and 6. The strategy assists in generating number of breakdown.

The study also generates cumulative number by adding number of weeks to get 52 weeks, which are the number of weeks in a year. The stimulation process in the Excel spreadsheet is as follows: The study stimulates the RN1 (Random Number 1) in B15:B42 using the =RAND (). In column C, the formula =6*SQRT (B15) and the formula is copied into the cell C17:C42. In the column D, the formula =D15+C17 are computed to stimulate the "Cumulative Number of Weeks" in the cells D17:D42.

Days-To-Repair Information from the case study reveals the probability distribution for repair days as being delivered as follows: Repair time P (y) y (days) 0.20 1 0.45 2 0.25 3 0.10 4 1.00 From the data provided above, the cumulative information is generated using the formula =A6+B6 in the cell B7, and the formula copy into the B8:B9.

Thus, the cumulative information is as follows: Cumulative Repair time P (y) Probability y (days) 0.20 0.00 1 0.45 0.20 2 0.25 0.65 3 0.10 0.90 4 1.00 The Random function is used in the Excel as the next step using the "RN2 (Random Number 2)" using the =RAND () function in the column E. In the E15:E42 cells leading to random number between 0 and 1 to be generated. Thus, the repair time will be 1 day if the number randomly generated is < 0.20. However, the repair time will be two days if the randomly generated number >0.20 and < 0.65.

The repair time is 3 days if the RN2 is >0.65 but < 0.90. In Excel, the study uses the VLOOKUP function for the B6:B9 and C6:C9 cells. Thus, the repair days are obtained using the formula "=VLOOKUP (E15, Lookup, 2)" within the cells F15:F42. Lost Revenue The study generates the "RN3 (Random Number 3)" in the cells G15:G42 using the =RAND () function in the column G. Thus, the number of lost copies ($000) is generated using the =6*G15+2, in the column H.

By typing the formula into the cell H15 and copy it to H16:H42 cells, the study stimulate the lost revenue for each day using the formula: =H15*1000*0.1, and copy in the cells I15:I42. Putting It Together The stimulation process generated in the Excel spreadsheet will provide the accurate revenue that the JET Copy will lose in a year due to the machine breakdown. The summary of the stimulation process is presented below: First, the study calculates the cumulative number of the breakdown for the 52 weeks.

Moreover, the study finds the repair time using the LOOKUP function. The values of the cumulative probability are used to estimate repair times. Furthermore, the study calculates the lost revenue for each day using the formula = z*1000*0.1. Finally, the study repeats the process until the total loss for one year is calculated. Conclusion The study provides the answers to the problem in the case, which assists the JET Copy to understand the lost revenue that would arise due to the breakdown of the machine. Based on the.