Problem 20-36 (Algo)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).Annual demandstandard deviation of daily demandItem costAnnual holding costReview period2, 2406$35.002028Optimal target levelmufflersmufflers per working dayper muffler% of item valueworking daysOrdering costService probabilityLead timeWorking days$60per order89 %2 working daysper year280a. 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.) b. If the service probability requirement is 90 percent, the optimal target level will:O IncreaseO DecreaseO Stay the same

The optimal target level is calculate with following formula: optimal target level = Daily demand *…

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

A manufacturer buys cardboard boxes from a supplier. The annual demand is 40,000 boxes and is uniformly distributed. The boxes cost $5 each. The estimated order cost is $10, and the carrying cost rate is 20% per year. What is the EOQ and what is the annual order and carrying cost? How many times a year are orders placed, and what is the average time, in weeks, between orders? Using the answer from (b), if you round the average time between orders to the nearest week, what should the order quantity be? Would you recommend using this order quantity and time interval? Suppose that the actual demand turns out to be 80,000 boxes instead of 40,000 boxes.If you had used the EOQ from the (a), what would be the annual order and carrying cost be?
A computer products store stocks color graphics monitors, and the daily demand is normally distributed with a mean of 1.6 monitors and a standard deviation of 0.4 monitor. The lead time to receive an order form the manufacturer is 15 days. Q 17.1- Determine the reorder point that will achieve 98 % service level.
University Drug Pharmaceuticals orders its antibiotics every two weeks (14 days) when a salesperson visits from one of the pharmaceutical companies. Tetracycline is one of its most prescribed antibiotics, with average daily demand of 2,000 capsules. The standard deviation of daily demand was derived from examining prescriptions filled over the past three months and was found to be 800 capsules. It takes f ive days for the order to arrive. University Drug would like to satisfy 99 percent of the prescriptions. The salesperson just arrived, and there are currently 25,000 capsules in stock.How many capsules should be ordered?
Peter Sagan is in charge of maintaining hospital supplies at Champs Hospital. During the past year the mean weekly demand for a special type of tubing was 186 packages of this tubing with a standard deviation of 13 packages of tubing. The lead time for receiving this tubing from the supplier is 1.5 weeks. Peter would like to maintain a 95% service level and places an order for 750 packages every time an order is placed. d) If the weekly demand is 186 and there is a 1.5 week lead time - what is the reorder point (99% service level)? e) If the carrying cost per year is $0.50/unit/year - what is the additional cost associate with the 99% service level compared to 95% service level (i.e. cost of safety stock at 99% level - cost of safety stock at 95% service level)?
kai
ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average of 500 boxes but maysometimes sell a maximum of 600 boxes. The supplier takes an average of 5 days to deliver the order. During busier times, thesupplier may take 7 days.Based on ABC’s records, ordering cost average P400 per order. Storage cost per box average P5 per year. There is also anopportunity cost of 1% per year for every peso invested in inventories. Each box of candles costs P450. If ABC would continue its current inventory management policy, it would keep 10,000 boxes as safety stock and order ten-days-worth of inventory. (B) Economic Order Quantity 1. How much would the total inventory related (ordering plus carrying) costs be if the economic order quantity wasfollowed (excluding safety stock)? (D) Cost-Benefit Analysis: If ABC maintains its current inventory policy for the year,1. How much would the entity save it followed the reorder point and economic order quantity models?…
Palin’s Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to answer the below questions. Annual demand 3,000 mufflers Standard deviation of daily demand 6 mufflers per working day Item cost $30 per muffler Annual holding cost 25% of item value Review period 15 working days Ordering cost $50 per order Service probability 90% Lead time 2 working days Working days 300 per year What is the optimal target level (order-up-to level)? 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 nearest whole number. If the service probability requirement is 95 percent, the optimal target level will: multiple choice Increase Decrease Stay the same
Please do not give solution in image format thanku
Oretailer of white goods buys small appliances from a supplier. Their line includes rwo types of appliances for which the related data are as follows: Appliance type 2. Annual demand (units) 5235 4850 Ordering cost (TL) 125 125 Enit purchasing cost (TL) 35 25 The retailer has allocated a budget of 22,000 TL for thas procurement Assume that the aunual inventory carrying cost rate is 20 percent Caleulnte the unconstramed order quantities Are these values optimal? If not detemine the optimal quantities to be purchased from each appliance type (Hat. 0056)
For many firms, inventory usage is not uniformthroughout the year but instead follows some seasonal pattern. Can the EOQ model be used in thissituation? If so, how?

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