- 27
- 11 821
Cornelio Abellanas
Приєднався 21 лют 2008
Theory of Constraints with Excel Solver
The Theory of Constraints is a process improvement methodology that emphasizes the importance of identifying the "system constraint" or bottleneck. By leveraging this constraint, organizations can achieve their financial goals while delivering on-time-in-full to customers, avoiding stock-outs in the supply chain, reducing lead time, etc.
Several examples of manufacturing, distribution and cargo plane loading optimization are used to illustrate
Several examples of manufacturing, distribution and cargo plane loading optimization are used to illustrate
Переглядів: 10
Відео
Six Sigma Virtual Catapult
Переглядів 35День тому
A wooden catapult has been widely used in Six Sigma education to illustrate multiple factor process variation and optimization. We will use a catapult simulator with 4 factors to practice: Process variation Linear regression Response surface analysis Process optimization This will be done using Microsoft Excel Analysis and Solver Download this Excel simulator from One Drive: 1drv.ms/x/s!AgdGqM2...
Test and Repair Loop: a Potential Value Stream Bottleneck
Переглядів 27Місяць тому
Test and Repair are Non-Value-Add operations: defective products should not be produced on the first place. Unfortunately, the state of the art in many processes is not there so tests and controls need to be part of the value stream. Ideally as the value stream becomes more robust some of these controls can be removed. On the mean time we need a test and repair plan (if repair is possible). A T...
Water engine 2
Переглядів 673 місяці тому
A water-fuelled car is an automobile that hypothetically derives its energy directly from water. Water-fuelled cars have been the subject of numerous international patents, newspaper and popular science magazine articles, local television news coverage, and websites. The claims for these devices have been found to be pseudoscience and some were found to be tied to investment frauds. These vehic...
Value Stream Constraints Management
Переглядів 454 місяці тому
Analyzing our Value Stream, we identify several constraints that limit its effective capacity. The most visible constraints are the process capacity of the different steps. But there are other, not so obvious, constraints such as the capacity variation of some steps. Process simulation helps us understand the value stream dynamic behavior: how variation affects key process metrics such as WIP, ...
Street Thermometer Error
Переглядів 524 місяці тому
One requisite for a correct ambient temperature measurement is to measure in the shade: away from the sunshine. Obviously, this is not always possible, and thermometers are often in the center of the street, with no protection from the sun. In this example, we notice an error of more than 5 degrees Celsius.
Random Variation Vs Trends: SPC
Переглядів 875 місяців тому
Understanding variation is key to interpret the value stream behavior. Not all variation is the same. Every process has variation. Some causes of variation may be identified and acted upon. Statistical Process Control is required to distinguish between a significant change in the process and intrinsic process variation SPC Western Electric rules can even detect small trends and alert the operat...
Virtual Obeya Room
Переглядів 1935 місяців тому
The Obeya room is a "war room" used by process improvement teams to meet and solve critical multi functional problems. The room walls are lined up with boards, highly visual charts and graphs showing program timing, milestones and progress to date and countermeasures to existing timing or technical problems. An alternative to a physical room is a virtual Obeya where the improvement team shares ...
Valencia Apartment Blok Fire
Переглядів 746 місяців тому
On 22 February 2024, at approximately 17:30 a fire broke out in a 14-storey luxury residential complex located in the Campanar district of Valencia, Spain. The rapid spread of the fire, exacerbated by strong winds, building materials and a stack effect, led to the complete destruction of the complex's 138 apartments, trapping numerous residents inside. Ten bodies were recovered from the buildin...
Autocorrelation: How to Manage it
Переглядів 688 місяців тому
When a process variable has only random variation, each output is independent of the previous ones. This is what happens, for instance, in a lottery. In some processes this independence does not happen. If we control our daily weight, for instance, our weight today is correlated to the weight of the previous days: it has autocorrelation. We will see that autocorrelation may have a positive effe...
Natural Gas Consumption Vs Temperature
Переглядів 699 місяців тому
Natural gas demand is highly seasonal, therefore forecasting the final consumption is essential to manage the complete supply chain. Temperature is a main factor affecting home gas consumption for heating. We will analyse the correlation between gas consumption and temperature. Download this Excel file with examples to your PC from OneDrive: 1drv.ms/x/s!AgdGqM2fFHF3haAX00fNjPhDN4W_kA?e=cbnX5y Y...
Multiple Response DOE
Переглядів 15510 місяців тому
Design of experiments, is a systematic experimentation, with a process critical factors, in order to correlate these factors to process responses. In DOE with Excel we obtained a linear relationship, between several factors and one response. In Response Surface DOE this was extended to non-linear relations. In both cases we were optimizing one single response. Now we will analyse some cases whe...
Response Surface Design Of Experiments with Excel
Переглядів 1,9 тис.Рік тому
Design of Experiments is a useful methodology for process improvement. The purpose is to find a relationship between process variables we can control and key process outputs in order to increase process capability. You can use Excel statistical analysis tools, Solver, Pivot charts, etc. to plan and analyse the results of these experiments. The first approach is to look for a linear relationship...
Design of Experiments with Excel
Переглядів 4 тис.Рік тому
Design of Experiments (DOE) is a very useful process improvement methodology. Microsoft Excel has some powerful data analysis tools, which I have, successfully, used for DOE. When it comes to analyzing cause and effect, we want to know what process factors affect our outputs. Correlation and Regression could give us an indication of the main factors, and the extent they affect the outputs. In s...
Lot Size: A Value Stream Constraint
Переглядів 127Рік тому
System constraints are key when it comes to optimizing our value stream. The process bottleneck limits the overall throughput and it determines such things as manufacturing lot sizes.Learning by doing is an effective way to understand how a value stream works.With this simple manufacturing line simulation you can experience the effects of alternative solutions in order to maximize profit. When ...
Value Stream Defect Generation and Detection
Переглядів 64Рік тому
Value Stream Defect Generation and Detection
When Car Accidents Increase, we Sell More Umbrellas
Переглядів 124Рік тому
When Car Accidents Increase, we Sell More Umbrellas
Love the video :), would you be able to share the excel file you present?
You should be able to download the Excel file from this video QR code now
@cornelioabellanas thankyou 😃
Excel file cannot be accessible.
Thanks for the explanation, but the excel file is not available on one drive, could you please share the excel file?
Duhhh, who could have imagined? Everyone.
Sorry, I can't open the URL of the excel.
You must download the Excel to your PC and then run it enabling macros.
1:25 shouldn't there also be a pH*Temp*Time column?
There is no problem in adding the three way interaction to the analysis. Normally 3 way interactions add significantly to the number of experiments and the probability of these interactions is very small.
Is possible to get the excel file? the link to download the excel file it's not working. Thanks in advance
Use this link: 1drv.ms/x/s!AgdGqM2fFHF3l08Idy5CE8MLoXSC
@wpadilla72 would you have the excel file an be able to share it?
You should be able to download the Excel file from this video QR code now
Please shared your file xls
good video.. Thanks
QR code does not take you to Excel simulator but shows another ad
Hello, you must click on the hiperlink: NOT on the OPEN button
Thank you very much for your time.