Inventory Management and EOQ MADE EASY | ACCA paper FM / F9

Inventory Management and EOQ MADE EASY | ACCA paper FM / F9 | Question Dusty

Рет қаралды 10,134

Steve Willis ACCA

Күн бұрын

Пікірлер: 50

@fayfaygirlly Жыл бұрын

Thank you Steve. Your videos helped me with PM, FM and now FR. ❤️

@SteveWillisACCA Жыл бұрын

Excellent! Glad they helped. And good luck next week!

@shraddhayadav300 15 күн бұрын

one heck of a sum!

@dureshahwar708 4 жыл бұрын

Unfortunately I saw all your videos just before few days😭😭😭😭..... I wish I saw them 3 month ago but still its helpful for me

@SteveWillisACCA 4 жыл бұрын

Glad they helped :)

@pallavisuradkar8564 4 жыл бұрын

Thank you ! Pl. give some guidance for Qs like Pangli March/June 2017

@SteveWillisACCA 4 жыл бұрын

I'll add the one soon.

@pallavisuradkar8564 4 жыл бұрын

@@SteveWillisACCA Thank you for Uploading requested question with solution !

@krish9663 Ай бұрын

Silly question but why do we calculate a finance cost saving for reduction in inventory?

@SteveWillisACCA Ай бұрын

Assuming no cash and not payables, inventory is funded by an overdraft, reduce inventory and we reduce the overdraft.

@krish9663 Ай бұрын

@SteveWillisACCA so essentially the reduction in average inventory means you're spending less on stock, which here means less of the overdraft is used, thus less interest is paid (aka a saving). That makes a lot of sense! I need to improve my reading skills fast. Thank you so much!

@pallavisuradkar8564 4 жыл бұрын

For Eoq we can use =SQRT(2*252*1500000/0.21)

@SteveWillisACCA 4 жыл бұрын

That's also a fine way to do it, Pallavi :)

@pallavisuradkar8564 4 жыл бұрын

Thank you Steve !

@saintsinner6689 3 жыл бұрын

Hi, really finds this helpful as it has widen my knowledge in inv.mgt. Please I will be sitting for FR and FM for a start. Hope the combination is cool cos I find those two kind of onter related. Thanks

@SteveWillisACCA 3 жыл бұрын

Best of luck! I agree they are intertwined.

@Champingcom 3 жыл бұрын

Very helpful and exam oriented.

@SteveWillisACCA 3 жыл бұрын

Keep watching

@mithunbabu1544 3 жыл бұрын

Superb sir very helpful 🤗 good job

@SteveWillisACCA 3 жыл бұрын

Good luck this week!

@drewski5150 Жыл бұрын

Hey Steve, how did you copy and paste the data while keeping the cell references?

@SteveWillisACCA Жыл бұрын

Use "$" in front of the row or column. $A1 will keep column A locked in when you copy paste. Give it a try, it works the same in Excel.

@amritavijayan8984 4 жыл бұрын

Thanks Love from Kerala☺️

@SteveWillisACCA 4 жыл бұрын

My pleasure 😊

@yusufhusseinmohamed9903 3 жыл бұрын

thanks sir for good fashionable presentation

@SteveWillisACCA 3 жыл бұрын

Most welcome :)

@MishalAbdulJaleel 6 ай бұрын

Hii steve why dont you take the finance cost associated with the holding cost (opportunity cost)??

@SteveWillisACCA 6 ай бұрын

Hi there, you are correct. If there is no cash, then the inventory is funded from the short-term finance. Could be payables or overdraft. For the exam if they state that finance costs are part of holding costs, then include it 100%. If they don't mention that, the model answer usually excludes that--either way it is only going be 1/2 of a mark or so, so do what seems correct based on the past papers you've tried and keep moving! Good luck tomorrow.

@suraqaar2871 Жыл бұрын

hi is the saving on the finance cost due to the average inventory always added ? because i did a question related to eoq and in the answer it was not added

@SteveWillisACCA Жыл бұрын

