If Purchase Quantities of 25 Units or Higher Are Found

question 5

Multiple Choice

If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5:H10 to calculate each order's size?

• A) =IF(D4=AND=OR=25,"Large","Small")
• B) =IF(D4<>25,"Small")=AND(D4=25,"Large")
• C) =IF(D4=25,"Large")=OR("Small")
• D) =IF(D4>=25,"Large","Small")

---

Definitions:

Replenishment Lead Time

The time taken from placing an order for more inventory until it is received and ready for use or sale, impacting inventory management strategies.

Transportation Cost

The expenses involved in moving goods from one location to another, including freight charges, fuel, and maintenance.

Shipping Cost

The expenses associated with the transportation of goods from the point of origin to the final destination.

Supply Chain Coordination

The practice of aligning and harmonizing all parties involved in a supply chain to ensure optimal efficiency, from suppliers to end consumers.