Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system tomanage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (ororder-up-to level).Ordering costService probabilityAnnual demand3,750mufflers$ 6092 %per ordermufflers per working dayper muffler% of item valueworking daysStandard deviation of daily demandItem cost$39.00working daysper yearLead time3Working daysAnnual holding costReview period3125020a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV() function to find the correct critical value for thegiven a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest wholenumber.)Optimal target levelb. If the service probability requirement is 92 percent, the optimal target level will:O Stay the sameDecreaseO Increase

Given, Annual demand D = 3750 Daily Demand d = 3750/250 = 15 per day Review Period T = 20 Lead time…

Answered: Palin's Muffler Shop has one standard…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

1. The overall objective of inventory management is to achieve satisfactory levels of customer service by having sufficient quantities while keeping inventory costs reasonable. True or false
Dunstreet's Department Store would like to develop an inventory ordering policy with a 95 percent probability of not stocking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets. Demand for white percale sheets is 5,000 per year. The store is open 365 days per year. Every two weeks (14 days) inventory is counted and a new order is placed. It takes 10 days for the sheets to be delivered. Standard deviation of demand for the sheets is five per day. There are currently 150 sheets on-hand. How many sheets should you order? Note: Use Excel's NORM.S.INV() function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number.
If I have available inventory, I should accept whatever paying customer comes along. Select one: True False
Caring Hospital's dispensary reorders doses of a drug when the supply on hand falls to 18 units. Lead time for resupply is three days. Given the typical usage over the last 10 days, what service level is achieved with the hospital's reorder policy? (Hint. Use the following formula.) (Do not round intermediate calculations. Round your "z" value and final answer to 2 decimal places.) Use Table. ROP =dLT +2 (od) √LT Day Units 1 3 2 3 4 4 7 5 Service level Click here for the Excel Data File 5 5 % 6 6 7 4 8 3 9 4 10 5
Sam's Pet Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag. The following information is available about these bags: ≻Demand=75 bags/week ≻Order cost=$55.00/order ≻Annual holding cost=25 percent of cost ≻Desired cycle-service level=80 percent ≻Lead time=4 weeks (24 working days) ≻Standard deviation of weekly demand=15 bags ≻Current on-hand inventory is 320 bags, with no open orders or backorders. Part 2 a. Suppose that the weekly demand forecast of 75 bags is incorrect and actual demand averages only 50 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $enter your response here higher owing to the error in EOQ. (Enter your response rounded to two decimal places.) a. What is the EOQ? What would the average time between orders (in weeks)? b. What should R be? c. An inventory withdraw…
Fush uses an average of 40 boxes of paper serviettes a day. The restaurant operates 260 days per year, storage and handling costs for the serviettes are $ 30 per year per box, and it costs approximately $60 to order and receive a shipment of serviettes. a. Calculating the order size would minimise the sum of annual ordering and carrying costs? b. compute the total annual costs using your size from part a?
Southern Markets, Inc. is considering the use of ABCanalysis to focus on the most critical SKUs in its inventory.Currently, there are approximately 20,000 different SKUswith a total dollar usage of $10,000,000 per year.a. What would you expect to be the number of SKUs and thetotal annual dollar usage for A items, B items, and C itemsat Southern Markets, Inc.? b. The following table provides a random sample of the unitvalues and annual demands of eight SKUs. Categorizethese SKUs as A, B, and C items.
First Printing has contracts with legal firms in San Francisco to copy their court documents. Daily demand is almost constant at 11,200 pages of documents. The lead time for paper delivery is normally distributed with a mean of 4 days and a standard deviation of 1 day. A 96% service level is expected. Compute First's ROP. Refer to the standard normal table for z-values. The reorder point is documents (round your response to the nearest whole number).
Please do not give solution in image format thanku A small mail-order company uses 14,000 boxes a year. Holding cost rate is 18 percent of unit cost per year, and ordering cost is $33 per order. The following quantity discounts are available. Number of Boxes Price per Box 1,000 to 1,999 $1.15 2,000 to 4,999 1.10 5,000 to 9,999 1.05 10,000 or more 1.00 a. Determine the optimal order quantity. Optimal order quantity boxes b. Determine the number of orders per year. (Round the final answer to 1 decimal place.) No. of orders per year
Wear A Mask (WAM) uses a continuous review system and operates 52 weeks per year with the following characteristics: Demand (d) = 52,505 units/week Ordering cost (S) = $55.00/order Holding cost (H) = $2.50/unit/year ■ Lead time (L) = 3 week(s) Cycle-service level = 90%, z = 1.28 ▪ Demand is normally distributed, with a standard deviation of weekly demand of 103 units. ■ ▪ Current on-hand inventory is 1,040 units, with no scheduled receipts and no backorders. What is the optimal order quantity? (Enter your response rounded to nearest whole number.)
Using relevant eoq calculations Which order size would you recommend that the hospital use?
David's Delicatessen flies in Hebrew National salamis regularly to satisfy a growing demand for the salamis in Silicon Valley. The owner, David Gold, estimates that the demand for the salamis is pretty steady at 175 per month. The salamis cost Gold $1.85 each. The fixed cost of calling his brother in New York and having the salamis flown in is $200. It takes three weeks to receive an order. Gold's accountant, Irving Wu, recommendsan annual cost of capital of 22 percent, a cost of shelf space of 3 percent of the value of the item, and a cost of 2 percent of the value for taxes and insurance. How many salamis should Gold have on hand when he phones his brother to send another shipment?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS