Perhitungan Metode Tsukamoto Menggunakan Aplikasi Microsoft Excel

Summary

This video provides a detailed explanation of how to calculate production using the Tsukamoto fuzzy inference method in Microsoft Excel. It walks through the process of defining input variables like demand and inventory, calculating membership values, and applying fuzzy inference rules. The script demonstrates how different fuzzy sets for demand and inventory lead to varying production outcomes. Using the method, the final production is determined by defuzzification, yielding a production value of 194 units. The video offers step-by-step guidance on performing these calculations, making it an informative resource for understanding fuzzy logic in production planning.

Takeaways

• 😀 The script introduces the Tsukamoto fuzzy logic method for calculating production using Microsoft Excel.
• 😀 The goal of the calculation is to determine the production amount based on given demand and inventory values.
• 😀 Fuzzy rules are applied to the relationship between demand, inventory, and production, affecting the production outcome.
• 😀 Demand is set between 100 and 150, with 120 as the given demand in the problem.
• 😀 Inventory is set between 20 and 60, with 45 being the given inventory value.
• 😀 The production range is between 150 and 250, with the script calculating a production value of 194 units.
• 😀 The script explains how membership functions are used to calculate the membership values of demand, inventory, and production.
• 😀 If a variable is less than the minimum, its membership value is 0, and if it exceeds the maximum, the membership value is 1.
• 😀 Linear interpolation is used to calculate the membership values for variables within their range.
• 😀 The final production value is calculated by applying fuzzy logic rules to the demand and inventory memberships.
• 😀 The Tsukamoto method provides a flexible way of calculating production by considering fuzzy logic and membership functions.

Q & A

What is the purpose of the Tsukamoto method in the context of this script?

The Tsukamoto method is used to calculate production based on fuzzy logic, taking into account varying levels of demand and inventory. It helps determine the appropriate production value in uncertain or imprecise situations.

How are fuzzy sets defined in this script for demand and inventory?

Fuzzy sets for demand and inventory are defined by ranges. For example, demand ranges from 100 to 150, and inventory ranges from 20 to 60. Specific values are assigned to these ranges based on the given inputs (e.g., demand = 120 and inventory = 45).

What happens when the demand and inventory values are low or high?

The production level is determined based on fuzzy rules. If both demand and inventory are low, production decreases. If both are high, production increases. In cases where one is low and the other is high, production may still increase, depending on the specific fuzzy rule.

What formula is used to calculate the fuzzy membership values for demand and inventory?

The fuzzy membership values are calculated using a specific formula. If the value of X (demand or inventory) is less than or equal to 'a', the membership value is 1. If X is greater than or equal to 'b', the membership value is 0. If neither condition is true, the formula used is (X - a) / (b - a).

How is the alpha value calculated in the Tsukamoto method?

Alpha values are derived from the fuzzy sets based on the relationships between demand and inventory. These values indicate the degree of membership for a given input in a particular fuzzy set. For example, if demand increases and inventory also increases, a higher alpha value is generated.

What is the purpose of the defuzzification process in this script?

The defuzzification process combines the fuzzy output values (calculated using alpha) to produce a single, crisp production value. This is done by calculating the weighted average of the production values, which results in a final, defuzzified production output.

What is the final production value determined in the script?

The final production value calculated through the Tsukamoto method is 194 units, which is the defuzzified output after considering all fuzzy rules and alpha values.

What are the conditions under which the production value increases or decreases?

Production increases if demand and inventory both increase, or if one increases while the other decreases. Production decreases if both demand and inventory decrease.

How is the production value calculated when alpha equals 1 or 0?

When alpha equals 1, the production value corresponds to the highest production value (250), and when alpha equals 0, the production value corresponds to the lowest production value (150). If alpha is between 0 and 1, the production value is calculated using a weighted average formula.

What role does the total alpha value play in the final production calculation?

The total alpha value, obtained by summing all individual alpha values, is used to weight the production values. The final production output is determined by dividing the weighted sum of production values by the total alpha value, resulting in the final production decision.