Bachelor/Master Internship: Standardize the process of cost price forecasting for future vehicles

Improving the Accuracy and Efficiency of Cost Price Forecast Reporting for Future Vehicle Development / Stageopdracht: Analyse en Optimalisatie van het Rapportageproces

Functiebeschrijving / Wat ga je doen?

During your internship, you will be part of a team of 10 colleagues. In this assignment, you will thoroughly analyze the reporting process involved in the preparation of review files (reviewdossiers). The goal is to assess the quality and efficiency of this process. You will examine the current workflow, identify potential bottlenecks, and propose improvements to make the process more robust and efficient. The deliverable of your study will be a clear and transparent description of all the steps within the process, serving as a foundation for further optimization.

Your challenge / Jouw uitdaging:

• Analyze the existing reporting process
• Evaluate the quality and efficiency of review file preparation
• Identify improvement opportunities and optimization potential
• Develop a comprehensive and transparent process description

Jouw profiel

We are looking for an enthusiastic, bright, and intelligent bachelor’s or master’s student with a background in business administration, business economics, or econometrics, and an affinity for technology. Strong knowledge of data analysis and experience in handling data transparently and robustly are essential. Interest in finance and a passion for collaborating within our team to create the most desired trucks on the market are important. Experience with PowerPivot and Queries is a significant plus.

Afdeling

The Cost Estimation Department within Finance is responsible for reporting forecasts of product cost, which are impacted by product innovations. This reporting covers a set of reference vehicles. The main focus is on the impact of product development on future trucks of DAF. Additionally, the effects of engineering maintenance on current products, as well as external economic influences such as raw material commodities, commercial conditions, and labor rates, are tracked to anticipate their overall impact on the forecasted future cost price.

A cost price report is created by extracting Bill of Material data, including costs, from current production and, if available, trial builds of future production. This data is reviewed, corrected, and supplemented with information from estimates and quotes to establish the most accurate forecast possible. The forecast information is consolidated and presented through multiple cross-sections in a standardized report, providing updates on the current status, the delta compared to the previous report, the risks, and the opportunities across three different time frames: present, near future, and long-term.

The source of the current production data is the Mainframe. Virtual order calculations are imported into the data warehouse Snowflake. Using Sigma, this data is extracted from the database and formatted into a working file in Excel. To facilitate review and analysis, a set of pivot tables is made available to each reviewer in a personal file, with customized views linked to the central working file.

Wij bieden

• A view behind the scenes at a large international corporation; you will get a lot of freedom and responsibility;
• We are open to your initiatives and depending on the assignment you see your results back in the workplace;
• An experienced coach and supervisor who can teach you a lot and is willing to help you with your assignment;
• After your graduation, you will have the opportunity to start your career at DAF;
• An internship wage of € 375,- Bachelor and € 450,- Master per month on full-time base;
• A travel allowance, if you don’t have a student travel product (provided by the Dutch government);
• A housing allowance, if you temporarily rent a room near DAF.