Concept explainers
a)
To determine: The optimal order quantity with the minimum annual cost for purchasing the integrated chips.
Introduction:
Quantity discount model:
Quantity discount model is a scenario where manufacturing companies receive price discount for ordering large quantities. The firm will estimate if the discount quantity is profitable for the firm and make the decision.
Economic order quantity (EOQ):
EOQ is the quantity of units a company must add to its inventory so as to minimize the total inventory costs. It will determine the ideal order quantity which will decrease the inventory management costs.
Annual holding cost:
Annual holding cost is the cost involved in holding the excess inventory present within a firm. The excess inventory will be carried on for the next year and used for production.
Annual ordering cost:
Annual ordering cost is the cost involved in making a purchase order and the following up of that order. It will account for the labor involved and other associated costs.
Purchase cost:
Purchase cost is the cost incurred to purchase the require components to satisfy the demand of the firm. The cost will vary according to the demand.
Total cost:
Total cost is the overall cost taking into estimation of the holding, ordering and the purchase cost of the materials.
a)
Answer to Problem 22P
The optimal order quantity is 200 units with the minimum annual cost of $1,446,380
Explanation of Solution
Given information:
Monthly demand (d)= 400 / month
Holding cost (H) = $35 / unit / year
Ordering cost (S) = $120 / order
Purchase price (P) = $350 / chip
Price structure:
Quantity purchased | Price / unit |
1 – 99 units | $350 |
100 – 199 units | $325 |
200 or more units | $300 |
Formula to calculate EOQ:
Formula to calculate annual holding cost:
Formula to calculate annual ordering cost:
Formula to calculate purchase cost:
Formula to calculate total cost:
Calculation of EOQ:
The obtained EOQ value is in the range of (100 – 199 units). Hence, the price of that range will be used for calculation.
Calculation of values at (EOQ = 181):
Calculation of annual holding cost at (EOQ = 181):
Calculation of annual ordering cost at (EOQ = 181):
Calculation of purchase cost:
Calculation of total cost at (EOQ = 181):
The total cost at the (EOQ = 181) is $1,566,350.
Calculation of values at discount quantity (200):
The next price break after the EOQ at 181 units is (200 or more units). The price of that range will be used in the following calculation.
Calculation of annual holding cost at (EOQ = 200):
Calculation of annual ordering cost at (EOQ = 200):
Calculation of purchase cost:
Calculation of total cost at (EOQ = 200):
The total cost at the (EOQ = 200) is $1,446,380
Calculation of difference in cost:
The total cost at (EOQ = 181) is $1,566,350. The total cost at (EOQ = 200) is $1,446,380. Therefore (EOQ = 200) has lesser cost ($1,446,380 < 1,566,350).
Hence, the optimal order quantity is 200 units with the minimum annual cost of $1,446,380
b)
To determine: The optimal order quantity with the minimum annual cost for purchasing the integrated chips.
b)
Answer to Problem 22P
The optimal order quantity is 200 units with the minimum annual cost of $1,445,880
Explanation of Solution
Given information:
Monthly demand (d)= 400 / month
Holding cost (H) = 10 % of purchase price of the price structure
Ordering cost (S) = $120 / order
Purchase price (P) = $350 / chip
Price structure:
Quantity purchased | Price / unit |
1 – 99 units | $350 |
100 – 199 units | $325 |
200 or more units | $300 |
Formula to calculate EOQ:
Formula to calculate annual holding cost:
Formula to calculate annual ordering cost:
Formula to calculate purchase cost:
Formula to calculate total cost:
Calculation of EOQ at each price structure:
EOQ at price = $350
EOQ at price = $325
EOQ at price = $300
EOQ = 181, cannot be bought at the price of $350. EOQ = 196 cannot be bought at the price of $300.
Hence, the EOQ is 188 units.
The obtained EOQ value is in the range of (100 – 199 units). Hence, the price of that range will be used for calculation.
Calculation of values at (EOQ = 188):
Calculation of annual holding cost at (EOQ = 188):
Calculation of annual ordering cost at (EOQ = 188):
Calculation of purchase cost:
Calculation of total cost at (EOQ = 188):
The total cost at the (EOQ = 188) is $1,566,319.
Calculation of values at discount quantity (200):
The next price break after the EOQ at 188 units is (200 or more units). The price of that range will be used in the following calculation.
Calculation of annual holding cost at (EOQ = 200):
Calculation of annual ordering cost at (EOQ = 200):
Calculation of purchase cost:
Calculation of total cost at (EOQ = 200):
The total cost at the (EOQ = 200) is $1,445,880
Calculation of difference in cost:
The total cost at (EOQ = 188) is $1,566,319. The total cost at (EOQ = 200) is $1,445,880. Therefore (EOQ = 200) has lesser cost ($1,445,880 < 1,566,319).
Hence, the optimal order quantity is 200 units with the minimum annual cost of $1,445,880.
Want to see more full solutions like this?
Chapter 12 Solutions
Principles Of Operations Management
- Bell Computers purchases integrated chips at $350.00 per chip. The holding cost is $35.00 per unit per year, the ordering cost is $120.00 per order, and sales are steady at 400 per month. The company's supplier, Rich Blue Chip Manufacturing, Inc., decides to offer price concessions in order to attract larger orders. The price structure is shown below. Rich Blue Chip's Price Structure Price/Unit $350 $325 $300 Quantity Purchased 1-99 units 100-199 units 200 or more units a) What is the optimal order quantity and the minimum annual cost for Bell Computers to order, purchase, and hold these integrated chips? The optimal order quantity after the change in pricing structure is units (enter your response as a whole number). The total annual cost for Bell computers to order, purchase, and hold the integrated chips is $O (round your response to the nearest whole number).arrow_forwardAlina Limited is a manufacturer of widgets orders components for use in manufacturing. The estimated demand for the components during the coming year is 15,000. Order costs are $100 per order; carrying costs are $12 per component. Using the economic order quantity model What is Alina Ltd’s optimum order quantity? If the supplier guarantees a three (3) day delivery on any order that is placed, What is the re-order point?arrow_forwardChris Sandvig Irrigation, Inc., has summarizedthe price list from four potential suppliers of an undergroundcontrol valve. See the accompanying table. Annual usage is2,400 valves; order cost is $10 per order; and annual inventory holding costs are $3.33 per unit.Which vendor should be selected and what order quantityis best if Sandvig Irrigation wants to minimize total cost?arrow_forward
- FlyUs Airlines is unhappy with the number of empty seats on its New York to Philadelphia flight. To remedy the problem, the airline is offering a special discounted rate of $89 instead of the normal $169, but only for 7-day advance purchases and for a limited number of seats per flight. The aircraft flown from NY to Philly holds 100 passengers. Last month’s distribution of full-fare passengers is shown below. How many seats should FlyUs reserve for full-fare passengers? Full-Fare Frequency 50 15 55 20 60 35 65 20 70 10arrow_forwardThe company Marombeiro is a commercial representative of a food supplement widely consumed in gyms. The average daily demand for the product is 1,500 units and a standard deviation of 300 units. Average shipping time is 5 days. Of course, if the order is placed at the end of the week, it may take a little longer to receive the shipment, so the standard deviation of the delivery time is 2 days. The unit has a value of R$ 50.00 per unit in stock, an order cost of R$ 50.00 and an annual maintenance fee of 20%. Assume the service level is 99.5%. How much safety stock should the company have? ( )7,500 units ( )19,350 units ( )3,074 units ( )7,916 unitsarrow_forwardOllah's Organic Pet Shop sells bags of cedar chips for pet bedding or snacking (buyers choice). The supplier has offered the following terms: Order 1-100 bags, and the price is $6.00 a bag. Order 101 or more and the price is $4.50 a bag. Annual demand is 630, fixed ordering costs are $9 per order, and the per bag holding cost is estimated to be around $2 per year. What is the economic order quantity for the bags? please show calculationsarrow_forward
- Maroons Medical Supplies, Inc. must order masks from its supplier in lots of 1 dozen boxes. Given the information provided below, complete the following table: Annual demand 26,000 dozen Cost per order placed P30 Carrying cost 20% Price per dozen P7.80 Order Size (Dozen) 250 500 1,000 2,000 13,000 26,000 Number of orders Average inventory Carrying cost Order cost Total cost 1. What is the EOQ? Please include/fill the table and solve for EOQ. Thank you so much!arrow_forward1. Given the following inventory system: average weekly (7 days a week) demand is 1000 units with a standard deviation of 100 units, review period is 28 days (4 weeks), lead time is 14 days (2 weeks) and the target service probability is 90%. What is the appropriate level of safety stock? 2. Given the following inventory system: average weekly (7 days a week) demand is 1000 units with a standard deviation of 100 units, review period is 28 days (4 weeks), lead time is 14 days (2 weeks) and the target service probability is 90%. Currently, inventory on hand is 50 units. How many units should be ordered? 3. Given the following inventory system: average weekly (7 days a week) demand is 1000 units with a standard deviation of 100 units, review period is 28 days (4 weeks), lead time is 14 days (2 weeks) and the target service probability is 90%. Currently, inventory on hand is 500 units. How many units should be ordered? 4. A product has an average daily demand of 400 units with standard…arrow_forwardOllah's Organic Pet Shop sells bags of cedar chips for pet bedding or snacking (buyers choice). The supplier has offered the following terms: Order 1-100 bags, and the price is $6.00 a bag. Order 101 or more and the price is $4.50 a bag. Annual demand is 630, fixed ordering costs are $9 per order, and the per bag holding cost is estimated to be around $2 per year. What order quantity should Ollah order, based on the volume discount? Is this different from the EOQ? if so how could this be? please show calculations.arrow_forward
- Calculate total annual cost for the alternative suppliers for aproduct with following characteristics: montly demand; mean: 5000, standard deviation 2000 Holding cost: 30% Cycle service level: 98% Using EOQ formula, find the lot size. Don’t forget to add ordering cost to the total cost! Supplier 1 Supplier 2 Supplier 3 Ordering Cost(per order ) 1000 2000 5000 Cost 10 9 8 Average Lead Time ( month ) 0.5 2 2 Lead time std deviation ( month ) 0.5 1 2arrow_forwardEarthbound Corporation is a manufacturer and distributor of air conditioning systems. You have been engaged to install an accounting system for Earthbound period among the inventory control features earthbound desires as part of the system are indicators of how much to order and when period. The following information is furnished for a product called “Hydronix” which is carried in inventory: Hydronix are sold by the gross (12 dozen) at a list price of P800 per gross FOB shipper. John receives a 40% trade discount off list price on purchases in gross lots. Freight cost is P20 gross from the shipping point to John's plant John uses about 5,000 Hydronix during 259-day production year and must purchase a total of 36 gross per year to allow for normal breakage. Minimum and maximum usages are 12 and 28, respectively. It takes 20 working days (normal delivery time) to receive an order from the date the purchase request is initiated. A rush order in full gross lots can be received by air…arrow_forwardSupply Chain Coordination problem Zamatia makes sunglass at a cost of $35 and sells them to UmbraVisage (UV) for $75. UV sells them for $115 and salvages left over inventory for $25 per unit. Demand is Normal with mean 250 and standard deviation 125. a. What should be the optimal ordering quantity for UV? b. What is the total supply chain profit (UV & Zamatia) given the ordering quantity computed in a? c. What should be the optimal ordering quantity to maximize the total supply chain profit (UV and Zamatia)?arrow_forward
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning