355 - Spring 2021 - Protected View - Saved to this PC- A halyna3111@gmail.com milings Review View Help Unless you need to edit, it's safer to stay in Protected View Enable Editing ut interruption activate before Sunday, April 11, 2021 Activate 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 26,000 boxes over the coming year. Each box costs $140, the annual holding cost per box is $32, and the cost of placing an order is $200 (regardless of the quantity ordered). For the following questions, use the basic economic order quantity model (without quantity discounts). 1. What is the economic order quantity (in boxes)? (2pts) 2. Calculate the annual inventory holding costs based on the average inventory level and annual holding cost per box. (2pts) 3. Calculate the annual inventory ordering costs based on the number of orders expected to be placed during the coming year. (2pts) 4. Create a data table showing the total annual inventory costs (inventory holding + inventory ordering) for order quantities varying from 100 to 1050 (in increments of 50). You must use a data table structure to receive full credit for this problem. (8pts) 5. Create a scatter chart (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. Observe that the total annual inventory costs are the smallest near to the EOQ value you found in the first question above. (6pts) I Focus ASUS ZenBook F8 FO FIO FI F12 Pet So