Loose Leaf for Operations Management in the Supply Chain: Decisions and Cases 7e
7th Edition
ISBN: 9781260151954
Author: SCHROEDER, Roger G
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 14, Problem 8P
An electronics retailer carries a particular cellular telephone with the following characteristics:
Average monthly sales = 120 units
Ordering cost = S25 per order
Carrying cost = 35 percent per year
Item cost = S300 per unit
Lead time = 4 days
Standard deviation of daily demand = .2 unit
Working days per year = 250
- a. Determine the EOQ.
- b. Calculate the reorder point for a 92 percent service level, assuming
normally distributed demand. - c. Design a Q system for this item.
- d. What happens to the reorder point when the lead time changes? What happens to the reorder point when the standard deviation of demand changes?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
An electronics retailer carries a particular cellular telephone with the following characteristics:Average monthly sales = 120 unitsOrdering cost = $25 per orderCarrying cost = 35 percent per yearItem cost = $300 per unitLead time = 4 daysStandard deviation of daily demand = .2 unitWorking days per year = 250a. Determine the EOQ.b. Calculate the reorder point for a 92 percent service level, assuming normally distributed demand.c. Design a Q system for this item.d. What happens to the reorder point when the lead time changes? What happens to the reorder point when the standard deviation of demand changes?
Petromax Enterprises uses a continuous review inventorycontrol system for one of its SKUs. The following informationis available on the item. The firm operates 50 weeks in a year.Demand = 50,000 units>yearOrdering cost = $35>orderHolding cost = $2>unit>yearAverage lead time = 3 weeksStandard deviation of weekly demand = 125 unitsa. What is the economic order quantity for this item?b. If Petromax wants to provide a 90 percent cycle-servicelevel, what should be the safety stock and the reorder point?
Your objective is to help company by determining EOQ* (Economic Order Quantity) that minimizes the totalinventory cost for a company that sells ceiling fans. Your worksheet provides information about the currentorder quantity, demand quantity and other costs.Questions: Answer A and Ba. With the current order quantity, what is the total cost of inventory?b. Implement the problem in Excel and find the order quantity (EOQ) (round to nearest integer) that givesminimum inventory cost. Note: this is a Non-linear programming, hence select “GRG Nonlinear” method inSolver- How much money would company save by switching to optimum quantity from current orderquantity?
Chapter 14 Solutions
Loose Leaf for Operations Management in the Supply Chain: Decisions and Cases 7e
Ch. 14.S - eXcel Suppose that for problem 1 in the chapter,...Ch. 14.S - Prob. 2PCh. 14.S - For problem 2 in the chapter, suppose the Grinell...Ch. 14.S - A producer of electronic parts wants to take...Ch. 14 - Identify the different types of inventories (raw...Ch. 14 - Why are stockout costs difficult to determine?...Ch. 14 - What is the difference between a requirements...Ch. 14 - Compare and contrast the management of finished...Ch. 14 - For a given service level, why does a P system...Ch. 14 - Under what circumstances might CPFR be useful, and...
Ch. 14 - Prob. 7DQCh. 14 - What is the appropriate role of inventory turnover...Ch. 14 - Suppose you are managing a chain of retail...Ch. 14 - The Always Fresh Grocery Store carries a...Ch. 14 - The Grinell Machine Shop makes a line of metal...Ch. 14 - The local Toyota dealer has to decide how many...Ch. 14 - Prob. 4PCh. 14 - The famous Widget Company sells widgets at the...Ch. 14 - Prob. 6PCh. 14 - Prob. 7PCh. 14 - An electronics retailer carries a particular...Ch. 14 - An electronics retailer carries a particular...Ch. 14 - The local Toyota dealer has to decide how many...Ch. 14 - The Suregrip Tire Company carries a certain type...Ch. 14 - The Suregrip Tire Company carries a certain type...Ch. 14 - eXcel 13. The Cover-up Drapery Company carries...Ch. 14 - Suppose you are the supplier of the Cover-up...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- the company expects to sell 19,200 units next year. it operates 360 days a year. annual carrying cost is P32 per unit ordering cost is P150. A. what is the length of an order cycle in days? (4 decimals) B. what is the total annual cost at EOQ? show solutionarrow_forwardthe company expects to sell 38,400 units next year. it operates 355 days a year. annual carrying cost is P64 per unit ordering cost is P300 A. what is the eoq? B. how many times per year does the store reorder? (round up) show solutionarrow_forwardThe following information regarding inventory policy was assembled by the GB Inc. The company uses a 50-week year in all calculations: Sales: 10,000 units per year Order quantity: 2,000 units Safety stock: 1,300 units Lead time: 4 weeks The reorder point is: a. 3,300 units b. 2,100 units c. 100 units d.300 unitsarrow_forward
- Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,800 cases. A case of the soft drink costs R&B $3. Ordering costs are $20 per order and holding costs are 25% of the value of the inventory. R&B has 250 working days per year, and the lead time is 5 days. Identify the following aspects of the inventory policy. a. economic order quantity (round your answer to the nearest integer.) _____450_______ b. reorder point ______76______ c. cycle time (in days) (round your answer to two decimal places.) ______29.61______ d. total annual cost (in $) (round your answer to two decimal places.) _____?_______ ***I am asking the question with the ? symbol. I have been able to locate the numbers for the first three but I am having issues computing my answers for the last one.arrow_forwardThompson Paint Company uses 60,000 gallons of pigment per year. The cost of ordering pigment is $200 per order, and the cost of carrying the pigment in inventory is $1 per gallon per year. The firm uses pigment at a constant rate every day throughout the year. a. Calculate the EOQ. b. If it takes 20 days to receive an order once it has been placed, determine the reorder point in terms of gallons of pigment. (Note: Use a 365-day year.)arrow_forwardI need answers A company uses on an average 216 parts a day with a standard deviation of 16 parts per day in a manufacturing process. Cost of placing and receiving an ordering is BDT 40,000. Estimated monthly carrying cost is BDT 90 per part. Orders are delivered approximately 7 days after being placed. The delivery time is normal with a mean of 7 days and a standard deviation of 2 days. The company is open 360 days per year. Find the order quantity that is economical. If the Company takes 3% stock out risk, then find safety stock (SS) quantity and Re-Order Point? 3.If the supplier offers a discount of BDT 8 per circuit board for purchasing of 4000 boards at a time, then financially evaluate and justify whether the company will go with the offer or not? 4.The person who orders the boards follows this rule: Order when the amount on…arrow_forward
- It is your responsibility, as the new head of the automotive section of Nichols Department Store, to ensure that reorder quantities for the various items have been correctly established. You decide to test one item and choose Michelin tires, XW size 185 × 14 BSW. A perpetual inventory system has been used, so you examine this as well as other records and come up with the following data: Cost per tire $35 each Holding cost 20 percent of tire cost per year Demand 1,000 per year Ordering cost $20 per order Standard deviation of daily demand 3 tires Delivery lead time 4 days Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 98 percent. Assume the demand occurs 365 days per year. Determine the order quantity. Note: Round your answer to the nearest whole number. Determine the reorder point. Note: Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places and final answer to the…arrow_forwardSam’s Cat Hotel operates 52 weeks per year, 7 days per week,and uses a continuous review inventory system. It purchaseskitty litter for $10.75 per bag. The following information isavailable about these bags.Demand = 95 bags>weekOrder cost = $58>orderAnnual holding cost = 25 percent of costDesired cycle@service level = 90 percentLead time = 4 weeks 128 working days2Standard deviation of weekly demand = 16 bagsCurrent on-hand inventory is 315 bags, with no open ordersor backorders.a. What is the EOQ? What would be the average time betweenorders (in weeks)?b. What should R be?c. An inventory withdrawal of 10 bags was just made. Is ittime to reorder?d. The store currently uses a lot size of 490 bags (i.e.,Q = 490). What is the annual holding cost of this policy?Annual ordering cost? Without calculating the EOQ, howcan you conclude from these two calculations that thecurrent lot size is too large?e. What would be the annual cost saved by shifting from the490-bag lot size to the EOQ?arrow_forwardSam’s Cat Hotel operates 52 weeks per year, 7 days per week,and uses a continuous review inventory system. It purchaseskitty litter for $10.75 per bag. The following information isavailable about these bags.Demand = 95 bags>weekOrder cost = $58>orderAnnual holding cost = 25 percent of costDesired cycle@service level = 90 percentLead time = 4 weeks 128 working days2Standard deviation of weekly demand = 16 bagsCurrent on-hand inventory is 315 bags, with no open ordersor backorders. a. Suppose that the weekly demand forecast of 95 bags isincorrect and actual demand averages only 65 bags perweek. How much higher will total costs be, owing to thedistorted EOQ caused by this forecast error?b. Suppose that actual demand is 65 bags but that orderingcosts are cut to only $10 by using the Internet to automateorder placing. However, the buyer does not tell anyone,and the EOQ is not adjusted to reflect this reduction in S.How much higher will total costs be, compared to whatthey could be if…arrow_forward
- EOQ, reorder point, and safety stock Alexis Company uses 937units of a product per year on a continuous basis. The product has a fixed cost of $44 per order, and its carrying cost is $4 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days' usage in inventory as a safety stock. a. Calculate the EOQ. b. Determine the average level of inventory. (Note: Use a 365-day year to calculate daily usage.) c. Determine the reorder point. d. Indicate which of the following variables change if the firm does not hold the safety stock: (1) order cost, (2) carrying cost, (3) total inventory cost, (4) reorder point, (5) economic order quantity.arrow_forwardThe following information regarding inventory policy was assembled by the GB Inc. The company uses a 50-week year in all calculations: Sales: 10,000 units per year Order quantity: 2,000 units Safety stock: 1,300 units Lead time: 4 weeks The reorder point is: 3,300 units 2,100 units 100 units 1,300 unitsarrow_forwardInventory Management Basic EOQ Webber Tools sells power washers and is open for business 320 days a year. It costs the store $3750 each time it places an order with the manufacturer for the washers. The annual cost of carrying a washer in inventory is $400. The manager uses the Basic EOQ Model and forecasts an annual demand for the washers of 1200 units. What is the economic order quantity? What is the total minimum annual inventory cost? What is the average inventory level? How many orders per year will be required? How long is the order cycle time? Now assume the manager does not use the EOQ model. Instead, the manager has been ordering 125 washers at a time. How much money will be saved in annual inventory costs if the company switches to the EOQ (assume no stockouts)?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY