An Office Supply Company Is Attempting to Determine the Order

question 14

Multiple Choice

An office supply company is attempting to determine the order quantity for laser printer toner cartridges which are sold to local businesses. Annual demand is 20,000 units and each cartridge costs the store $25. It costs $30 to place an order and the inventory carrying cost rate is 25% of the value of the item. The following spreadsheet has been set up to solve the problem. What constraint would you impose on this problem to ensure that at least one order is placed per year?

• A) MAX B9
• B) B9 = 1
• C) B9 ≥ 1
• D) MIN B11