Management Consulting World 130

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 median readiness score, willing to pilot new tools, willing to spend >2 days in training with dedicated training time, and above the overall median digital comfort score? Once you've identified that "high-priority" group, can you tell me: 1. How many employees qualify and what percentage of the total workforce that represents 2. How many hours these employees spend on manual entry / searching / fixing errors, and what percentage of total manual entry / searching / error fixing hours that represents 3. How many "high-priority" employees there are for each role type Just give me the final answers as a reply in this box, rounded to one decimal place.

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 minimum in the range of acceptable scrap rate in the scrap rate report. Just use COGS per ton as your scrap cost for now. Report your final answers to me in a message. Round values to the nearest dollar.

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 year are at or above that equipment type's median scheduled hours and b) whose labor hours are at or above its plant's median labor hours. For all equipment qualifying for the pilot, apply the improvement assumptions from the Gogo Food case study. 1. Calculate the new overall scrap rates per product family, rounded to one decimal point place. 2. Calculate the total scrap units each product family avoids per year after these improvements, rounded to the nearest whole number. Please return all results to me in your reply.

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 digital lever, determine the OEE level in the first full year in each plant location where the annual OEE value exceeds the world-class target. Assume OEE rates stay constant until the investment start dates (Jan 2026 for plants in the East North Central region; Jan 2027 for others) and that the % annual OEE improvement begins in the same year HarFeast starts investing/executing the initiative (the first investment year counts as Year 1 such that Year 1 Value = Baseline * (1 + Rate))). Use the relative % annual OEE increase mentioned in the interviews for each year thereafter. If multiple % annual OEE increase figures are given in the interviews, use the highest figure. 3. For the two plant locations with the highest OEE level, what is the calendar year in the first full year where the annual OEE value exceeds the world target? Give me your answers printed back here as a short response, with values rounded to the nearest hundredth of a percent.

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 from labor cost. For other locations, the efficiency gain is 20%. However, the efficiency gain is 5% for non-unionized production supervisors no matter where they are located. 3. Give me the forecasted increase in annual labor cost as a result of union demand. All union members in the East North Central division plant locations other than production supervisors are demanding a 5% increase in annual pay. The rest of the union members in all locations are asking for an 8% increase in annual pay. Write your answers here with everything I requested, rounded to the nearest dollar. Ignore any plants in Ohio and Michigan for all questions.

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 efficient operations? How much more efficient are the highest efficiency locations vs the lowest efficiency locations? Assume the following activities are considered inefficient: (a) manual data entry, (b) searching for data, and (c) fixing errors. Report final answers to one decimal place, except percent final answers, which should be rounded to the nearest percent. Report the final information I want in here

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 errors. Then, I want to calculate the total productivity loss cost HarFeast faces every year, company-wide. Note that the survey responses represent one week of work. Report your final answer as a message here, rounded to the nearest dollar.

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 for canned vegetables as "high-priority". 1. For the "high-priority" group, calculate the total annual quality-related losses (scrap + unplanned failure cost). If the quality losses dataset has a different product family label, ignore it. 2. Calculate the percentage of all canned-vegetable quality losses that comes from these "high-priority" assets. Print it here, numbers rounded to the nearest whole number.

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 than Total Standard Hours. You can use the median wage for All Occupations in the food manufacturing industry in the attached file to convert from hours to dollars. Also, please give me the straight average of the Productivity Index (Standard Labor Hours per Ton divided by Actual Labor Hours Per Ton) for each location. Round the final answers to the nearest hundredth. Provide all your answers directly as a reply to me here. Use the plant-level equipment data by location for the analysis. Also, per client, the total Standard Hours shall be based on Actual Throughput Tons and the Standard Labor Hours per Ton.

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 figures (in 000s). Find the average hourly salary of employee roles and use that to update the annual productivity loss estimate (rounded to 1 decimal place). Assume average hourly wages in the data are fully-loaded costs. Assume the following activities are non-productive: manual data entry, searching for data, and fixing errors. Report final answers here, written out in a short message.

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 report explicitly identifies as either top technology investments to date or top investments planned for 2024. Next, assume that Harfeast will deploy all five of these top initiatives at every plant location, except for its vegetable-heavy processing locations, which will only deploy the top two. Use the resulting percentage revenue impact to project Harfeast's total 2024 unit sales for each location after investing in the initiatives. For this projection, assume the unit sales price remains constant from 2023 to 2024, and that the calculated revenue impact is consistent across all product lines within each plant. Finally, using the calculated 2024 unit sales, determine the expected 2024 total revenue (in $) for each plant location, incorporating a 15% unit price increase for all canned vegetables, a 10% unit price increase for condiments produced at the Rockford, Illinois location, and a 5% unit price increase for all other condiments and sauces across the remaining locations. Round all final numerical values to the nearest whole number. Return answers directly in here.

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 training program in those plants that have highest and lowest willingness and, within these plants, those roles with highest and lowest willingness to adopt digital tools. This will help us determine how much digital willingness matters and what changes we might need to do accordingly. Once we determine what training preferences (i.e. how much time) might be most suited for each group, we will calculate the potential costs of training these employees (i.e. those that have the highest preference for a length of training in roles with high willingness to adopt tools in plant with highest willingness and role with lowest willingness in plant with lowest willingness). Write out for me here a message with the roles impacted per category (high/high, low/low), the count of employees, the length of training in hours, and the total cost in $. Round numbers to 1 decimal.

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 (rounded to the nearest full percentage point). Output the information in a message here.

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 training quality rating. Reply back here to me.