Hi, when they give you the info about short-term finance costs, best to use it in your answer. In section C, if you left it out, it would only be 1 or maybe 2 marks.

@suraqaar2871 Жыл бұрын

@@SteveWillisACCA Ok thanks

@SAIFULISLAM-dn1is 2 жыл бұрын

Why purchasing cost is not considered In this question?

@SteveWillisACCA 2 жыл бұрын

That's an excellent question. Yes, purchasing costs are a cost of inventory. But if we are making a decision and there is no discount offered by the supplier, the purchase cost is not incremental--think of it as a fixed cost for this decision.

@SteveWillisACCA 2 жыл бұрын

If they add another complication to problem, 'the supplier will give a 10% discount if the company changes the order quantity...' then we would include it

@darshghia 6 ай бұрын

@@SteveWillisACCA But wasn't there a bulk order discount of 0.5%? If the company would instead order 250000 units? So why didn't we use the purchase costs? Also, other questions dont use this decrease in avg inventory, so what is the reason for using it here?

@benwhite8371 Жыл бұрын

Hi Steve, thanks for this - a question on intuition for financing costs for inventory. We have an overdraft with which we purchase stock to hold in our inventory. Moving from our original average inventory of 62,500 down to our new average inventory of 30,000 doesn't reduce the number of units of components we need to buy - only how many components we hold on average, right? Since we're still purchasing the same amount of components (D = 1.5m units) - shouldn't our financing costs be the same? We're still using the overdraft to pay for the purchase price over our demand for components, not our average inventory. I understand financing with respect to falling AP days, since we need cash in order to reduce our AP days, and therefore (if we're in overdraft / have no cash) we require the use of overdraft to finance the reduction, but I'm failing to grasp the intuition with respect to reduction / increases in inventory.

@SteveWillisACCA Жыл бұрын

Hi, inventory and cash are assets. All things being equal, if Inventory goes down, cash goes up. If you hypothetically go the the supermarket and buy all the food you'll eat in a year (stick it in a giant freezer (not counting the electricity costs :) ) You'll need a lot of cash on hand. If you didn't have cash, you'd owe the supermarket a lot of money. Back to the inventory, If I had magical just-in-time and sold the goods the same day I received them, I would only need enough cash in advance to buy one-day's worth of goods. Think of a supermarket--they pay their suppliers maybe 60 days (if they are big corporate supermarkets) but only hold the inventory 2 weeks--so they have the opposite problem, treasury management of the spare cash. So assuming constant consumption of inventory, the more you buy in advance, the less cash you have sitting around.

@vaishnavisurnam5719 8 ай бұрын

Hi Steve, Thank you for the explanation. I have a question. why do we multiply our reduction in average inventory by the purchase price? Is it because the purchase price is based on the purchase of inventory from suppliers and therefore finance cost is calculated based on that? Please enlighten me :)

@SteveWillisACCA 6 ай бұрын

Good question! Yes, inventory valuation is based on its cost.

@PrashantPatil-gm6vx 3 жыл бұрын

NPV calculation sir how to do in excel and how to use dollar sign in formats sir ..

@SteveWillisACCA 3 жыл бұрын

Hi Prashant, don't worry about formatting your cell with a currency sign. This would be a poor use of your time in the exam. Just tell the marker what you are doing in an adjacent cell as a label.

@bvboys6097 4 ай бұрын

Hi, Sir thank you for debriefing this question. Really helpful Sir. For EOQ i was wondering why can't we multiply the savings of 3549 by .03 to get the savings related to finance cost and add the 3549 with that figure to get the total savings. I am not able to find the logic. Can you please help me on this Sir

@PrashantPatil-gm6vx 3 жыл бұрын

Thank you sir 😊

@SteveWillisACCA 3 жыл бұрын

My pleasure, Prashant, good luck on you upcoming exam!!!

@PrashantPatil-gm6vx 3 жыл бұрын

I am sitting exam for this June session sir .. Actually i spent lot of times doing section C in examination In previous attempts I couldn't clear the exam sir ..this time I am trying by best sir . Thank you for your concern sir it's really helpful me a lot ...