How would adding additional reorder points change the annual cost?
Global manufacturing and services require the ordering, transportation and logistical activities to provide adequate inventories to meet customer demand. One of the programming tools in the MBA’s Management Science toolbox is the Economic Order Quantity or EOQ model. The EOQ model in an Excel based formula template can solve for least cost, ordering costs, maximum inventory levels, reorder points and number of reorders per year, just to name a few.
In this assignment, you will use the Excel data analysis tool known as EOQ Solver. Read the example in Chapter 10 on The Bub Beer EOQ Inventory Model Problem. The Excel setup for this problem is embedded herePreview the document. There is no need to set up anything! The embedded excel sheet in this assignment has all the formulas included. You need only plug in the different values called out below to solve this EOQ problem!
Given the following, assume the following data is used:
Annual demand = 200000
Ordering cost = 45
Annual Inventory holding rate = 25
Cost per unit = 10
Working days per year = 365
Lead-time = 7 days
Answer the following questions:
What is the EOQ?
What is the annual inventory holding cost?
What is the annual ordering cost?
What is the total annual cost?
What is the maximum inventory level?
What is the average inventory level?
What is the reorder points?
What is the number of reorders per year?
What is the cycle time in days?
How would adding additional reorder points change the annual cost? What implications does this have for the business?
Provide a brief narrative on your EOQ analyses and describe the importance of the use of this tool for business and industry. Insert this narrative as a text box in the excel file.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
