Jet Copies

Jet Copies

May 4, 2014

The JET Copies assignment is similar to the Bigelow Manufacturing Company machine

breakdown example in the textbook. Hence the example was used as a guide. Days to Repair Simulation Process. In simulating the number of days to repair, first a table was created based on the information given in the Repair time and Probability information table as found in the case. The created table was defined as “Lookup” in the array information for VLookup function in Microsoft Excel. Next, based on the probability information provided, a Cumulative Probability column was generated by adding the probability numbers given (each with the number above it) and distributing the probability to the number of possible repair days from 1-4. For example, a .20 probability corresponds to 2 repair days. Next, simulating the repair times, random numbers were generated in Microsoft Excel, with the VLookup function referencing the “Lookup” table; and based on the range of the random number generated returns the associated number of repair days . Interval Between Successive Breakdowns Simulation Process 

According to the information provided, interval between successive breakdowns is 0-6 weeks. Using the Bigelow Manufacturing example, the formula for continuous probability function for the time between breakdowns is f(x) =x/18, 0 < x < 6 weeks. To simulate the interval successive breakdowns, random numbers were generated and the result multiplied by 6 and Square root. This gives the number of weeks between machine breakdowns. Cumulative Time was also generated adding the result of the generated square root and stopping just a bit above 52 weeks for the one year simulation requirement. Lost Revenue Simulation Process.

Simulations are used as analytical tools in business planning and studing revenue and costs. To support their accuracy, models are incorporated and utilized to assist with business and organizational planning activities. JET Copies...