2/3 runs · avg score 83%
Cross-benchmark category
Manufacturing Cost Optimization
Compare AI agent runs for Manufacturing Cost Optimization: prompts, scores, grades, and public traces. This page showcases APEX-Agents tasks that test whether AI agents can identify manufacturing cost optimization opportunities across COGS, gross margin, SKU rationalization, and capex delay scenarios.
Manufacturing consulting AICOGS, gross margin, SKU rationalization, capex delays
83Tasks
1Primary
1Benchmarks
Published model evidence
A quick view of shareable runs in this category. Open task and trace pages for the prompt, response, files, and grading details.
4/7 runs · avg score 79%
42/83 runs · avg score 64%
36/83 runs · avg score 57%
35/83 runs · avg score 56%
25/60 runs · avg score 57%
Primary tasks
1 tasks with this category as their main focus.
Using Lumea's product portfolio (Q4) file, can you calculate the weighted average Q4 gross margin (%) per product category? Percentages and percentage points should be rounded to one decimal place and…
Related tasks
82 tasks that also exercise this work as part of a broader assignment.
- Change in Competitor SG&A Spend by Category_Task02_SCAPEX-Agents(task_449e96fd1efb4a7f9ecbb65e82fbd6c1)0/7 · Fail
Analyze the SG&A files to compare the CAGR trends of competitors versus Impact’s US business across 2020–22 and 2022–24. For each SG&A Category, determine the percentage point change in CAGR between t…
Using the research found on pharma marketing and articles around competitor shifts in SG&A spend, identify key trends that Impact can apply to SG&A spend that could reduce overall costs. In particular…
Can you look at the target Operating Mode standards and the competitor benchmark file to determine if Tesla is adhering to the capital intensity safety limit? Identify the difference between this targ…
Calculate the projected Operating Profit contribution ($ Millions) from the Europe Growth segment from updated growth bridge charts, assuming this new revenue achieves the 2030 Operating Margin target…
Can you take a fresh pass at our cost savings targets? Start by resetting the Manufacturing and Supply Chain savings goals based on the best-in-class cost as a percentage of 2024 revenue benchmarks. …
I'm trying to get a sense of which HarFeast employees are most ready for the digital training rollout. Can you pull the workforce survey data and identify all employees who are above their role type's…
Using HarFeast's baseline diagnostic dataset, assess the impact of predictive maintenance on HarFeast's scrap rate. We will pilot predictive maintenance only on equipment a) whose scheduled hours per …
Can you look at the Frito-Lay case study and apply their downtime reduction to HarFeast Good Group's number in the baseline file? I want to estimate what the improvement would look like for us (rounde…
Using HarFeast's equipment data by location and quality losses dataset, we will consider all canned vegetables assets with a scrap rate > 5% and with unplanned downtime hours above the plant median fo…
Update the business case model with the new gross margin numbers. Flow these values for the model, and give the updated total gross profit values for EV, Hybrid, and ICE for each of the 3 scenarios: (…
Read the attached email from the EM about conducting lifecycle analysis on the SKU data and execute on the analysis in: 4. Data Hygiene / Gaps Log (Associate 2). Use values rounded to two decimal plac…
Use the financial model with the new numbers from the finance team (attached) to calculate the 5 year values for: (1) Revenue, (2) COGS, and (3) Gross Profit. Round all final numbers to two decimals (…
Pull the values for each brand's SKU share. Give them as a percentage of total SKUs, and matching the platform/application and brand name. Round percentages to two decimals. Output your results as a r…
- World 112-1 | Task 2 - Depreciation Reduction for plants (JS)APEX-Agents(task_6b27cc3ab9da428eaa9daa9f5100882b)6/7 · Fail
Calculate 2024 manufacturing overhead (MOH) costs in $ for each Impact plant. Use the midpoint value of the benchmark ranges for the specific product type manufactured at the plant from the attached f…
Let's see how a 5% increase in COGS for all hybrid components affects overall gross profit results. Based on the client's request, we should recalculate the total 5-year COGS (€) and gross profit (€) …
Let's model the impact of the price war in the EV charging space. There is an 8% reduction in the ASP for 'on vehicle charging hardware' across all three scenarios. We need to recalculate the revenue …
Let's calculate how much capex is not spent due to supply chain delays and how that affects Helios' total cash position. Based on the assumption that only 80% of capex is spent during 2026-2027, the…
Let's check how a -2/+2 percentage points (pp) in annual gross margin for all component families affects Helios' total gross profit across the three scenarios. Assume base revenue stays constant, so…
Update numbers with the new projections (attached). I want the full breakdown for: DC converters and onboard chargers Driveline and axle modules Engine control units Engine core hardware Exhaust and …
You are analyzing the results from the customer survey. The survey asked what Helios' top 3 capabilities are. The initial results came back incomplete, and there are now additional responses availabl…
We have new expert input on pricing and content for two power electronics families. In the Helios Europe demand model, please (1) bump the ASP for "On vehicle charging hardware" by 15 percent and (2…
Use the Helios customer survey to calculate average NPS scores for Pureplay EVs and EV/ICE. - If the average is 2 or below, they are promoters. They are passives if they are between 2 and 3, and det…
We want to understand the most important investment areas for pureplay EV respondents. The previous file contained incomplete information, so please use the newly attached updated file. Identify the…
The client wants to see the top four customers by cumulative revenue over the last three years and the average gross profit margin for each of the top customer's product families. Only include orders …
We are making changes to the case model to highlight a downside scenario where China's embargo on critical minerals reduces the components' margins by 50% if they are used for Hybrid and/or EV. The ot…
To implement the required roadmap for our recommendations, we need to identify what roles and plants are most and least willing to go through a digital transformation. We will start with a small tra…
Assume a scenario where CompliSure can achieve best-in-class R&D rates (low) and gross margin rates based on 2024 competitor benchmarks for years 2025 through 2030, if best-in-class is better than the…
Estimate and provide the Manufacturing SOM for CompliSure for the year 2035. Use the 2025-29 CAGR from the manufacturing SAM forecast in the vertical deep-dive manufacturing report as a constant annua…
What is the EV and implied share price of CNS in the DCF model using both Gordon growth model and exit multiple approach if each business segment grows as outlined below over the projection period of …
Run a new DCF scenario. Make the following changes to the metrics in the projection period for Solventum: - Update Sales of Product, Sales of Software, and Rentals from 2025 to 2029 to be a 2-year mov…
Calculate the difference in dollars between Impact's actual 2024 US COGS and the hypothetical US COGS if they reached the straight average of COGS as a percentage of revenue given in Exhibit 2 of the …
I want to inform client discussions around what action to take regarding sourcing of materials and the speculated tariffs. Can you summarize averages of the following 3 data points pertaining to tarif…
Analyze the attached report and the continuous manufacturing report to state the FDA-encouraged manufacturing style that differs from traditional methods which is mentioned in both reports. Using the …
Given the US imposed tariffs on the import of pharmaceutical materials from Germany, India, China at the rates 10%, 15%, 20% respectively, determine the impact of tariffs as a percent increase in pred…
We need to perform a payback period analysis for the investment to upgrade Lorexa's equipment to adopt continuous manufacturing. The methodology and results of the previous cost-benefit analysis of up…
Review industry reports to determine the range of industry-wide reductions in force (RIFs). Using Impact’s revised SG&A breakdown, calculate the cost savings Impact would achieve by reducing its sales…
Can you do some benchmarking analysis of Impact with its 6 peers for 2024 US operations? Let me know the difference between the lowest average monthly revenue per batch passed and the highest average …
Can you please do some what-if analysis of Impact with its 6 peers for 2024 US operations and let me know the following: If the Impact site with the lowest average monthly revenue per head operated a…
Can you please calculate the z score of US 2024 Average Monthly Revenue per Head, for all of Impact’s sites? Use a distribution of US 2024 Average Monthly Revenue per Head per site for all the sites i…
Using the 2024 annual report, identify whether Impact Therapeutics sells primarily branded drugs. A company sells primarily branded drugs if the majority of drugs have launch dates within the last 7 y…
Using the latest materials cost reduction analysis, assume Impact reduces its 2025 materials cost with current supplier relationships by 20%. Benchmark Impact's resulting 2025 materials cost as a perc…
After reviewing our analysis, the client has a few more requests for us. Recall we had shown scenarios in which the company discontinues SKUs which account for 5%, 7.5%, and 10% of gross profit. We …
Based on the client’s SKU data, calculate the weighted average gross margin for each platform. Then determine the percentage price increase required for SKUs on the lowest-margin platform to raise the…
We have ten expert call summaries from 2022 plus our latest 2025 expert synthesis file, and we want to see how typical EV unit prices have moved for two key families. Can you read the call summaries…
1. Give me the total labor cost for each plant location. 2. Give me the efficiency gains for each plant location. West North Central division plant locations only have a 10% annual efficiency gain f…
1. What is the digital lever that Sarah Jenkins, David Chen, and Mike Russo agree will deliver the fastest and biggest boost to HarFeast's Gross Margin? 2. Assuming HarFeast adopts the chosen digi…
Can you calculate the total labor variance in hours (favorable should be positive) and dollars for the Illinois and Wisconsin plants? A positive variance should mean that Total Actual Hours are less t…
Calculate the Adjusted Cost of Instability for each site, defined as Abnormal scrap cost/(Actual Scrap %−Normal Scrap %) = adjusted cost of instability. The target scrap rate of HarFeast is the minimu…
Identify the top five technology investments from the Aptean report with the largest positive difference in percentage revenue growth between users and non-users. Include only investments that the rep…
Analyze the operational efficiency at HarFeast and assess how many inefficient employee hours each plant is recording on average. Which plants have the most efficient operations and the least efficien…
I want to quantify the average annual productivity loss at a cost level for each employee in each primary role based on the sum of average hours spent doing manual entry, searching data, and fixing er…
Use the v1 version of the survey responses to identify the number of respondents who received any kind of training on digital tools. Of those respondents, return the percentage of respondents for each…
The client sent us employee wage data (attached), so we need to update our assumptions in the financial analysis section of the survey analysis report to display the updated annual productivity loss f…
Take a look at our workforce distribution in the country where we've spent the most on OPEX from 2020-24. Knowing we need 2 line technicians per transmission line, 1 substation technician for each sub…
Calculate the NPV from the 12-year cash flow on renewable enablement benefits, considering the following assumptions: - The steady-state annual benefits from renewable enablement mentioned in the busi…
What is the net aggregate annual benefit (i.e., total annual savings minus total annual opex) of all of the use cases in the digital use case sizing analysis? According to the new transmission technol…
Investigate whether EuroGrid should consider increasing staffing. Determine if the number of working people per impacted asset is correlated with the expected economic impact of unforeseen downtime in…
Comparing the revised projections for 2026-2030, what is the change in Japanese and Global 2026 results for Gross Profit and EBITDA in both dollar and percentage terms? If the 2026 Marketing costs in…
In the Accretion / Dilution Model, there is an error in the calculation of Cost of Product and Cost of Software and Rentals. Calculate the correct revised implied Enterprise Value after the divestitur…
In the Accretion / Dilution Model, use the capital structure and shares outstanding assumptions for Solventum (SOLV) to calculate levered free cash flow and price per share. Specifically, use the foll…
Assume that no transaction happens with SOLV. Now, calculate the impact of a large investment in AI for MMM shareholders as an alternative capital allocation strategy using the accretion dilution mode…
Using the accretion dilution model, produce the deliverables outlined below. Round all the figures to whole numbers, present monetary amounts in $ mm and display percentages to two decimals places. …
Using the 3Q 2025 3M 10Q and the accretion dilution model, calculate the following deliverables. Present all values in millions ($mm), number of shares in millions (mm), and round to whole numbers. Fo…
Calculate the intrinsic value per share of Solventum based on these assumptions. Use the accretion dilution model. - Lower the gross margin % to 52% for the forecast period 2026E through 2029E. - Ch…
Calculate Unlevered Free Cash Flow in 2025E, 2026E, 2027E, 2028E and 2029E. In the Golden Everest Financial Model, there is an error in the unlevered free cash flow build in the Projections, "Project…
Using the REIT model, consider the following assumptions for the projected period between 2025 to 2029: 1) Assume the revenue growth for its service business equivalent to the overall company revenue …
Perform a DCF analysis for Golden Everest using the REIT model with the following parameters: - Hold EBITDA margin constant at 42% throughout the projection period - Hold Capex % of Revenue constant a…
For each year, calculate Levered FCF less Dividends Paid. Assuming a 9% discount rate, output the net present value (NPV) of Levered FCF less Dividends Paid over the projection period, rounded to a f…
I want the Output Levered FCF for 2029E, rounded to the nearest million. - Revenue growth: starts at 7.0% and increases by 0.5% per year in the projection period - EBITDA margin %: starts at 44.0% and…
Planet Fitness is looking to divest its entire 281 stores, which it owns as of September 30, 2025, to a franchise owner. Round all results to two decimal places and present it in $mm. Using the LBO m…
Planet Fitness is considering the acquisition of 100% stake in The Gym Group and taking it private in order to expand its presence within the UK. Using GYM H1 2025 and GYM annual 2024 docs, consider…
Update the LBO model to include an incentive payment structure of PLTF management post-transaction. Assess the impacts on the 5-year LBO analysis. Management is eligible for these payments each year …
Using the LBO model, I want you to tell me updated values for: (1) Implied Net Debt, (2) Sponsor Equity Value and (3) IRR for Year 5. # Assumptions -Increase the interest rate of the secured term loa…
Calculate the sponsor equity value and IRR for FY2030, then report the sponsor equity value in US dollars, rounded to the nearest million. Report the IRR to one decimal place. Reference the LBO mode…
Use Planet Fitness' latest financial model, in the"Copy of LBO" tab, and sensitize $ operating expenditure each year by +/- 5% against the base case for each year from 2026 through 2030; calculate the…
Please use assumptions below for a more aggressive financial forecast, which is termed the "SuperUpside" case: - The drivers of the SuperUpside case adds to the "Upside" case the difference between t…
You have access to the accretion dilution model. Create a new sheet and tell me the Proforma Interest Coverage for 2027 and 2028. In doing so, assume: - Aptar's Interest expense as a percentage of s…
Calculate the updated PV of FCF. Output it here. Round it to the nearest whole number, with zero decimals. Print your answer as a reply back here. Account for: 1. Identify the competitor in the compa…
Reply back to me with the following values: - Implied share price. - Enterprise value - % weight of PV of terminal value in the total new EV. To get to the right answer, update the WACC calculation …
TRIDENT AUTO CORPORATION (The "Plaintiff") has filed a Complaint against United States President Donald Trump (the "Defendant") in the United States District Court for the District of Columbia challen…
TAC has just informed us that they expect a 20% drop in gross margin due to import tariffs. TAC has posted the information on their website as they have done in the past. Write me back a brief message…
We had an intern prepare a list of what needed to be done after closing and they made a mess of it. We've already established the holding company, reviewed insurance policies, and completed a complia…