Preview

Mat 540 Week 1 Assignment

Satisfactory Essays
Open Document
Open Document
405 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Mat 540 Week 1 Assignment
Assignment

Quantitative Methods Strayer University

Step 1 For step, one I generated a column of random numbers, which will help me to determine the weeks between breakdowns. I used the equation in excel =Rand( ). Next, I generated a column to determine the weeks between breakdowns. I used the formula in excel =8*SQRT(r) and used the previous mentioned randomly generated numbers. Once I had the randomly generated weeks, I created a column for the cumulative weeks to reach around the 52-week mark.

Step 2 Step 2 I generated another column of random numbers, again using in excel =Rand( ). This random variable is used to generate days for repair. Using these generated numbers, I calculated the number of days the machine will be down for repair. In excel I used the equation =IF(F20.85,3,2)). This allows me to use the random numbers generated …show more content…
In excel I sued the equation =Rand( ). This new random number column will help me to determine the money lost per day. Next, I created a column that will actually generate the dollar amount of money lost. I used the equation =(400-200)*r=200. I used the mentioned random variable numbers for this new equation. I will use the generated number of days for repair to determine the cost of money loss per breakdown. In excel I use the equation =E2*G2. This uses the days of repair and multiplies this by the money per day lost

Step 4 Finally, for step 4 I will show the yearly revenue lost. In this column, I will use the two previous columns and add together using a formula that will add the two previous cells together. In excel using the formula =I2+H3. Next, I ran the confidence intervals for the previous found data. For the Upper confidence level I used the excel formula =C17-(1.96) * (SQRT (COUNT (H2:H11))) and the lower confidence level I used the excel formula =C17-(1.96) *(C18/SQRT
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    MAT 221 WK 5 ASSIGNMENT
    • 1108 Words
    • 3 Pages

    MAT 221 WK 5 ASSIGNMENT

    In this essay of Buried Treasure we will use many different ways to attempt to factor down three expressions problems. Our first problem from our reading talks about Ahmed and Vanessa, Ahmed has half of a treasure map, which indicates that the treasure is buried in the desert 2x + 6 paces from Castle Rock. The other half of the map is in Vanessa possession and her half indicates that to find the treasure, one must get to Castle Rock. When she get there to walk x paces to the north, and then walk 2x + 4 paces to the east. I wonder what X could equal to, if Ahmed and Vanessa come together in finding the treasure they would save a lot of time of digging.…

    • 1108 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Mat 540 Final Paper
    • 340 Words
    • 2 Pages

    Mat 540 Final Paper

    Let us examine the following condition of complete observations given above. Assume that $\Upsilon_{\chi}$ is taken as distribution function whose total failure times is studied using gamma distribution applied to the shape parameters $3$ together with scale parameters $2.$ On side of repair time it goes with the same way failure time with gamma distribution together with shape parameter $1,$ and scale parameter $2$ respectively. The time $\tau$ is examined as the following $\tau=2.5,\tau=5,$ and $\tau=7.5$ for getting a good approximation. For precise value to $\Lambda_{a}(\tau)$ at given time $\tau$ is examined by applying Mathematica. The given $(n)$ indicated in table$(2)$ is the observations number to the operating with repair times, $\widehat{\overline{\Lambda}}_{a}(\tau)$ indicates also the average to $\widehat{\Lambda}_{a}(\tau)$ more than $100$ times repetitions at time $\tau$, where $\widehat{\overline{\theta}}(\tau)$ indicates the mean of sample to estimate the standard error to the estimation where $\Lambda_{a,\rho}$ and $\Lambda_{a,Q}$ indicates $100\%$ upper and lower to the limit of confidence interval to $\Lambda_{a}(\tau)$.\\…

    • 340 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Jet Copies
    • 1218 Words
    • 5 Pages

    Jet Copies

    4. Put all of this together to simulate the lost revenue due to copier breakdowns over 1 year to answer the question asked in the case study.…

    • 1218 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    RES 320 Week 3 Assignment
    • 479 Words
    • 3 Pages

    RES 320 Week 3 Assignment

    · Make sure the article includes a description of the independent and dependent variables and the sampling plan.…

    • 479 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    Jet copies
    • 825 Words
    • 4 Pages

    Jet copies

    In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown.…

    • 825 Words
    • 4 Pages
    Powerful Essays
    Read More
  • Good Essays

    Mat 540 Week 9 Discussion
    • 374 Words
    • 2 Pages

    Mat 540 Week 9 Discussion

    Integer programming is concerned with optimization problems in which some of the variables are required to take on discrete values. Rather than allow a variable to assume all real values in a given range, only predetermined discrete values within the range are permitted. In most cases, these values are the integers, giving rise to the name of this class of models. Models with integer variables are very useful. Situations that cannot be modeled by linear programming are easily handled by integer programming. Primary among these involve binary decisions such as yes-no, build-no build or invest-not invest. Although one can model a binary decision in linear programming with a variable that ranges between 0 and 1, there is nothing that keeps the solution from obtaining a fractional value such as 0.5, hardly acceptable to a decision maker. Integer programming requires such a variable to be either 0 or 1, but not in-between. Unfortunately integer programming models of practical size are often very difficult or impossible to solve. Linear programming methods can solve problems orders of magnitude larger than integer programming methods. A typical mathematical program consists of a single objective function, representing either a profit to be maximized or a cost to be minimized, and a set of constraints that circumscribe the decision variables. In the case of a linear program (LP) the objective function and constraints are all linear functions of the decision variables. At first glance these restrictions would seem to limit the scope of the LP model, but this is hardly the case. Because of its simplicity, software has been developed that is capable of solving problems containing millions of variables and tens of thousands of constraints.…

    • 374 Words
    • 2 Pages
    Good Essays
    Read More
  • Good Essays

    Jet Copies Essay
    • 556 Words
    • 3 Pages

    Jet Copies Essay

    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…

    • 556 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    R.C. Coleman Case Study
    • 435 Words
    • 2 Pages

    R.C. Coleman Case Study

    2. To complete the expansion in 40 weeks with an 80% probability of success, the activities would need to have a completion time of 38 weeks. This is given the same variance score and times for the schedules above. However, presently it is unable to conclude five weeks earlier without an increase in funding, workers and supplies.…

    • 435 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Jet Copies Case
    • 776 Words
    • 4 Pages

    Jet Copies Case

    I used originally 20 breakdowns but then I ended up going to 13 breakdowns. I then created a list of random numbers. The list of random numbers was figured out in excel with the formula =RAND. Which is depicted by the column r2. After obtaining these random numbers and then using the chart that was provided below I then reviewed my random numbers to see where they fell inline with the repair time day chart. The chart was gathered by Terri from the college of business in which the point was to try and get an understanding how long it would take to get the copier that they purchased repaired if in fact it did break down. Using her chart I then created another list of random numbers using the same formula =RAND, which is depicted in column labeled r1. I then looked at my random numbers to see where they fell in with Terri’s data chart to see how the random numbers turned into how many days it would take to fix. Next we had to figure out the time between breakdowns. The formula that was used to obtain the time between breakdowns is (6x sqrt x r1). This information is depicted in the column labeled Time between Breakdowns. Next I…

    • 776 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Microsoft Excel Test
    • 380 Words
    • 2 Pages

    Microsoft Excel Test

    h) Produce a scenario summary table showing the results cell as the profit/Loss figure for each of the five years that the business is forecasting for.…

    • 380 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Internet Field Trip
    • 696 Words
    • 3 Pages

    Internet Field Trip

    The table displays the probability distribution that will be use to find cumulative probabilities. The table above is inserted into Excel. Each numbers corresponds to the probability of demanded value. The cumulative probability numbers are entered into a table, with the demand, and range of values. Next, the Random function is use in excel. Random numbers between 0 and 1 will be generated in Excel using =Rand formulas. Based on the information in the table, if the generated random number is greater than 0 but less than 2 then the repair time will be 1 day. Any random numbers greater than .20 but less than .65 the repair time will be 2 days. Any random number greater than .65 but less than .90 repair time will be 3 days. Any number greater than .90 will take 4 day repair the machine.…

    • 696 Words
    • 3 Pages
    Better Essays
    Read More
  • Powerful Essays

    Operational and reputational risk in the European banking industry: The market reaction to operational risk events
    • 9937 Words
    • 40 Pages

    Operational and reputational risk in the European banking industry: The market reaction to operational risk events

    The analysis is based on a sample of 136 operational losses stemming from a database of…

    • 9937 Words
    • 40 Pages
    Powerful Essays
    Read More
  • Good Essays

    Administrator
    • 834 Words
    • 4 Pages

    Administrator

    TABLE 1: Weekly Sales Data for Combination 1 Meals (1998) week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Q 51,345 50,337 86,732 118,117 48,024 97,375 75,751 78,797 59,856 23,696 61,385 63,750 60,996 84,276 54,222 58,131 55,398 69,943 79,785 38,892 43,240 52,078 11,321 73,113 79,988 98,311 P 2.78 2.35 3.22 1.85 2.65 2.95 2.86 3.35 3.45 3.25 3.21 3.02 3.16 2.95 2.65 3.24 3.55 3.75 3.85 3.76 3.65 3.58 3.78 3.75 3.22 3.42 A 4,280 3,875 12,360 19,250 6,450 8,750 9,600 9,600 9,600 6,250 4,780 6,770 6,325 9,655 10,450 9,750 11,500 8,975 8,975 6,755 5,500…

    • 834 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    5.2 Performance Optimization Of Different Subsystem In Selected Industries?
    • 760 Words
    • 4 Pages

    5.2 Performance Optimization Of Different Subsystem In Selected Industries?

    The corresponding values of failure and repair rates for various subsystems of the system (parameters) are at λ1 = 0.00032, µ1 = 0.0068, λ2 = 0.001, µ2 = 0.005, λ3 = 0.001513, µ3 = 0.031, λ4 = 0.00302, µ4 = 0.035, λ5= 0.025, µ5 = 0.05, λ6 = 0.005, µ6 = 0.038, λ7 = 0.005077, µ7 = 0.019, which is the optimized value of these parameters for the maximum availability. The simulation is performed again by varying the population size from 10 to 100 in a step size of 10 and keeping the generation size constant at 100.The optimum value of system performance is 86.90% and for which the best possible combination of failure and repair rate is λ1 = 0.00033, µ1 = 0.0067, λ2 = 0.00106, µ2 = 0.005, λ3 = 0.003, µ3 = 0.030, λ4 = 0.02659, µ4 = 0.03499, λ5= 0.00502, µ5 = 0.049, λ6 = 0.005, µ6 = 0.0379, λ7 = 0.005227, µ7 = 0.0172 as shown in Table…

    • 760 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    SIMULATION AND MODELLING
    • 266 Words
    • 2 Pages

    SIMULATION AND MODELLING

    2. A piece of equipment contains four identical tubes and can function only if all the four are in working order. The lives of tubes has approximately uniform distribution from 1000 to 2000 hours. The current maintenance practice is to replace a tube when it fails. Equipments has to be shut down for 1 hr for replacing a tube, the cost of one tube is sh 100, while the shut down time cost sh 200 per hour. Simulate the system for about 6000 hrs of run and find the maintenance cost using the following random numbers…

    • 266 Words
    • 2 Pages
    Satisfactory Essays
    Read More