Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Widget Division factory purchases 2 5 , 0 0 0 couplers per year for use in its widget manufacturing process. The Director of Purchasing
The Widget Division factory purchases couplers per year for use in its widget manufacturing process. The Director of Purchasing has determined that it costs $in personnel and computer time for the company to process an order to purchase couplers. It costs the company $ per year to carry a coupler in inventory including space allocation, breakage, theft, insurance As the new Assistant to the Director of Purchasing, your job is to calculate how many couplers should be ordered each time. If you order couplers at a time, orders will be arriving almost daily so you will have low carrying costs but you will have to pay for processing the purchases in the year. If you order couplers at a time, you will have low purchase costs but very high inventory carrying costs. The Economic Order Quantity EOQ is the amount that should be ordered each time to minimize the total order plus carry cost The EOQ is calculated by DOC where D is the annual demand, O is the cost to process an order, and C is the annual carrying cost for a unit in inventory. a Create a worksheet for determining the Economic Order Quantity. Your worksheet should work for any quantities entered. Note that the square root of a quantity can be calculated by raising the quantity to the power. How many couplers should be purchased at a time?
Step by Step Solution
★★★★★
3.43 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
To solve this problem we can use the Economic Order Quantity EOQ formula to determine the optimal or...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started