Concept explainers
Joe Birra needs to purchase malt for his microbrewery production. His supplier charges $35
per delivery (no matter how much is delivered) and $1.20 per gallon. Joe’s annual holding
cost per unit is 35 percent of the price per gallon. Joe uses 250 gallons of malt per week.
a. Suppose Joe orders 1000 gallons each time. What is his average inventory (in gal)?
b. Suppose Joe orders 1500 gallons each time. How many orders does he place with his
supplier each year?
c. How many gallons should Joe order from his supplier with each order to minimize the
sum of the ordering and holding costs?
d. Suppose Joe orders 2500 gallons each time he places an order with the supplier. What
is the sum of the ordering and holding costs per gallon?
e. Suppose Joe orders the quantity from part (C) that minimizes the sum of the ordering
and holding costs each time he places an order with the supplier. What is the annual
cost of the EOQ expressed as a percentage of the annual purchase cost?
f. If Joe’s supplier only accepts orders that are an integer multiple of 1000 gallons, how
much should Joe order to minimize ordering and holding costs per gallon?
g. Joe’s supplier offers a 3 percent discount if Joe is willing to purchase 8000 gallons or
more. What would Joe’s total annual cost (purchasing, ordering, and holding) be if he
were to take advantage of the discount?
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps
- 7. Sam's Cat Hotel operates 52 weeks per year, 5 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.00 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. ≻Demand = 95 bags/week ≻Order cost = $57/order ≻Annual holding cost = 30 percent of cost ≻Desired cycle-service level=98 percent ≻Lead time = 1 week(s) (5 working days) ≻Standard deviation of weekly demand = 20 bags ≻Current on-hand inventory is 350 bags, with no open orders or backorders. d. The store currently uses a lot size of 490 bags (i.e., Q=490). What is the annual holding cost of this policy? (Enter your response rounded to two decimal places.) and (Enter your response rounded to two decimal places.) **select the correct multiple choice answer** e. What would be the annual cost saved by shifting from the 490-bag lot size to the EOQ? (Enter your responses rounded to two decimal places.)arrow_forwardIn an ABC system based on revenue, C items individually make the lowest annual revenue contribution. TRUE FALSEarrow_forwardIf annual sales in are 65,000 units, price per unit is $25, carrying costs are 30%, and fixed costs per order is $100, then EOQ is 1,316.56. True or False?arrow_forward
- Can someone please help me with the folowing problems on excel with the formulas. Thank youarrow_forwardThe following data give monthly Demband >1300 units Ordenng cost Holding lo st to Q - $ 15 pe oder $2/ units peo year 464 Lead time 4 days %3D wha t is the tolal annua / vanable inventory Cost Cie total annus! total aroual ordening) © $968 $ 8 ® $484 D $ I436 14520arrow_forwardJoe Birra needs to purchase malt for his microbrewery production. His supplier charges $35 per delivery (no matter how much is delivered) and $1.20 per gallon. Joe's annual holding cost per unit is 35 percent of the price per gallon. Joe uses 250 gallons of malt per week. a. Suppose Joe orders 1,000 gallons each time. What is his average inventory (in gal)? (Round your answer to 2 decimal places.) Suppose Joe orders 1,500 gallons each time. How many orders does he place with his supplier each year? How many gallons should Joe order from his supplier with each order to minimize the sum of the ordering and holding costs? (Round your answer to 3 decimal places.) Suppose Joe orders 2,500 gallons each time he places an order with the supplier. What is the sum of the ordering and holding costs per gallon? (Round your answer to 2 decimal places.) e. Suppose Joe orders the quantity from part (c) that minimizes the sum of the ordering and holding costs each time he places an order with the…arrow_forward
- 6. Leaky Pipe, a local retailer of plumbing supplies, faces demand for one of its SKUs at a constant rate of 17,000 units per year. It costs Leaky Pipe $5 to process an order to replenish stock and $2.00 per unit per year to carry the item in stock. Stock is received 12 working days after an order is placed. No backordering is allowed. Assume 365 working days a year. a. Leaky Pipe's optimal order quantity is ______ units. (Enter your response rounded to the nearest whole number.) Part 3 b. The optimal number of orders per year is _____ orders. (Enter your response rounded to the nearest whole number.) Part 4 c. The optimal interval (in working days) between orders is ______ days. (Enter your response rounded to one decimal place.)arrow_forward7. Sam's Cat Hotel operates 52 weeks per year, 5 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.00 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. ≻Demand = 95 bags/week ≻Order cost = $57/order ≻Annual holding cost = 30 percent of cost ≻Desired cycle-service level=98 percent ≻Lead time = 1 week(s) (5 working days) ≻Standard deviation of weekly demand = 20 bags ≻Current on-hand inventory is 350 bags, with no open orders or backorders. a. What is the EOQ? (Enter your response rounded to the nearest whole number.) and (Enter your response rounded to one decimal place.) b. What should R be? (Enter your response rounded to the nearest whole number.) c. An inventory withdrawal of 10 bags was just made. Is it time to reorder? (is or is not)arrow_forwardThe production order quantity for this problem is approximately 332 units. daily demand rate = 64; daily production rate = 100. What is the average inventory on - hand ( in other words - the inventory for which you are paying Holding Costs ) In this problem ?arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.