Question 1

What does the "range\_lookup" parameter in the VLOOKUP function control? With the following data, determine which SKU has the minimum Average Days of Inventory. | Stock Keeping Unit | Open Stock in Warehouse | Avg Daily Sales | |---|---|---| | A01 | 18.7 | 8.5 | | A02 | 31.2 | 6.3 | | A03 | 15.9 | 3.7 | | A04 | 12.4 | 2.9 | Calculate the Overall Equipment Effectiveness (OEE) of the Assembly Line Equipment for the month of July. $$\text{OEE} = \underbrace{\text{Availability}}_{\dfrac{\text{Run Time}}{\text{Planned Production Hours}} = \%} \times \overbrace{\text{Performance}}^{\dfrac{\text{Actual Machine Speed}}{\text{Design Machine Speed}} = \%} \times \underbrace{\text{Quality}}_{\dfrac{\text{Number of Good Products}}{\text{Total Products Made}} = \%}$$ Parameters: | Planned Production Hours (PPH): | 400 | |---|---| | Lost Time (LOT): | 30 | | Designed Assembly Speed from Equipment (DA) per Hour: | 180 | | Actual Assembly Speed from Equipment (AA) per Hour: | 160 | | Total Units Assembled (TU): | 8000 | | Defective Units (DU): | 320 | Round the OEE to two decimal places