Concept explainers
a)
To determine: The optimal order quantity.
Introduction: Inventory management is the process of ordering, storing and using inventory of the company such raw material, components and finished goods. It governs the flow of goods from manufacturers to warehouse and to the point of sale. The key function is to maintain record of flow of new or returned products which enters or leaves the company.
a)
Answer to Problem 24P
The optimal order quantity is 16,970.56.
Explanation of Solution
Given information:
Formula:
Where
Calculation of optimal order quantity:
Calculation of EOQ for orders less than 2000 pieces:
Holding cost is 5% of the purchase price for orders less than 2000 pieces which is 0.05 multiplied by 7.80 which yields 0.39.
EOQ for order less than 2000 pieces is calculated by multiplying 2, 45,000 and 200 and dividing the resultant with 0.39 and taking square root which gives 6,793.66 pieces.
Calculation of EOQ for orders between 2,001 to 5,000 pieces:
Holding cost is 5% of the purchase price for orders between 2001 to 5000 pieces which is 0.05 multiplied by 1.60 which yields 0.08.
EOQ for order orders between 2,001 to 5,000 pieces is calculated by multiplying 2, 45,000 and 200 and dividing the resultant with 0.08 and taking square root which gives 15,000 pieces.
Calculation of EOQ for orders between 5,001 to 10,000 pieces:
Holding cost is 5% of the purchase price for orders between 5,001 to 10,000 pieces which is 0.05 multiplied by 1.40 which yields 0.07.
EOQ for order orders between 5,001 to 10,000 pieces is calculated by multiplying 2, 45,000 and 200 and dividing the resultant with 0.07 and taking square root which gives 16,035.67 pieces.
Calculation of EOQ for orders more than 10,001 pieces:
Holding cost is 5% of the purchase price for orders more than 10,001 pieces which is 0.05 multiplied by 1.25 which yields 0.0625.
EOQ for order orders more than 10,001 pieces is calculated by multiplying 2, 45,000 and 200 and dividing the resultant with 0.0625 and taking square root which gives 16,970.56 pieces.
Based on the above calculations, EOQ for orders more than 10,001 pieces gives optimal order quantity as the EOQ lies within the quantities ordered. Therefore the optimal order quantity is 16,970.56 pieces at $1.25.
Hence, the optimal order quantity is 16,970.56.
b)
To determine: The annual holding cost.
b)
Answer to Problem 24P
The annual holding cost is $530.33.
Explanation of Solution
Given information:
Formula:
Calculation annual holding cost:
Annual holding cost is calculated by multiplying half of the economic order quantity which is 16,971 divided by 2 and multiplying with 0.0625 which yields $530.33.
Hence, the annual holding cost is $530.33.
c)
To determine: The annual setup cost.
c)
Answer to Problem 24P
The annual setup cost is $530.33.
Explanation of Solution
Given information:
Formula:
Calculation annual ordering cost:
Annual ordering cost is calculated by dividing 45,000 with 16,971 and multiplying the resultant with 200 which yields $530.33.
Hence, the annual ordering cost is $530.33.
d)
To determine: The annual cost of silverware with optimal order quantity.
d)
Answer to Problem 24P
The annual cost of silverware with optimal order quantity is $56,250.
Explanation of Solution
Given information:
Formula:
Calculation of annual cost of silverware with optimal order quantity:
Annual cost of silverware with optimal order quantity is calculated by multiplying 1.25 with 45,000 which gives $56,250.
Hence, the annual cost of silverware with optimal order quantity is $56,250.
e)
To determine: The total annual cost including ordering, holding and purchasing the silverware.
e)
Answer to Problem 24P
The total annual cost including ordering, holding and purchasing the silverware is $57,310.66.
Explanation of Solution
Given information:
Calculation of total annual cost:
Total annual cost is calculated by adding holding cost, ordering cost and unit cost which is 530.33, 530.33 and 56,250 is summed up to give 57,310.66.
Hence, the total annual cost including ordering, holding and purchasing the silverware is $57,310.66.
Want to see more full solutions like this?
Chapter 12 Solutions
Principles Of Operations Management
- In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the best order quantityin this case, the one with the largest mean profit. Using the statistics and/or graphs from @RISK, discuss whether this order quantity would be considered best by the car dealer. (The point is that a decision maker can use more than just mean profit in making a decision.)arrow_forwardThe catering manager of La Vista Hotel, Lisa Ferguson, is distu rbed by the amount of silverware she is losing every week. Last Friday night, when her crew tried to set up for a banquet for 500 people, they did not have enough knives. She decides she needs to order some more silverware, but wants to take advantage of any quantity discounts her vendor willoffer.For a small order (2,000 or fewer pieces), her vendor quotes a price of$1.80 piece.I f she orders 2,001- 5,000 pieces, the price drops to $ 1.60/piece. 5,001- 10,000 pieces brings the price to $1.40/ piece, and I 0,00 I and above reduces the price to $1.25.Lisa's order costs are $200 per order, her annual holding costs are 5%, and the annual demand is 15,000 pieces. For the best option:a) What is the optimal order quantity?b) What is the annual holding cost?c) What is the annual ordering (setup) cost?d) What a re the annual costs of the silverware itself with an optimal order quantity?e) What is the total annual cost, including…arrow_forwardRocky Mountain Tire Centre sells 20,000 tires of a particular type per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year. The purchase price is $20. per tire if fewer than 500 tires are ordered, $18. Per tire if more than 500 but fewer than 1,000 tires are ordered and $17. per tire if 1,000 or more tires are ordered. Quantity Unit Price 1-499 $20. 500-999 $18. 1000 & over $17 Based on available information, lead time demand for CD-ROM drives averages 50 units (normally distributed), with a standard deviation of 5 drives. Management wants a 97% service level. What value of Z should be applied? How many drives should be carried as safety stock?arrow_forward
- A confectioner buys plastic boxes in bulk and uses them to pack chocolates. The annual requirement of these boxes is 1,200, and each box costs $30. The ordering and carrying costs are $10 per order and 20%, respectively. The supplier from whom the confectioner purchases these boxes sells them only in lots of 25, that is, you only purchase quantities in multiples of 25 boxes. Suppose the supplier has decided that instead of the 2% discount offer the following price breaks will be used:ORDER QUANTITY COST PER BOXLess than 100 $30.00100 to 199 $29.75200 or more $29.60What order quantity should the confectioner make?arrow_forwardAfter taking a production seminar, Al Weiss, the owner of Weiss’s paint storementioned in Problem 14, decides that his stock-out cost of $10 may not be veryaccurate and switches to a service level model. He decides to set his lot size by theEOQ formula and determines his reorder point so that there is no stock-out in90 percent of the order cycles.a. Find the resulting (Q, R) values.b. Suppose that, unfortunately, he really wanted to satisfy 90 percent of hisdemands (that is, achieve a 90 percent fill rate). What fill rate did he actuallyachieve from the policy determined in part (a)?arrow_forwardA hot dog vendor at Wrigley Field sells hot dogs for$1.50 each. He buys them for $1.20 each. All the hot dogshe fails to sell at Wrigley Field during the afternoon can besold that evening at Comiskey Park for $1 each. The dailydemand for hot dogs at Wrigley Field is normally distributedwith a mean of 40 and a standard deviation of 10.a If the vendor buys hot dogs once a day, how manyshould he buy?b If he buys 52 hot dogs, what is the probability that hewill meet all of the day’s demand for hot dogs at Wrigley?arrow_forward
- ABC firm uses roughly 3,400 pounds of chemical dye a year. Currently, the firm purchases 300 pounds per order and pays P120.00 per pound. The supplier has just announced that orders of 1,000 pounds or more will be filled at a price of P80.00 per pound. The manufacturing firm incurs a cost of P4,000.00 each time it submits an order and assigns an annual holding cost of 17% of the purchase price per pound. a. Determine the order size that will minimize the total cost.b. If the supplier offered the discount at 1,500 pounds instead of 1,000 pounds, what order size would minimize total cost?arrow_forwardAAA auto supply store sells snow tires which are ordered every Friday to meet next week's demand. The sales price for the most popular size is $50 per tire and its cost for AAA is $35. If too many tires are ordered AAA incurs an inventory carrying cost of $2 per tire. If AAA is out of stock, it forgoes the profits from missed sales. AAA has the option to order 100, 150, or 200 tires to meet next week's demand which can be either 100, 150, or 200 tires.Based on its historical demand distribution, assume that AAA Inc. has determined the followingprobability information: P(100) = 0.4, P(150) = 0.3, and P(200) = 0.3 e. Which alternative should be chosen based on the minimax regret criterion? f. Which alternative should be chosen using the expected monetary value (EMV) criterion? g. What is the expected value under perfect information (EVPI)? Show Workarrow_forwardAAA auto supply store sells snow tires which are ordered every Friday to meet next week's demand. The sales price for the most popular size is $50 per tire and its cost for AAA is $35. If too many tires are ordered AAA incurs an inventory carrying cost of $2 per tire. If AAA is out of stock, it forgoes the profits from missed sales. AAA has the option to order 100, 150, or 200 tires to meet next week's demand which can be either 100, 150, or 200 tires.Based on its historical demand distribution, assume that AAA Inc. has determined the followingprobability information: P(100) = 0.4, P(150) = 0.3, and P(200) = 0.3.a. Which alternative should be chosen based on the maximax criterion?b. Which alternative should be chosen based on the maximin criterion?c. Which alternative should be chosen based on the Lapalce criterion?d. Which alternative should be chosen based on criterion of realism with alpha = 0.7?e. Which alternative should be chosen based on the minimax regret criterion?f. Which…arrow_forward
- A Mercedes dealer must pay $20,000 for each carpurchased. The annual holding cost is estimated to be 25%of the dollar value of inventory. The dealer sells an averageof 500 cars per year. He believes that demand is backloggedbut estimates that if he is short one car for one year he willlose $20,000 worth of future profits. Each time the dealerplaces an order for cars, ordering cost amounts to $10,000.Determine the Mercedes dealer’s optimal ordering policy.What is the maximum shortage that will occur?arrow_forwardABC Company has correctly computed its economic order quantity at 1,000 units; however, management feels it would rather order in quantities of 1,500 units. How should ABC’s total annual purchase order cost and total annual carrying cost for an order quantity of 1,500 units compare to the respective amounts for an order quantity of 1,000 units? A. Lower purchase order cost and lower carrying cost B. Lower purchase order cost and higher carrying cost C. Higher purchase order cost and higher carrying cost D. Higher purchase order cost and lower carrying costsarrow_forwardANT Infra orders two kinds of precast items: A and B for use in its projects from two different suppliers. The precasts are needed throughout the entire 52-week year. Precast A are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. While, precast B is ordered from a supplier who delivers by every three weeks. Data for both precast items are as follows:Item Precast A Precast BAnnual demand 10,000 5,000Holding cost (% of item cost)20% 20%Order cost $150 $25Lead time 4 weeks 1 weekSafety stock 55 units 5 unitsItem cost $10.00 $2.00 a. Employ Q system for precast A and calculate the EOQ, the reorder point, total inventory cost? b. Employ P system for precast B and estimate the target level inventory and total inventory cost?arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,