Can any one pls solve the math related to supply chain management?

Given the following information, compute the economic order quantity, annual holding cost, annual ordering cost and annual total cost.

1. Annual requirements(R) = 50000 units
2. Set up cost(S) = $ 150 per order
3. Holding rate(k) = 15 percent
4. Unit cost(C) = $100 per unit

Here it is mate ... the answer is economic order qtty= 1000
Here is the detail (copy paste it in excel, A1 is 50000, A5 is the economic lot size, the rest is logical)

50000 1. Annual requirements庐
150 2. Set up cost(S)
0,15 3. Holding rate(k)
100 4. Unit cost(C)
1000 order qtty(units)
=A5/2 avg stock in the year(units)
=A6*A3*A4 holding cost per year($)
=A1/A5 number of orders per year
=A8*A2 ordering cost per year($)
=A9+A7 TOTAL COST($)

Tags

　　Business Software 　　Online Business 　　Internet Business 　　E-Business 　　E-Commerce 　　Supply Chain 　　Data Mining 　　ERP 　　CRM 　　Application Development 　　Software Consulting 　　Software Development

Related information

Work permit in the US ?

IT WILL BE VERY HARD , NURSES,SOFTWARE ENGINEERING,OIL ENGINEERING,PLASTIC ENGINEERING,AND P.H.D IN SCIENCE ARE MORE NEEDED IN USA , AND THEY WILL GET MOST OF THE SPONSOR VISA. YOUR FILED I...

Any constructive advice? ?

safety related to your job,listen and don screw the chance.

...

How do I install an electric light switch?

If you're asking what to do with wires after you cut them, DON'T CUT THEM. CALL AN ELECTRICIAN!

...

Where can I find eco-friendly office/school supplies?

I was looking for eco friendly school supplies in May for my sons Earth Club. I went to the 3 major office supply stores in my area, Office Max, Office Depot, and Staples. I also checked Target and...

Where do I learn oracle R 12 in Pune?

at home, you need a private tutor. But that's going to cost a fortune. Try getting the user guides and study them. or attend a week at oracle university.

...

Can anyone think of a food web/chain that goes full circle & includes humans?

grass>cricket>rabbit>human>decomposers in the soil>grass You could get more complex by including something between the rabbit and the human if you wanted to, but this would work. ...

Do I use the word "speardhead" correctly in this sentence?

Try this: "Group Supply Chain Management (SCM), a spearhead of the company in interacting with contractors, was appointed as an implementer in the application of CHESM process."

...

Help me on these questions please!!!?

Among the populations of any natural community, the basic food supply is always a critical factor because it is 3) a means of transferring energy An earthworm lives and reproduces in the ...