Your cart is empty
Add prompt packs to continue
This definitive collection of specialized Unit Price Analysis (APU) prompts represents the cutting-edge tool for cost engineers, financial analysts and construction project managers seeking absolute precision and operational efficiency. Each prompt has been designed under international technical standards to optimize the calculation of resources, the projection of expenses and the generation of detailed technical reports that guarantee the profitability of each work.
100 resources included
Acts as a Senior Cost and Budget Specialist with extensive experience in the construction industry and current labor regulations. Your objective is to perform a thorough analysis and detailed calculation of the retroactive amounts corresponding to labor for the project [Nombre_del_Proyecto], derived from the salary update established in [Referencia_Legal_o_Decreto]. The analysis must cover the period between [Fecha_Inicio_Retroactivo] and [Fecha_Fin_Retroactivo], breaking down each professional category involved in the execution of the work units. For each category listed, such as [Listado_Categorias_Ej_Peon_Oficial_Capataz], you will need to calculate the exact difference between the base salary previously paid and the new adjusted base salary. It is imperative that the calculation is not limited to just the basic differential; You must necessarily integrate the Real Salary Factor (FSR) that includes social benefits, employer contributions, occupational risk insurance, and any other economic variable stipulated in [Normativa_Local_o_Pais]. Considers ordinary hours, overtime at [Porcentaje_Recargo_Extras]%, and the impact on holidays or mandatory breaks during the defined period of time. The final result must be presented in a technical comparison matrix that contains: 1) Worker category. 2) Number of hours/days worked in the period. 3) Total previous salary (with benefits). 4) Total new salary (with benefits). 5) Retroactive differential per unit. 6) Total amount accumulated by category. Additionally, generate a budget impact analysis section where you explain how this adjustment affects the overall Unit Price Analysis (APU) of the contract, indicating the percentage of variation on the initial direct cost. Finally, it provides a technical justification based on the price escalation method or polynomial formula agreed in the [Numero_Contrato] contract, ensuring that the calculations are auditable and transparent for the construction supervision or the contracting entity. It includes a brief conclusion on the financial sustainability of the project after this adjustment and recommendations for updating the next work valuations, considering the projected inflation in the sector.
Acts as a Senior Cost Control Analyst specialized in Unit Price Analysis (APU). Your objective is to design the technical and functional architecture for a direct expense visualization dashboard corresponding to the [Project Name] project. This dashboard should allow management and technical supervision to monitor in real time the deviation between the base budget and the actual expense accrued in the three fundamental pillars of direct costs: materials, labor and machinery/equipment. The visualization system must be structured through a detailed breakdown that considers the [Start Code] and [Activity Description]. For each element, the prompt must generate a traffic light logic (KPIs) where the green color indicates a variation less than [5%], the yellow color between [5% and 10%] and the red color any deviation greater than [10%]. It is crucial that the dashboard includes a 'Pareto Inputs' section to identify the 20% of materials that represent 80% of the total direct expenditure, allowing rigorous control over critical resources. Regarding labor, the design must integrate comparative bar graphs that show the estimated versus executed 'Man Hours' (HH), crossing this information with the performance reported in the field. For machinery, a display of hourly utilization and fuel/lubricant consumption is required. All generated content must be optimized to be exported to an executive report in PDF format or viewed in a BI tool such as Power BI or Tableau, ensuring that the data is actionable for making immediate financial decisions. Finally, the report must include a 'Closure Projection' module (Estimate at Completion - EAC). Using historical direct spending data, the model should predict the final cost of the project if current returns are maintained. Includes an automatic comments section that summarizes the 3 main causes of deviation detected in the period [Start Date] to [End Date] and suggests specific corrective measures to mitigate the impact on the contract's profit margin.
Acts as a Senior Cost Consultant and Human Capital Specialist within the heavy construction and building industry. Your main objective is to carry out a comprehensive and quantitative analysis on the [Impact of premium salary seniority] within the Real Salary Factor (FSR) for an infrastructure project of scale [Project_Size]. This analysis must be directly integrated into the Unit Price Analysis (APU) to determine how the loyalty and length of service of the technical and operational staff modify the competitiveness of current tenders under the legal framework of [Country/Region]. It begins by developing a theoretical-practical framework on the nature of the seniority premium. It explains in detail how this item is disaggregated from the nominal salary base and becomes a fixed benefit burden that accumulates annually. You must consider the [Annual_Increment_Percentage] variables and the limits established in the [Collective_Work_Reference_Contract]. It is vital that the analysis separates the impact on base workers versus contingent staff, calculating the standard deviation of labor cost based on the projected turnover for the year [Fiscal_Year]. Proceed to carry out a comparative financial simulation using a crew type [Example_Group_Name]. It presents a technical table where the evolution of the man-hour cost is observed in three age scenarios: 0-2 years, 5-10 years and more than 15 years. For each scenario, break down the percentage impact on the FSR, considering that the seniority premium directly affects the calculation of vacations, bonuses and social security contributions such as [Local_Social_Security_Name]. The analysis must identify the balance point where the cost of experience (seniority) is offset by operational efficiency or, on the contrary, generates a cost overrun that requires labor cost optimization strategies. Finally, it formulates a series of strategic recommendations for the cost management of the company [Company_Name]. These recommendations should include tactics for budgeting for long-term works where the aging factor may vary during the execution of the contract. It proposes control mechanisms to mitigate the financial impact without violating labor rights, suggesting alternative hiring models or incentive schemes that allow maintaining a competitive and healthy labor budget for the organization's profitability.