Enhancing cost efficiency in manufacturing through 3C: an excel-based solution
Enhancing cost efficiency in manufacturing through 3C: an excel-based solution

Author(s): Ramë Likaj, Gëzim Hoxha, Albi Macula
Subject(s): Economy, Business Economy / Management, Accounting - Business Administration, Business Ethics
Published by: Национално издателство за образование и наука „Аз-буки“
Keywords: Cost Estimation; Manufacturing Processes; Production Planning; Automated Calculation; Data-Driven Decision Making; Excel Programming; VBA; Manufacturing Optimization; Cost Analysis
Summary/Abstract: Manufacturing cost estimation is crucial for improving production efficiency and competitiveness. This paper describes a responsive and real Production Cost Program that is structured as an interactive form that incorporates data analysis for a variety of production processes such as milling, drilling, laser cutting, and water jet cutting. The system uses the supplied data to select the best processing methods, assuring accurate cost calculations. The user interface acts as a structured questionnaire, requiring users to enter essential parameters such as materials, machining procedures, and production volume. Once these inputs are entered, the system automatically computes the required cost factors in the background of the application by referencing pre-entered tabular data. This method reduces user effort while retaining high accuracy in cost estimation. The program that was built by using Microsoft Excel as a programming tool, leveraging its advanced formula-based calculations, macros, and Visual Basic for Applications (VBA) scripts to automate data processing. Its structured style enables dynamic cost analysis with real-time accuracy. Excel’s interaction with external databases extends functionality beyond standalone estimation. The program that we have created in this paper and its adaptability enables modification to industry requirements, streamline cost analysis and optimizing production planning. Excel’s automation and scalability increase resource allocation, waste reduction and adaptability to a wide range of manufacturing environments.

• Details
• Contents