The Excel file, LLBean.xls $($download from the class folder$)$ contains demand and forecast data for $84$ items. Suppose that these are the data that LL Bean will use to plan their next season. Consider an item that retails for $$45$ and costs LL Bean $$25.$ The liquidation price for this item is estimated to be $$12\mathrm{.}5.$ The sales forecast for this item is $11,000$ units. What order quantity should LL Bean choose for this item? $($Follow the method outlined in the L$.$L$.$Bean case using the Actual$/$Forecast ratios.$)$ Hint: There are many ways to arrive at the correct answer. One way involves the use of the PERCENTILE function in Excel. Even if you have not used this function before, it is easy to learn.