Answered step by step
Verified Expert Solution
Link Copied!

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 25,000 couplers per year for use in its widget manufacturing process. The Director of Purchasing has determined that it costs $20.00(in personnel and computer time) for the company to process an order to purchase couplers. It costs the company $4.00 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 100 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 250 purchases in the year. If you order 100,000 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 (2DO/C) 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 0.5 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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Engineering Economics

Authors: Chan S. Park

5th edition

136118488, 978-8120342095, 8120342097, 978-0136118480

More Books

Students also viewed these Accounting questions