Please Show excel work with full tables, I need to understand this.

A milling department has 10 machines. Each operates an average of eight hours before requiring adjustment, which takes an average of 2.67 hours. While running, each machine can produce 45 pieces an hour. Use Table 1, Table 2 and Table 3. a. With one adjuster, what is the net average hourly output per machine? (Round your answer to 1 decimal place.) Number of pieces per machine b. If machine downtime cost is $70 per hour and adjuster cost is $30 per hour, how many adjusters would be optimal? 01 O2 03 04 O 5 X M D F x M D F X M D F X MDF TABLE 18.7 Finite-queuing tables .260 NN 3 2 .270 1 2 1 2 1 1 3 2 1 3 2 1 4 .280 1993 3 2 .290 .300 1 3 2 1 3 2 1 3 2 999 .310 320 N 1 3 2 1 3 2 .710 Population 5 .125 .012 1 .060 .999 .019 1 .095 .998 .130 .025 1 .125 .997 .030 1 .149 .996 .135 .034 1 .169 .995 036 1 .179 .994 .140 .040 1 .199 .993 .042 1 .208 .992 .145 044 1 .218 .991 046 1 .228 .990 ,050 1 .247 .989 .150 .052 1 .257 .988 .054 1 .266 .987 .056 2 .018 .999 .155 1 .276 .985 .058 2 .019 1 .285 .984 .160 .060 2 .020 .999 1 .295 .983 .062 2 .022 .999 .165 1 .304 .982 .064 2 .023 .999 1 314 981 .170 .066 2 .024 1999 1 .323 .979 .068 2 .026 .999 .180 1 .333 978 .070 2 .027 .999 1 342 .977 .190 .075 2 .031 .999 1 .365 .973 .080 2 .035 .998 .200 1 .388 .969 .085 2 .040 .998 1 .410 965 .210 090 2 .044 .998 1 .432 .960 .095 2 .049 .997 .220 1 .454 .955 .100 2 .054 .997 1 .475 .950 .230 .105 2 .059 .997 1 .496 .945 .110 2 .065 .996 .240 1 .516 .939 .115 2 .017 .995 1 .537 .933 .250 .120 2 .076 .995 1 .556 .927 .082 .994 .575 .920 .089 .933 .594 .914 .095 .933 .612 .907 .102 .992 .630 .900 .011 .999 .109 .991 .647 .892 .012 .999 .115.990 .664.885 .013 .999 .123 989 .680 .877 .015 .999 .130 .988 .695 .869 .016 .999 .137 .987 .861 .017 .999 .145 .985 .725 .853 .021 .999 .161 .983 .836 .024 .998 .117 .980 .778 .819 .028 .998 .194.976 .801 .801 .032 .998 .211 .973 .822 .783 .036 .997 .229 .969 .842 .765 .041 .997 .247 .965 .860 .747 .046 .996 .265 .960 .876 .730 .052 .995 .284 .955 .890 .712 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 .058 .994 .440 .305 .950 .903 .695 .064 .994 .460 .323 .944 .915 .677 .071 .342 .938.480 .925 .661 .007 .999 .079 .992 .362 .932 .500 .934 .644 .008 .999 .086 .990 .382 .926 .520 .942.628 .009 .999 .094 .989 .402 .919 .540 .950 .613 .010 .999 .103 988 .422 .912 560 .956 -597 .012 .999 .112 .986 .442 .904 .580 .962 .583 .013 .999 .121.985 .462.896 .600 .967.569 .017 .998 .141 501 .880 .650 .975 .542 .021 .998 .163 .976 .540 .863.700 .981 .516 .026 .997 .186 .972 .579 .845.750 986 .493 .031 .997 .211 .966.800 .616 .826 .989 .471 .037 .996 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 2 4 3 2 .238 960 .652.807 1992 .451 .045.995 .266 .953 .686 787 .994 432 .053.994 .296.945 .719 767 .996 415 .063 992 327966 .750 748 .997 399 .073 .991 .359.927 .779.728 .998 384 .085 .989 392 917 .806 708 .998 370 .098 986 426 906 .831.689 .999 357 .113.984 461 895 .854 670 .999.345 .130 981 .497.883 .875.652 .999 363 .179.972 .588 .850 .918 608 .999 .308 .240.960 .678 815 .950 .568 .999.286 .316 .944 .763 777 .972 532 .410 924 .841 .739 .987.500 .330 1 3 2 1 3 2 .752 .340 .360 1 3 2 1 3 2 .981 .380 1 3 2 3 2 1 3 2 .400 1 3 2 1 4 3 2 1 4 3 .420 1 3 2 1 1 4 .440 X M D F X MDF X M D F X MDF .135 .064 .066 .140 2 1 4 3 2 1 .068 .070 .145 .075 .150 4 3 2 1 4 3 2 1 4 3 2 1 5 4 3 2 1 5 4 3 2 1 5 4 3 2 1 6 5 4 3 2 1 6 5 .080 .025 .155 .085 .090 .160 4 3 2 1 921 .095 .165 4 .100 .850 4 .522 .900 3 .907 .702 2 .995 .470 .900 4 .656 .871 3 .957 .666 2 .998 .444 .950 4 .815 .838 3 .989 .631 Population 10 .016 .144 .997 .019 .170 .996 .021 1 .188 .995 .023 1 .206 .994 1 .224 1993 026 1 .232 .992 028 1 .250 .991 .030 1 .268 .990 .032 2 .053 .999 1 .285 1988 .034 2 .037 .999 1 301 986 .036 2 .041 .999 1 320 .984 .038 2 .046 .999 1 .337 .982 .040 2 .050 .999 1 .354 .980 042 2 .055 .999 1 .371 .978 .044 2 .060 998 1 .388 .975 .046 2 .065 .998 1 .404 .973 .048 2 .071 .998 1 .421 .970 .050 2 .076 .998 1 .437 1967 .052 2 .082 .997 1 .454 .963 .054 2 .088 997 1 .470 .960 056 2 .094 .997 1 .486 .956 .058 2 .100 .996 1 .501 .953 .060 2 .106 1996 1 .517 .949 ,062 2 .113 .996 1 .532 .945 .064 2 .119 .995 1 2 1 3 2 1 3 2 1 3 2 1 3 2 1 3 2 1 3 2 1 3 2 1 3 2 1 3 2 1 3 2 1 3 2 1 4 3 2 1 4 3 2 1 4 3 2 1 4 3 .547 .940 .126 .995 .562 .936 .020 999 .133 .994 .577 .931 .022 .999 .140 .994 .591 .926 .026 .999 .158 .992 .627 .913 .031 .999 .177 .990 .660 .899 .037 .999 .196 .988 .692 .883 .043 .998 216 .986 .722 867 .049 .998 .237 .984 .750 .850 .056 .998 .258 .981 .776 832 .064 .997 .279 978 .800 .814 .072 .997 .301 .974 .822 .795 .081 .996 .324 .971 .843 .776 .016 .999 .090 .995 .346 .967 .756 .019 .999 .100 1994 .369 .962 .878 .737 .022 .999 .994 392 .958 .893 .718 .025 .999 .121 .993 .415 .952 .220 .907 .699 .028.999 .132.991 .437 .947 .919 .680 .230 .032.999 .144.990 .460 .941 1929 .662 .036 .998 .240 .156.989 483 .935 .939 .644 .040.998 .169.987 .250 .505 .928 .947 .627 .044 .998 .182.986 528 .954 .610 .260 .049 .997 .195.984 .550 .914 .961 .594 .054.997 .209.982 .270 .571 .906 .966 .579 .013 .999 .066 .996 .238 .978 .614.890 .280 .975 .890 .016 999 .078 .995 .269.973 .654.873 1982 .522.290 .020 .999 .092 .994 .300 .968 .692.854 .987 .497 .025 .999 .300 . 108 .992 .333 .961 .728 .835 .990 .474 3 2 1 4 3 2 1 5 .170 .030 998 .124.990 .366 .954 .761 .815 .993 .453 .037 .998 .142.988 .400 .947 .791 .794 .995 .434 .044 997 .162.986 .434 938 .819.774 .996 416 .010 .999 .052.997 .183.983 .469.929 .844 .753 .997 .400 .013 .999 .060 .996 .205.980 .503.919 .866 .732 .998 .384 .015.999 .070 995 .228 976 .537.908 .886 712 .999 .370 .018 .999 .081 1994 .252 .972 .571 .896 .903 .692 .999 .357 .022 .999 .093 .996 .278 .968 .603 .884 .918 672 .999.345 .026 .998 .106 .991 .304.963 .635 872 .105 .110 4 3 2 1 6 5 4 3 2 1 6 5 4 3 2 .180 .115 .190 .120 4 3 2 1 5 4 3 2 1 5 4 3 861 .125 .200 6 5 4 3 2 1 6 5 4 3 .130 .110 .210 .135 X MDF X M D F X M D F X MDF .300 310 .752 320 3 2 8 7 6 5 4 3 2 8 7 6 5 4 3 .330 .972 598.650 .999 400 .026 .998 .115 989 .316 .958 .606 .884 .700 .864 .980 575 .999 385 .034 .997 .141.986 .363 949 .750 .658 867 .893.729 .986 555 .044 .996 .982 .413 .939.800 1961 .171 .932.653.400 .999 353 .031 .998 .120.990 .331 .957 .666 858 420 .943.635 .036 998 .135.988 .359.952 .695 .845 .952 .617 440 .042 .997 .151 .986 .387.945 .723.831 .600 010 1999.460 .049.997 .168.983 .416 .938 .750.816 .968 .584 .014 .999 .064 .995480 .205 .978 .474.923 .798 787 .978.553 .019.999 .083 993 .247.971 .500 .533 906 .840.758 .986 .525 .026 .998 340 6 5 4 3 2 7 6 5 4 3 2 7 6 5 4 3 2 8 7 6 5 4 3 2 8 7 6 5 4 3 2 8 7 6 5 4 7 6 5 4 3 9 8 7 6 5 4 9 8 7 6 5 4 9 8 7 6 5 4 9 8 7 .105 .991 .500 .292.963 .591 .887 .520 .875 728 .991 499 .034 .993 .130 .987 .341 .954 .646 .866 .905 700 .540 .994 .476 .045 .997 .160.984 .392 .943 .698 .845 .928 .672 560 .996 .454 011 .999 .058.995 .193 .979 .445.930 .747 .822.580 .947 .646 .998 .435 .015 .999 .074.994 .230 .973 .499 .916 .600 .791 .799 .961 .621 .998 .417 .020 .999 .093 .992 .271 .966 .553.901 .650 .830 .775 3 2 6 5 4 3 2 7 6 5 4 3 2 7 6 5 4 3 2 7 6 5 4 3 2 7 8 7 6 5 4 3 353.954 .651.878 .882 759 .980.614 .999.461 .040.997 .200.979 .484.929 .772.836 .940 .711 .992 571 .075.994 .307.965 .626 .897 .870.792 .975.666 .998 533 134.988 .446.944 .763 859 .939.747 .991.625 .999.500 .232.979 .611.916 .879.818 .978 705 .998 588 387.963 .785.881 .957777 .995.667 .630.938 .934.841 .994.737 .707 .848 360 ANNI .850 8 7 6 5 4 3 9 8 7 6 .917 .706 .991 .535 .057 .995 .204 .977 .465 927 .753 .829 .937 .684 .994 517 .010 .999 .072 .994 .242 .972 .518 .915 795 809 .953 .663 .996 500 .021 .999 .123 .988 .900 Co Co Co Co o .380 oo o o o o o o . .950 5 4 3 9 7 .400