# Mat 540 Week 1 Assignment

Satisfactory Essays
405 Words
Grammar
Plagiarism
Writing
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
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

## You May Also Find These Documents Helpful

• Satisfactory Essays

D = c – 3 Since this is a negative, use the reciprocal to cancel out the negative…

• 386 Words
• 2 Pages
Satisfactory Essays
• Good Essays

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
• Satisfactory Essays

Which of the following is a factor that can affect the success of the installation plan for a purchased package?…

• 820 Words
• 4 Pages
Satisfactory Essays
• Good Essays

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

• 479 Words
• 3 Pages
Good Essays
• Good Essays

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
• Powerful Essays

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
• Satisfactory Essays

Using these figures, we created a normal distribution and then calculated the number of days frozen in our simulation, using the random number generator.…

• 554 Words
• 3 Pages
Satisfactory Essays
• Good Essays

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
• Satisfactory Essays

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
• Better Essays

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
• Powerful Essays

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

• 9937 Words
• 40 Pages
Powerful Essays
• Satisfactory Essays

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
• Good Essays

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
• Satisfactory Essays

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
• Good Essays

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