Supporting Local Business Growth through Better Production Cost Calculation at Kerupuk Lempeng Bapak Haryono

Sragen Regency, August 2, 2026. As part of the 2026 KKN program, Cintha Shaffa Aurellia, an Accounting and Taxation student at Diponegoro University, provided guidance on production cost calculation for Kerupuk Lempeng Bapak Haryono, a local small business in Gringging Village.

The program began with an initial interview with the business owner. During the interview, the business owner explained that the selling price was mainly based on the cost of raw materials. Other costs, such as labor, packaging, and transportation, had not been included in the calculation in a systematic way. As a result, the business did not have a clear picture of its actual production costs and profit margin.

The activity began with data collection on July 9, 2026, through direct observation and interviews at the production site. The data collected included the raw materials used in each production batch, the production process, and other operating costs such as fuel and packaging. The visit also showed that raw material and operating costs were not recorded regularly, especially when prices changed.

Based on the data collected, Cintha Aurellia held a practical training session on August 2, 2026. The session covered the main components of production costs, including direct materials, direct labor, and overhead costs. The participants then used a Microsoft Excel template prepared for the business. One of the business representatives was guided through the process of entering production and cost data into the template until the production cost per batch and per unit could be calculated.

The training also included several practice situations, such as changes in raw material prices and the efficiency of the drying process. These exercises helped the business owner understand how changes in costs could affect production costs and profit margins. Simple recommendations for keeping regular cost records were also provided.

At the end of the program, Cintha Aurellia developed an Excel based guide for calculating production costs and handed it over to the business owner. The guide explains the production cost calculation, provides a worksheet for entering data, and shows how to use the template with the business’s own figures. The template was also tested using actual business data to make sure it could be used properly.

Through this program, Kerupuk Lempeng Bapak Haryono can determine its production cost per unit more accurately when setting selling prices. Using Excel can also make business records more organized and help the owner make decisions based on cost data, including when raw material prices change.

The program is also related to the Sustainable Development Goals (SDGs), particularly SDG 8, Decent Work and Economic Growth, by supporting productivity and better management of the local business. It also supports SDG 12, Responsible Consumption and Production, through more efficient management of production costs and resources.