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 $10.75 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. > Demand = 85 bags/week > Order cost $55/order > Annual holding cost = 29 percent of cost > Desired cycle-service level = 92 percent > Lead time = 4 week(s) (20 working days) > Standard deviation of weekly demand = 13 bags > Current on-hand inventory is 350 bags, with no open orders or backorders. a. What is the EOQ? Sam's optimal order quantity is bags. (Enter your response rounded to the nearest whole number.)

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 $10.75 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. > Demand = 85 bags/week > Order cost $55/order > Annual holding cost = 29 percent of cost > Desired cycle-service level = 92 percent > Lead time = 4 week(s) (20 working days) > Standard deviation of weekly demand = 13 bags > Current on-hand inventory is 350 bags, with no open orders or backorders. a. What is the EOQ? Sam's optimal order quantity is bags. (Enter your response rounded to the nearest whole number.)

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

Sam’s Cat Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.70 per bag. The following information is available about these bags.Demand = 90 bags/weekOrder cost = $54/orderAnnual holding cost = 27 percent of costDesired cycle@service level = 80 percentLead time = 3 weeks 118 working days2Standard deviation of weekly demand = 15 bagsCurrent on-hand inventory is 320 bags, with no open orders or backorders.a. What is the EOQ? What would be the average time between orders (in weeks)?b. What should R be?c. An inventory withdrawal of 10 bags was just made. Is it time to reorder?d. The store currently uses a lot size of 500 bags (i.e., Q = 500). What is the annual holding cost of this policy? Annual ordering cost? Without calculating the EOQ, how can you conclude from these two calculations that the current lot size is too large?e. What would be the annual cost saved by shifting from the 500-bag lot size to the…
Pet Empire operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.70 per bag. The following information is available about these bags. Demand is 90 bags per week, order cost is $54 per order, annual holding cost is 27% of the cost, service level is 80%, lead time is 3 weeks (18 working days), and standard deviation of weekly demand is 15 bags. Current on hand inventory is 320 bags with no open orders or back orders. Require to calculate Economic Order Quantity (EOQ). What would be the average time between orders (in weeks)? Calculate reorder point (R). The store currently uses a lot size of 500 bags (i.e., Q = 500). Calculate the annual holding cost of this policy and also annual ordering cost. Without calculating the EOQ, how can you conclude from these two calculation that the current lot size is too large? What would be the annual cost saved by shifting from the 500-bag lot size to the EOQ? Consider again the…
the 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 solution
Sam’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?
Sam’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…
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 EOQ? (round up) B. how many times per year does the store reorder?(round up) show solution
Use the information below for the following questions: Knights Corporation also needs to determine the proper reorder point and safety stock level. Annual Demand = 15000 gallons Lead Time = 15 days Standard deviation of lead time = 3 days Standard deviation of demand = 10 gallons Service Level = 96% (Z score of 1.75 or 1.76) Open days per year = 360 days 1. What is the reorder point? (keep two decimal places through your work, round your final answer up to the next highest whole number) 2.What is the safety stock? (keep two decimal places through your work, round your final answer up to the next highest whole number) 3. If the service level increased to 99% (Z score of 2.32 or 2.33), what would be the new safety stock? (keep two decimal places through your work, round your final answer up to the next highest whole number)
Sunstar Ice Cream Sells 12,000 gallons of ice cream each month from its central storagefacility. Monthly carrying cost are P.10 per gallon and ordering cost are P50 per order.Ignore potential stockout cost and assume a 30 days month. What is the optimal length of the inventory cycle?How many orders will be placed per month?
A local TV repairs shop uses 36,000 units of a part each year (A maximum consumption of 100 units per working day). It costs RM20 to place and receive an order. The shop orders in lots of 400 units. It cost RM4 to carry one unit per year of inventory. Calculate total annual ordering cost Calculate total annual carrying cost Calculate total annual inventory cost Calculate the Economic Order Quantity Calculate the total annual cost inventory cost using EOQ inventory Policy How much is the saving if using EOQ? Compute re-ordering point assuming the lead time is 3 days.
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?
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 solution
Golden Crust Bakery buys flour in 25-pound bags. The bakery uses an average of 1,215 bags ayear. Preparing an order and receiving a shipment of flour involves a cost of $10 per order.Annual holding costs are $75 per bag. Once an order for flour is placed, it takes six (6) days toreceive the order from the flour factory. The bakery operates 350 days per year.Calculate the following:(i) Economic Order Quantity(ii) Expected number of orders (Order Frequency)(iii) Average inventory(iv) The annual holding cost(v) The annual ordering cost(vi) The total annual cost of inventory management(vii) Reorder point(viii) If holding costs were to increase by $9 per year, how much would thataffect the minimum total annual cost?