CBE Section-c ( correct way to do in Excel)

This topic has 6 replies, 3 voices, and was last updated 6 years ago by litsa2013.

Viewing 7 posts - 1 through 7 (of 7 total)

Author
Posts
August 2, 2018 at 10:47 pm #465910
nuri1
Participant
- Topics: 1
- Replies: 3
Hi
Could anybody please show me how to calculate EOQ in excel ?
EOQ=(2*ordering cost*demand per year)/Holding cost per unit
=(2*400*160000)/5.5
I don’t know how to write root over.
please help me
August 2, 2018 at 11:09 pm #465911
nuri1
Participant
- Topics: 1
- Replies: 3
EOQ={(2*400*160000)/5.12}^0.5
=5000 units
Is it correct format?
August 2, 2018 at 11:16 pm #465913
nuri1
Participant
- Topics: 1
- Replies: 3
Total ordering cost= $400 x 10=$4000
Or
Total ordering cost=$400*10=$4000
which method is correct please?
August 18, 2018 at 6:02 pm #468403
litsa2013
Member
- Topics: 3
- Replies: 5
can we write in the excel the numbers and then calculate in our calculator and only put the result in the paper? or we must put a formulas in the excel?
August 24, 2018 at 10:15 am #469224
misbahkiran
Participant
- Topics: 109
- Replies: 194
there is a formula for this = (sqrt,x)
x is the value for which u need to take root.
u can do CBE online and find excel formula in sample CBE.
and we need to completely do working in excels and linked figures with workings that what i saw in the videos.
September 3, 2018 at 8:27 pm #471126
litsa2013
Member
- Topics: 3
- Replies: 5
Hello
How we put in the excel this sympol {
September 4, 2018 at 6:02 pm #471384
litsa2013
Member
- Topics: 3
- Replies: 5
Hello Sir
If we want to write in the excel the below is correct?
56*(1+g)^3=60
1+g=60/56 ^(1/3)
g=1.0714^(1/3)-1
g=0.023
Author
Posts

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.

20% off ACCA & CIMA Books