Consider a very busy working week with many warehouse transactions to complete; customer orders, replenishment orders and inbound receiving. Consider the following operational limitations: - You receive a call from your warehouse supervisor indicating that there will be resource capacity limitation due to unexpected people absence - You receive another call from a sales representative who's waiting with the customer for their products at the hospital - they need the products immediately Note: - Analyze \& use the sample data set provided in the Excel to answer the questions - 'Scenario 2: Operational Execution' - Total number of available resources in the warehouse on this day is 15 in each shift (2 shifts per day) - You can make any data assumptions, if needed, to support your answers (e.g. order processing time, time to complete pallet receiving, and others) - Provide your answers \& inputs in 1-3 slides as needed Questions - Given the data set in the Excel: What's your view on warehouse performance? - What measure/KPI do you propose to monitor process performance? How do you propose to allocate your existing resources to ensure the order backlog is 'minimized'? - How do you propose to prioritize the activities, including the request from the sales representative, on this day to maximize benefits to customers and business