QUESTION 4Harry's is a famous souvenir shop that targets tourists. Harry purchases souvenirs for $5 each. It is estimated that the cost of order processing is $100 per order. Harry uses a 19% annualinterest rate to compute holding cost.The six-month demand for the souvenirs sale follows a normal distribution with mean 580 and standard deviation 36. Lead time is 6 months. What is thereorder size (R) to ensure a type 1 service level of 95%.

Step 1: Calculate the Economic Order Quantity (EOQ): The EOQ formula is given by:EOQ = 2DS /…

Answered: QUESTION 4 Harry's is a famous souvenir…

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

03) Halifax Souvenir Company currently orders 500 units four times each year. Each order costs $12 and each unit costs $1.20 per year to carry. On average, it takes 5 days to receive an order from the supplier. The company operates 250 days per year. Required: 1. What is the EOQ? 2. Calculate total annual inventory cost under EOQ. 3. What is the current inventory cost? 4. What is the re-order point?
Current decision to buy: Ross White's machine shop uses 300 brackets each month during the course of a year. This usage is relatively constant throughout the year. Currently, these brackets are purchased from a supplier 100 miles away for $25 each and the lead time is 2 days. The holding cost per bracket per year is $3.75 (15% of the unit cost) and the annual ordering cost per order is $18.50. There are 240 working days per year. Possible future decision to make in-house: Ross White is reconsidering his decision of buying the brackets and is considering making the brackets in-house. He has determined the set up costs would be $22.50 in machinist time and lost production time. Forty eight brackets could be produced in a day once the machine has been set up. Ross estimates that the cost (including labor and materials) of producing one bracket would be $22.85. The holding cost would be 12% of the cost. What is the EOQ given Ross' current decision to buy the brackets? What is the…
Need in Detail (No AI)
Please show work so I can understand it. Given this information: •Expected demand during lead time = 800 units • Standard deviation of lead time demand = 40 units Assuming that lead time demand is distributed normally. The risk of stockout is 5 percent during lead time (a) What amount of safety stock is appropriate? (b) Calculate ROP
Kooyman hardware sells 31 different types of drills. They had demand for 25 of the drills and satisfied 78 percent of the demand. What was their fill rate for drills? % ( Do not round intermediate calculations.
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.
Can someone please help me with the folowing problems on excel with the formulas. Thank you
8
AaBbCc AaBbCc AaBbCc No Spacing Normal Reuse Heading 1 Replace Files Paragraph Styles Editing Reuse Files Item SKU A3378 has a demand that is normally distributed during the lead time, with a mean of 360 units and standard deviation of 12. If Hinsdale cannot have stockouts in more than 10% of the time in any order, how much safety stock should be maintained and at what reorder point? 1. SKU F5402: daily demand is normally distributed with a mean of 16, standard deviation of 4, lead time is 4 days, and must operate at a 95% service level. 2. SKU B7319: daily demand is constant at 24 units per day, lead time is normally with a mean of 6 days and standard deviation of 2 days, and must operate at a 95% service level. 3. SKU F9004: daily demand is normally distributed with a mean of 21 units and a standard deviation of 3 days. The lead time is also normally distributed with a mean of 4 days, standard deviation of 2 days, and a service level of 90% is required. dictions: On acer %24 4. % &…

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