Forecasting problem using Excel Modules add in
Not what you're looking for?
Uses Excel Modules Addin to solve. Add in is attached
12-16 Barbara Bright is the purchasing agent for West Valve Company. West Valve sells industrial valves and fluid control devices. One of the most popular valves is the Western, which has an annual demand of 4,000 units. The cost of each valve is $90, and the inventory carrying cost is estimated to be 10% of the cost of each valve. Barbara has made a study of the costs involved in placing an order for any of the valves that West Valve stocks, and she has concluded that the average ordering cost is $25 per order. Furthermore, it takes about two weeks for an order to arrive from the supplier, and during this time the demand per week for West valves is approximately 80. Compute the EOQ, ROP, optimal number of orders per year, and total annual cost for Western valves.
Purchase this Solution
Solution Summary
This posting contains solution to following forecasting problem using Excel modules.
Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Probability Quiz
Some questions on probability
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.