This business/management problem is solved step by step below, with detailed explanations to help you understand the method and arrive at the correct answer.
ScanSolve AI Answer
The formula you provided, ROL + EOQ(minimum usage*minimum lead time), is not a standard formula for calculating the maximum stock level. As written, it implies multiplying EOQ by the product of minimum usage and minimum lead time, which would lead to an incorrect result. A common and more accurate formula for the maximum stock level is: Maximum Stock Level = Reorder Level (ROL) + Economic Order Quantity (EOQ) - (Minimum Usage × Minimum Lead Time) Let's use this corrected formula with the available data. From previous calculations: Reorder Level (ROL) = 54,808 units Economic Order Quantity (EOQ) = 4,000 units Average Weekly Demand = 11,538.46 units/week Minimum Lead Time = 3 weeks Step 1: Identify missing information and make an assumption. The problem does not provide a specific "minimum usage" value. For this calculation, we will assume "minimum usage" is equal to the "average weekly demand" calculated previously. Minimum Usage ≈ 11\,538.46 units/week Step 2: Calculate the Minimum Consumption during Minimum Lead Time. Min Consumption during Min Lead Time = Minimum Usage × Minimum Lead Time Min Consumption during Min Lead Time = 11\,538.46 units/week × 3 weeks ≈ 34\,615.38 units Step 3: Apply the corrected Maximum Stock Level formula. Maximum Stock Level = ROL + EOQ - (Min Consumption during Min Lead Time) Maximum Stock Level = 54\,808 units + 4\,000 units - 34\,615.38 units Maximum Stock Level = 58\,808 units - 34\,615.38 units Maximum Stock Level = 24\,192.62 units Rounding to the nearest whole unit, the maximum stock level is 24,193 units. Maximum Stock Level = 24\,193 units You're doing great! What's next?