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 here download. 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.
Unit 3 Assignment 1Unit 3 Assignment 1CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeContentAll requirements of the assignment are met. Calculations for each of the 9 questions are correct.70 ptsFull Marks0 ptsNo Marks70 pts
This criterion is linked to a Learning OutcomeJustificationExplains how reorder points affect annual costs. Narrative content demonstrates sufficient elaboration and explanation of calculations.20 ptsFull Marks0 ptsNo Marks20 pts
This criterion is linked to a Learning OutcomeMechanicsFile is organized and has a logical sequence.10 ptsFull Marks0 ptsNo Marks10 pts
Total Points: 100