A Linear Programming Methodology to Optimize Decision-Making for Ready-Mixed Cement Products: a Case Study on Egypt’s New Administrative Capital

Egypt has started constructing its New Administrative Capital since 2015. The new capital was designed to meet smart city standards, which presents a challenge for businesses to make the optimum business decisions given the set budget for such a project. As a result, reaching the optimum solution for allocating the needed materials to each building became important. Many researchers have considered the theory of constraints in their studies to determine the optimum product mix. Frequently, research considers the target of profit maximization to reach the optimum solution with one scenario. In this paper, we aim to solve the problem of product mix in cement production, which organizations face. The problem was formulated based on a case study in Egypt with two linear programming approaches. For this problem, many scenarios were presented under the consideration of two aspects, which are resource utilization and productivity. Data visualization was used in this paper to simplify the procedure of decision-making. Also, a dashboard web application was made for the decision makers to make it easier to create, analyze, and see different business scenarios.