Question

The INDY Industrial Supply Company has finished a highly-sophisticated project where they separately determined order setup...

The INDY Industrial Supply Company has finished a highly-sophisticated project where they separately determined order setup (S) costs for each of their main suppliers, based on the specific ordering process for that supplier. They have determined that the ACME Supplier, from which they order six different SKUs, the setup cost for an order (which has been highly automated) to be $32.50 per order, with an additional cost of $3.25 for each line on the order. Annual demand data and cost per unit for six SKUs is provided below; assume an annual inventory holding rate of 17%.

SKU D Cost/unit

SKU1 500 $25

SKU2 900 $20

SKU3 . 600 . $28

SKU4 450 . $23

SKU5 700 $33

SKU6 200 $19

The optimal number of orders per year from this supplier is (to two decimals): _____________

The amount of SKU3 that will be ordered each time (round to nearest integer): ______________

The EOQ for SKU3, if ordered on its own, would be (round to nearest integer): _______________. Note - use the major setup cost plus the setup cost for one line when finding the EOQ of an individual item. Also, your answer should make sense (i.e. you should think about whether you think the optimal order quantity for one SKU ordered alone should be higher or lower than the optimal order quantity for that SKU when it is combined with other SKUs on an order.)

Homework Answers

Answer #1
Common Fixed cost (S) = $32.50
Item (j) Demand (Dj) Unit cost
(Cj)
Unit carrying cost
(Hj = 17% x Cj)
Individual ordering cost (Sj)
SKU 1 500 $25.0 $4.25 $3.25
SKU 2 900 $20.0 $3.40 $3.25
SKU 3 600 $28.0 $4.76 $3.25
SKU 4 450 $23.0 $3.91 $3.25
SKU 5 700 $33.0 $5.61 $3.25
SKU 6 200 $19.0 $3.23 $3.25

For combined ordering,

Number of order placed, N* = [Σj Dj.Hj / {2.(S + Σj Sj)}]1/2

Σj Dj.Hj = 500*4.35 + 900*3.4 + 600*4.76 + 450*3.91 + 700*5.61 + 200*3.23 = 14423.5
Σj Sj = 6*3.25 = 19.5

So, N* = sqrt(14423.5 / (2*(32.5+19.5))) = 11.76

The optimal number of orders per year from this supplier is (to two decimals): 11.76

The amount of SKU3 that will be ordered each time (round to nearest integer) = Q3* = D3 / N* = 600 / 11.76 = 51

For individual ordering,

The EOQ for SKU3 = Q3 = (2.D3.(S+S3) / H3)1/2 = sqrt(2*600*(32.5+3.25) / 4.76) = 95

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Demand for carpet at a carpet wholesaler stays constant at 10,000 sq. ft. per month. The...
Demand for carpet at a carpet wholesaler stays constant at 10,000 sq. ft. per month. The wholesaler incurs a fixed transportation cost of $100 each time an order is placed and delivered. The carpet costs $3 per sq. ft. and the wholesaler has an annual holding cost rate (per sq. ft.) that is 20% of the unit purchase cost. What should the optimal order size (or EOQ) be? Note that the carpet can be ordered in any size, so there...
A jewelry firm buys semiprecious stones to make bracelets and rings. The supplier quotes a price...
A jewelry firm buys semiprecious stones to make bracelets and rings. The supplier quotes a price of $8 per stone for quantities of 600 stones or more, $9 per stone for orders of 400 to 599 stones, and $10 per stone for lesser quantities. The jewelry firm operates 200 days per year. Usage rate is 25 stones per day, and ordering costs are $48. a. If carrying costs are $2 per year for each stone, find the order quantity that...
Operations Management: Supply and Ordering question BACKGROUND UPD Manufacturing produces a range of healthcare appliance for...
Operations Management: Supply and Ordering question BACKGROUND UPD Manufacturing produces a range of healthcare appliance for hospital as well as for home use. The company has experienced a steady demand for its products, which are highly regarded in the healthcare field. Recently the company has undertaken a review of its inventory ordering procedures as part of a larger effort to reduce costs. One of the company’s products is a blood pressure testing kit. UPD manufactures all of the components for...
Problem 1 - Better Life Pharmacies /////////////////////////////////////////// Part 1: Optimal order quantity Joshua is running a...
Problem 1 - Better Life Pharmacies /////////////////////////////////////////// Part 1: Optimal order quantity Joshua is running a pharmacy in Nigeria (where Naira is the local currency). His recent experience in the MicroMasters course motivated him to rethink how to reorder pharmaceuticals to replenish inventory. He recalls from Module 4, Unit 1, Video 5, that he should consider the purchase cost, the order cost, and the holding cost. In the past, Joshua rigorously tracked these cost items. For Ibuprofen he knows that:...
Sportswear company O'yeah designs and sells wetsuits to the U.S. market. The designs of the wetsuits...
Sportswear company O'yeah designs and sells wetsuits to the U.S. market. The designs of the wetsuits are updated each year. The process for updating the design typically starts in January the year before the designs are to be released. At this time, the purchasing, design, and sales departments have a two-day meeting to discuss the product portfolio for the upcoming year, including design, functionality, and price. In March, the designs are finalized, and the purchasing department starts negotiating with suppliers...
Please read the following case of UPD Manufacturing and write the required report. UPD Manufacturing produces...
Please read the following case of UPD Manufacturing and write the required report. UPD Manufacturing produces a range of healthcare appliance for hospital as well as for home use. The company has experienced a steady demand for its products, which are highly regarded in the healthcare field. Recently the company has undertaken a review of its inventory ordering procedures as part of a larger effort to reduce costs. One of the company’s products is a blood pressure testing kit. UPD...
Inventory Management 1. Ayo is the Purchasing Officer for a company that assembles desktop computers. The...
Inventory Management 1. Ayo is the Purchasing Officer for a company that assembles desktop computers. The computers come with 4 to 6 USB ports. The annual demand for the computers is 600 units. The cost of each computer is $1700, and the inventory carrying cost is estimated to be 10% of the cost of each computer. Ayo has made a study of the costs involved in placing an order and has concluded that the average ordering cost is $50.00 per...
EOQ, Safety Stock, Lead Time, Batch Size, and JIT Bateman Company produces helmets for drivers of...
EOQ, Safety Stock, Lead Time, Batch Size, and JIT Bateman Company produces helmets for drivers of motorcycles. Helmets are produced in batches according to model and size. Although the setup and production time vary for each model, the smallest lead time is six days. The most popular model, Model HA2, takes two days for setup, and the production rate is 750 units per day. The expected annual demand for the model is 36,000 units. Demand for the model, however, can...
Case 5.1 EuroWatch Company assembles expensive wristwatches and then sells them to retailers throughout Europe. The...
Case 5.1 EuroWatch Company assembles expensive wristwatches and then sells them to retailers throughout Europe. The watches are assembled at a plant with two assembly lines. These lines are intended to be identical, but line 1 uses somewhat older equipment than line 2 and is typically less reliable. Historical data have shown that each watch coming off line 1, independently of the others, is free of defects with probability 0.98. The similar probability for line 2 is 0.99. Each line...
Assessment Module 9 – Marginal Analysis Please create a tab in your Excel Workbook and name...
Assessment Module 9 – Marginal Analysis Please create a tab in your Excel Workbook and name it “Module 9 Marginal Analysis.” You have same basic templates in your Resources workbook, but you may need to modify these to fit the individual business problem. I am evaluating your professional ability to do so, and to create professional models and reports, so take your time, think through a logical, clear, well-structured, well-formatted model. Remember, assumption tables (like T-accounts) are your friends! Be...