Question Set 2. A manufacturing operation must periodically purchase bulk quantities of bolts. The bolts are purchased in boxes of 500 and are consumed at a constant rate. The operation expects to purchase 28,000 boxes over the coming year. Each box costs $140, the annual holding cost per box is $21, and the cost of placing an order is $160 (regardless of the quantity ordered). For the following questions, use the basic economic order quantity model (without quantity discounts). 1a. Create a data table in excel showing the total inventory costs (only) for order quantities varying from 100 to 1050 (use a step size of 50). You must use a data table structure to receive full credit for this problem. 16. Create a scatter chart in excel (use the one with markers and smooth lines) showing how total inventory costs are a function of the order quantity. Be sure to label your axes appropriately