Question: Which one is the right excel function for total annual cost of inventory (R= Annual Demand, S = Inventory carrying cost per unit, A= Order

Which one is the right excel function for total annual cost of inventory (R= Annual Demand, S = Inventory carrying cost per unit, A= Order Cost, V = Unit Value, W= Inventory Carrying Cost Rate) O =(Q'S)/2 + (R/Q)'A =(Q*S)/2 =(R/Q)'A =(QS)/2 + (R/Q2
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
