Thank you in advance for your help; could you please provide an excel spreadsheet solution too, to help in my understanding?

?

11. EOQ analysis Tiger Corporation purchases 1,420,000 units per year of one component. The fixed cost per order is $55. The annual carrying cost of the item is 25.9% of its $10.23 cost. a. Determine the EOQ if (1) the conditions stated above hold, (2) the order cost is $1.00 rather than $55, and (3) the order cost is $55 but the carrying cost is $0.01. b. What do your answers illustrate about the EOQ model? Explain. a. (1) If there are no changes in the costs, the EOQ is units. (Round to the nearest integer. For infinity, input INF) (2) If the fixed cost per order is $0, the EOQ is units. (Round to the nearest integer. For infinity, input INF) (3) If the annual carrying cost of the item is $0.01, the EOQ is units. (Round to the nearest integer. For infinity, input INF) b. Is the following statement about the EOQ model true or false? (1). (Select from the drop-down menu.) "The EOQ model is not useful when ordering costs are zero. As shown in part a, when the fixed cost per order is zero the model is not realistic. With zero ordering costs the firm is shown to never place an order." (1) O True False