Examlex

Solved

An Office Supply Company Is Attempting to Determine the Order

question 5

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? 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


Definitions:

Skilled Laborers

Workers who have specialized training, certifications, or expertise in specific fields, enabling them to perform complex tasks and often command higher wages.

Good Wages

Compensation for employment that is considered sufficient to live on and possibly support a family, often associated with fair or above-average pay.

Charlotte Perkins Gilman

An American feminist, sociologist, and writer of the late 19th and early 20th centuries, known for her advocacy for women's rights and her seminal work, "The Yellow Wallpaper."

Related Questions