Question: I need help with figuring our the data that goes into yellow highlighted areas on this supply chain project. 4. Calculate the (EOQ) Economic Order

I need help with figuring our the data that goes into yellow highlighted areas on this supply chain project.

I need help with figuring our the data that goes

4. Calculate the (EOQ) Economic Order Quantity for each item. 5. Calculate the number of orders the company would need to place annually based on the EOQ that you calculated and the item's annual unit demand. 6. HINT: Formula: Average Daily Demand X # of days in a year = Annual Demand in units 7. HINT: Refer to the EOQ Formula in the textbook page # 138 Annual Demand in Annual Demand Economic Order Orders (EOQ) # of EOQ Average Daily Model Item # (Units) Demand Replenishment Purchase Cost Re-Order Cost/ Cycles (days) per Unit Order Inventory Carrying Cost units (use 360 days/year) in Dollars Quantity per Year EOQ DD RC 1 B D A A-001 B-002 C-003 D-004 D-005 30 210 300 5 1,200 5$ 215 30 S 150 ls 90 $ 10.00 $ 2.00 $ 6.00 $ 2,000.00 $ 0.25$ 5.00 5.00 5.00 75.00 5.00 20% 20% 20% 20% 20% Problem # 2: Using the data from Problem #1 Create an Excel Spreadsheet as illustrated below and then calculate the Annual demand in units, annual demand in dollars, the (EOQ) Economic Order Quantity in units and the number of orders per year required for each item below when there are changes with the re-order cost per order, Inventory carrying cost and / or Purchase cost for an item. Requirements for this Problem: 1. Create a Spreadsheet like the table below. 2. Calculate the new values for the Annual unit demand, Annual dollar demand, EOQ, Annual number of orders based on the changes listed for each item below 3. Calculate the percent change in the EOQ and the annual number of orders compared to the results in Problem 1. 4. Does the EOQ increase, decrease or stay the same? If so by what percent? 5. Does the Order frequency (the numbers of orders per year) increase, decrease or stay the same? If so by what percent? Item A-001: If carry cost increase to 30% what is the new EOQ & how many orders will need to be placed each year. Does EOQ & Order frequency increases or decrease compared to the situation in problem #? What is the percent of change? Item B-002: If carry cost decrease to 10% and Re-Order cost/order increases to $5.50 what is the new EOQ & how many orders will need to be placed each year. Does EOQ & Order frequency increases or decrease compared to the situation in problem #? What is the percent of change? Item C-003: If Re-Order cost/order increases to $6.00 what is the new EOQ & how many orders will need to be placed each year. Does EOQ & Order frequency increases or decrease compared to the situation in problem #1? What is the percent of change? Item D-004: If Purchase cost for the item increase to $2100 and Re-Order cost/order decreases to $50 what is the new EOQ & how many orders will need to be placed each year. Does EOQ & Order frequency increases or decrease compared to the situation in problem #1? What is the percent of change

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!