Skip to content

Ask the Tutor ACCA FM

EOQ

CCarl2y ago
A company currently places 40 orders of inventory per year, ordering 2,000 units each time, but is to change to an ordering system based on the economic order quantity (EOQ) model. Its ordering costs are $75 per order. Units cost $8 each and the company’s cost of finance is 10% per annum. Other costs of holding inventory amount to $0.70 per unit. Calculate the quantity that would be ordered using the EOQ model: 1,549 units 2,000 units 2,828 units 4,140 units Should we include finance costs when calculating holding costs for EOQ or no?
IAW3005IAW3005Tutor2y ago#1
Regarding the finance costs, the formula for EOQ does not explicitly include finance costs. However, finance costs can be considered as part of the holding cost per unit if they are CLEARLY related to the cost of holding inventory. In this case, if the finance costs are CLEARLY & directly related to the inventory holding, they can be included in the calculation of the holding cost per unit. Only do if clearly identified....... If it says something along the lines that the cost of tying up money in inventory, could have been used to earn interest or could result in interest expenses - say if the company is overdrawn. Why? Including finance costs in the holding costs for a company could provide a more accurate reflection of the total cost of holding inventory. However, it is important to note that the decision to include finance costs ultimately depends on the specific context and requirements of the question.
CCarl2y ago#2
Sir, how is (2 x 80,000 x $75) / $0.70)^0.5 = 2828? Isn't it 4140? Also, in Dusty co, holding costs did not include finance costs when calculating EOQ So which approach should we follow in the exam?
CCarl2y ago#3
I just checked the answer and its 2828 and they included the finance costs by taking (purchase price 8 *10%=0.8) therefore total holding costs = $1.5. This question was from the Pre Dec 2021 mock exam. Now I'm really confused!
IAW3005IAW3005Tutor2y ago#4
So sorry your confused Well let’s see Annual demand (D) = 40 orders x 2,000 units per order = 80,000 units Ordering cost per order (Co) = $75 Holding cost per unit (Ch) = $0.70 +$ 0.8 ( 10% * 8) Plugging these values into the formula: EOQ = ((2 x 80,000 x $75) / ($0.70 + $0.80) EOQ = 2,828 units So in answer to your question this one did include it!! This proves that if it’s in the question it means include it! I am very tired I must apologise If I have confused you
CCarl2y ago#5
Great thanks a lot! Just want to know why dusty co excluded finance costs when calculating EOQ...the inconsistency is what is confusing me :(
IAW3005IAW3005Tutor2y ago#6
The question asks for the current cost and then eoq The thing is when you have eoq you are saving on inventory Annual holding and ordering costs of the current inventory management system Each current order is 1,500,000/12 = 125,000 units per order Average inventory = 125,000/2 = 62,500 units Current holding cost = 62,500 x 0·21 = $13,125 per year Current ordering cost = 12 x 252 = $3,024 per year Current total inventory management cost = $13,125 + $3,024 = $16,149 per year Financial effect of adopting EOQ model EOQ = (2 x 252 x 1,500,000/0·21)0·5 = 60,000 units/order Number of orders = 1,500,000/60,000 = 25 orders per year Average inventory = 60,000/2 = 30,000 units Holding cost = 30,000 x 0·21 = $6,300 per year Ordering cost = 25 x 252 = $6,300 per year EOQ total inventory management cost = $6,300 + $6,300 = $12,600 per year Then you compare the two Reduction in total inventory management cost = $16,149 – $12,600 = $3,549 per year So what does that do for your business? Reduction in average inventory So you don’t buy as much inventory = (62,500 – 30,000) x $14 pu = $455,000 The overdraft will decrease by the same amount. Finance cost saving = 455,000 x 0·03 = $13,650 per year Overall saving = $3,549 + $13,650 = $17,199 This is like what I was referring to Do you understand My advice is don’t worry about it anymore If in the exam it isn’t clear in a written question State your assumptions It will be marked as OFR which means you only loose the marks for that small part move on……. Everything else is marked Own Figure Rule
CCarl2y ago#7
If I calculated EOQ using holding costs of $0.63 (0.21+(14*0.03)) would that be fine?
Sign into reply to this topic.