Barmalt Malting Operations Executive Interview Questions and Answers

Conditional sum is used to calculate the sum based on certain conditions, while distinct count is used to count unique values in a pivot table.

• Conditional sum can be achieved using functions like SUMIF or SUMIFS in Excel.

• Distinct count can be achieved using the COUNTIF function with a unique identifier column.

• In a pivot table, you can use the Value Field Settings to choose between sum or count, based on your requiremen

Managed database systems, generated reports, provided technical support, and implemented new technologies.

• Managed database systems to ensure data integrity and security

• Generated reports for management to analyze business performance

• Provided technical support to end users for software and hardware issues

• Implemented new technologies to improve efficiency and productivity

• Collaborated with cross-functional teams to integra

To increase OEE, focus on reducing downtime, improving quality, and increasing speed.

• Identify and address the root causes of downtime

• Implement preventive maintenance programs

• Train employees to operate equipment efficiently

• Improve quality control processes

• Optimize production scheduling

• Invest in new technology or equipment

• Streamline processes to reduce waste and increase speed

SMED stands for Single Minute Exchange of Die, a lean manufacturing technique to reduce setup time.

• SMED aims to reduce the time it takes to switch a production line from making one product to another

• It involves breaking down the setup process into small steps and finding ways to streamline each step

• The goal is to reduce setup time to less than 10 minutes, hence the name Single Minute Exchange of Die

• Examples of SMED in ...read more