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
Q18: Which point or points are global optima
Q20: Which point or points are local optima
Q21:
The following questions pertain to the problem
Q21: A company wants to locate a new
Q24: An investor is developing a portfolio of
Q25: An office supply company is attempting
Q26: In a maximization problem, the GRG algorithm's
Q26: A company wants to locate a new
Q27: An office supply company is attempting
Q28: A company has collected the following
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents