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 formula goes in cell B11 in this problem?
A) =B3*B7+B9/B3*B6+B9*2+B5*B7
B) =B3*B5+B3/B9*B6+B9/2*B5*B7
C) =SQRT(B3*B5+B3/B9*B6+B9/2*B5*B7)
D) =B3*B3+B3/B9+B6*B9/2*B5*B7
Correct Answer:

Verified
Correct Answer:
Verified
Q1: The main difference between shadow prices and
Q2: Exhibit 8.2<br>The following questions pertain to the
Q3: In solving the NLP problem, Solver produced
Q4: Exhibit 8.2<br>The following questions pertain to the
Q6: An investor is developing a portfolio of
Q7: A company wants to locate a new
Q8: What is the straight line (Euclidean) distance
Q9: The Lagrange multipliers can be used to<br>A)
Q10: A company wants to locate a new
Q11: A NLP problem can have nonlinear objective