Assignment 1 - Quantitative Methods Essay examples

1090 WordsJul 25, 20125 Pages
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 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 distributions according the given probability law. 1. Simulation for the repair time. |Repair Time (days) |Probability…show more content…
998082 |5.994243 |0.216353 |1 |3330 |\$3,330.00 |19.34677 | |5 |0.963834 |5.890502 |0.415313 |4 |5487 |\$21,948.00 |25.23727 | |6 |0.130715 |2.169274 |0.201205 |1 |7810 |\$7,810.00 |27.40655 | |7 |0.499181 |4.239164 |0.36532 |2 |3030 |\$6,060.00 |31.64571 | |8 |0.461862 |4.077625 |0.268624 |2 |3987 |\$7,974.00 |35.72334 | |9 |0.424543 |3.909416 |0.802426 |3 |6846 |\$20,538.00 |39.63275 | |10 |0.387223 |3.733637 |0.474831 |2 |3449 |\$1,281.00 |43.36639 | |11 |0.349904 |3.549162 |0.148055 |4 |6373 |\$25,492.00 |46.91555 | |12 |0.312585 |3.354559 |0.24356 |4 |7206 |\$28,824.00 |50.27011 | |13 |0.275266 |3.147948 |0.716607 |1 |4446 |\$307.50 |53.41806