Question: QUESTION 5 Problem 2 A product is stocked in a warehouse, where the average demand d - 200 per month with standard deviation of 50

QUESTION 5 Problem 2 A product is stocked in a warehouse, where the average demand d - 200 per month with standard deviation of 50 units per month, the lead time LT = 0.5 months. The product is valued at $75 per unit in the warehouse. The ordering costs $50 per order and the inventory carrying cost is 15% per month. The Service level is set at 97% during the lead time. The out of stock cost per unit is $10 Auming the manager in this warehouse is using EOQ and re-order point control policy Question 2.5. As a result of adopting this policy, what is annual inventory carrying cost for regular inventory? QUESTION 10 Problem 2 Question 2.6. As a result of adopting this policy, what is annual inventory carrying cost for safety stock? QUESTION 11 Problem 2 w Question 2.7 For out-of-stock calculation, what is the E(z) for the service level required? (tip: NORM DIST(2.0.1. FALSE)2"NORM S DIST(-2. TRUE)) (keep at least precision after the decimal point, do not round if copied from Excel) Problem 2 Question 2.8. As a result of adopting this policy, what is the average number of products running out of stock each year? QUESTION 13 Problem 2 Question 2.9. As a result of adopting this policy, what is annual out of of stock cost for the warehouse

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Concord Company acquired the assets (except for cash) and assumed the liabilities of Cullumber Company on January 1, 2024, paying $745,000 cash. Cullumber Company's December 31, 2023, balance sheet,...

Problem 2. A product is stocked in a warehouse, where the average demand d - 200 per month with standard deviation of 50 units per month, the lead time LT -0.5 months. The product is valued at $75...

A product is stocked in a warehouse where the average demand d= 200 per month with standard deviation of 50 units per month the lead time LT = 0.5 months. The product is valued at $75 per unit in the...

A company carries nine product lines, 1-9. All have average weekly demand of 100 units per week, but the product categories have different levels of demand uncertainty, different unit costs, and...

Problem 1: A fertilizer plant acquires phosphate from a single source. The plant's annual phosphate requirement has a normal distribution with a mean of 25,000 metric tons and the standard deviation...

For this assignment, you are going to use a MS Excel spreadsheet to simulate a series of sequential processes in an industrial setting. The structure is similar to the one developed during our...

*** Excel sheet required only for 3 parts using the following data. Urgently *** For this assignment, you are going to use a MS Excel spreadsheet to simulate a series of sequential processes in an...

3. The local Toyota dealer from problem 2 is considering installing either a Q or P system for inventory control. The past standard deviation of demand has been 2.5 units per month, and the...

This data case question is divided in 7 part, I need assistance please: Data case 2 Econ 670 Show all your work to receive full credit. Completed assignments will include an Excel file. Please use...

HI, Need assistance with this data case. It does not has to be every single question, any help is much appreciated. Data case 2 Econ 670 Show all your work to receive full credit. Completed...

I need help with this data set, thank you! Data case 2 Econ 670 Show all your work to receive full credit. Completed assignments will include an Excel file. Please use one sheet for each question....

At least 99% of the data in any data set lie within how many standard deviations of the mean? Explain how you obtained your answer.

Repeat Problem 91 if the gas is CO2.

Which of the following statements are correct with respect to an Interest-Charge Domestic International Sales Corporation ("IC-DISC"): A: The IC-DISC is a taxable entity which will pay U.S. income...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...