ECR--Calculate the major control level?
yunfei
Registered Posts: 9 New contributor 🐸
Hi,all,
need help at this exercise,
Given situation:
average usage: 100 units /day
minimum usage: 60 units /day
maximum usage: 130 units /day
Lead time: 20-26 days
E.O.Q.: 400 units
you are require to Calculate: re-order level
maximum level
minimum level
need help at this exercise,
Given situation:
average usage: 100 units /day
minimum usage: 60 units /day
maximum usage: 130 units /day
Lead time: 20-26 days
E.O.Q.: 400 units
you are require to Calculate: re-order level
maximum level
minimum level
0
Comments
-
Hi
Re-order Level = Max usage x max lead time
= 130 x 26
= 3,380
Minimum Stk level = re-order level - ( avg usage x avg lead time)
= 3,380 - (100 x 20+26/2)
= 1,080
Max stk level = re-order level + re-order quantity( EOQ) - ( min usage x min lead time)
= 3,380 + 400 - (60 x 20)
= 2,5800 -
Hi, Spring Flower,Thank u very much!
At the 1st calculation for re-order level, i even was stucking there by the formula told us:
Re-order level= (Max usage X Max lead time) + Mini level
i was looking for to find out the Mini level, but from your answer, Is that means we can omit that --(Mini level) when the situation not given to us?0 -
Hello,:001_smile:
Re-order Level = Max usage x Max lead time + Reserve Stock(i.e given in your question,oftenly says additional stock also).
In your case, No additional stock mentioned.
Also,as far as I know there is nothing to do with mini level while you calculating re-order level. Still i would recommand that double check with your tutor.0 -
Thanks spring flower, i will see my tutor this saturday, after that i will come back to you with the answers.
And sorry for the error of the EOQ should be 4000 units.
How are you doing now? Are you still continue your study? I just take a look of your another early thread. I am studing PLB,ECR and FRA now, i hope i can pass them this June. Hope you also can done your study successfully.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 322 NEW! Qualifications 2022
- 159 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 93 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 274 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 201 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership